def deleteUsers(id):
sql = f'DELETE from CustomerService.users WHERE id={id};'
print(sql)
msg = dbsvc.getDbConnection(sql)
print(msg)
rsp = Response(json.dumps(msg, default=str), status=200, content_type="application/json")
return rsp
def getAddresses(parameter=""):
if parameter:
sql = f"SELECT * from CustomerService.addresses LIMIT {parameter};"
else:
sql = f"SELECT * from CustomerService.addresses;"
msg = dbsvc.getDbConnection(sql)
print(msg)
rsp = Response(json.dumps(msg, default=str), status=200, content_type="application/json")
return rsp
def activateUser():
body = json.loads(request.data.decode())
email = body['email']
email = f"'{email}'"
stringy = "email_verification = 'active'"
sql = f'UPDATE CustomerService.users SET {stringy} WHERE email={email};'
print(sql)
msg = dbsvc.getDbConnection(sql)
if msg == 0:
return Response("Failure", status=404)
print(msg)
return Response("Success", status=200)
def updateAddress(id):
body = json.loads(request.data.decode())
names = [x for x, y in body.items()]
values = [y for x, y in body.items()]
stringy = ''
for i, name in enumerate(names):
stringy += f'{name} = "{values[i]}", '
stringy = stringy[:-2]
print(stringy)
sql = f'UPDATE CustomerService.addresses SET {stringy} WHERE id={id};'
print(sql)
msg = dbsvc.getDbConnection(sql)
print(msg)
rsp = Response(json.dumps(msg, default=str), status=200, content_type="application/json")
return rsp