Oh. I thought if I call the service method then it would delegate to the actual implementation. I'll try that when I'm back at desktop.

Alright. This is my end result for the MockApiService. getFullName calling getFullName does seem like something could be improved there, but this gets me to my goal of being able to swap out my ProdApi with a MockApi which would allow me to work on the app even while I'm on an airplane. Thanks everyone!

class MockApiService(delegate: BehaviorDelegate<NetworkBackedApiService>) :
    NetworkBackedApiService {
    private val delegate: BehaviorDelegate<NetworkBackedApiService> = delegate
    override fun getFullName(user: String?): Call<String>? {
        return delegate.returning(Calls.response("Colton Idle")).getFullName(user)
    }
}

I still want to play around with this to see if I can add in artificial delays for the network calls and set errors for certain calls, etc, but this is cool for the time being.

the behavior delegate can do both of those things for you

Oh cool. It does, but it has to go in my app code and can't be done on a per call basis like I'm trying here

hello. in sqldelight, is there any standard way of performing migrations, outside sqm files? For instance, imagine i want to rename a column (rename table, create new one, copy data), but i need to access a const for the table name. How would i accomplish this ?

you can do it in your SqliteOpenHelper’s

onMigrate

function

ok. thanks

Hey all! regarding sqldelight, do you have to migrate even when just using emulator/simulator? I've got a KMM project and at the moment I'm running IOS tests that are failing with the following error:

chorgi.data.DatabaseTest.updateCharacterAbilitiesSetsAbilityScores STANDARD_OUT
    Invalid connection: com.apple.coresymbolicationd

chorgi.data.DatabaseTest.updateCharacterAbilitiesSetsAbilityScores FAILED
    kotlin.Exception: android/database/sqlite/SQLiteException - no such column: strength (code 1): , while compiling: UPDATE character

but sqldelight knows nothing about what an emulator or simulator is in relation to an actual phone and it knows nothing about your local debug builds in relation to builds which are published to app stores

if you have an existing database and you change the schema you're going to have to do something to make it work, yes

Probably overthinking this, but in Retrofit I just have a question about how baseUrls should be defined. Should base url be

"<https://myapi.com/>"

and an api call be

@GET("auth/login")

or leave off the trailing

/

in baseUrl and have an api call be

@GET("/auth/login")

Reason why I ask is that retrofit homepage shows:

.baseUrl("<https://api.github.com/>")

and

@GET("users/{user}/repos")

While retrofit samples has a SimpleService that does:

API_URL = "<https://api.github.com>"

and

@GET("/repos/{owner}/{repo}/contributors")

It works like

<a href="">

so you can do whichever you want

The behavior is documented on the baseUrl builder method

I believe it's also linked from each HTTP annotation's docs

It's also showing an red underline error even in the sqm files themselves. I'm wondering if it's an ordering issue in gradle. I'm aslo receiving these warnings:

- Gradle detected a problem with the following location: '.../shared/build/generated/sqldelight/code/ChorgiDatabase'. Reason: Task ':shared:sourcesJar' uses this output of task ':shared:generateIosMainChorgiDatabaseInterface' without declaring an explicit or implicit dependency. This can lead to incorrect results being produced, depending on what order the tasks are executed. Please refer to <https://docs.gradle.org/7.0/userguide/validation_problems.html#implicit_dependency> for more details about this problem.

Hi all, I’m using SqlDelight in a Ktor application, with MySql. I’m just curious, when is the appropriate time to call

MyDatabase.Schema.create

on application startup you'll want to check the database version and conditionally create/migrate as needed

Yeah, I thought as much. I’m doing something similar on Android with SqlLite, using the

PRAGMA user_version

to figure out the current db version

yep. that's what i do, too: https://github.com/JakeWharton/dodo/blob/trunk/src/main/kotlin/com/jakewharton/dodo/db.kt

i'm pretty sure on Postgres you have to use a table not a pragma. I've never used MySQL though so pragma might work. I'm using sqlite.

Yeah, I think the schema version is buried somewhere in the ‘information_schema’ db in MySql, but I can’t figure out where. Unfortunately the keywords ‘database version’ yield quite a few unrelated results

Thanks, at least I know this is the normal approach

i've always seen people just make their own little table to track it

OK, I’ll give it a crack

Ideally never.

Here's one thing we can do: https://github.com/cashapp/sqldelight/issues/2334

But that auto migration stuff is... kinda trash

They trade an industry standard language whose knowledge is transferrable across domains and for which there exists near-limitless books and tutorials to learn for a bespoke, proprietary, stringly-typed annotation syntax that can only support a subset of operations. Do not want.

Room is an sql framework which pretends users don’t need to know sql. A lot of people ready to jump on that so Google delivers.