Slide 63
Slide 63 text
SQLDelight
● Generates typesafe Kotlin APIs from SQL
● Created by Square
● 100% Kotlin
● Multi-platform (supported SQLite drivers on Android, JVM and iOS)
val database = Database(driver)
val playerQueries: PlayerQueries = database.playerQueries
println(playerQueries.selectAll().executeAsList())
// Prints [HockeyPlayer.Impl(15, "Ryan Getzlaf")]
playerQueries.insert(player_number = 10, full_name = "Corey Perry")
println(playerQueries.selectAll().executeAsList())
// Prints [HockeyPlayer.Impl(15, "Ryan Getzlaf"), ...]
val player = HockeyPlayer(10, "Ronald McDonald")
playerQueries.insertFullPlayerObject(player)
PlayerQueries.kt