what does your sqlite look like that's erroring

ahh i think i found it.. forgot a single comman on the last element it seems

Hey everyone. If I have an app that is built for a single customer and don’t want to add ClientID to all database columns. Can I achieve the same behaviour using SQLDelight by creating one database per customer? @jw your input is appreciated.

In SQLDelight, is it possible to use custom column types that in turn use their own custom types? As an example:

import com.myapp.model.Medication;
import com.myapp.model.Dosage;

CREATE TABLE _Treatment(
    startDate TEXT NOT NULL,
    endDate TEXT,
    medication TEXT as Medication,
    dosage TEXT as Dosage
);

Is there a recommended way to encode/decode this in a ColumnAdapter?

what you've written should work (though

as

might need to be capitalized), are you asking how to write ColumnAdapters for your own types?

Yeah, exactly, that’s more where I was heading with the question. I started with decoding with a delimiter between the parameters, as recommended, but then the custom types need to be decoded too and I though I’d ask before going down that rabbit hole.

in our case the custom types were encoding for the db are already encodable as protobufs so its pretty trivial

that would be my recommendation, using something like protobufs or json to serialize your types so they can be stored as a blob/text

Of course! 🤦‍♂️Thanks for that! Worked perfectly 🙂

What's the workaround for https://github.com/square/moshi/issues/775 ?

copying the

KotlinJsonAdapter

file and patching it as described here seems to work: https://github.com/square/moshi/issues/775#issuecomment-450222124

is it possible in sqldelight to autoatically prefix the properties of autogenerated classes from join results with their tables ? i have id, name and url all over the place.. and currently its deduplication strategy seems to be only to append a _ at the end

Give them an alias

SELECT blah AS myBlah FROM table

so with 3 or four joins and originially

SELECT *

this would add 50-60 lines, maybe i should generate it

or just rename the fields in each table and add prefixes i guess

Hi guys, I'm having problems with sqldelight on multiplatform. I have

packageName

setted in the build.gradle, but when running the gradle task to generate the code I get a

SqlDelight files must be placed in a package directory

error message. I setted the

sourceSet

to the folder where my

.sq

files are located but I can't get this error to go away (PS: using sqldelight 1.0.3 since 1.1.3 seems to have some problem with kotlin 1.3.40 with ios)

What directory are you putting .sq files in

Uhhhhh 1.0.3 hmmm

That may have worked differently

We're working on getting a 1.3.40 compatible version out for mpp

I'd try putting them in src/commonMain/sqldelight

right now I have them in

src/commonMain/sqldelight/com/mypackage/name

, will try them both 🙂

src/main/sqldelight/com/mypackage/name

worked!

@jw I have a question about coroutines implementation in latest retrofit: In

suspend fun <T : Any> Call<T>.await(): T {}

function, Call gets enqueued on OkHttp thread pool. Shouldn't it be

async { call.execute() }

, so the call uses coroutine dispatcher and things like

runBlocking and ThreadContextElement

work correctly with it?

Hm, the new retrofit doesn't play well with

Unit

. Is there a workaround to have suspending functions without a result?

For example this function:

kotlin
  @POST("$V1/user/appsflyer")
  suspend fun updateAppsFlyerData(@Body data: AppsFlyerDataDTO)

Unit

works fine in the same way it did with

Deferred

or any other call adapter

throws

kotlin.KotlinNullPointerException: Response from AccountApi.updateAppsFlyerData was null but response body type was declared as non-null

your service returns a 204 or 205 which bypasses the converter. you would get this with any call adapter and it's not new behavior.