How do I add a relationship to an existing table alembic sqlalchemy?

Asked Feb 10 '23 at 14:01

Active Feb 10 '23 at 14:04

Viewed 71 times

I'm doing an update on the existing table. I add new relation and Foreign Key Constraint. But i am getting error;

sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (3780, "Referencing column 'product_id' and referenced column 'id' in foreign key constraint 'product_categories_ibfk_2' are incompatible.")

but when I delete the database completely and run it, it doesn't give an error.

I'm waiting for your help.

Attached are the new tables I added.

table

Creating a new pivot table and establishing a relationship

edited Feb 10 '23 at 14:04

python_user

5,375
2
13
32

asked Feb 10 '23 at 14:01

Sheeva

1

Instead of an image for the tables, please provide the code as text. – Dorian Turba Feb 10 '23 at 14:32

How do I add a relationship to an existing table alembic sqlalchemy?

0 Answers0