Inserting data with migration file
Is there a way to insert data to a table that has foreign keys?
I get an error:
Error: P3006
Migration
Error:
insert or update on table "<table_name>" violates foreign key constraint "<constraint_name>"
0: sql_migration_connector::validate_migrations
with namespaces=None
at migration-engine/connectors/sql-migration-connector/src/lib.rs:297
1: migration_core::state::DevDiagnostic
at migration-engine/core/src/state.rs:264
ELIFECYCLE Command failed with exit code 1.
SQL command seems to be correct and the entry on the other table is present.
I get an error:
Error: P3006
Migration
20240702073109_migration_name failed to apply cleanly to the shadow database. Error:
insert or update on table "<table_name>" violates foreign key constraint "<constraint_name>"
0: sql_migration_connector::validate_migrations
with namespaces=None
at migration-engine/connectors/sql-migration-connector/src/lib.rs:297
1: migration_core::state::DevDiagnostic
at migration-engine/core/src/state.rs:264
ELIFECYCLE Command failed with exit code 1.
SQL command seems to be correct and the entry on the other table is present.
