Lbenyehu
12/21/2020, 9:19 AMJoel
12/21/2020, 2:33 PMLbenyehu
12/21/2020, 2:36 PMobject record : Table() {
val id = integer("ewid") // Column<Int>
// Buckets Columns:
val bckt_0_2_ms = integer("bckt_0_2_ms").nullable() // Column<Int>
val bckt_3_4_ms = integer("bckt_3_4_ms").nullable() // Column<Int>
val bckt_5_7_ms = integer("bckt_5_7_ms").nullable() // Column<Int>
}
And every transaction, I insert/update different buckets…
How should I write a generic code for it?Joel
12/21/2020, 2:38 PMrecord.insert { stmt ->
val columnToUpdate = when (someValue) {
conditionOne -> bckt_0_2_ms
conditionTwo -> bckt_3_4_ms
else -> bckt_5_7_ms
}
stmt[columnToUpdate] = someValue
}
Lbenyehu
12/21/2020, 2:47 PMJoel
12/21/2020, 2:56 PMobject Record : Table() {
val id = integer("ewid") // Column<Int>
// Buckets Columns:
val bckt_0_2_ms = integer("bckt_0_2_ms").nullable() // Column<Int>
val bckt_3_4_ms = integer("bckt_3_4_ms").nullable() // Column<Int>
val bckt_5_7_ms = integer("bckt_5_7_ms").nullable() // Column<Int>
}
fun foo() {
val someValue = Random.nextInt(0, 10)
Record.insert { stmt ->
val columnToUpdate = when (someValue) {
in (0 until 3) -> bckt_0_2_ms
in (3 until 6) -> bckt_3_4_ms
else -> bckt_5_7_ms
}
stmt[columnToUpdate] = someValue
}
}
object Record : Table() {
val id = integer("ewid") // Column<Int>
val bucketColumns = mapOf(
(0 until 3) to "bckt_0_3_ms",
(3 until 6) to "bckt_3_6_ms",
(6 until 9) to "bckt_6_9_ms",
).mapValues { (_, colName) ->
integer(colName).nullable()
}
}
fun foo() {
val someValue = Random.nextInt(0, 10)
Record.insert { stmt ->
val bucketColumn = bucketColumns.entries.first { someValue in it.key }.value
stmt[bucketColumn] = someValue
}
}
Lbenyehu
12/21/2020, 3:01 PMJoel
12/21/2020, 3:01 PMobject Record : Table() {
val id = integer("ewid") // Column<Int>
val bucketColumns = mapOf(
(0 until 3) to integer("x").nullable(),
(3 until 6) to integer("y").nullable(),
(6 until 9) to integer("z").nullable(),
)
}
If you need to have differences in each columnLbenyehu
12/21/2020, 3:04 PMtransaction {}
the insert statment?Joel
12/21/2020, 3:05 PMLbenyehu
12/21/2020, 3:06 PMJoel
12/21/2020, 3:07 PMLbenyehu
12/21/2020, 3:08 PMJoel
12/21/2020, 3:22 PMLbenyehu
12/21/2020, 3:23 PM<dependency>
<groupId>org.jetbrains.exposed</groupId>
<artifactId>exposed-core</artifactId>
<version>0.28.1</version>
</dependency>
<dependency>
<groupId>org.jetbrains.exposed</groupId>
<artifactId>exposed-dao</artifactId>
<version>0.28.1</version>
</dependency>
<dependency>
<groupId>org.jetbrains.exposed</groupId>
<artifactId>exposed-jdbc</artifactId>
<version>0.28.1</version>
</dependency>
<dependency>
<groupId>org.jetbrains.exposed</groupId>
<artifactId>exposed-jodatime</artifactId>
<version>0.28.1</version>
</dependency>
<dependency>
<groupId>org.jetbrains.exposed</groupId>
<artifactId>exposed-java-time</artifactId>
<version>0.28.1</version>
</dependency>
Joel
12/21/2020, 3:38 PMRandom.nextInt
Lbenyehu
12/21/2020, 3:39 PM