def get_rate_template_context(buff, user_id):
"""
return the template name and correct context for rating and comment
"""
day = Helper.get_day_of_week()
week = Helper.get_week_number()
if day in ["saturday", "sunday"]:
return {"template": "weekend_rate_error", "context": {}}
else:
meal = buff[1]
option = buff[2]
rating = buff[3]
comment = " ".join(buff[4:]) or "no comment"
check_option = Helper.check_option_selected(option, day, week, meal)
if not Helper.check_meal_selected(meal):
return {"template": "invalid_meal", "context": {}}
if not check_option["bool"]:
return {"template": "invalid_option", "context": {"option_count": check_option["option"]}}
if not Helper.check_rating(rating):
return {"template": "invalid_rating", "context": {}}
if Helper.check_multiple_rating(user_id, meal):
return {"template": "multiple_rating", "context": {}}
variables = (meal, day, week, option)
sql = CustomSQL()
query_string = (
"SELECT id FROM menu_table WHERE meal = (%s) AND day = (%s) AND week = (%s) AND option = (%s)"
)
result = sql.query(query_string, variables)
food_menu_id = int(result[0][0])
get_date = Helper.get_date()
variables = (user_id, food_menu_id, rating, comment, get_date)
query_string = (
"INSERT INTO rating (user_id, menu_id, rate, comment, created_at) VALUES (%s, %s, %s, %s, %s)"
)
sql.command(query_string, variables)
return {"template": "rating_response", "context": {}}
def get_rate_template_context(buff, user_id):
"""
return the template name and correct context for rating and comment
"""
day = Helper.get_day_of_week()
week = Helper.get_week_number()
if day in ['saturday', 'sunday']:
return {'template': 'weekend_rate_error', 'context': {}}
else:
meal = buff[1]
option = buff[2]
rating = buff[3]
comment = ' '.join(buff[4:]) or 'no comment'
check_option = Helper.check_option_selected(option, day, week,
meal)
if Helper.check_meal_selected(meal) is False:
return {'template': 'invalid_meal', 'context': {}}
if check_option['bool'] is False:
return {'template': 'invalid_option',
'context': {'option_count': check_option['option']}}
if Helper.check_rating(rating) is False:
return {'template': 'invalid_rating', 'context': {}}
variables = (meal, day, week, option,)
sql = CustomSQL()
query_string = 'SELECT id FROM menu_table WHERE meal = (%s) AND day = (%s) AND week = (%s) AND option = (%s)'
result = sql.query(query_string, variables)
food_menu_id = int(result[0][0])
variables = (user_id, food_menu_id, rating, comment)
query_string = "INSERT INTO rating (user_id, menu_id, rate, comment) VALUES (%s, %s, %s, %s)"
sql.command(query_string, variables)
return {'template': 'rating_response', 'context': {}}
