Closed ellisjasmine closed 3 months ago
Sorry to reopen this but I have the same problem. I define my schema and then run a query, but I get an error in the console:
SQLite3Error: SQLITE_ERROR: sqlite3 result code 1: no such table: institutions
at toss3 (sqlite3-bundler-friendly.mjs?v=28ec45dd:10701:17)
at checkSqlite3Rc (sqlite3-bundler-friendly.mjs?v=28ec45dd:10720:13)
at DB.checkRc (sqlite3-bundler-friendly.mjs?v=28ec45dd:11033:42)
at OpfsDb.exec (sqlite3-bundler-friendly.mjs?v=28ec45dd:11167:20)
at SQLocalProcessor.value [as exec] (processor.js?v=28ec45dd:171:50)
at SQLocalProcessor.value [as postMessage] (processor.js?v=28ec45dd:112:30)
at SQLocalProcessor.value [as flushQueue] (processor.js?v=28ec45dd:370:26)
at SQLocalProcessor.value [as init] (processor.js?v=28ec45dd:91:22)
In the tests I see that tables are manually created: https://github.com/DallasHoff/sqlocal/blob/main/test/drizzle/driver.test.ts but the correct way would be to generate a migration. Is there a way to solve this? @ellisjasmine do you have any suggestions?
See #32
I'm having problems connecting tables I define with my database. In the drizzle docs they mention migrations however it's not clear how to make this work with SQLocal.
My code follows the readme pretty closely. The database is created successfully but I can't insert anything into the table.