Has anyone gotten sqldelight to be accessible for jsBrowserTest? I have been messing with karma.config files and haven't been able to crack it. I can see the wasm file in the correct tmp folder but it isn't able to be accessed by the tests

Hi -- i have a question about how code generators work. What all does

projectFiles

encompass? Is it divided up by gradle target?

Does sqldelight sanitize the sql it runs??

Is it possible to return a max value from a table in SQLDelight? I'm trying

retrieveMostRecentLastModificationDate:
SELECT MAX(Information.lastModificationDate) FROM Information LIMIT 1;

And it is returning Query<RetrieveMostRecentLastModificationDate> I just need to return the most recent date from the table, so I would expect it to return as an Int or a Long as we are storing it using toEpochMilliseconds

It's more a general question than specific to okhttp, but when Android only provides

HttpURLConnection

as http client, every 3rd party has to be based on

HttpURLConnection

and so okhttp too or not? But since Android 4.4

HttpURLConnection

uses okhttp as http engine. This confuses me a bit. Does that mean okhttp is not based on any other API and is written from scratch? Can someone enlighten me please?

I've been trying to integrate SQLDelight for a couple of days now, and have failed. See the thread for more info.

Hello! I'm using SQLDelight for my project and I'm trying to understand what's the "correct" way of doing a query returning a Flow. My goal is to make sure the DB access happens on

IO

and the transformation of data happens on

Default

. I have something like this:

fun someQuery(): Flow<List<SomeItem>> = database.transactionWithResult {
  database.someQueries.someItems(someMapper)
    .asFlow()
    .flowOn(IO)
    .mapToList()
    .distinctUntilChanged()
    .map { someTransformation(it) }
    .flowOn(Default)
}

Is the

flowOn(IO)

required?. What about this:

...
  database.someQueries.someItems(someMapper)
    .asFlow()
    .mapToList(IO)
    .distinctUntilChanged()
    .map { someTransformation(it) }
    .flowOn(Default)
...

Would that make any difference? From my understanding,

mapToList()

will use

Default

if we don't pass a context but I want to make sure

IO

is used during the DB access and

Default

during the transforming the data. Thanks in advance!

I’ve just published https://github.com/charleskorn/okhttp-system-keystore/, a small library that makes it easy to use trusted certificates from the operating system keystore (Keychain on macOS, Certificate Store on Windows) with OkHttp. Feedback, suggestions and ideas welcome 🙂

My app has a typical OAuth flow in terms of, 401 comes into the app, the app (via an interceptor) detects this 401, and tries to exchange the refresh token for a new set of auth and refresh tokens. This works great with okhttp interceptors... but I've noticed in cases where the user comes back to the app and 2 network calls are made at the same, I will get two 401s, and therefore (unfortunately) my interceptor will trigger twice. Anyone have any guidance/experience around this. My initial reaction is to write some sort of state to my user

isAuthRefreshInProgress

and short-circuit the interceptor if it's already in progress, but then I'm not sure how I'd wait for the auth refresh to be complete, so I can make that second call again. Here's a gist of my current interceptor.

With any luck, in a year or two we'll have a Kotlin-first Retrofit where it won't matter

When implementing a new driver, is there any mechanism in sqldelight to translate the

?

placeholders (like

INSERT INTO a VALUES (?, ?)

) to something else, e.g.

($1, $2)

, if the underlying driver doesn't like the question marks?

if you want to wait on wall-clock time you can do

withContext(Default) { delay(2.seconds) }

and then assert no events were received

Hello, about

okio

, is there a way to read a path using

ByteReadChannel

? I am trying to create a multiplatform image loading library and I want to create something like this: https://github.com/alialbaali/Kamel/blob/main/kamel-core/src/jvmMain/kotlin/io/kamel/core/fetcher/JvmFileFetcher.kt

With the latest release of turbine I’m seeing a behavior change I can’t make sense of. Basically it boils down to this test case failing:

private fun contentFlow(): Flow<Int> {
    return combine(
      flowOf(Unit),
      flowOf(2).onStart { emit(1) }
    ) { _, b ->
      b
    }.onEach { println(it) }
  }

  @Test
  fun turbineCollect() = runTest {
    contentFlow()
      .test {
        check(awaitItem() == 1)
        cancelAndIgnoreRemainingEvents()
      }
  }

  @Test
  fun regularCollect() = runTest {
    check(contentFlow().toList() == listOf(1, 2))
  }

https://github.com/cashapp/turbine/issues/112

generally seems like people point to this wiki to answer those questions https://github.com/yapstudios/YapDatabase/wiki/SQLite-version-(bundled-with-OS)

hi all, i am using issue integrating sqldelight with KMM with ``app.cash.sqldelightsqlite 3 38 dialect2.0.0-alpha02``, it is working for android, but not for the ios

I am trying to use SQLDelight 2.0.0-alpha02 but it seems like I'm missing something with the setup. Using the guide ( https://cashapp.github.io/sqldelight/android_sqlite/ ) but then replacing it with the new namespace

app.cash.sqldelight

and version

2.0.0-alpha02

gradle seems to be a bit unhappy. I'm using AS Dolphin Canary 9.

While it's not explicitly mentioned in the docs, but is sqlite-android from Requery the preferred method to get a json1 compatible sqlite version in SQLDelight (on Android)? Looks like using:

dialect = "app.cash.sqldelight:sqlite-3-35-dialect:2.0.0-alpha02"

With:

implementation 'com.github.requery:sqlite-android:3.36.0'

and this is working quite well:

val driver = AndroidSqliteDriver(
            schema = MyDatabase.Schema,
            context = this,
            name = "test.db", 
            factory = RequerySQLiteOpenHelperFactory()
        )

I'm using Retrofit with Gson, and and when some field is incorrect, I'm not receiving an exception until try to read the value - only then I'm getting a

NullPointerException

Is there a way to enable exceptions for non null fields when deserialization fails?

SQLdelight and gradle magic: How can you add a dependency to a local dialect? I hoped, simple setting

dialect = ":native-dialect

would work.

Can I make the SQLDelight generated classes

internal

?

We've had samples running on Android, iOS, and the browser for a year, we're rolling it out in projection in the next few weeks, and it's entirely built as a standalone tool so it can be open sourced once we finish polishing it as an offering

When using

sqlDelight

how do you usually combine relations to keep everything reactively observable? Let's say I have a

User

and

Comment

tables, each user has many comments. And now I build a list of users with comments:

val users: List<User> = database.userQueries.select_all { userId, userName ->
  val comments = database.commentQueries.find_by_user_id(userId).executeAsList()
  User(userId = userId, name = userName, comments = comments)
}.executeAsList()

But now I want to create a

Flow<List<User>>

. I have no problem doing

val usersFlow = database.userQueries.select_all(...).asFlow()

But this won't emit if individual comment changes, won't it? So I need to do

asFlow

on each individual user's "comment"-query and then flatMap them, this gets complicated suddenly. Is there a nicer way?

yep, here's an example: https://github.com/saket/press/blob/trunk/shared/src/macosTest/kotlin/me/saket/press/shared/db/BaseDatabaeTest.kt

Probably https://github.com/touchlab/SQLiter/issues/7 and https://github.com/cashapp/sqldelight/issues/3241

Hi, all! Does anyone know how to use JavaNetCookieJar to collect cookies from multiple redirects? I’ll post more info in a thread below.

Hi team -- I have some questions about Anvil. I am trying to autogenerate both a

MergeModules

and a

MergeComponent

that depends on that

MergeModules

. It looks something like this:

@MergeModules(scope = MyScope::class)
public interface MyModule

@MergeComponent(
  scope = AnvilScope::class,
  dependencies = [],
  modules = [MyModule::class]
)
public interface MyComponent

However, Anvil complains that it can't resolve

MyModule

even though they are defined in the same generated file. Any thoughts?

Duplicated the files for now 😕

Is it possible to let paparazzi only do a screenshot of the actual composable? For example here I’d like to have the composable without the statusbar and with the whole screen height.

@rkeazor can you elaborate?