Good morning guys,
I'm looking for a way in which I can query my database for records which meet multiple, optional arguments. I'm looking to encapsulate access to this using a service layer, I want to create a method like this: def get_foos(self, foo_id="", foo_firstname="", foo_lastname=""): foos = session.query(Foo).filter_by(foo_id=foo_id, foo_firstname=foo_firstname, foo_lastname=foo_lastname) return foos Now, the thing I'm struggling with is how to make all those attributes optional. Because at the moment I call that method like so: get_foos(foo_id=2) I get no results returned because SQLAlchemy is looking for records that not only have an id of 2 but also have a first and last name which is an empty string. What I would ideally like to do is only have it filter by the arguments for getfoos() which are not empty strings. This would allow me to build a more reusable query method. Is this possible? And how would one achieve it? Cheers, Heston --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---