How to automatically run migration on NextJS start
The docs is not clear on how to do it. It still uses
npx tsx src/index.ts which is a CLI command instead of runtime.
[SOLVED] "Not enough info to infer relation", many-to-many junction table w/ postgres
I have read the posts online that say you must define relation names on both sides, and I already did that, but it still isn't working. Can anyone else spot an issue here? I have a junction table representing a many-to-many relationship. The way it is organized in my schema can be seen in the following link, and the way I am trying to query it can be seen in the attached picture.
The TLDR of the schema: templateDefinition has many colorSets, colorSets have many templateDefinition. I want to query templateDefinition to include colorSets from the junction table https://gist.github.com/Connorelsea/76f12181ec4205533bdc4329970a6f66...
The TLDR of the schema: templateDefinition has many colorSets, colorSets have many templateDefinition. I want to query templateDefinition to include colorSets from the junction table https://gist.github.com/Connorelsea/76f12181ec4205533bdc4329970a6f66...
Orphaned Children tables after a successful migration
I was able to bypass sqlite constraint error by using PRAGMA foreign_keys option but it left my database in a corrupted state where children tables of
ticket_order are referring to the temporary and now deleted ticket_order_old table
``sql
PRAGMA foreign_keys=off;--> statement-breakpoint
ALTER TABLE ticket_order RENAME TO ticket_order_old`;--> statement-breakpoint...
