def create_db(): """ Create the db""" conn = open_connection() cur = conn.cursor() for query in QUERIES: cur.execute(query)
def orders(): ''' Make an order ''' conn = open_connection() cur = conn.cursor() if request.method == 'POST': order_desc = request.get_json('order_desc')['order'] user_id = request.get_json('user_id')['user_id'] if not order_desc or order_desc == " ": response = jsonify({"message": "You have not made an order"}) response.status_code = 400 return response if not request.json: response = jsonify({"message": "incorrect request format"}) response.status_code = 400 return response Order(str(order_desc)) cur.execute("update users set orders = array_append(orders, '{}') where user_id = {}".format(order_desc, user_id)) conn.commit() return jsonify({'message': "your order has been created"}) user_id = request.get_json('user_id')['user_id'] cur.execute("select orders from users where user_id ={}".format(user_id)) orders = cur.fetchall() return jsonify({"orders": orders})
def __init__(self, order_desc): self.order_desc = order_desc conn = open_connection() cur = conn.cursor() cur.execute( "insert into orders(order_desc) values('{}')".format(order_desc)) cur.close() conn.commit()
def __init__(self, item, cost): self.item = item self.cost = cost conn = open_connection() cur = conn.cursor() cur.execute("insert into menu(item,cost) values('{}',{})".format( item, cost)) cur.close() conn.commit()
def get_order(order_id): ''' Get one order function ''' if request.method == 'GET': conn = open_connection() cur = conn.cursor() cur.execute("select * from orders where order_id = {}".format(order_id)) order = cur.fetchone() if len(order) == 0: response = jsonify({"message": "Cannot find that order"}) response.status_code = 404 return response return jsonify({"order": order}) conn = open_connection() cur = conn.cursor() cur.execute("delete from orders where order_id = {}".format(order_id)) cur.close() return jsonify({'message': " Order deleted successfully"})
def sign_up(): conn = open_connection() cur = conn.cursor() email = request.get_json('email')['email'] password = request.get_json('password')['password'] username = request.get_json('username')['username'] cur.execute("select * from users where username = '******'".format(username)) names = cur.fetchall() cur.close() if len(names) > 0: response = jsonify({"message": "Username is taken"}) response.status_code = 409 return response if not email or email == " ": response = jsonify({"message": "Email not provided"}) response.status_code = 400 return response if not re.match(email_format, email): return jsonify({"message": "incorrect email format"}) if not password or password == " ": response = jsonify({"message": "Password not provided"}) response.status_code = 400 return response if not username or username == " ": response = jsonify({"message": "Username not provided"}) response.status_code = 400 return response if not request.json: response = jsonify({"message": "Incorrect request format"}) response.status_code = 400 return response user = User(email, password) register = user.signup(username) return register