ExpoSQLite migration immediately fails... How to solve (without deleting migration files)?
I am trying to run my first update migrations after my first DB change (after initial migration to create initial migration from schema)...
But the migration immediatey fails:
0000_migration_file.sqlCREATE TABLE `categories` ( `id` text PRIMARY KEY NOT NULL, `name` text NOT NULL, `wordIds` text NOT NULL, `type` text NOT NULL, `deletedAt` text, `learning` integer DEFAULT 0, `targetLanguage` text DEFAULT 'DE' NOT NULL);--> statement-breakpointCREATE TABLE `daily_progress` ( `date` text PRIMARY KEY NOT NULL, `metricType` text PRIMARY KEY NOT NULL, `count` integer NOT NULL);[...]
0000_migration_file.sqlCREATE TABLE `categories` ( `id` text PRIMARY KEY NOT NULL, `name` text NOT NULL, `wordIds` text NOT NULL, `type` text NOT NULL, `deletedAt` text, `learning` integer DEFAULT 0, `targetLanguage` text DEFAULT 'DE' NOT NULL);--> statement-breakpointCREATE TABLE `daily_progress` ( `date` text PRIMARY KEY NOT NULL, `metricType` text PRIMARY KEY NOT NULL, `count` integer NOT NULL);[...]
It already fails on the first migration file... but why? This shouldn't even run, no? Those tables were already created on the first app run.
I would expect this one and the one before (0001) to be running via the
I would expect this one and the one before (0001) to be running via the
const { success, error } = useMigrations(drizzleDb, migrations)` method. But it seems it tries to run the first migration which I believe shouldn't be executed (?)
I used npx drizzle-kit generate before to generate my migration files. Anyone got experience with Expo/SQLite & Drizzle failing migrations? Am I forgetting anything? Thanks!