With SA 0.4beta4 if I try to access a mapped object field
(Table.c.fieldname) before any query has been sent to the database the
call fails with a AttributeError(key). Everything works if I do this
after having issued a query.
-- Example: (skip to the __main__ section)
import sqlalchemy as sqa
import sqlalchemy.orm as sqorm
class Table(object):
pass
class Model(object):
def connect(self, u, p, db, h):
dsn =""postgres://%(u)s:%(p)[EMAIL PROTECTED](h)s:5432/%(db)s""" %
vars()
self.engine = sqa.create_engine(dsn)
metadata = sqa.MetaData()
metadata.bind = self.engine
self.table_table = sqa.Table('table', metadata,
sqa.Column('id', sqa.Integer,
primary_key = True),
sqa.Column('field1', sqa.String(120))
)
sqorm.mapper(Table, self.table_table)
if __name__ == "__main__":
model = Model()
model.connect("user", "password", "db", "host")
session = sqorm.create_session()
filters = []
#THE FOLLOWING WILL FAIL WITH AttributeError: field1
#BUT NOT IF A QUERY HAS ALREADY BEEN ISSUED
#also against another mapped object.
#test = session.query(ANYMAPPEDOBJ).all()
#test = session.query(Table).all()
#uncomment one of the above and it works
filters.append(Table.c.field1.op('ILIKE') ("FILTERTEXT"))
filter = sqa.and_(*filters)
result = session.query(Table).\
filter(filter).\
all()
session.close()
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
