hello all, my kmp app uses com.sqaureup.sqldelight, it has some tables which now needs alteration i ...

# multiplatform

[Priyansh Nama]

hello all, my kmp app uses com.sqaureup.sqldelight, it has some tables which now needs alteration
i am stuck in adding migration plans to this, can someone help, details in thread 🧵

[Priyansh Nama]

build.gradle.kts (shared)

sqldelight {
    database("MyDb") {
        packageName = "com.example.some.db"
        sourceFolders = listOf("sqldelight")
        verifyMigrations = true
        deriveSchemaFromMigrations = true
    }
}

[Priyansh Nama]

there is a file at /commonMain/sqldelight/com/example/some/db/MusicGenre.sq

createTableIfNotExists:
CREATE TABLE IF NOT EXISTS MusicGenres (
    id TEXT NOT NULL PRIMARY KEY,
    title TEXT NOT NULL,
    thumbnail_url TEXT NOT NULL,
    selected INTEGER NOT NULL
);

setAllMusicGenres:
INSERT OR REPLACE INTO MusicGenres(id, title, thumbnail_url, selected)
VALUES(?, ?, ?, ?);

[Priyansh Nama]

now we need to add a new column to this table for this
i created a file 1.sqm at
/commonMain/sqldelight/com/example/some/db/migrations

ALTER TABLE MusicGenres ADD COLUMN type TEXT NOT NULL DEFAULT '';

[Priyansh Nama]

Error i get in 1.sqm file is
Attempting to alter something that is not a table
No table found with name MusicGenres

[Muaz]

Make sure to add column creation statement in 1.sqm as well with the new column;
CREATE TABLE IF NOT EXISTS MusicGenres (
id TEXT NOT NULL PRIMARY KEY,
title TEXT NOT NULL,
type TEXT NOT NULL DEFAULT ''
thumbnail_url TEXT NOT NULL,
selected INTEGER NOT NULL
);

[Priyansh Nama]

tried this

1.sqm

CREATE TABLE IF NOT EXISTS MusicGenres (
    id TEXT NOT NULL PRIMARY KEY,
    title TEXT NOT NULL,
    type TEXT NOT NULL DEFAULT '',
    thumbnail_url TEXT NOT NULL,
    selected INTEGER NOT NULL
);

ALTER TABLE MusicGenres ADD COLUMN type TEXT NOT NULL DEFAULT '';

file generated

public data class MusicGenres(
  public val id: String,
  public val title: String,
  public val type: String,
  public val thumbnail_url: String,
  public val selected: Long,
  public val type: String
) {
  public override fun toString(): String = """
  |MusicGenres [
  |  id: $id
  |  title: $title
  |  type: $type
  |  thumbnail_url: $thumbnail_url
  |  selected: $selected
  |  type: $type
  |]
  """.trimMargin()
}

type is added 2 times, hence an error ?

[Muaz]

I have added and tested migrations on the Android side for SqlDelight. In my opinion, it should be similar in multiplatform. You can check it here; https://github.com/muazdev26/Notsi/tree/master/app/src/main/sqldelight/com/muazdev/notsi

[Chrimaeon]

better to ask in #squarelibraries

[Priyansh Nama]

thanks