DB Setup

MainController.kt

package codemwnci

import spark.Spark.*
import kotliquery.*
import com.fasterxml.jackson.module.kotlin.jacksonObjectMapper
import java.time.LocalDateTime

fun main(args: Array<String>) {
    setupDB()
}

fun setupDB() {
    HikariCP.default("jdbc:h2:mem:todo", "user", "pass")
    // when using in memory DB, create the DDL
    using(sessionOf(HikariCP.dataSource())) { session ->
        session.run(queryOf("""
          create table todo (
            id serial not null primary key,
            text varchar(255),
            done boolean default false,
            created_at timestamp not null default now()
          )
        """).asExecute) // returns Boolean
    }
}