SQLAlchemy/0.4.5

1. filter_by(**kwargs) is the only option available 1. filter can do multiples via and_ or_

from sqlalchemy import and_,or_
a=session.query(th).filter(and_(th.APPLIED_TEST==1,th.CODING_DATE=='20080325'))

a=session.query(th).filter(and_(th.APPLIED_TEST==1,th.CODING_DATE=='20080325')).all()

MyWiki: TurboGears/0.4.5 (last edited 2009-09-06 02:50:28 by localhost)