Skip to content

Instantly share code, notes, and snippets.

View nakamura-to's full-sized avatar

Toshihiro Nakamura nakamura-to

80 followers · 5 following
View GitHub Profile
@nakamura-to
nakamura-to / Application.kt
Created July 21, 2024 13:55
KomapperのEntityMetamodelのためにインタフェースを定義する案
import org.komapper.annotation.*
import org.komapper.core.dsl.expression.PropertyExpression
import org.komapper.core.dsl.expression.WhereDeclaration
import java.time.LocalDateTime
// EntityMetamodelのためのインタフェース
interface BiTemporal {
val validFrom: PropertyExpression<LocalDateTime, LocalDateTime>
val validTo: PropertyExpression<LocalDateTime, LocalDateTime>
}
@nakamura-to
nakamura-to / Application.kt
Created July 21, 2024 07:41
Komapperにおける複数クエリ共通の検索条件の定義方法 2
package org.komapper.quickstart
import org.komapper.annotation.*
import org.komapper.core.dsl.Meta
import org.komapper.core.dsl.QueryDsl
import org.komapper.core.dsl.expression.PropertyExpression
import org.komapper.core.dsl.expression.WhereDeclaration
import org.komapper.core.dsl.metamodel.EntityMetamodel
import org.komapper.jdbc.JdbcDatabase
import java.time.LocalDateTime
@nakamura-to
nakamura-to / Application.kt
Last active July 21, 2024 06:55
Komapperにおける複数クエリ共通の検索条件の定義方法
package org.komapper.quickstart
import org.komapper.annotation.*
import org.komapper.core.dsl.Meta
import org.komapper.core.dsl.QueryDsl
import org.komapper.core.dsl.expression.PropertyExpression
import org.komapper.core.dsl.expression.WhereDeclaration
import org.komapper.jdbc.JdbcDatabase
import java.time.LocalDateTime
@nakamura-to
nakamura-to / entities.kt
Last active July 20, 2024 01:23
クエリの比較 - Komapper版
@KomapperEntity
@KomapperTable("users")
data class User(
@KomapperId
val id: String,
val name: String,
val age: Int
)
@KomapperEntity
@nakamura-to
nakamura-to / ContextualAbstractions.kt
Created May 31, 2022 14:21
KotlinでScala3のContextual Abstractionsみたいなもの
// 下記の記事の最後のコード例をKotlinで書いてみた
// https://zenn.dev/hinastory/articles/c8d5267ea43ed6
package hello.kotlin
data class Person(val name: String, val age: Int)
data class Japanese(val name: String, val age: Int, val info: String)
interface CanGreet<T> {
fun T.hello()
@nakamura-to
nakamura-to / AssociationExample.kt
Created November 3, 2021 14:10
Komapperでエンティティの関連づけを行うAPIの例
val d = Dept.meta
val e = Emp.meta
val query = SqlDsl.from(d).innerJoin(e){ d.id eq e.deptId }.associate(d, e)
val aggregate = db.runQuery { query }
val map: Map<Dept, Set<Emp>> = aggregate.oneToMany(d, e)
@nakamura-to
nakamura-to / Address.java
Last active October 30, 2021 08:50
Domaで@embeddableの代替策
public class Address {
public String ctiy;
public String street;
public Address(String city, String street) {
this.city = ctiy;
this.street = street;
}
}
@nakamura-to
nakamura-to / extension.kt
Created August 18, 2021 14:39
拡張関数の利用範囲を限定する方法
fun String.globalExtension() {
println(this)
}
class Scope {
fun String.narrowExtension() {
println(this)
}
}
@nakamura-to
nakamura-to / where-declaration-composition.kt
Created August 17, 2021 08:25
KomapperでWhere宣言を合成する例
package org.komapper.quickstart
import org.komapper.annotation.KomapperAutoIncrement
import org.komapper.annotation.KomapperEntity
import org.komapper.annotation.KomapperId
import org.komapper.core.dsl.EntityDsl
import org.komapper.core.dsl.SchemaDsl
import org.komapper.core.dsl.expression.ColumnExpression
import org.komapper.core.dsl.scope.WhereDeclaration
import org.komapper.jdbc.JdbcDatabase
@nakamura-to
nakamura-to / sql.md
Last active April 20, 2020 09:49
KotlinのDSLでSQLっぽく書くために

selectするカラムの選択

ラムダで指定できなくはないが、型パラメータが面倒臭いことになる

DSLの利用コード

val query = select({ it.name }, from = ::_Emp) { e -> where { eq(e.id, 1) }}

DSLの定義