[sqlalchemy] self.data[i] index out of range

2009-11-07 Thread jo
Hia all, I'm dogged by this error for months, could someone, please, explain me what it means and how to avoid it. File /usr/lib/python2.4/site-packages/sqlalchemy/orm/attributes.py, line 532, in __getitem__ return self.data[i] IndexError: list index out of range thanks for any help.

[sqlalchemy] no such table OperationalError despite CREATE TABLE being issued

2009-11-07 Thread James
Hi, this concerns running functional tests in TurboGears2, using SA 0.5.1. As part of the functional test set up, all the model's tables are CREATEd, and DROPped as part of the tear down. However, despite seeing the expected sequence of CREATE, 1st test, DROP, CREATE, 2nd test, DROP, the second

[sqlalchemy] Re: no such table OperationalError despite CREATE TABLE being issued

2009-11-07 Thread Michael Bayer
On Nov 7, 2009, at 6:06 AM, James wrote: Can anyone see why a new created table wouldn't be found by SQLAlchemy? What more information could I give that would be useful? This is using sqlalchemy.url = sqlite:///:memory: the most obvious cause would be that two different engines are being

[sqlalchemy] Re: self.data[i] index out of range

2009-11-07 Thread Michael Bayer
On Nov 7, 2009, at 3:17 AM, jo wrote: Hia all, I'm dogged by this error for months, could someone, please, explain me what it means and how to avoid it. File /usr/lib/python2.4/site-packages/sqlalchemy/orm/ attributes.py, line 532, in __getitem__ return self.data[i] IndexError:

[sqlalchemy] Re: executemany + postgresql

2009-11-07 Thread Jon Nelson
On Fri, Nov 6, 2009 at 9:57 AM, Michael Bayer mike...@zzzcomputing.com wrote: Before I even posted I resorted to strace. strace immediately confirmed my suspicion - when using psycopg2 I don't see one big fat INSERT with lots of binds, I see one INSERT per bind, and it's this that is

[sqlalchemy] Re: executemany + postgresql

2009-11-07 Thread Michael Bayer
On Nov 7, 2009, at 12:53 PM, Jon Nelson wrote: have you asked about this on the psycopg2 mailing list ? its at http://mail.python.org/mailman/listinfo/python-list . Let me know if you do, because I'll get out the popcorn... :) That's the python list. oops:

[sqlalchemy] Re: executemany + postgresql

2009-11-07 Thread Jon Nelson
On Sat, Nov 7, 2009 at 11:58 AM, Michael Bayer mike...@zzzcomputing.com wrote: On Nov 7, 2009, at 12:53 PM, Jon Nelson wrote: have you asked about this on the psycopg2 mailing list ?   its at http://mail.python.org/mailman/listinfo/python-list  .   Let me know if you do, because I'll get

[sqlalchemy] Re: executemany + postgresql

2009-11-07 Thread Michael Bayer
On Nov 7, 2009, at 1:30 PM, Jon Nelson wrote: File pg8000/protocol.py, line 121, in serialize val = struct.pack(!i, len(val) + 4) + val UnicodeDecodeError: 'ascii' codec can't decode byte 0x8d in position 3: ordinal not in range(128) make sure you're on the latest tip of pg8000, which

[sqlalchemy] Re: executemany + postgresql

2009-11-07 Thread Jon Nelson
On Sat, Nov 7, 2009 at 3:02 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Nov 7, 2009, at 1:30 PM, Jon Nelson wrote:  File pg8000/protocol.py, line 121, in serialize    val = struct.pack(!i, len(val) + 4) + val UnicodeDecodeError: 'ascii' codec can't decode byte 0x8d in position 3:

[sqlalchemy] Query caching and garbage collection of related instances

2009-11-07 Thread Adam Dziendziel
Hi, I am trying to use the query caching solution described here: http://svn.sqlalchemy.org/sqlalchemy/trunk/examples/query_caching/per_session.py In most cases it works, the returned records are cached, I store them in a LRU cache modeled after http://code.activestate.com/recipes/498245/