[sqlalchemy] Re: union with two different orders

2009-06-07 Thread Adrian von Bidder
On Saturday 06 June 2009 17.39:20 naktinis wrote: I think this was not the case, since I didn't expect the merged result to be ordered. To be more precise, the query looks like: q1 = Thing.query().filter(...).order_by(Thing.a.desc()).limit(1) q2 =

[sqlalchemy] Re: ForeignKey not saved - sqlite3, TG1.1

2009-06-07 Thread Mike Conley
Think of it this way. The original code says set user.blogs to be this list containing exactly one Blog. SQLAlchemy does what you told it to and issues an update removing the foreign key from all blog entries that originally pointed to this user and then inserts a new entry pointing where you

[sqlalchemy] some the wrong about sqlsoup in mulithread request

2009-06-07 Thread tsangpo
I use the SqlSoup to make it easy to access the database. It's all right when I make the http request one by one. But it run into errors when serveral requests were sent at the same time, and fail to proccess requests anymore. I log the Session, and found that each request exact has different

[sqlalchemy] something wrong about sqlsoup in mulithread request

2009-06-07 Thread tsangpo
I use the SqlSoup to make it easy to access the database. It's all right when I make the http request one by one. But it run into errors when serveral requests were sent at the same time, and fail to proccess requests anymore. I log the Session, and found that each request exact has different