Dear all,
I've a form where people fill one or more fields to search in a db.
For the moment I solve it using a lot of if statement and a lot of
different query based on the filled fields. Something like that:
if start_date and end_date and instrument and details and technician:
c.results =
Session.query(Repairs).filter(and_(Repairs.start_date>=start_date,
Repairs.end_date<=end_date,
Repairs.instrument_id==instrument,
Repairs.details.like('%%%s%%' % details),
Repairs.technician.like('%%%s%%' % technician)
)).order_by('start_date').all()
elif start_date and end_date and instrument and details:
c.results =
Session.query(Repairs).filter(and_(Repairs.start_date>=start_date,
Repairs.end_date<=end_date,
Repairs.instrument_id==instrument,
Repairs.details.like('%%%s%%' % details),
)).order_by('start_date').all()
and so on for each combination (for 5 fields I have 20 query!). There is
a way to do that in a more dynamic way?
Thanks
--
-------------------------------------------------------------------
(o_
(o_ //\ Coltivate Linux che tanto Windows si pianta da solo.
(/)_ V_/_
+------------------------------------------------------------------+
| ENRICO MORELLI | email: [email protected] |
| * * * * | phone: +39 055 4574269 |
| University of Florence | fax : +39 055 4574253 |
| CERM - via Sacconi, 6 - 50019 Sesto Fiorentino (FI) - ITALY |
+------------------------------------------------------------------+
--
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.
