kotlinlang #squarelibraries

Hi guys! Can someone confirm for me if the cocoapods-pack should be able to work in a Pod that has some subspecs? I have a project that only supports Cocoapods integration, that project has 5 subspecs and it depends on some other libraries that also provide support to Cocoapods only. There’s something I can do here to use cocoapods-pack and create the xcframework?

Paul Woitaschek

06/01/2022, 3:35 PM

Is there a way to tell sqldelight where the query files are located? We conditionally configure the build as either multiplatform or jvm. In multiplatform, sqldelight always looks for the sq files in commonMain and for jvm it always searches in main. Right now the only workaround I found is to duplicate the files to have them both in commonMain and main

alec

06/01/2022, 3:37 PM

sourceFolders

gradle property: https://cashapp.github.io/sqldelight/multiplatform_sqlite/gradle/

Paul Woitaschek

06/01/2022, 3:43 PM

Copy code

// An array of folders where the plugin will read your '.sq' and '.sqm' 
    // files. The folders are relative to the existing source set so if you
    // specify ["db"], the plugin will look into 'src/main/db' or 'src/commonMain/db' for KMM. 
    // Defaults to ["sqldelight"]
    sourceFolders = ["db"]

Paul Woitaschek

06/01/2022, 3:43 PM

That is relative so it won't help

alec

06/01/2022, 3:45 PM

you could probably cheat,

sourceFolders = ["../sqldelightMain"]

alec

06/01/2022, 3:45 PM

maybe

Paul Woitaschek

06/01/2022, 7:54 PM

I think it would work if this would normalize the file: https://github.com/cashapp/sqldelight/blob/dd20d6ff578d2af854d2817d3c075eb3d39b3b52/sqldelight-gradle-plugin/src/main/kotlin/app/cash/sqldelight/gradle/SqlDelightDatabase.kt#L159

06/04/2022, 12:14 PM

Not yet

Paul Woitaschek

06/04/2022, 12:18 PM

Figured out a way, solution in the thread 👍

Andromadus Naruto

06/05/2022, 7:12 AM

Hi everyone.

Andromadus Naruto

06/05/2022, 7:12 AM

Please I have an issue setting up SQL Delight on my Ktor project.

Andromadus Naruto

06/05/2022, 7:31 AM

Screenshot from 2022-06-05 08-13-58.png

Andromadus Naruto

06/05/2022, 7:32 AM

Here's the content of my build.gradle.kts file

Copy code

val ktor_version: String by project
val kotlin_version: String by project
val logback_version: String by project
//val sqldelight_version = ""

plugins {
    application
    kotlin("jvm") version "1.6.21"
    id("org.jetbrains.kotlin.plugin.serialization") version "1.6.21"
    id("com.squareup.sqldelight") version "2.0.0-alpha02"
}

group = "com.andromadus.kotlin.ktor"
version = "0.0.1"
application {
    mainClass.set("io.ktor.server.netty.EngineMain")

    val isDevelopment: Boolean = project.ext.has("development")
    applicationDefaultJvmArgs = listOf("-Dio.ktor.development=$isDevelopment")
}

repositories {
    google()
    mavenCentral()
    maven { url = uri("<https://maven.pkg.jetbrains.space/public/p/ktor/eap>") }
    maven { url = uri("<https://oss.sonatype.org/content/repositories/snapshots>") }
}

dependencies {
    implementation("com.squareup.sqldelight:gradle-plugin:1.5.3")

    implementation("io.ktor:ktor-server-core-jvm:$ktor_version")
    implementation("io.ktor:ktor-server-websockets-jvm:$ktor_version")
    implementation("io.ktor:ktor-server-content-negotiation-jvm:$ktor_version")
    implementation("io.ktor:ktor-serialization-kotlinx-json-jvm:$ktor_version")
    implementation("io.ktor:ktor-server-call-logging-jvm:$ktor_version")
    implementation("io.ktor:ktor-server-cors-jvm:$ktor_version")
    implementation("io.ktor:ktor-server-compression-jvm:$ktor_version")
    implementation("io.ktor:ktor-server-host-common-jvm:$ktor_version")
    implementation("io.ktor:ktor-server-status-pages-jvm:$ktor_version")
    implementation("io.ktor:ktor-server-auth-jvm:$ktor_version")
    implementation("io.ktor:ktor-server-auth-jwt-jvm:$ktor_version")
    implementation("io.ktor:ktor-server-netty-jvm:$ktor_version")

    // SQL Delight
    implementation("com.squareup.sqldelight:jdbc-driver:1.5.3")

    // Hikari JDBC connection pool
    implementation("com.zaxxer:HikariCP:5.0.1")

    // MySQL
    implementation("mysql:mysql-connector-java:8.0.29")

    implementation("ch.qos.logback:logback-classic:$logback_version")
    testImplementation("io.ktor:ktor-server-tests-jvm:$ktor_version")
    testImplementation("org.jetbrains.kotlin:kotlin-test-junit:$kotlin_version")
}

//sqldelight {
//
//}

Andromadus Naruto

06/05/2022, 7:33 AM

Here's the content of my settings.gradle.kts file

Copy code

rootProject.name = "com.andromadus.kotlin.ktor.kontaktor"

pluginManagement {
    repositories {
        gradlePluginPortal()
        maven(url = "<https://oss.sonatype.org/content/repositories/snapshots>")
    }
}

Andromadus Naruto

06/05/2022, 7:33 AM

Does anyone know how to fix this?

Andromadus Naruto

06/05/2022, 7:35 AM

And also, can anyone please refer me to a ktor server project with SQLDelight setup?

🧵 1

Derek Ellis

06/05/2022, 10:09 AM

Add

mavenCentral()

to your

plguinManagement.repositories {}

block. The alphas are published there.

Andromadus Naruto

06/05/2022, 4:11 PM

@Derek, thanks for your feedback. However, it didn't work. After some trial and errors, I replaced:

id("com.squareup.sqldelight") version "2.0.0-alpha02

with:

Copy code

id("app.cash.sqldelight") version "2.0.0-alpha02"

and it worked. 🤷🏾‍♂️

Andromadus Naruto

06/05/2022, 5:07 PM

I'm still figuring my way around using it. Setting it up isn't that intuitive...

saket

06/05/2022, 5:34 PM

using 2.x shouldn't be necessary, but the problem was that you were using different versions of sqldelight in your build scripts shared above

Andromadus Naruto

06/05/2022, 7:58 PM

Oh. So, what do you suggest @saket?

saket

06/05/2022, 10:35 PM

I suggest using the same version (for both the plugin and the drivers) 😄

😄 1

Michal Klimczak

06/07/2022, 10:17 AM

kotlinpoet: Is it possible / planned to generate a

TypeSpec

from

KSDeclaration

like you can from

TypeElement

(

TypeElement.toTypeSpec(ClassInspector)

✔️ 1

Matthias Geisler

06/08/2022, 8:09 AM

Hey just a small question in regards to kotlinpoet in terms of the ksp interop should this not be

kotlin.Function$count

Iuhas Cezar

06/08/2022, 10:51 AM

Hi guys, I'm using SqlDelight in a KMM project. I'm having problems when using the

INSERT ON CONFLICT DO UPDATE

command. After some investigation, I found that I needed to update my dialect version of SqlDelight to 3.25 which I did and it works fine, except it still crashes on Api 29 and below. I tested it on a pixel 4 Api 29 emulator and on a physical device pixel 3 Api 28 which both crash. On Pixel 2 Api 30 and above emulators works fine. SqlDelight version: 1.5.3 dialect = "sqlite:3.25" My insert statement looks like this

Copy code

insertLocalPortfolioItem:
INSERT INTO localPortfolioList(name, symbol, pricePerShare, currency, cost, noOfShares, logo, availableFunds, orderAction)
VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT(symbol) DO UPDATE SET noOfShares=excluded.noOfShares;

StackTrace:

Copy code

android.database.sqlite.SQLiteException: near "ON": syntax error (code 1 SQLITE_ERROR): , while compiling: INSERT INTO localPortfolioList(name, symbol, pricePerShare, currency, cost, noOfShares, logo, availableFunds, orderAction)
VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT(symbol) DO UPDATE SET noOfShares=excluded.noOfShares

Any ideas please?

alec

06/08/2022, 10:52 AM

https://developer.android.com/reference/android/database/sqlite/package-summary

✅ 2