[sqlalchemy] Fwd: before_insert is not being called, thus invalidating extensions in the spirit of acts_as_versioned

2008-08-31 Thread alex bodnaru
hello friends, i notice that the before_insert method in an orm MapperExtension derived class is not being called at all, thus invalidating these extensions. any idea of how could i proceed? best regards, alex --~--~-~--~~~---~--~~ You received this message

[sqlalchemy] seeking advice for multi-table query

2008-08-31 Thread Eric Lemoine
Hello Here's my case. I have 3 tables, summits, parkings, and huts. They all have an elevation column. And I want to do queries like that: the summits, parkings, and huts that are higher than 2000 meters, the summits that are lower than 1000 meters, the parkings and huts that are between 500 and

[sqlalchemy] Re: timing all queries

2008-08-31 Thread Michael Bayer
the two approaches are just plain old profile (or hotspot), and just look at the timing for execute(), or for a more comprehensive solution write some timing code around ConnectionProxy, docstring at

[sqlalchemy] Re: Fwd: before_insert is not being called, thus invalidating extensions in the spirit of acts_as_versioned

2008-08-31 Thread Michael Bayer
On Aug 31, 2008, at 2:21 AM, alex bodnaru wrote: hello friends, i notice that the before_insert method in an orm MapperExtension derived class is not being called at all, thus invalidating these extensions. any idea of how could i proceed? provide a reproducible example of the failing

[sqlalchemy] Re: seeking advice for multi-table query

2008-08-31 Thread Michael Bayer
On Aug 31, 2008, at 4:44 PM, Eric Lemoine wrote: Hello Here's my case. I have 3 tables, summits, parkings, and huts. They all have an elevation column. And I want to do queries like that: the summits, parkings, and huts that are higher than 2000 meters, the summits that are lower than

[sqlalchemy] Re: Fwd: before_insert is not being called, thus invalidating extensions in the spirit of acts_as_versioned

2008-08-31 Thread alex bodnaru
hi mike, i found my fault: the before_insert was omitted while i inserted a record via an insert statement, thus bypassing the orm. thanks for your reply, alex On Mon, Sep 1, 2008 at 12:37 AM, Michael Bayer [EMAIL PROTECTED] wrote: On Aug 31, 2008, at 2:21 AM, alex bodnaru wrote: hello