def deleteproduct(name):
ambilnama(name)
if (mycursor.rowcount > 0):
mycursor.execute("DELETE FROM product WHERE name= %s", (name))
mydb.commit()
ambilnama(name)
rv = mycursor.fetchall()
payload = []
for result in rv:
payload.append(result)
return json.dumps(payload)
else:
return ("product not found")
def login(email, password):
mycursor.execute(
"""SELECT * FROM User WHERE email = %s and password =%s""",
(email, password))
if (mycursor.rowcount > 0):
mycursor.execute("""SELECT * FROM User WHERE email = %s""", (email))
rv = mycursor.fetchall()
payload = []
for result in rv:
payload.append(result)
return json.dumps(payload)
else:
return ("wrong email or password")
def register(name, gender, email, password):
ambilemail(email)
if (mycursor.rowcount == 0):
mycursor.execute(
"INSERT INTO User(name,gender,email,password,role) VALUES (%s,%s,%s,%s,%s)",
(name, gender, email, password, "Client"))
mydb.commit()
ambilemail(email)
rv = mycursor.fetchall()
payload = []
for result in rv:
payload.append(result)
return json.dumps(payload)
else:
return ("email already registered")
def updateproduct(name, quantity, price):
ambilnama(name)
if (mycursor.rowcount > 0):
mycursor.execute(
"UPDATE product set quantity =%s, price=%s where name = %s",
(quantity, price, name))
mydb.commit()
ambilnama(name)
rv = mycursor.fetchall()
payload = []
for result in rv:
payload.append(result)
return json.dumps(payload)
else:
return ("product not registered yet")
def inputproduct(name, quantity, price):
ambilnama(name)
if (mycursor.rowcount == 0):
mycursor.execute(
"INSERT INTO product(name,quantity,price) VALUES (%s,%s,%s)",
(name, quantity, price))
mydb.commit()
ambilnama(name)
rv = mycursor.fetchall()
payload = []
for result in rv:
payload.append(result)
return json.dumps(payload)
else:
return ("product already registered")
def ambilemail(email):
mycursor.execute("""SELECT * FROM User WHERE email = %s""", (email))
return mycursor
def ambilnama(name):
mycursor.execute("""SELECT * FROM product WHERE name = %s""", (name))
return mycursor