Hey, I created a new .sq file, which has CREATE TA...

# squarelibraries

[Andrew O Hart]

Hey, I created a new .sq file, which has CREATE TABLE LastModificationDate(lastModificationDate TEXT NOT NULL);
This causes a crash when testing against our production app as it says LastModificationDate.
no such table: LastModificationDate: , while compiling: SELECT * FROM LastModificationDate

I'm not sure how I am meant to migrate this new table, in the .sqm file I don't think I'm altering anything as its actually just a new table, so should I be creating the table in the .sqm?
If so, how does that work with the functions that exist in LastModificationDate such as insert/get/delete

[alec]

you need to create the table in a migration file. You dont need to create queries in a migration file

[Andrew O Hart]

@alec just saw your message, thanks.
So I created a 1.sqm file with CREATE TABLE LastModificationDate(lastModificationDate TEXT NOT NULL);
Then in my LastModificationDate.sq, i just have the queries such as insert, get, delete?

[Andrew O Hart]

If the case, LastModificationDate.sq it shows 'no table found with name LastModificationDate'

[alec]

you need the create table in both .sq and .sqm

[Andrew O Hart]

Thanks. I actually just tried rebuild it with only CREATE TABLE in 1.sqm, and just the queries in the LastModificationDate.sq and it seemed to build correctly.

[Andrew O Hart]

When i try it by creating a table in both .sq and .sqm, i get

[Andrew O Hart]

'Table already defined with name LastModificationDate'

[alec]

i see, you have deriveSchemaFromMigrations = true

[Andrew O Hart]

No I don't, should I add it?

[Andrew O Hart]

Sorry, I actually do have it added, forgot that I added it earlier

[Andrew O Hart]

Another thing I noticed was all my DAO related tests for Android were failing, it was fixed by moving all my other CREATE TABLE in the other .sq files to the .sqm file, is this a normal part of the process?

[Andrew O Hart]

Adding them to the .sqm file makes the tests pass but the actual app crashes on migration