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
Devraj -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit

[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?

[sqlalchemy] Auto discover primary key field in tables defined using metadata

2011-09-25 Thread Devraj
Hi all, SQLAlchemy 0.7.1 / Python 2.7.1 on Ubuntu 11.04 server / Apache 2.2.x + mod_wsgi 3.3.x I am *very* new to SQLAlchemy, so please be kind. We are trying to use SQLAlchemy with an existing database / tables. Our preference is to use the Metadata auto discover mechanism so we don't have to