Re: [sqlalchemy] passive_deletes/updates with sqlite

2010-09-14 Thread alex bodnaru
On 09/13/2010 05:49 PM, Michael Bayer wrote: On Sep 13, 2010, at 11:16 AM, alex bodnaru wrote: hope my approach isn't too simplist, but onetomany is usually implemented in rdbms by an manytoone column or a few of them, with or without ri clauses: thus, a foreign key or an index.

Re: [sqlalchemy] passive_deletes/updates with sqlite

2010-09-13 Thread Michael Bayer
On Sep 12, 2010, at 11:02 PM, alex bodnaru wrote: thanks a lot michael. indeed it works, but it seems counter-intuitive a little since passive_* should in my opinion be on the side of the on * cascade it describes. anyway, it's great, and hope to make it work with elixir too. If you said

Re: [sqlalchemy] passive_deletes/updates with sqlite

2010-09-13 Thread alex bodnaru
On 09/13/2010 08:32 AM, Michael Bayer wrote: On Sep 12, 2010, at 11:02 PM, alex bodnaru wrote: thanks a lot michael. indeed it works, but it seems counter-intuitive a little since passive_* should in my opinion be on the side of the on * cascade it describes. anyway, it's great, and hope

Re: [sqlalchemy] passive_deletes/updates with sqlite

2010-09-13 Thread Michael Bayer
On Sep 13, 2010, at 11:16 AM, alex bodnaru wrote: hope my approach isn't too simplist, but onetomany is usually implemented in rdbms by an manytoone column or a few of them, with or without ri clauses: thus, a foreign key or an index. conversely, a manytoone relation has an implicit

Re: [sqlalchemy] passive_deletes/updates with sqlite

2010-09-12 Thread Michael Bayer
cant speak for Elixir, but your passive_deletes is on the wrong side in your declarative example. The correlations between classical and declarative relationship patterns are now individually contrasted at http://www.sqlalchemy.org/docs/orm/relationships.html#basic-relational-patterns . On

Re: [sqlalchemy] passive_deletes/updates with sqlite

2010-09-12 Thread alex bodnaru
On 09/12/2010 04:27 PM, Michael Bayer wrote: cant speak for Elixir, but your passive_deletes is on the wrong side in your declarative example. The correlations between classical and declarative relationship patterns are now individually contrasted at

Re: [sqlalchemy] passive_deletes/updates with sqlite

2010-09-12 Thread alex bodnaru
On 09/12/2010 04:27 PM, Michael Bayer wrote: cant speak for Elixir, but your passive_deletes is on the wrong side in your declarative example. The correlations between classical and declarative relationship patterns are now individually contrasted at

Re: [sqlalchemy] passive_deletes/updates with sqlite

2010-09-11 Thread alex bodnaru
On 09/11/2010 04:31 AM, alex wrote: On 09/10/2010 05:41 PM, Michael Bayer wrote: On Sep 10, 2010, at 4:13 AM, alex wrote: hello friends, as sqlite has recently introduced support for on delete/update cascade, i'd like to implement the passive_* functionality for this driver too. please

[sqlalchemy] passive_deletes/updates with sqlite

2010-09-10 Thread alex
hello friends, as sqlite has recently introduced support for on delete/update cascade, i'd like to implement the passive_* functionality for this driver too. please give me a hint where to start. best regards, alex -- You received this message because you are subscribed to the Google Groups

Re: [sqlalchemy] passive_deletes/updates with sqlite

2010-09-10 Thread Michael Bayer
On Sep 10, 2010, at 4:13 AM, alex wrote: hello friends, as sqlite has recently introduced support for on delete/update cascade, i'd like to implement the passive_* functionality for this driver too. please give me a hint where to start. passive_delete and passive_update are database