def search_products_like_category(self):
#Function to find products by category
cat_prod_dict = {}
category_to_check = self.answer.lower().replace(".", "")
category_id = Categories.read_column_sql(
"id", f"WHERE name='{category_to_check}'")
cat_products = Product.display_product(
["name_product", "id_product", "nutrition_grades_product"],
'category_ID', category_id[0])
product_and_grade = []
for element in cat_products:
cat_prod_dict[element[0]] = [element[1], element[2]]
product_and_grade.append(element[0] + " (" + element[2] + ")")
C_EMPTY.append(product_and_grade[-1])
first_question = Question(QUESTIONER, Q3_1, clean=1).answer
choiced_product = Product.display_product(
["*"], "id_product",
f"{cat_prod_dict[first_question[0:-4]][0]}")[0]
C_EMPTY.clear()
self.display_details(choiced_product)
ids = self.ask_found_better(category_id)
if ids != MAIN_MENU:
self.ask_add_favourite(ids, choiced_product[0])
return MAIN_MENU
