[sqlalchemy] Problem with inserting multiple rows as lists/tuples

2012-12-27 Thread Stefan Urbanek
Hi, I am trying to pass multiple rows as tuples into an INSERT statement.: *# buffer is list of lists/tuples, like: [ [1, foo], [2, bar], ... ] * insert = self.table.insert() engine.execute(insert, buffer) This fails with: File

Re: [sqlalchemy] Problem with inserting multiple rows as lists/tuples

2012-12-27 Thread Michael Bayer
On Dec 27, 2012, at 4:55 PM, Stefan Urbanek wrote: Hi, I am trying to pass multiple rows as tuples into an INSERT statement.: # buffer is list of lists/tuples, like: [ [1, foo], [2, bar], ... ] insert = self.table.insert() engine.execute(insert, buffer) This fails with:

Re: [sqlalchemy] Problem with inserting multiple rows as lists/tuples

2012-12-27 Thread Stefan Urbanek
On 27.12.2012, at 23:21, Michael Bayer mike...@zzzcomputing.com wrote: On Dec 27, 2012, at 4:55 PM, Stefan Urbanek wrote: Hi, I am trying to pass multiple rows as tuples into an INSERT statement.: # buffer is list of lists/tuples, like: [ [1, foo], [2, bar], ... ] insert =

[sqlalchemy] MySQL has gone away

2012-12-27 Thread Diego Woitasen
Hi, I know that this was discussed several times in the past but I can't solve the problem with the tip that I read in this list. Every morning my application dies with the msg MySQL has gone away. My app has different modules (which are process) and this errors appears in the simplest one and

Re: [sqlalchemy] Problem with inserting multiple rows as lists/tuples

2012-12-27 Thread Michael Bayer
On Dec 27, 2012, at 6:06 PM, Stefan Urbanek wrote: On 27.12.2012, at 23:21, Michael Bayer mike...@zzzcomputing.com wrote: On Dec 27, 2012, at 4:55 PM, Stefan Urbanek wrote: Hi, I am trying to pass multiple rows as tuples into an INSERT statement.: # buffer is list of

Re: [sqlalchemy] MySQL has gone away

2012-12-27 Thread Michael Bayer
On Dec 27, 2012, at 6:28 PM, Diego Woitasen wrote: Hi, I know that this was discussed several times in the past but I can't solve the problem with the tip that I read in this list. Every morning my application dies with the msg MySQL has gone away. My app has different modules (which