The colors "black", "green" and "red" are listed as ingredient names

openculinary / knowledge-graph

The RecipeRadar knowledge graph stores and provides access to recipe and ingredient relationship information.

GNU Affero General Public License v3.0

10 stars 0 forks source link

The colors "black", "green" and "red" are listed as ingredient names #66

Closed jayaddison closed 2 years ago

jayaddison commented 3 years ago

Describe the bug This is essentially the same issue as #64, albeit for three named colours.

jayaddison commented 3 years ago

Status:

[x] products.csv update
[x] hierarchy.json file regeneration
[x] knowledge-graph service redeployment
[x] affected recipe reindexing
[x] verification

jayaddison commented 3 years ago

It would be really nice if the process of updating the product metadata produced a precise list of the affected recipes for recrawling as a side-effect. Currently they have to be identified by making additional queries, either against the database and/or search index.

jayaddison commented 3 years ago

$ python recipes.py --where "exists (select * from recipe_ingredients as ri where ri.recipe_id = recipes.id and ri.markup ilike '%>black<%')" --recrawl
$ python recipes.py --where "exists (select * from recipe_ingredients as ri where ri.recipe_id = recipes.id and ri.markup ilike '%>green<%')" --recrawl
$ python recipes.py --where "exists (select * from recipe_ingredients as ri where ri.recipe_id = recipes.id and ri.markup ilike '%>red<%')" --recrawl