significantotter Posts - Answer Overflow

significantotter

Explore posts from servers

DIAdiscord.js - Imagine an app KKysely DTDrizzle Team

•Created by significantotter on 9/14/2023 in #help

Nesting sqlite drizzle into a deeper location in my ts app, difficulties with src/ vs dist/

Hey! I'm very new to drizzle and trying to set up a very small drizzle instance for a service that reads a whole pile of json files and acts as a simple read-only information store. I got most of the setup to work. I have it at a location

src/
--services/
----this-service/
------drizzle.config.ts
------sqlite.db
------schema.ts
------this-service.db.ts

src/
--services/
----this-service/
------drizzle.config.ts
------sqlite.db
------schema.ts
------this-service.db.ts

I have some the command in my package.json

"migrate:this-service": "cd ./src/services/this-service && drizzle-kit push:sqlite"

"migrate:this-service": "cd ./src/services/this-service && drizzle-kit push:sqlite"

This works, but it appears that once I build, the sqlite isn't copied over to the /dist directory. When I then try to call this-service.db.ts, after instantiating drizzle on sqlite in its directory, it doesn't see any of the proper tables from the schema in the sqlite.db file. Is there a way to make this work? Or do I have to move this all to the root directory? One option would be is if there are importable drizzle kit functions to replicate the CLI options. I didn't see that in the documentation. Is that possible?

13 replies

Gaming

Programming