[sqlalchemy] Re: AmbiguousForeignKeysError

2020-05-30 Thread Sydo Luciani
Correction on wordings: One parent table, two child tables, one foreign key from each child pointing to the same field in parent with "one to one relationship" works with no problem, but getting "AmbiguousForeignKeysError" as soon as adding the second foreign key to child tables pointing to the

[sqlalchemy] AmbiguousForeignKeysError

2020-05-30 Thread Sydo Luciani
One parent table, two child tables, two foreign keys pointing to a field in parent with "one to one relationship" works with no problem, but getting "AmbiguousForeignKeysError" as soon as adding the second foreignkey to child table. tried various combinations but none has worked so far.

Re: [sqlalchemy] Re: how can i remove an entry from relational database using sqlalchemy in python

2020-05-30 Thread Jonathan Vanasco
If I had time to respond yesterday, I would have said the same thing as Simon. Your database model leverages two separate parts of SQLAlchemy: * SqlAlchemy ORM (Left side of the docs https://docs.sqlalchemy.org/en/13/ ) * SqlAlchemy Core (Right side of the docs