def modifyQuantity(self, multiplier, id_Cart, id_Ingredient):
query = 'UPDATE CartItem SET multiplier = %(multiplier)s WHERE id_Cart = %(id_Cart)s AND id_Ingredient = %(id_Ingredient)s'
db.replace(
query, {
'id_Cart': id_Cart,
'id_Ingredient': id_Ingredient,
"multiplier": multiplier
})
return self.getByCartAndIngredientIds(id_Cart, id_Ingredient)
def replace(self, ratingModel):
if not isinstance(ratingModel, RatingModel):
raise ValueError("ratingModel should be of type RatingModel")
query = 'UPDATE Rating SET value = %(value)s WHERE id_User = %(id_User)s AND id_Recipe = %(id_Recipe)s'
db.replace(
query, {
'value': ratingModel.value,
'id_Recipe': ratingModel.id_Recipe,
'id_User': ratingModel.id_User
})
return self.getUserRecipeRating(ratingModel.id_User,
ratingModel.id_Recipe)
def modifyQuantity(self, id_Recipe, id_Ingredient, totalQuantity):
query = 'UPDATE RecipeIngredient SET totalQuantity = \'{}\' Where id_Recipe = {} AND id_Ingredient = {}'.format(
totalQuantity, id_Recipe, id_Ingredient)
db.replace(
query, {
'id_Recipe': id_Recipe,
'id_Ingredient': id_Ingredient,
'totalQuantity': totalQuantity
})
return {
'id_Recipe': id_Recipe,
'id_Ingredient': id_Ingredient,
'totalQuantity': totalQuantity
}
def modifyRecipeDirective(self, directives, id):
query = 'UPDATE Recipe SET directives = \'{}\' WHERE id = {}'.format(directives, id)
db.replace(query, {'directives': directives})
return {"id": id, "directives": directives}
def modifyRecipeName(self, name, id):
query = 'UPDATE Recipe SET name = \'{}\' WHERE id = {}'.format(name, id)
db.replace(query, {'id': id, 'name': name})
return {"id": id, "name": name}
def modifyPassword(self, password, id_User):
query = 'UPDATE Account SET password = \'{}\' WHERE id_User = {}'.format(
password, id_User)
db.replace(query, {'id_User': id_User, 'password': password})
return {"id_User": id_User, "password": password}
def modifyEmail(self, email, id_User):
query = 'UPDATE Account SET email = \'{}\' WHERE id_User = {}'.format(
email, id_User)
db.replace(query, {'id_User': id_User, 'email': email})
return {"id_User": id_User, "email": email}