android-kmp-sqldelightlisted
Install: claude install-skill lenorebreakneck630/claude-zero-to-hero-android-KMP
# KMP SQLDelight
## Dependency setup
```toml
# libs.versions.toml
[versions]
sqldelight = "2.0.2"
[libraries]
sqldelight-android-driver = { module = "app.cash.sqldelight:android-driver", version.ref = "sqldelight" }
sqldelight-native-driver = { module = "app.cash.sqldelight:native-driver", version.ref = "sqldelight" }
sqldelight-coroutines = { module = "app.cash.sqldelight:coroutines-extensions", version.ref = "sqldelight" }
[plugins]
sqldelight = { id = "app.cash.sqldelight", version.ref = "sqldelight" }
```
```kotlin
// core:data build.gradle.kts
sqldelight {
databases {
create("AppDatabase") {
packageName.set("com.example.db")
}
}
}
```
## Schema file (`commonMain/sqldelight/`)
```sql
-- Task.sq
CREATE TABLE TaskEntity (
id TEXT NOT NULL PRIMARY KEY,
title TEXT NOT NULL,
due_at INTEGER,
priority TEXT NOT NULL DEFAULT 'MEDIUM',
is_completed INTEGER NOT NULL DEFAULT 0
);
selectAll:
SELECT * FROM TaskEntity ORDER BY due_at ASC;
selectById:
SELECT * FROM TaskEntity WHERE id = :id;
upsert:
INSERT OR REPLACE INTO TaskEntity VALUES (?, ?, ?, ?, ?);
delete:
DELETE FROM TaskEntity WHERE id = :id;
```
## Platform driver factory (`expect/actual`)
```kotlin
// commonMain
expect class DriverFactory {
fun createDriver(): SqlDriver
}
// androidMain
actual class DriverFactory(private val context: Context) {
actual fun createDriver(): SqlDriver =
AndroidSqliteDriver(AppDatabase.Schema, context, "app.db")