Prod database and Test database in Drizzle
I would like to know how you are dealing with having a test (or dev) database in your projects beside the prod database.
As I'm using postgre, all my environments are in the same database, just with different schemas.
How should that reflect in my drizzle files ? Should I declare each table and each column 3 times ? (for prod, dev and test)
I can't just use an env variable, because each time I change its value and try to migrate, drizzle delete the previous schema.
As I'm using postgre, all my environments are in the same database, just with different schemas.
How should that reflect in my drizzle files ? Should I declare each table and each column 3 times ? (for prod, dev and test)
I can't just use an env variable, because each time I change its value and try to migrate, drizzle delete the previous schema.
