Clarification on how to handle migrations

[pc-erin]

Clarification on how to handle migrations

[stuible]

I am also struggling with this issue. Would love to see some improvements in the documentation around this area!

[pc-erin]

I know you can use prisma's seeding feature to inject database entries. Maybe we're supposed to put all our dev data in a seed file? If so it would be good to have the docs mention that.

It might still be an issue for projects where you need to constantly be changing data during development and testing. Same for projects that involve file/image uploads since I'm not sure how you'd put those in a seed file.

I've been reading through the docs, and the only other way I can see to do migrations is to change your dev script to keystone dev --no-db-push, which doesn't make any database changes, so you have to manually run keystone prisma migrate dev each time you change the schema.

I also tried to figure out a way to get back to a working state after using the default push behavior, without deleting all the dev data.

You can use:

keystone prisma migrate diff --from-migrations migrations --to-schema-datasource schema.prisma --script --shadow-database-url='[SHADOW_DATABASE_URL]' > migrations/[migration_number_and_name]/migration.sql

To create the missing migration.

Then run keystone prisma migrate resolve --applied [migration_number_and_name], to tell the database that the missing migration has already been applied.

After that the database should be fully up to date with the migrations, and you can switch over to using the --no-db-push manual migration mode.

Not sure if that's how it's intended to be done, but those are my workarounds so far.