DSL Kotlin Exposed Example

dslKotlinExposedExample.kt

// READ
val query: Query = StarWarsFilms.select { StarWarsFilms.sequelId eq 8 }

// INSERT
val id = StarWarsFilms.insertAndGetId {
  it[name] = "The Last Jedi"
  it[sequelId] = 8
  it[director] = "Rian Johnson"
}

// UPDATE
StarWarsFilms.update ({ StarWarsFilms.sequelId eq 8 }) {
  it[name] = "Episode VIII – The Last Jedi"
}

// DELETE
StarWarsFilms.deleteWhere { StarWarsFilms.sequelId eq 8 }