Re: [sqlalchemy] [Q] SQLSoup and pymssql from Linux

2012-10-05 Thread lenartlad
Hello. I dont have easy access to pymssql here so can you fully define what fails means ? stack trace ? I don't have access to my development environment during the weekend, so I cannot provide you with a stacktrace, but I try to better describe the issue: def

Re: [sqlalchemy] [Q] Why the following emits SQL for slot access?

2012-09-28 Thread lenartlad
Hello. Thank you for the tips. I stick to my simple approach for the time being: _rows = q.all() rows = unwrap(_rows) I need the cache within the context of one method only. Ladislav Lenart Od: Michael Bayer mike...@zzzcomputing.com On Sep 27, 2012, at 4:37 PM, Ladislav Lenart

Re: [sqlalchemy] query joining and filtering with table inheritance

2012-09-28 Thread lenartlad
Hello. I am not at my development environment now so I cannot test it, but I think you want this: http://docs.sqlalchemy.org/en/rel_0_7/orm/inheritance.html?highlight=of_type#basic-control-of-which-tables-are-queried Ladislav Lenart PS: I'm by no means a DB or SQLA expert too :-) Od: Iain

Re: [sqlalchemy] [Q] Any difference betwen two style of core inserts?

2012-09-10 Thread lenartlad
Works like a charm. Thank you! Ladislav Lenart On Sep 10, 2012, at 10:53 AM, Ladislav Lenart wrote: Hello. Is there any performance (plus communication) difference between # bulk insert of several rows new_rows = [] for i in range(10):