[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