How should I do custom migrations?
I am trying to do migrations in sqlite and sometimes drizzle will leave a comment in the migration file saying it cannot add constraints to existing columns, I understand it is necessary but it'd be appreciated if there was better documentation on how to achieve these things without leaving drizzle too much.
I feel like the whole migration process from drizzle-kit is not that clear and its quite hard to understand what are its limitations. For instance, I had a 0005_etc migration file written by me (I guess this is necessary to keep it version-controllable) and it used
Now, trying to run my 0006_etc file I am getting
- Does running
- Why can't it point me to the file/statement that is erroring?
- how are
- Can I turn on/off foreign keys during migrations?
I feel like the whole migration process from drizzle-kit is not that clear and its quite hard to understand what are its limitations. For instance, I had a 0005_etc migration file written by me (I guess this is necessary to keep it version-controllable) and it used
BEGIN TRANSACTION;Now, trying to run my 0006_etc file I am getting
SQL_MANY_STATEMENTSSQLite error: cannot start a transaction within a transaction- Does running
drizzle-kit migrate- Why can't it point me to the file/statement that is erroring?
- how are
--> statement-breakpoint- Can I turn on/off foreign keys during migrations?
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
