Re: [sqlalchemy] Expire SQLAlchemy session if Oracle node failover

2013-09-13 Thread Devraj Mukherjee
this condition, if such handling is necessary. On Sep 13, 2013, at 1:46 AM, Devraj Mukherjee dev...@gmail.com wrote: Hi all, We are using SQLAlchemy + cx_Oracle to connect to one of two Oracle nodes (setup to mirror the databases). Connection string as follows: oracle+cx_oracle://%s:%s

[sqlalchemy] Expire SQLAlchemy session if Oracle node failover

2013-09-12 Thread Devraj Mukherjee
Hi all, We are using SQLAlchemy + cx_Oracle to connect to one of two Oracle nodes (setup to mirror the databases). Connection string as follows: oracle+cx_oracle://%s:%s@

[sqlalchemy] Ensure that relationships aren't loaded in query

2011-10-24 Thread Devraj Mukherjee
Hi all, I have a model that loads a many relationship (User has many addresses) class User(Base): __table__ = Base.metadata.tables['user'] addresses = relationship(Address, backref=user) For one of our queries I want to ensure that the relationship is not fetched. Is this possible?