def add_member(): new_member = [value for value in request.get_json().values()] db = db_helpers.get_db() db.execute("INSERT INTO members (name,email,level) VALUES (?,?,?)", new_member) db.commit() return "Membro inserido com sucesso"
def get_member(member_id): db = db_helpers.get_db() response_qry = db.execute( "SELECT * FROM members WHERE id == {}".format(member_id)) data_member = response_qry.fetchone() member = { "id": data_member["id"], "name": data_member["name"], "email": data_member["email"], "level": data_member["level"] } return jsonify(member)
def get_members(): db = db_helpers.get_db() response_qry = db.execute("SELECT * FROM members") members = response_qry.fetchall() list_members = [] for member in members: member = { "id": member["id"], "name": member['name'], "email": member["email"], "level": member["level"] } list_members.append(member) return jsonify(list_members)
def edit_member(member_id): db = db_helpers.get_db() if request.method == "PUT": new_values = [value for value in request.get_json().values()] new_values.append(member_id) db.execute( "UPDATE members SET name = '{}',email = '{}',level = '{}' WHERE id = {}" .format(*new_values)) db.commit() return "Membro COMPLETAMENTE editado com sucesso" keys = [*request.get_json()] values = [*request.get_json().values()] qry = "UPDATE members SET " for n in range(len(values)): if n < len(values) - 1: qry += "{} = '{}',".format(keys[n], values[n]) elif n == len(values) - 1: qry += "{} = '{}'".format(keys[n], values[n]) qry += " WHERE id = {}".format(member_id) db.execute(qry) db.commit() return "Membro PARCIALMENTE editado com sucesso"
def delete_member(member_id): db = db_helpers.get_db() db.execute("DELETE FROM members WHERE id == {}".format(member_id)) db.commit() return "Membro deletado com sucesso"
def delete_members(): db = db_helpers.get_db() db.execute("DELETE FROM members") db.commit() return "Todos os membros foram deletados com sucesso"