Re: [sqlalchemy] Bulk Update using ShardedSession

2013-09-24 Thread Piotr Deszyński
Hello, Ok, thank you for the answer. I will try to look into that deeper then. Best regards W dniu środa, 25 września 2013 02:51:06 UTC+2 użytkownik Michael Bayer napisał: > > > On Sep 23, 2013, at 8:13 AM, Piotr Deszyński > > > wrote: > > I'm tryign to do a

[sqlalchemy] Bulk Update using ShardedSession

2013-09-24 Thread Piotr Deszyński
I'm tryign to do a bulk update using sqlalchemy ShardedSession. I've stumbled on a problem when i have to do a bulk update without selecting rows from a database. Here's how I've tried to do it: class Row(Base, object): #pylint: disable=I0011, R0903 ''' Row ''' __tablename__ =

Re: [sqlalchemy] "InvalidRequestError: Can't reconnect until invalid transaction is rolled back" error during "SELECT" query

2012-12-05 Thread Piotr Deszyński
Ok, got it working. Sorry for the problem. W dniu wtorek, 4 grudnia 2012 16:31:16 UTC+1 użytkownik Michael Bayer napisał: > > test cases and stack traces would be a start > > On Dec 4, 2012, at 9:29 AM, Piotr Deszyński wrote: > > Hello, > > Is there a way to use ZopeTr

Re: [sqlalchemy] "InvalidRequestError: Can't reconnect until invalid transaction is rolled back" error during "SELECT" query

2012-12-05 Thread Piotr Deszyński
A simple test case can be found here https://gist.github.com/4214092 Expected result: Query returns a list of results from database Current behaviour: Query throws an exception: https://gist.github.com/4214131 W dniu środa, 5 grudnia 2012 07:54:48 UTC+1 użytkownik Piotr Deszyński napisał

Re: [sqlalchemy] "InvalidRequestError: Can't reconnect until invalid transaction is rolled back" error during "SELECT" query

2012-12-04 Thread Piotr Deszyński
k Michael Bayer napisał: > > test cases and stack traces would be a start > > On Dec 4, 2012, at 9:29 AM, Piotr Deszyński wrote: > > Hello, > > Is there a way to use ZopeTransactionExtension using ShardedSession? I > just cannot figure it out. When I use it then

Re: [sqlalchemy] "InvalidRequestError: Can't reconnect until invalid transaction is rolled back" error during "SELECT" query

2012-12-04 Thread Piotr Deszyński
Hello, Is there a way to use ZopeTransactionExtension using ShardedSession? I just cannot figure it out. When I use it then I'm getting exception during any query: unbound method after_begin() must be called with ZopeTransactionExtension instance as first argument (got SessionMaker instance i