[sqlalchemy] Re: the return type of conn.execute(text())

2009-01-28 Thread King Simon-NFHD78
-Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalch...@googlegroups.com] On Behalf Of Faheem Mitha Sent: 27 January 2009 22:41 To: sqlalchemy@googlegroups.com Subject: [sqlalchemy] the return type of conn.execute(text()) Hi, Today I attempted to serialize

[sqlalchemy] Re: the return type of conn.execute(text())

2009-01-28 Thread MikeCo
Doesn't this work? result = conn.execute('some select statement').fetchall() result will be a ResultProxy containing RowProxy's pickleable = [tuple(row) for row in result] Each tuple contains the column data in what should be a pickleable form. This will work for ints, strings, unicodes, etc.

[sqlalchemy] Re: the return type of conn.execute(text())

2009-01-27 Thread az
i have recently stumbled on similar - the rowproxy's __hash__ was missing. so i have to tuple() them before usage. Then there was Mike's question, what should the RowProxy emulate? the tuple of the row, or something else? Today I attempted to serialize the return value of the form result =

[sqlalchemy] Re: the return type of conn.execute(text())

2009-01-27 Thread az
On Wednesday 28 January 2009 01:34:30 Michael Bayer wrote: On Jan 27, 2009, at 6:28 PM, a...@svilendobrev.com wrote: i have recently stumbled on similar - the rowproxy's __hash__ was missing. so i have to tuple() them before usage. that doesnt strike me as a similar issue. we should

[sqlalchemy] Re: the return type of conn.execute(text())

2009-01-27 Thread Michael Bayer
On Jan 27, 2009, at 6:28 PM, a...@svilendobrev.com wrote: i have recently stumbled on similar - the rowproxy's __hash__ was missing. so i have to tuple() them before usage. that doesnt strike me as a similar issue. we should apply that patch someone had to detect python 2.6 and place

[sqlalchemy] Re: the return type of conn.execute(text())

2009-01-27 Thread Faheem Mitha
[This message has also been posted.] On Wed, 28 Jan 2009 01:28:31 +0200, a...@svilendobrev.com a...@svilendobrev.com wrote: i have recently stumbled on similar - the rowproxy's __hash__ was missing. so i have to tuple() them before usage. Then there was Mike's question, what should the