def delete_user(user_id):
DBService.DBConnect("UserData.db", "User")
try:
DBService.delete(user_id)
except:
abort(404)
finally:
DBService.DBClose()
return jsonify({'result': True})
def get_user(user_id):
DBService.DBConnect("UserData.db", "User")
try:
selectResult = DBService.select_By_ID(user_id)
except:
abort(404)
finally:
DBService.DBClose()
return jsonify({'users': selectResult})
def update_user(user_id):
if not request.json or not 'name' in request.json or not 'birthday' in request.json:
abort(404)
DBService.DBConnect("UserData.db", "User")
try:
DBService.update(user_id,
[request.json['name'], request.json['birthday']])
except:
abort(404)
finally:
DBService.DBClose()
return jsonify({'result': True})
def add_user():
if not request.json or not 'name' in request.json or not 'birthday' in request.json:
abort(404)
DBService.DBClose()
DBService.DBConnect("UserData.db", "User")
try:
id = DBService.insert([request.json['name'], request.json['birthday']])
selectResult = DBService.select_By_ID(id)
except:
abort(404)
finally:
DBService.DBClose()
return jsonify({'users': selectResult})
def get_allusers():
DBService.DBConnect("UserData.db", "User")
selectResult = DBService.select_All()
DBService.DBClose()
return jsonify({'users': selectResult})
