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?
