Product filter by category

[raphodn]

Story

Following #154

We need to add a new filter capability to find only products of a certain category. Bonus : allow filtering by multiple categories as well.

But I'm not exactly sure how to proceed with the fastapi-filter library. I opened an issue : arthurio/fastapi-filter#556

Or maybe I'm missing something ? 😅

[raphodn]

@raphael0202 need your help on this 😇

[raphael0202]

From what I see it's not supported by fastapi-filter, we can either:

• work on adding this feature to fastapi-filter, and wait for a release
• supercharge the fastapi-filter class to implement it from our side, without contributing to the source

I would personally be in favor of option 1 if the maintainer reply fast :)

[raphodn]

I looked into updating the fastapi-filter library, but our need here is linked to postgresql array, whereas the library does only filtering on basic/sqlite fields.

So I ended up trying something in our API directly, you can have a look here : #234

• it works :)
• missing some tests (still having issues with our test setup, when I comment out the product filtering tests they fail)

[raphodn]

Now possible to filter by categories_tags (single tag only) : Done in #234

https://prices.openfoodfacts.org/api/v1/products?categories_tags__contains=en:beverages

Edit : now possible to filter by labels_tags (single tag only) : done in #238

https://prices.openfoodfacts.org/api/v1/products?labels_tags__contains=en:organic

Edit 2 : now possible to filter by brands_tags (single tag only) : done in #390

https://prices.openfoodfacts.org/api/v1/products?brands_tags__contains=carrefour-bio