println("DSL: ${Kreuzungen.selectAll().toList().get(0)}")
println("Element 1: ${Kreuzung.all().toList().get(0)}")

InsertStatement.generatedKey

get()

get()

generatedKey

toInt()

SHOW PROCESSLIST

SHOW ENGINE INNODB STATUS

<T: Any> Map<Column<out T?>, T>

out T?

T?

varchar(MAX)

WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

class User(id: EntityID<Long>) : LongEntity(id) {
    var images by Image via UserImages

    companion object : LongEntityClass<User>(Users)
}

class Image(id: EntityID<Long>) : LongEntity(id) {
    val user by User referencedOn Images.user

    companion object : LongEntityClass<Image>(Images)
}

object Images : LongIdTable() {
    val user = reference("user", Users)
}


object Users : LongIdTable() {
// Do I need to do something to establish a relationship to images here?
}

object UserImages : Table() {
    val user = reference("user", Users).primaryKey(0)
    val image = reference("image", Images).primaryKey(1)
}

!User.find { Users.login eq login }.empty()

PreparedStatement

SELECT * 
FROM my_table 
WHERE (col1, col2) IN ((1, 'apple'), (2, 'banana'), (3, 'cat'));

Foo.insert {
    it[name] = foo.name
    it[query] = foo.query
    it[description] = foo.description
    it[status] = foo.status
} 

Foo.update (where = { Foo.id.eq(fooId) } ) {
    it[name] = foo.name
    it[query] = foo.query
    it[description] = foo.description
    it[status] = foo.status
}

object Users : Table() {
    val id = varchar("id", 10).primaryKey() // Column<String>
    val name = varchar("name", length = 50) // Column<String>
    val cityId = (integer("city_id") references Cities.id).nullable() // Column<Int?>
}
Users.insert {
            it[id] = "andrey"
            it[name] = "Andrey"
            it[cityId] = saintPetersburgId
        }

it[id]

it[title]

kotlin
fun getCitation(code: String, offset: Int = 0): Citation? {
        var result: Citation? = null
        transaction(db) {
            result = Citation.wrapRows(Citations
                .select { Citations.code eq code }.limit(1)).toList().getOrNull(0)
        }
        return result
    }

SomeTable.batchInsert((0 until 1_000).toList()) { number ->
    this[SomeTable.type] = "some-type"
    this[SomeTable.data] = """{"foo":"$number"}"""
}

UPDATE Orders SET Quantity = Quantity + 1 WHERE ...