Seeding production db

[felixyeboah]

i’ve been going through the documentation for seeding production database and i don’t know if i’m doing something wrong. i followed the process of creating another script similar to prisma/seed.ts. after running the script and also running the dump script, the dump sql file seems empty. there’s nothing in that file.

also, i want to state, i have multiple migration files due to additions made to the schema file and i don't know if thats the cause of the issue.

any help with this please 🙏

[kentcdodds]

Hi @felixyeboah,

It's hard to say what's wrong without seeing an example of the exact steps you took because you probably missed a step or got something wrong.

[kentcdodds]

Sorry, to be more clear, the step you got wrong is the "run your seed script" step. That's probably my fault because it's not clear how to do this. You don't run prisma db seed to run your custom script and have it pointing to a custom database.

I've updated the docs to be more clear: https://github.com/epicweb-dev/epic-stack/blob/main/docs/database.md

Thanks for your patience and persistence!

[felixyeboah]

this is clear. got it now. thank you so much for the help. God bless you

[felixyeboah]

@kentcdodds I have one more question based on this step:

5. Copy the relevant bits from the seed.local.sql file into your migration.sql file. The seed.local.sql will include create table/index lines etc. which should already be in your migration.sql. You probably just want INSERT commands.

my question: say I have multiple migration.sql files, which of them do I include the INSERT commands? is it the first migration.sql file or the last migration.sql file?

[kentcdodds]

Put them wherever it makes sense. Probably the last one.

[felixyeboah]

thanks