Migration

[JosepAjith]

How migrate floor Database

[vitusortner]

You can find instructions here: https://floor.codes/migrations/

[neeluagrawal04]

can't open the link

[Amir-P]

Check this out: https://vitusortner.github.io/floor/migrations/ @neeluagrawal04

[zmm2tysu]

@Amir-P can't open either

[ThomasMiddel]

@zmm2tysu You can find the updated link here: https://pinchbv.github.io/floor/migrations/

[Soliardi-Chyngyz]

Anyone could help me with primery keys?

I added: skiPass, date
https://github.com/entity(primaryKeys: ['entityType', 'id', 'skiPass', 'date'])

but this doesn't work and show error
final migration1to2 = Migration(1, 2, (database) {
return database
.execute('ALTER TABLE TariffEntity DROP PRIMARY KEY, ADD PRIMARY KEY(skiPass, date)');
});

tried 'ALTER TABLE TariffEntity DROP PRIMARY KEY, ADD PRIMARY KEY(skiPass, date)' nothing

[dkaera]

Hey, SQLite doesn't support replacing the primary key in this way.
So, you need to follow next steps:

// Create copy of table with a new PRIMARY KEY
await database. execute ( 'CREATE TABLE TariffEntityCopy(id INTEGER, skiPass TEXT, date TEXT, PRIMARY KEY (skiPass, date));
// Copy all data from the original to the copy
await database. execute ('INSERT INTO my_table_copy (id, skiPass, date) SELECT id, skiPass, date FROM TariffEntity');
// Copy drop the original table
await database.execute ('DROP TABLE TariffEntity');
// Rename copy of the table to original
await database. execute ( 'ALTER TABLE TariffEntityCopy RENAME TO TariffEntity');