[sqlalchemy] How does auto-reconnect work?

2007-11-06 Thread Hong Yuan
for the database connection to work again. How is auto-reconnect suppposed to work? Is there any connection parameter to alter for instance? Thanks, Hong Yuan --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

[sqlalchemy] Re: Bug in selection from many-to-many relationship?

2007-06-24 Thread Hong Yuan
PersonAddress(a2)) session.save(p1) session.save(p2) session.flush() persons = session.query(Person).join('addresses').select(address.c.street.op('like') ('Street%')) print len(persons) Best Regards Hong Yuan --~--~-~--~~~---~--~~ Yo

[sqlalchemy] Re: Bug in selection from many-to-many relationship?

2007-06-23 Thread Hong Yuan
and. With eager loading turned on, the query has 2 joins and 2 left joins. Though a bit complex, I guess it is actually exactly what is needed. Best Regards Hong Yuan --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[sqlalchemy] Bug in selection from many-to-many relationship?

2007-06-22 Thread Hong Yuan
and then again in the JOIN clause. This doesn't seem to be the right select statement. Is this a bug? If no, how should I structure my code to eliminate this duplication? If yes, is there a work-around? Thanks, Best Regards Hong Yuan --~--~-~--~~~---~--~~ You

[sqlalchemy] backref not working for concrete table inheritance?

2007-04-28 Thread Hong Yuan
f work with concrete table inheritance? It works in the simple.py. Best Regards, Hong Yuan == The example code below from sqlalchemy import * metadata = MetaData() managers_table = Table('managers', metadata, Column('employee_id

[sqlalchemy] Re: different number range for primary key

2007-04-24 Thread Hong Yuan
On 4月24日, 下午5时09分, [EMAIL PROTECTED] wrote: > orm-wise, u can probably use MapperExtension.before_insert(), and set > up the value there. but this is worst as speed, synchronisation etc. Seems workable. I will try this. Although a solution on the SQL level would be better. > At lower level (SQL