groovy
plugins {
id("com.squareup.sqldelight") version "1.5.0"
}
sqldelight {
database("MyDatabase") {
packageName = "com.example.db"
sourceFolders = listOf("src/main/sqldelight")
}
}
sql
CREATE TABLE User (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
email TEXT NOT NULL
);
kotlin
val database = MyDatabase(driver)
val userDao = database.userQueries
database.transaction {
userDao.insertUser(1, "John Doe", "john@example.com")
val users = userDao.getAllUsers().executeAsList()
for (user in users) {
println(user.name)
}
}
