I'm really struggling to set up SQL Delight in a Compose Desktop project. This the reference I'm usi...

# compose-desktop

[John Aoussou]

I'm really struggling to set up SQL Delight in a Compose Desktop project. This the reference I'm using but I can't quite follow:
https://cashapp.github.io/sqldelight/jvm_sqlite/ , does anyone have another template? Please look in the thread to see what I have attempted.

[John Aoussou]

settings.gradle.kts file:

pluginManagement {
    repositories {
        google()
        gradlePluginPortal()
        mavenCentral()
        maven("<https://maven.pkg.jetbrains.space/public/p/compose/dev>")
    }

    plugins {
        kotlin("multiplatform").version(extra["kotlin.version"] as String)
        id("org.jetbrains.compose").version(extra["compose.version"] as String)
        id("com.squareup.sqldelight").version("1.5.3")
    }
}

build.gradle.kts file:

plugins {
    kotlin("multiplatform")
    id("org.jetbrains.compose")
    id("com.squareup.sqldelight")
}

sqldelight {
    database("MyDatabase") { // This will be the name of the generated database class.
        packageName = "delight-desktop"
    }
}

...

kotlin {
    jvm {
        compilations.all {
            kotlinOptions.jvmTarget = "11"
        }
        withJava()
    }
    sourceSets {
        val jvmMain by getting {
            dependencies {
                implementation(compose.desktop.currentOs)
                implementation("com.squareup.sqldelight:sqlite-driver:1.5.3")
            }
        }
        val jvmTest by getting
    }
}

Is it indeed in jvmMain I'm supposed to create the sqldelight directory?

Am I supposed to use in the driver the same database name as in the build.gradle.kts? (I tried that but it doesn't recognize the reference).

class DriverFactory {
    fun createDriver(): SqlDriver {
        val driver: SqlDriver = JdbcSqliteDriver(JdbcSqliteDriver.IN_MEMORY)
        MyDatabase.Schema.create(driver)
        return driver
    }
}

[hfhbd]

Yes, you can use the folder sqldelight in jvmMain. What do you mean with the driver?

[John Aoussou]

Well, if you look at the reference, it say

val driver: SqlDriver = JdbcSqliteDriver(JdbcSqliteDriver.IN_MEMORY)
Database.Schema.create(driver)

Sorry, there was a mistake in my question: in the driver, should I use the same database name as in the build.gradle.kts?

[hfhbd]

The database name declared in the sqldelight gradle plugin is only for code generation, it does not matter during using a "real" sql database.

[John Aoussou]

So what name am I supposed to use for the driver? Database.Schema.create(driver)

[hfhbd]

Ahh, okay I got your question. Yes

[hfhbd]

I thought you mean somethink like this:

val driver: SqlDriver = JdbcSqliteDriver("<jdbc://sqlite>:localhost/fooDB")
MyDatabase.Schema.create(driver)

[John Aoussou]

Yes, I tried MyDatabase.Schema.create(driver) but it says it doesn't know what "MyDatabase" is.

[hfhbd]

Thats strange. Is your project uploaded?

[John Aoussou]

Do you mean on Github?

[hfhbd]

yeah

[John O'Reilly]

example of it in following if that helps (at least part of kmp project anyway) https://github.com/joreilly/PeopleInSpace/blob/main/common/src/jvmMain/kotlin/com/surrus/common/repository/actual.kt

[John Aoussou]

https://github.com/aoussou/delight-desktop

[John Aoussou]

Btw, not sure if the problem is related, but

sqldelight {
  Database { // This will be the name of the generated database class.
    packageName = "com.example"
  }
}

doesn't work, I have to use

database("MyDatabase") { // This will be the name of the generated database class.
        packageName = "delight-desktop"
    }

[hfhbd]

Yes the first one is groovy, which some magic (missing function name as db name hacks) while the last one is kotlin with a typed syntax 🙂

[John Aoussou]

@John O'Reilly where do you define your tables? I can't find them in "surrus".

[hfhbd]

https://github.com/joreilly/PeopleInSpace/blob/main/common/src/commonMain/sqldelight/com/surrus/peopleinspace/db/PeopleInSpace.sq

[John Aoussou]

Curiously, it works with a multiplatform project, but with a Desktop only project it won't detect the DB directory (in @John O'Reilly’s case com.surrus.peopleinspace.db )

[oianmol]

here's an example of sqldelight in compose multiplatform android and desktop https://github.com/Anmol92verma/SlackComposeMultiplatform/blob/master/common/src/desktopMain/kotlin/dev/baseio/slackclone/data/DriverFactory.kt

[John Aoussou]

@oianmol Thank you, I got it to work on multiplatform, now I'm trying to do it with only Dekstop

[John Aoussou]

Here is the default settings https://kotlinlang.slack.com/archives/C01D6HTPATV/p1662293351991109?thread_ts=1662293323.003779&cid=C01D6HTPATV