def add(args):
search_request = "SELECT code FROM garbage_types WHERE code = %s"
found_users = execute_all(search_request, (args["code"]))
if len(found_users) != 0:
return "Garbage type '" + args["code"] + "' already exist!", 400
request = "INSERT INTO garbage_types VALUES (%s, %s, %s)"
garbage_info = (args["code"], args["name"], args["unit"])
execute_one(request, garbage_info)
return jsonify({"code": args["code"]})
def add_delivery_point(args, id):
request = "INSERT INTO garbage_collector.`delivery_points` VALUES (null, %s, %s, %s, %s)"
execute_one(request, (args["x"], args["y"], args["address"], id))
delivery_point_id = get_last_id("`delivery_points`")
gt_request = "INSERT INTO garbage_collector.delivery_point_garbage_types VALUES (null, %s, %s)"
for garbage_type in args["garbageTypes"]:
id = find_garbage_type(garbage_type)
execute_one(gt_request, (id, delivery_point_id))
return jsonify({"id": delivery_point_id})
def add(args):
search_request = "SELECT `id` FROM `users` WHERE `type`='citizen' AND `login` = %s"
found_users = execute_all(search_request, (args["login"]))
if len(found_users) != 0:
return "User '" + args["login"] + "' already exist!", 400
passowrd_hash = md5(args["password"].encode('utf-8')).hexdigest()
request = "INSERT INTO garbage_collector.`users` VALUES (null, %s, %s, now(), 'citizen')"
citizen_info = (args["login"], passowrd_hash)
execute_one(request, citizen_info)
id = get_last_id("`users`")
return jsonify({"id": id})
def get_points(id):
request = "SELECT Loyalty FROM gamefication_state WHERE UserId = %s"
result = execute_one(request, (id))
return jsonify(result)
def delete(id):
request = "DELETE FROM garbage_collector.`users` WHERE id=%s"
execute_one(request, (id))
return "0k"
def delete(code):
request = "DELETE FROM garbage_types WHERE code=%s"
execute_one(request, (code))
return "0k"
def find_garbage_type(garbage_type):
request = "SELECT code FROM `garbage_types` WHERE code=%s"
result = execute_one(request, (garbage_type))
return result["code"]