Hey! I was wondering how to resolve an issue where...

# squarelibraries

[Tech]

Hey! I was wondering how to resolve an issue where SQLDelight can't resolve tables in my migration files.
Using the Postgres dialect, thank you.

[Tech]

Migrations seem to work but it just can't resolve the tables.

I was also wondering if I could properly name the migration files to <DATE>_<NAME>_<ID>.sqm instead of just <ID>.sqm

[griffio]

🤔 Have a look at https://github.com/griffio/sqldelight-postgres-01
Where I list various issues and pending fixes with migrations sqldelight 🔨
Are you seeing a compile error?
There appeared to be an issue with flyway where using post-fix id caused the ordering to go wrong.

[Tech]

There’s no compile error but it simply doesn’t resolve the table and its fields when typing in

[griffio]

🐛 Maybe raise an issue if you can https://github.com/cashapp/sqldelight/issues where you think it should be working…
Sadly - I don’t know myself

[Tech]

Yeah it’s a weird one where my SQM files are compiling properly but when I’m typing them out it can’t resolve my table names and stuff so it shows an error.

I believe when I was researching this I saw a very similar issue that was marked as would be fixed in 2.0 but even when I asked one of my friends to test it out they also had the same issue.

Might be user config but I followed the docs so not sure

[Kev]

What does your gradle configuration look like?