def find_drinker(name):
if name is None:
raise ValueError("Drinker is not specified.")
drinker = database.find_drinker(name)
if drinker is None:
return make_response("No drinker found with the given name.", 404)
return jsonify(drinker)
def insert_transaction3(drinker):
try:
name = database.find_drinker(drinker)
if name is None:
return make_response("drinker name does not exist.", 400)
return jsonify(database.insert_transaction3(drinker))
except ValueError as e:
return make_response(str(e), 400)
except Exception as e:
return make_response(str(e), 500)
def find_drinker(name):
try:
if name is None:
raise ValueError("Drinker is not specified.")
drinker = database.find_drinker(name)
if drinker is None:
return make_response("No drinker found with the given name.", 404)
return jsonify(drinker)
except ValueError as e:
return make_response(str(e), 400)
except Exception as e:
return make_response(str(e), 500)
def get_most_ordered_beer(name):
try:
if name is None:
raise ValueError('Drinker is not specified.')
drinker = database.find_drinker(name)
if drinker is None:
return make_response("No drinker found with the given name.")
return jsonify(database.get_most_ordered_beer(name))
except ValueError as e:
return make_response(str(e), 400)
except Exception as e:
return make_response(str(e), 500)
def add_Drinker():
if request.method == 'POST':
name = request.form['name']
phone_num = request.form['phone_num']
city = request.form['city']
addr = request.form['Address']
find_drinker = database.find_drinker(name, phone_num, addr, city)
if len(find_drinker) > 0:
return render_template('error.html')
else:
insert_drinker = database.insert_drinker(name, phone_num, addr,
city)
return render_template('submission.html',
insert_drinker=insert_drinker)
else:
return render_template('add.html', result4=" ")
def get_drinker_spendings_bymonth(name, bar, month):
try:
if bar is None:
raise ValueError("Bar is not specified")
bar1 = find_bar (bar)
if bar1 is None:
return make_response("No Bar found with the given bar name" )
if month is None:
raise ValueError("Month is not specified")
if name is None:
raise ValueError("Drinker is not specified or DNE")
drinker = database.find_drinker(name)
if drinker is None:
return make_response ("No drinker found with the given name")
return jsonify(database.get_drinker_spendings_bymonth(name,bar,month))
except ValueError as e:
return make_response(str(e), 400)
except Exception as e:
return make_response(str(e), 500)