用于RESTful-API中的动态DQL的Symfony2-Bundle

Question

I built a simple API in symfony2 with doctrine 2 (with a little help from here: http://williamdurand.fr/2012/08/02/rest-apis-with-symfony2-the-right-way/). Everything works fine. GET (All/One), PUT, POST or DELETE works, but I can either fetch all Resources or only one with a specific Id.

But I want something like this: GET /api/stuff?filter={ [ { "field": "fieldname", "operator": "eq", "value": "foo" }, { ... } ] }

and then call getByFilter($filter) to build a generic DQL. I have a pretty clear idea how to do it (I did something similar, without symfony), but I don't want to reinvent the wheel.

Are there any bundles or best practices out there?

Answer 1

As far as I know, there is no bundle providing generic filtering feature. What you are describing here looks a bit like OData filter system queries, and I never found a bundle implementing such a spec.

However, the FOSRestBundle provides a ParamFetcher feature, allowing you to configure the query parameters you may expect, as well as default values, and basic validation constraints. This is something to consider while developing the "filtering part" of an API.