Import .db file and work from that database

[tiagoggdev]

Hi, first sorry for my english, I need help
I have a .db file in my directory and I need import this db for i need import get and update data from my tables.
Basically I don't need to create my database with code but rather adapt the code for an already created database, something like that a database first model.

I didn't find any information in the documentation on how to import a database file, somebody can tell me if its can do it?

[simolus3]

So essentially if I understood you correctly, you have an existing database file and no existing database code, right? And now you want drift to generate code based on tables defined in that database file?

There's no builtin option that does all of that, but you can open the database on the command line using sqlite3 path/to/file.db. Then, you can run select group_concat(sql || ';', '') from sqlite_schema; and copy the outputs. Create a file named .drift somewhere under lib that contains the CREATE TABLE statements listed.

Then, you can use this setup to define a drift database following the schema from your database.