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

2013-09-13 Thread Devraj Mukherjee
Thanks Michael. I was just making sure before I started digging any further. Cheers. On Sat, Sep 14, 2013 at 1:55 AM, Michael Bayer wrote: > failing over between database nodes is not something that is handled > within SQLAlchemy, it's part of the functionality of your cx_Oracle driver > as well

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

2013-09-13 Thread Michael Bayer
failing over between database nodes is not something that is handled within SQLAlchemy, it's part of the functionality of your cx_Oracle driver as well as your tns setup. You should check with the cx_oracle list or perhaps google around some for correct TNS settings regarding this feature. No

Re: [sqlalchemy] how to count function

2013-09-13 Thread Alysson Bruno
I think so your problem is in this line: rowCounter = rowCounter.filter(and_(getattr(MaterialsTable,attr).like("%%%s%%" % val))).count() Here you put a integer in your rowCounter variable, then in your next call of this the don't have a filter method in your rowCounter ;) Em quinta-feira, 12 d