def deleteUserByID(user_id):
data = getUserByID(user_id)
if data == "No data to return.":
return {"msg": "User with user_id " + str(user_id) + " does not exist in DB."}
else:
data = 'DELETE FROM "user" WHERE user_id = ' + (str(user_id))
return querydb(data, 'DELETE', user_id=user_id)
def deleteFlowerByID(flower_id):
data = getFlowerByID(flower_id)
if data == "No data to return.":
return {"msg": "Flower with flower_id " + str(flower_id) + " does not exist in DB."}
else:
data = 'DELETE FROM flower WHERE flower_id = ' + (str(flower_id))
return querydb(data, 'DELETE', flower_id=flower_id)
def putFlowerByID(request, flower_id):
data = getFlowerByID(flower_id)
if data == "No data to return.":
return postFlower(request)
else:
putData = putDataCheck(request, data)
if putData == "Something went wrong in mapping data.":
return {"msg": "Something went wrong in mapping data."}, 500
data = "UPDATE flower SET flower_id = '" + str(flower_id) + "', name_ser = '" + putData[0] + "', name_lat = '" + \
putData[1] + "', description = '" + putData[2] + "', watering_period = '" + putData[
3] + "' WHERE flower_id = '" + str(flower_id) + "'"
return querydb(data, 'PUT', flower_id=flower_id)
def postUsers2Flowers(request):
checkQuery = 'SELECT * FROM user2flower WHERE user_id=' + str(
request.json['user_id']) + ' AND flower_id=' + str(
request.json['flower_id'])
if getAllUsers2Flowers(checkQuery) == {'msg': 'No data to return.'}:
data = "INSERT INTO user2flower (user_id, flower_id, date_of_inception, email) values ('" + str(
request.json['user_id']) + "', '" + str(
request.json['flower_id']) + "', '" + str(
request.json['date_of_inception']) + "', '" + str(
request.json['email']) + "')"
return querydb(data, operation='POST')
else:
return {'msg': 'That entry already exists in DB.'}
def postUser(request):
# Check if user with that email or username already exists in DB
checkUserEmail = 'SELECT * FROM "user" WHERE email=' + "'" + str(
request.json['email']) + "' OR username="******"'" + str(request.json['username']) + "'"
checkResponse = getAllUsers(checkUserEmail)
if checkResponse == ({'msg': 'No data to return.'}, 204):
passwd = sha256_crypt.encrypt(str(request.json['password']))
data = "INSERT INTO \"user\" (first_name, last_name, username, email, admin, password) values ('" + str(
request.json['first_name']) + "', '" + str(request.json['last_name']) + "', '" + str(
request.json['username']) + "', '" + str(request.json['email']) + "', '" + str(
request.json['admin']) + "', '" + str(passwd) + "')"
return querydb(data, operation='POST')
else:
return {"msg": "Email or username already in use."}
def putUser2flowerByID(request, user2flower_id):
data = getUser2flowerByID(user2flower_id)
if data == "No data to return.":
return postUsers2Flowers(request)
else:
putData = putDataCheck(request, data)
if putData == "Something went wrong in mapping data.":
return {"msg": "Something went wrong in mapping data."}, 500
data = "UPDATE user2flower SET user2flower_id = '" + str(
user2flower_id
) + "', user_id = '" + putData[0] + "', flower_id = '" + putData[
1] + "', date_of_inception = '" + putData[2] + "', email = '" + str(
putData[3]) + "' WHERE user2flower_id = '" + str(
user2flower_id) + "'"
return querydb(data, 'PUT', user2flower_id=user2flower_id)
def putUserByID(request, user_id):
# Check if user with user_id already exist
data = getUserByID(user_id)
if data == "No data to return.":
return postUser(request), 204
else:
# Map sent data to user data
putData = putDataCheck(request, data)
if putData == "Something went wrong in mapping data.":
return {"msg": "Something went wrong in mapping data."}, 500
data = "UPDATE \"user\" SET user_id = '" + str(user_id) + "', first_name = '" + putData[
0] + "', last_name = '" + \
putData[1] + "', username = '******', email = '" + putData[3] + "', admin = '" + putData[4] + \
"', password = '******' WHERE user_id = '" + str(user_id) + "'"
return querydb(data, 'PUT', user_id=user_id)
def getAllUsers(data=None):
if data is None:
data = 'SELECT * FROM "user"'
return querydb(data, operation='GET', check='list')
def getUserByID(user_id):
data = 'SELECT * FROM "user" where user_id = ' + str(user_id)
return querydb(data, 'GET', 'tuple', user_id=user_id)
def getUserByUsername(username):
data = 'SELECT * FROM "user" where username = '******'" + str(username) + "'"
data = querydb(data, operation='GET', check='tuple', )
if data == "No data to return.":
return data, 204
return data
def postFlower(request):
data = "INSERT INTO flower (name_ser, name_lat, description, watering_period) values ('" + str(
request.json['name_ser']) + "', '" + str(request.json['name_lat']) + "', '" + str(
request.json['description']) + "', '" + str(request.json['watering_period']) + "')"
return querydb(data, operation='POST')
def getAllFlowers():
data = 'SELECT * FROM flower'
return querydb(data, operation='GET', check='list')
def getFlowerByID(flower_id):
data = 'SELECT * FROM flower where flower_id = ' + str(flower_id)
return querydb(data, 'GET', 'tuple', flower_id=flower_id)
