Query in SQLAlchemy

[rhubee]

Hi,

I am currently working on a job recorder and i dont know how to translate this query into an SQL Alchemy query,

SELECT * from productivity_det where "Employee_Num"='0204110020' and "Date">='09/10/2011' and "Date"=<'09/16/2011';

HERE IS MY TABLE STRUCTURE:

id = Column (Integer, primary_key=True)
Employee_Num = Column(String)
Group = Column(String)
Process = Column(String)
Batch_Num = Column(String)
State = Column(String)
County = Column(String)
Date = Column(Date)

Thanks!

[RSamper11]

engine.query(ProductivityD).filter(and_(ProductivityD.Employee_Num == '0204110020' , and_(ProductivityD.Date >= datevalue1, ProductivityD.Date <= datevalue2)).all()

engine, and ProductivityD can change depending on the name you instanstiated and declared each one.
Hope it helps