implementation("org.jetbrains.exposed:exposed-core:$eV")
implementation("org.jetbrains.exposed:exposed-dao:$ed")
implementation("org.jetbrains.exposed:exposed-jdbc:$eV")
implementation("org.jetbrains.exposed:exposed-java-time:$eV")
implementation("com.h2database:h2:$h2Version")
implementation("ch.qos.logback:logback-classic:1.4.6")

data class Student(
    val name: String,
    val group: String,
    val id: UUID? = null
)

object StudentTable : IdTable<UUID>("students") {
    override val id: Column<EntityID<UUID>> = 
      uuid("id").entityId().uniqueIndex()
    val name: Column<String> = varchar("name", 512)
    val group: Column<String?> = varchar("group", 10).nullable()
}

Database.connect(
  "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1", 
  driver = "org.h2.Driver"
)
transaction {
  addLogger(StdOutSqlLogger)
  SchemaUtils.create(StudentTable)
}

abstract class UpdateBuilder<out T>(
  type: StatementType, 
  targets: List<Table>
) : Statement<T>(type, targets) {
  ...
  open operator fun < S> set(column: Column<S>, value: S) {
    ...
  }
}

fun UpdateBuilder<Number>.save(student: Student) {
    this[StudentTable.id] = student.id ?: UUID.randomUUID()
    this[StudentTable.name] = student.name
    this[StudentTable.group] = student.group
}

val students = listOf("Penny", "Amy")
  .map { Student(it, "Girls") } + listOf("Sheldon", "Leonard", 
  "Howard", "Raj").map { Student(it, "Boys") }
students.map { student ->
  StudentTable.insert { 
    // this: StudentTable, it: InsertStatement<Number>
    it.save(student) } } 

fun ResultRow.toStudent(): Student = Student(
    id = this[StudentTable.id].value,
    name = this[StudentTable.name],
    group = this[StudentTable.group] ?: ""
)

val allQuery: Query = StudentTable.selectAll()
println("Students: ${allQuery.map { it.toStudent() }}")

val boysQuery = StudentTable.select {
  // this: SqlExpressionBuilder
  StudentTable.group eq "Boys"
}
println("Boys: ${boysQuery.map { it.toStudent() }}")

val amy = StudentTable.select {
  StudentTable.name eq "Amy"
}.first().toStudent()

StudentTable.update({
  StudentTable.name eq "Amy"
}) {
  it.save(amy.copy(name = "Amy Farrah Fowler"))
}

StudentTable.deleteWhere {
  group eq "Boys"
}