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