[sqlalchemy] Re: Cyclic references and Nullable

2008-09-24 Thread mraer
Thank you - i think it is a solution SA's Constraint types have support for generating a deferrable key at CREATE TABLE table: http://www.sqlalchemy.org/docs/05/sqlalchemy_schema.html#docstrings_s... I believe you can either define the cyclic constraints as initially deferred for this

[sqlalchemy] Re: Cyclic references and Nullable

2008-09-24 Thread Michael Bayer
On Sep 24, 2008, at 12:11 PM, jason kirtland wrote: SA's Constraint types have support for generating a deferrable key at CREATE TABLE table: http://www.sqlalchemy.org/docs/05/sqlalchemy_schema.html#docstrings_sqlalchemy.schema_Constraint I believe you can either define the cyclic

[sqlalchemy] Re: Cyclic references and Nullable

2008-09-23 Thread Alex K
And how can you do this via explicit SQL? On 23 сент, 18:32, mraer [EMAIL PROTECTED] wrote: Suppose I have two classes of objects which have a reference to each other: Class A: b Class B: a Both references are mandatory so nullable = False I use post_update = True in relation function

[sqlalchemy] Re: Cyclic references and Nullable

2008-09-23 Thread mraer
I think it depends on specific DB. In DBs I can start checking constraints after comitting a transaction, I think. On Sep 23, 6:58 pm, Alex K [EMAIL PROTECTED] wrote: And how can you do this via explicit SQL? --~--~-~--~~~---~--~~ You received this message

[sqlalchemy] Re: Cyclic references and Nullable

2008-09-23 Thread Michael Bayer
On Sep 23, 2008, at 10:32 AM, mraer wrote: Suppose I have two classes of objects which have a reference to each other: Class A: b Class B: a Both references are mandatory so nullable = False I use post_update = True in relation function and use_alter = True in ForeignKey