def user_register(body):
sql = """
INSERT INTO "user" (username, email, password, first_name, last_name, created, is_active)
VALUES (%s, %s, %s, %s, %s, %s, %s);
"""
try:
conn = connector.connect()
cur = conn.cursor()
cur.execute(sql, (
body.get('username'),
body.get('email'),
helpers.password_salt(body.get('password')),
body.get('first_name'),
body.get('last_name'),
datetime.now(),
True
))
conn.commit()
conn.close()
return user_detail(body.get('username'))
except Exception as e:
raise Exception(str(e))
def user_detail(username): sql = """SELECT username, email, first_name, last_name, created, is_active FROM "user" WHERE username=%s;""" try: conn = connector.connect() cur = conn.cursor() cur.execute(sql, (username,)) raw = cur.fetchone() cur.close() conn.close() return raw except Exception as e: raise Exception(str(e))
def product_list(query=None):
sql = """
SELECT * FROM product;
"""
try:
conn = connector.connect()
cur = conn.cursor()
cur.execute(sql)
rows = cur.fetchall()
conn.close()
return rows
except:
return False
def product_detail(id):
sql = """
SELECT * FROM product WHERE id=%s;
"""
try:
conn = connector.connect()
cur = conn.cursor()
cur.execute(sql, (id, ))
row = cur.fetchone()
cur.close()
conn.close()
return row
except Exception as e:
raise Exception(str(e))
def product_edit(data, id):
sql = """
UPDATE product SET name=%s, cost=%s, final_price=%s, stock=%s, minimum_stock=%s
WHERE id=%k;
"""
try:
conn = connector.connect()
cur = conn.cursor()
cur.execute(
sql, (data.get('name'), data.get('cost'), data.get('final_price'),
data.get('stock'), data.get('minimum_stock'), id))
conn.commit()
cur.close()
conn.close()
return product_detail(id)
except Exception as e:
raise Exception(str(e))
def product_add(data):
name = data.get('name')
cost = data.get('cost')
final_price = data.get('final_price')
stock = data.get('stock')
minimum_stock = data.get('minimum_stock')
sql = """
INSERT INTO product (name, cost, final_price, stock, minimum_stock)
VALUES (%s, %s, %s, %s, %s);
"""
try:
conn = connector.connect()
cur = conn.cursor()
cur.execute(sql, (name, cost, final_price, stock, minimum_stock))
conn.commit()
conn.close()
return True
except:
return False