def find(user_product):
"""
used for finding substitute from selected product
"""
user_product.categories = Category.load_from_id(user_product.id)
i = 1
substitute = list()
cur = Database.createCursor()
cur.execute("""
SELECT product_id
FROM categories_products
INNER JOIN categories
ON categories_products.category_id = categories.id
INNER JOIN products
ON categories_products.product_id = products.id
WHERE categories.name = %s
AND products.nutriscore = 'a' limit 5""",
(user_product.categories[0], ))
for elt in cur.fetchall():
substituts_with_id = dict()
substituts_with_id['id'] = i
substituts_with_id['product'] = Product.get(elt[0])
substitute.append(substituts_with_id)
i += 1
cur.close()
return substitute
def display(self):
"""
displaying product
"""
return ('**********************\n'
'id : {}\n'
'Marque : {}\n'
'Nom: {}\n'
'Image: {}\n'
'Url: {}\n'
'Description: {}\n'
'Nutriscore: {}\n'
'Magasins: {}\n'
'Catégories: {}\n'
'**********************'.format(
self.id, self.brands, self.name, self.image, self.url,
self.description, self.nutriscore,
Store.load_from_id(self.id),
Category.load_from_id(self.id)))
