def validate_get_request(request, params):
if request is None:
raise ErrorHandler(403, "Validation failed : No params")
if request.args is None:
raise ErrorHandler(403, "Validation failed : No params")
for param in params:
if request.args.get(param) is None:
raise ErrorHandler(
403, "Validation failed , no param : {}".format(param))
def validate_onj(dish_id, ing_id, amount):
if dish_id is None or ing_id is None or amount is None:
raise ErrorHandler(403,
"Dish Ingredient : validation failed, must fill : dish_id(int) , ing_id(int) and amount(int)")
if isinstance(dish_id, int) and isinstance(ing_id, int) and isinstance(amount, int) and amount > 0:
return
else:
raise ErrorHandler(403,
"Dish Ingredient : validation failed, must fill : dish_id(int) , ing_id(int) and amount(int)")
def insert(self, query, params):
try:
self.cursor = self.conn.cursor()
self.cursor.execute(query, params)
self.cursor.close()
self.conn.commit()
return self.cursor.lastrowid
except Exception as e:
print(
"INSERT : error received from sql for query {query} with error {error}"
.format(query=query, error=e))
if e.args[0] == 1062:
raise ErrorHandler(400, "Already Exists")
else:
raise ErrorHandler(500, e)
def is_exists(self, query, params):
try:
self.cursor = self.conn.cursor()
self.cursor.execute(query, params)
result = self.cursor.fetchall()
self.cursor.close()
return len(result) > 0
except Exception as e:
print("SELECT : error received from sql for query {query}".format(
query=query))
raise ErrorHandler(500, e)
def delete(self, query, params):
try:
self.cursor = self.conn.cursor()
self.cursor.execute(query, params)
self.cursor.close()
self.conn.commit()
return True
except Exception as e:
print("DELETE : error received from sql for query {query}".format(
query=query))
raise ErrorHandler(500, e)
def get(self, query, params):
try:
self.cursor = self.conn.cursor()
if params == ():
self.cursor.execute(query)
else:
self.cursor.execute(query, params)
result = self.cursor.fetchall()
self.cursor.close()
return result
except Exception as e:
print(
"SELECT : error received from sql for query {query} ׳with error {err}"
.format(query=query, err=e))
raise ErrorHandler(500, e)
def validate_insert_obj(obj):
if 'user' not in obj:
raise ErrorHandler(403, "Dish : validation failed, no user")
if 'dish_id' not in obj:
raise ErrorHandler(403, "Dish : validation failed, no dish id")
if 'calories' not in obj:
raise ErrorHandler(403, "Dish : validation failed, no calories")
if 'recipe' not in obj:
raise ErrorHandler(403, "Dish : validation failed, no recipe")
if 'peopleCount' not in obj:
raise ErrorHandler(403, "Dish : validation failed, no peopleCount")
if 'cookingTime' not in obj:
raise ErrorHandler(403, "Dish : validation failed, no cookingTime")
if 'photoLink' not in obj:
raise ErrorHandler(403, "Dish : validation failed, no photoLink")
def validate_dish(dish):
if 'name' not in dish:
raise ErrorHandler(403, "Dish : validation failed, no name")
if 'recipe' not in dish:
raise ErrorHandler(403, "Dish : validation failed, no recipe")
if 'peopleCount' not in dish:
raise ErrorHandler(403, "Dish : validation failed, no peopleCount")
if 'cookingTime' not in dish:
raise ErrorHandler(403, "Dish : validation failed, no cookingTime")
if 'photoLink' not in dish:
raise ErrorHandler(403, "Dish : validation failed, no photoLink")
if 'calories' not in dish:
raise ErrorHandler(403, "Dish : validation failed, no calories")
def validate_dish_search(dish):
if 'text' not in dish:
raise ErrorHandler(403, "Dish search : validation failed, no text")
def validate_insert(meal_id, dish_id, creation_date):
if dish_id is None or meal_id is None or creation_date is None:
raise ErrorHandler(
403,
"Meal Dishes : validation failed, must fill : meal_id(int) , dish_id(int)"
)
def validate_insert(user_id, creation_date):
if user_id is None or creation_date is None:
raise ErrorHandler(403, "User Meal : validation failed, no user id")
def validate_request(request):
if not request.is_json:
raise ErrorHandler(403, "Validation failed : No Data")
if request.json is None:
raise ErrorHandler(403, "Validation failed : No Data")
def validate_get(user):
if 'email' not in user:
raise ErrorHandler(403, "User : Validation failed, no email")
if 'password' not in user:
raise ErrorHandler(403, "User : Validation failed, no password")
def validate_insert(user):
validate_get(user)
if 'user' not in user:
raise ErrorHandler(403, "User : Validation failed, no user")
def return_internal_err(self, msg):
raise ErrorHandler(ERROR, msg)
def return_not_found(self, err):
raise ErrorHandler(NOT_FOUND, err)
def return_validation_err(self, err):
raise ErrorHandler(VALIDATION_ERR, err)
def validate_get(meal_id):
if meal_id is None:
raise ErrorHandler(
403, "Meal Dishes : validation failed, must add meal_id(int)")
def validate_get(user_id):
if user_id is None:
raise ErrorHandler(403, "User Meal : validation failed, no user id")