def delete_student(id):
db = DBConnect()
result = db.execute("DELETE FROM students WHERE id='{}'".format(id))
response_object = {'method': 'deleted {}'.format(id)}
db.close()
return json.dumps(response_object)
def update_student(id):
request_data = get_request_data(request)
if len(request_data) == 0:
return json.dumps({'error': 'no data'})
db = DBConnect()
result = db.execute("UPDATE students SET {} WHERE id='{}'".format(to_string(request_data), id))
response_object = {'method': 'updated {}'.format(id)}
db.close()
return json.dumps(response_object)
def add_student():
request_data = get_request_data(request)
if len(request_data) == 0:
return json.dumps({'error': 'no data'})
db = DBConnect()
values = (
request_data.get('name'),
request_data.get('phone'),
request_data.get('email'),
request_data.get('address'),
)
result = db.execute("INSERT INTO students (name, phone, email, address) VALUES (%s,%s,%s,%s)", values)
response_object = {'method': 'created {}'.format(id)}
db.close()
return json.dumps(response_object)
