is there an easy way I can just run the migrations...
# prisma-migrate
b
is there an easy way I can just run the migrations for a (simple) postgres database on a local sqlite instance for integration testing?
1
a
Hey there! If you are trying to run the actual
.sql
files from your
migration
folder, I don’t think they would work against SQLite if they were generated using a Postgres database. If you only cared about the end state of the database schema, you could potentially maintain a separate Prisma schema for your testing database. Then you could generate and import your SQLite Prisma Client in your integration tests. Relevant docs
b
ah I feared that would be the case, I was hoping there was a way to generate two sets of migrations from one schema
as we can already generate code for multiple languages
I’ll avoid it for now, but thanks for the suggestion!
👍 1