elaranthedreamer
DTDrizzle Team
•Created by elaranthedreamer on 8/23/2023 in #help
Is there a --force option for generating migrations in CI?
I understand. Thanks for taking the time to discuss this 🫶 . We'll adapt our workflow to the intended process. You guys rock!
21 replies
DTDrizzle Team
•Created by elaranthedreamer on 8/23/2023 in #help
Is there a --force option for generating migrations in CI?
This is our workflow
1. In development
- Team member changes a schema file
2. Opens PR → CI runs in postgres docker container
- Generate temporary migrations to apply the new changes <— The step we are talking about (using
drizzle-kit generate:pg)
- Apply all migrations to the freshly created Postgres instance (using Drizzle migrator)
- Run e2e tests on the temporary instance
- Done
3. PR is merged into main → CD runs
- Generates migrations again
- Applies migrations to real database
- Commits new migration files to the repo
Failure potential lies within the fact that the raw SQL migration files are not as intuitive to review and can simply be forgotten easily. Overall this setup allows us to only change the actual schema and leave the rest to CI/CD, leaving out any possibility for human failure.21 replies
DTDrizzle Team
•Created by elaranthedreamer on 8/23/2023 in #help
Is there a --force option for generating migrations in CI?
@Raphaël M (@rphlmr) ⚡ Thanks for the fast reply! For us it's a matter of consistency + letting people generate the migration files locally adds failure potential to the whole process. Though I totally understand if this is not one of your priorities right now!
21 replies
DTDrizzle Team
•Created by elaranthedreamer on 8/17/2023 in #help
Relational Queries: How to query based on the value of a joined table?
Thank you so much this helps a lot @angelelz
7 replies