Re: [sqlalchemy] Re: SQLAlchemy NotImplementedError when doing a metadata create_all

2010-07-27 Thread Michael Bayer
On Jul 27, 2010, at 1:34 AM, Faheem Mitha wrote: My usage is slightly non-standard - a foreign key pointing to a foreign key. that never worked, most likely. its very complicated to get the types to propagate up a chain like that, and all on a deferred execution, in a reasonable way.

[sqlalchemy] Re: SQLAlchemy NotImplementedError when doing a metadata create_all

2010-07-27 Thread Faheem Mitha
Hi Mike, On Tue, 27 Jul 2010 09:07:15 -0400, Michael Bayer mike...@zzzcomputing.com wrote: On Jul 27, 2010, at 1:34 AM, Faheem Mitha wrote: My usage is slightly non-standard - a foreign key pointing to a foreign key. that never worked, most likely. its very complicated to get the types

[sqlalchemy] Re: SQLAlchemy NotImplementedError when doing a metadata create_all

2010-07-26 Thread Faheem Mitha
Hi, It turns out my example was too hasty. I should have had something like foobar = Table( 'foo', meta, Column('id', Integer, nullable=False, primary_key=True), ) bar = Table( 'bar', meta, Column('id', None, ForeignKey('foo.id', onupdate='CASCADE', ondelete='CASCADE'),

Re: [sqlalchemy] Re: SQLAlchemy NotImplementedError when doing a metadata create_all

2010-07-26 Thread Lance Edgar
On 7/26/2010 4:55 PM, Faheem Mitha wrote: Hi, It turns out my example was too hasty. I should have had something like foobar = Table( 'foo', meta, Column('id', Integer, nullable=False, primary_key=True), ) bar = Table( 'bar', meta, Column('id', None,

[sqlalchemy] Re: SQLAlchemy NotImplementedError when doing a metadata create_all

2010-07-26 Thread Faheem Mitha
Update: On Tue, 27 Jul 2010, Faheem Mitha wrote: Hi, It turns out my example was too hasty. I should have had something like foobar = Table( 'foo', meta, Column('id', Integer, nullable=False, primary_key=True), ) bar = Table( 'bar', meta, Column('id', None,

[sqlalchemy] Re: SQLAlchemy NotImplementedError when doing a metadata create_all

2010-07-26 Thread Faheem Mitha
[This message has also been posted.] Hi Lance, Thanks for the quick reply. On Mon, 26 Jul 2010 17:09:06 -0500, Lance Edgar lance.ed...@gmail.com wrote: I had a similar question a little while back and here was the answer: