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)