Programmatic Database Migration without migrations folder
I'm curious if there's a way to programmatically run the migration without the need for the migrations folder.
I have a mono repo with an
api
library that uses my db
package. I'm creating tests for the api
and was going to recreate the db before each test run. I was going to run the migrate
function from drizzle-orm/mysql2/migrator
but it requires the migrationsFolder
path to be supplied as an argument. Since I'm in a mono repo, this path will vary based on the relative paths of my tests and the db
package. I can't put those paths in my test files.
Since the tables are defined in typescript, is there a way to directly in code to create the table without first doing a generate
and then a migrate
?0 Replies