using string as id

Question

I am making a KMM app using SQLDelight for the cache and recently I changed my database entities to use Text(String) for the id field instead of Int, now i am getting an error when inserting, I might just be missing some sqlDelight knowledge

here is my table:

 CREATE TABLE sidework_Entity(
   id TEXT NOT NULL PRIMARY KEY,
   name TEXT NOT NULL,
   employees TEXT NOT NULL,
   todoToday INTEGER AS Boolean DEFAULT 0
);

here is my insert method:

insertSidework:
INSERT OR REPLACE
INTO sidework_Entity(
       id,
       name,
       employees,
       todoToday
) VALUES (?,?,?,?);

here is my error:

statement aborts at 5: [INSERT OR REPLACE
    INTO sidework_Entity(
           id,
           name,
           employees,
           todoToday
    ) VALUES (?,?,?,?)] datatype mismatch

I think it is most likely the Primary Key i have set on the id field or something of that sort but the documentation is a bit short.

Answer 1

The solution to this problem is actually running a migration. Although deleting the app to clear the database cache is a valid solution for testing purposes. For an app in production, this isn't the correct approach.

Documentation for running Migration

Stackoverflow answer with explanation