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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
