[sqlalchemy] combining single table and joined table inheritance

2009-02-03 Thread qvx
I have a base class/table with many common fields. Those fields are enough to handle several Child classes. So, I can use single table inheritance. But, I have a special case when another Child class has other fields so I should join new table in this case. Is this possible? Pseudo code

[sqlalchemy] Re: combining single table and joined table inheritance

2009-02-03 Thread qvx
To answer my own question: it is working! On Feb 3, 2:10 pm, qvx qvx3...@gmail.com wrote: I have a base class/table with many common fields. Those fields are enough to handle several Child classes. So, I can use single table inheritance. But, I have a special case when another Child class has

[sqlalchemy] pretend like an object was loaded, not created

2009-01-21 Thread qvx
I have a web application which is accessed from different sub-domains. Each sub-domain corresponds to one row/object in installation table. I am fetching this one row/object on every request which is unnecessary. My question is: how can I fetch this object only once and somehow stuff it inside a

[sqlalchemy] Re: pretend like an object was loaded, not created

2009-01-21 Thread qvx
combined with no data shared between sessions. some examples of moderately-to-completely transparent caches that   build into Query are in the examples directory with the distribution   under examples/query_caching.  they might give you some ideas. On Jan 21, 2009, at 3:51 PM, qvx wrote: I

[sqlalchemy] Re: timing all queries

2008-09-06 Thread qvx
On Aug 31, 11:36 pm, Michael Bayer [EMAIL PROTECTED] wrote: for a more comprehensive solution   write some timing code around ConnectionProxy, docstring athttp://www.sqlalchemy.org/docs/05/sqlalchemy_interfaces.html#docstrin... What would be the equivalent way in 0.4 version of sqlalchemy

[sqlalchemy] timing all queries

2008-08-29 Thread qvx
Is there a way to record the execution time for all queries issued by sqlalchemy? Thanks, Tvrtko --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] readonly attributes

2006-11-10 Thread qvx
I have an ActiveMapper class which looks like this: class OraJob(ActiveMapper): class mapping: id = column(Integer, primary_key = True) job_type = column(Unicode(30)) source_type = column(Unicode(30)) ... Attributes are used / should be used in readonly