Query API

[lmacken]

We need to port & improve the query API to ensure that it allows users to query updates & buildroot overrides appropriately.

An example of one of the issues we're having with the current API is that certain parameters, like 'bugs' and 'date_modified', are mutually exclusive.

[lmacken]

We also need pagination support.

WebHelpers provides a nice API that will integrate nicely with our SQLAlchemy & WebOb setup: http://docs.pylonsproject.org/projects/webhelpers/en/latest/modules/paginate.html

[bochecha]

We've done a fair bit of this during Flock. The current Git HEAD can return updates filtered by:

• release(s)
• request
• status
• type
• username
• critpath
• submitted_since

None are mutually exclusive, the filters can all be combined as desired. Adding filters just AND-s them.

@giallu has started working on filters on other dates:

• modified_since
• approved_since
• pushed_since
• security_approval_since
• qa_approval_since
• releng_approval_since

Compared to Bodhi 1, we're still missing update filters by:

• bugs
• cves
• packages

[bochecha]

So if you merge pull requests #20 and #21, we should have filters for pretty much every attribute in the Update model. (unless I forgot some, of course)

Last thing to do would be pagination, but I think I'd rather wait to see how we'd use that before doing it, because I'm personally not really familiar with WebHelpers. (or even pagination)

[lmacken]

@ralphbean implemented pagiation in f5ba563d