It seems what when using .first() with from_statement() I get a traceback with 0.5rc4 when no rows are found (works when a row is fount):
using 0.4.8 I get: /usr 0.4.8 with 0.5rc4 I get: /users/dgardner/dev 0.5.0rc4 Traceback (most recent call last): File "assetdb_test.py", line 38, in <module> session.query(Note).from_statement(qry%(uid,name,updated)).first() File "/users/dgardner/dev/lib/python2.5/site-packages/SQLAlchemy-0.5.0rc4-py2.5.egg/sqlalchemy/orm/query.py", line 1025, in first return list(self)[0] IndexError: list index out of range My test: -------------------- import sys print sys.prefix from sqlalchemy import * import sqlalchemy from sqlalchemy.orm import * DB_HOST = 'localhost' DB_NAME = 'transitional' DB_USER = 'sqluser' DB_PASS = 'not_my_password' db_uri = 'postgres://%s:[EMAIL PROTECTED]/%s' % (DB_USER,DB_PASS,DB_HOST,DB_NAME) db = create_engine (db_uri, pool_size=200,max_overflow=200) #db.echo = True metadata = MetaData(db) class Note(object): pass note_table = Table('note', metadata, Column('id', Integer, primary_key=True), Column('created', DateTime, default=func.now()), Column('updated', DateTime, default=func.now(), onupdate=func.current_timestamp()), Column('author', String(255),ForeignKey('users.userid')), Column('note', String), Column('asset', String(20), ForeignKey('nodehierarchy.uid'), nullable=False) ) mapper(Note, note_table) print sqlalchemy.__version__ qry="""SELECT note.* FROM note_task JOIN note ON note_task.note=note.id WHERE note_task.task_asset='%s' AND note_task.task_name='%s' AND note.updated='%s'""" uid='00420123774551347239' name='UV' updated='2008-12-05 16:45:46.299124-08:00' session = create_session() session.query(Note).from_statement(qry%(uid,name,updated)).first() sys.exit(0) -- David Gardner Pipeline Tools Programmer, "Sid the Science Kid" Jim Henson Creature Shop [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---