[sqlalchemy] Re: setattr + unmapped attribute

2012-11-14 Thread MikeParent
Learn something new every day! Thanks. On Tuesday, November 13, 2012 7:05:24 PM UTC-6, MikeParent wrote: > > With a mapped class instance, if I try and set an unmapped attribute, > Sqlalchemy simply adds this new attribute (locally) to the object, and > subsequent 'get' operations return the as

Re: [sqlalchemy] Problems handling an Amazon RDS Multi-AZ failover with SqlSoup and SqlAlchemy 0.7.8

2012-11-14 Thread Michael Bayer
On Nov 14, 2012, at 2:38 PM, JonathanQ wrote: > We have some code running against MySQL running in Amazon RDS. During an > outage or the maintenance window - Amazon issues an automatic failover of our > RDS instance. However our code doesn't failover with it. > > We are having issues with 2

[sqlalchemy] Re: Problems handling an Amazon RDS Multi-AZ failover with SqlSoup and SqlAlchemy 0.7.8

2012-11-14 Thread Richie Foreman
Hey Jonathan, When I was creating the Google AppEngine Cloud SQL driver I was having a very similar issue. The nature of the "cloud" is to not really hold open long-lived connections, it seems. I switched my driver code to FORCE SqlAlchemy's 'NullPool', which essentially does NO connection po

[sqlalchemy] Re: Problems handling an Amazon RDS Multi-AZ failover with SqlSoup and SqlAlchemy 0.7.8

2012-11-14 Thread JonathanQ
Ok - it appears that the 2nd issue (DNS resolving) may be related to AWS: https://forums.aws.amazon.com/thread.jspa?threadID=109414&tstart=0 But I am sure the first issue is something wrong with how we are using SqlAlchemy/SqlSoup connections. -- You received this message because you are subs

[sqlalchemy] Problems handling an Amazon RDS Multi-AZ failover with SqlSoup and SqlAlchemy 0.7.8

2012-11-14 Thread JonathanQ
We have some code running against MySQL running in Amazon RDS. During an outage or the maintenance window - Amazon issues an automatic failover of our RDS instance. However our code doesn't failover with it. We are having issues with 2 of our applications (2 different issues): First one: Unab

Re: [sqlalchemy] with_polymorphic query and parent attribute filtering

2012-11-14 Thread tonthon
Le 14/11/2012 06:19, Michael Bayer a écrit : > On Nov 13, 2012, at 3:34 AM, tonthon wrote: > >> Hi, >> >> I'm using polymorphism for some of my models and I'm wondering how I >> should use the with_polymorphic query method. >> >> Consider the following: >> """ >> class A(Base): >> type_ = Column(