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)
def get_student(id): db = DBConnect() result = db.query("SELECT * FROM students WHERE id='{}'".format(id)) db.close() return json.dumps(result)
def get_students(): db = DBConnect() result = db.query("SELECT * FROM students") db.close() return json.dumps(result)