Create a new Todo, plus some helper classes / functions

MainController.kt

fun main(args: Array<String>) {

    setupDB()
    port(9000)
    staticFileLocation("/public/")
 
    path("/todo/") {
        data class Todo(val id: Long, val text: String, val done: Boolean, val createdAt: LocalDateTime)
        
        val toTodo: (Row) -> Todo = { row -> Todo(row.long(1), row.string(2), row.boolean(3), row.localDateTime(4))}
        fun getTodo(id: Long): Todo? = using(sessionOf(HikariCP.dataSource())) { session ->
            session.run(queryOf("select id, text, done, created_at from todo where id=?", id).map(toTodo).asSingle)
        }

        post("") { req, res ->
            if (req.body().isNullOrEmpty()) badRequest("a todo cannot be blank")

            val todo = req.body()
            val id = using(sessionOf(HikariCP.dataSource())) { session ->
                session.run(queryOf("insert into todo (text) values(?)", todo).asUpdateAndReturnGeneratedKey)
            }

            if (id == null) internalServerError("there was a problem creating the Todo")
            else jacksonObjectMapper().writeValueAsString( getTodo(id) )
        }
    }
}