Re: [Sqlalchemy-users] constraints, cont'd

2006-07-14 Thread Michael Bayer
OK, you can see what ive done so far in rev 1709, over at: http://www.sqlalchemy.org/trac/changeset/1709 unit tests work for postgres, sqlite, and mysql so far, including composite foreign key reflection. oracle/mssql/firebird probably work at least as good as they used to. for examp

Re: [Sqlalchemy-users] constraints, cont'd

2006-07-14 Thread Michael Bayer
On Jul 14, 2006, at 2:21 PM, David Shoemaker wrote: > > This is actually somewhat unrelated, but how are circular foreign > key dependencies handled? In the example above, what if table lala > had to be created after table foo because of such a dependency? > While you're refactoring this

Re: [Sqlalchemy-users] constraints, cont'd

2006-07-14 Thread David Shoemaker
On 7/14/06, Michael Bayer <[EMAIL PROTECTED]> wrote: OK, in continuing with the UNIQUE issue of the other day, id like tocontinue making the whole "constraint" methodology as simple andconsistent as possible, including getting all the reflection towork.  this is more complicated than I first realiz

[Sqlalchemy-users] constraints, cont'd

2006-07-14 Thread Michael Bayer
OK, in continuing with the UNIQUE issue of the other day, id like to continue making the whole "constraint" methodology as simple and consistent as possible, including getting all the reflection to work. this is more complicated than I first realized. So, Id like to move all the logic for c