kotlinlang #squarelibraries

val tables = driver.executeQuery(null, "SELECT name FROM sqlite_master WHERE type='table';", 0).use {
      buildList {
        while (it.next()) {
          val name = it.getString(0)!!
          if (name != "sqlite_sequence" && name != "android_metadata") {
            add(name)
          }
        }
      }
    }
    for (table in tables) {
      driver.execute(null, "DROP TABLE $table", 0)
    }
    Database.Schema.create(driver)

We have the following doubts: • Is this logic safe? Could be device or os dependent or be broken by library updates? • What is the correspondent for ios?

05/18/2023, 12:54 AM

Seems fine. The code for iOS, or any platform running sqlite, is identical.

Raghav

05/18/2023, 7:51 AM

While using SQLDelight, I'm getting these errors in Xcode while compiling the iOS app. The android app is running fine but can't compile the iOS app now. Any tips on resolving the same?

hfhbd

05/18/2023, 9:13 AM

You "just" need to link the native sqlite library, but it depends on your setup.

Raghav

05/18/2023, 11:44 AM

I'm already using the dependency in the iosMain source set, if that what you mean

Copy code

implementation("com.squareup.sqldelight:native-driver:$sqlDelightVersion")

Pablichjenkov

05/18/2023, 2:26 PM

Try to compare with a working SQDelight project and then compare what you are missing or what you have extra

👍 1

KamilH

05/18/2023, 6:46 PM

I bet Philip meant this: https://github.com/cashapp/sqldelight/issues/1442#issuecomment-523435492

👍 1

Rohan Maity

05/19/2023, 1:48 PM

I have query for SqlDelight in a multi-module setup I am trying to have have separate feature module and shared KMM module will include these feature modules as a dependency so that I can share it as a single pod to iOS Regarding sqlDelight, I am struggling with sq files. Ideally I would want for sqlDelight to generate wrappers for sq file inside the feature module only but currently AFIAU, sqlDelight looks for particular folder as mentioned in the gradle file and generate wrappers for those sq files So how to make sqlDelight to generate wrappers for sq files which are in different feature modules having single database only

Derek Ellis

05/19/2023, 1:58 PM

You can have a feature module's database depend on the schemas created in other modules: https://cashapp.github.io/sqldelight/2.0.0-alpha05/multiplatform_sqlite/gradle/#schema-dependencies

Sean Wong

05/20/2023, 1:03 AM

May I know how to use snapshot version? any guideline?

Виталий Перятин

05/20/2023, 10:18 AM

Hello everyone! I use SQLDelight and Paging libraries by CashApp. I wrote a code for pagination according to CashApp's documentations. Everything works good, but when data is updated in database, data in list with pagination on UI isn't updated. Functions 'getRefreshKey' and 'load' are also not recalled

Colton Idle

05/23/2023, 1:27 PM

Not sure how I'd model this with moshi

Copy code

{
  "items": [
    { "x": { // bunch of properties} },
    { "y": { // bunch of properties, identical to above} },
    { "z": { // ^^^} },
  ]
}

So my problem is because I seemingly have the same Type going into items array, but I want to be able to dynamically chance the name of the item (x,y,z) at runtime, but

name

isn't a property... its the object name itself?

05/23/2023, 1:29 PM

Well, how do you want to model it? You could use a

Map<String, BunchOfProperties>

and runtime verify there's only a single entry. You could model it as

data class Something(val name: String, val stuff: BunchOfProperties)

and write a custom serializer that emits it as an object with a single key/value pair using the provided name.

Colton Idle

05/23/2023, 1:42 PM

Maybe a map is what I'm after. I actually never used a map before when serializing. Will give it a go. thanks

05/23/2023, 1:48 PM

Moshi is super versatile in its ability to fairly easily adapt the representation in code to the representation on the wire. I always determine the ideal modeling that I want in code first, and then work on how to do the correct transformation in a JSON adapter second.

➕ 2

❤️ 1

Joel Denke

05/23/2023, 2:01 PM

I would use custom serializer in Moshi with Sealed interface/class. But depends if having more than x, y, z or more complicated fields. You could evaluate which fields exists and switch class representation based on that. I did this a couple of times in the past. I would say it depends how you want to consume your Moshi models in UI or such later on, whats most benefitial for the use case depends 🙂 From my experience I avoid using Maps, as most often complicating stuff imo and complexer writing loops and transformations later on.

05/23/2023, 2:02 PM

x/y/z are just examples. they stated that the key values are dynamic. otherwise yes, a sealed type is the desired modeling in code.

hfhbd

05/25/2023, 8:17 AM

KotlinPoet: Why is there a difference between %N and %M? I often need to handle illegal Kotlin member names, so I use

MemberName("MyObject", "my-prop")

and I need carefully adopt my generator to use

%N

. This is also affects

%L

, which uses the same

%M

escaping when passing

MemberName

. Also related,

%N

only writes the escaped property name, but does not include the class name, so I need to write the classname manually in another code block too.

Colton Idle

05/25/2023, 9:42 PM

Testing + moshi + retrofit question. I have a tricky request body that I had to model with moshi. server finally responds with 200 so it looks like i got it right. would it be weird to write a test with mockhttpserver so that I can locally verify my models are what the server the server expects...? i feel like maybe its weird because ive never done it before, and it would be overkill IMO to do that for like 99% of my network calls. but this 1 network call is tricky and so verifying it could be good

05/25/2023, 9:49 PM

I would personally test your model deserializatiom directly. There's little point going through the actual HTTP layer unless you're testing HTTP things or the actual configuration of Retrofit. If you are just testing custom JSON adapter logic then do that directly

😍 1

Tolriq

05/27/2023, 7:39 PM

I'm getting a few ANRs reported by Android for WaitForOtherNonDaemonThreadsToExit
in each case I have an OkHttp thread running. Any knowledge about such kind of issues ? Anr:

Copy code

#00  pc 0x000000000004e8f0  /apex/com.android.runtime/lib64/bionic/libc.so (syscall+32)
  #01  pc 0x00000000003a9ae4  /apex/com.android.art/lib64/libart.so (art::ConditionVariable::WaitHoldingLocks(art::Thread*)+140)
  #02  pc 0x00000000007267c0  /apex/com.android.art/lib64/libart.so (art::ThreadList::WaitForOtherNonDaemonThreadsToExit(bool)+336)
  #03  pc 0x000000000034dc20  /apex/com.android.art/lib64/libart.so (art::JII::DestroyJavaVM(_JavaVM*)+32)
  #04  pc 0x00000000000ce520  /system/lib64/libandroid_runtime.so (android::AndroidRuntime::start(char const*, android::Vector<android::String8> const&, bool)+1032)
  #05  pc 0x0000000000002570  /system/bin/app_process64 (main+1304)
  #06  pc 0x000000000004a7d4  /apex/com.android.runtime/lib64/bionic/libc.so (__libc_init+100)

Thread code in thread.

Ahmad Hassan

05/28/2023, 6:43 PM

Hi I want to pre-populate the database in my KMM project. I’m using SQLDelight. I have this implementation for the Android side.

Copy code

actual fun Scope.createDriver(): SqlDriver {

    val context = androidContext()
    val fileName = "dbFileName"
    val database: File = context.getDatabasePath(fileName)

    if (!database.exists()) {
        val inputStream = context.assets.open(fileName)
        val outputStream = FileOutputStream(database.absolutePath)

        inputStream.use { input ->
            outputStream.use {
                input.copyTo(it)
            }
        }
    }

    return AndroidSqliteDriver(NoteDatabase.Schema, context, fileName)
}

What are the steps for the iOS side..? thanks!

Jan Skrasek

05/31/2023, 11:38 AM

We have Paparazzi in the same modules as our other module's unit tests. Previously it worked, the bad part was that running screenshots was also executing unit tests and vice versa, but that was a thing to optimize, not a thing to make it work. But after upgrading to 1.2.0, we have many issues when these run together: • Dispatcher.Main fails in normal unit tests when recording screenshots ◦

java.lang.IllegalStateException at MainDispatchers.kt:115

◦

Caused by: java.lang.IllegalStateException at MainDispatchers.kt:115

◦

Caused by: java.lang.IllegalStateException at HandlerDispatcher.kt:55

• Android Lint linting our dependencies (probably some classpath manipulation?) ◦

/builds/mobile/android/cache/.gradle/caches/modules-2/files-2.1/org.bouncycastle/bcpkix-jdk15on/1.67/5f48020a2a60a8d6bcbecceca23529d225b28efb/bcpkix-jdk15on-1.67.jar: Error: checkClientTrusted is empty, which could cause insecure network traffic due to trusting arbitrary TLS/SSL certificates presented by peers [TrustAllX509TrustManager]

So what approach you would suggest? We have tens of modules, so separating screenshot test to separate modules is not something we would prefer. We are considering JUnit suite or other filtering, but I guess this must be an issue for everybody. Thank you.

Adam S

05/31/2023, 4:04 PM

hi 👋 I’m trying to convert some Kotlin/JVM code to Kotlin Multiplatform, so I’m using Okio. The class in question reads an InputStream, determines the BOM (byte order mark), and then provides a correct stream. I can replace the InputStream with an Okio Source, and I can determine the correct encoding from the BOM, but I’m struggling to figure out how to use Okio to read a string with a different encoding. I’ve gotten pretty close, but if I try and

peek()

past the BOM, Okio always throws an exception. There’s no KDoc so I’m not clear what it’s for.

Marc

06/01/2023, 5:31 AM

Hey I am trying out redwood and I am a bit confused as to how to implement widget schemas

Håkon Pettersen

06/03/2023, 2:46 PM

When working with SQLDelight migrations, I have set up migration to execute using the following code:

Copy code

Database.Schema.migrate(
    driver = driver,
    oldVersion = 0,
    newVersion = Database.Schema.version,
)

I assume that this won't work if the user is currently on version 2, and I am trying to migrate to version 3. I assume that I have to check which version of the database the user is currently on and only execute migration if it is lower than the latest version. If that's the case, how can I check the current database-verison that the user is on? (Also, If this is the wrong way to handle migrations, please elaborate).

Nacho Ruiz Martin

06/05/2023, 4:45 PM

👋 After updating to the latest SQLDelight version (2.0.0-rc01 (2023-05-30)) I can’t change the sourceFolders using the gradle configuration. I have this:

Copy code

databases {
        create("X") {
            ... other config ...
            sourceFolders.set(listOf("db"))
        }
    }

And the last line is throwing:

Function invocation 'sourceFolders(...)' expected

But, at the same time,

sourceFolders

is a private function inside

SqlDelightDatabase

sourceFolders

is supposed to be a public variable of type

ListProperty<String>

✅ 1