[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.

[sqlalchemy] AmbiguousForeignKeysError or CircularDependencyError

2014-12-11 Thread Boris Sabatier
Hi, I have a problem to do the model I need. I have 3 types of object : Category, Picture and Video. All of these types have some common part, like a name. Also I want to be able to select all object with a name like bar (Category, Picture and Video) So I use the Joined_table inheritance

Re: [sqlalchemy] AmbiguousForeignKeysError or CircularDependencyError

2014-12-11 Thread Simon King
On Thu, Dec 11, 2014 at 2:44 PM, Boris Sabatier sabatier.bo...@gmail.com wrote: Hi, I have a problem to do the model I need. I have 3 types of object : Category, Picture and Video. All of these types have some common part, like a name. Also I want to be able to select all object with a name

Re: [sqlalchemy] AmbiguousForeignKeysError or CircularDependencyError

2014-12-11 Thread Boris SABATIER
Thanks Simon it's work !!! 2014-12-11 16:06 GMT+01:00 Simon King si...@simonking.org.uk: On Thu, Dec 11, 2014 at 2:44 PM, Boris Sabatier sabatier.bo...@gmail.com wrote: Hi, I have a problem to do the model I need. I have 3 types of object : Category, Picture and Video. All of these types

Re: [sqlalchemy] AmbiguousForeignKeysError or CircularDependencyError

2014-12-11 Thread Jonathan Vanasco
Just a quick warning on this pattern (which I use as well)... When dealing with Edits/Updates and Database Migrations, you might run into issues where any mix of SqlAlchemy commands simply will not make the mapper happy. A workaround is to ignore the session and do these operations using the