def get_aluno(matricula): try: if matricula is None: abort(404) with Database.getConn().cursor() as cursor: sql = "SELECT nome, email, endereco, cpf, matricula, telefone FROM aluno WHERE matricula = %s" cursor.execute(sql, (matricula)) result = cursor.fetchone() from classes.Aluno import Aluno return jsonify(Aluno(result).__dict__) finally: Database.closeConn()
def index(): try: with Database.getConn().cursor() as cursor: sql = "SELECT nome, email, endereco, matricula FROM aluno" cursor.execute(sql) result = cursor.fetchall() return_data = [] for aluno in result: from classes.Aluno import Aluno return_data.append(Aluno(aluno).__dict__) return jsonify(return_data) finally: Database.closeConn()
def delete_aluno(): try: if request.form['matricula'] is None: abort(404) return_data = {"success": False} with Database.getConn().cursor() as cursor: sql = "DELETE FROM aluno WHERE matricula = %s" cursor.execute(sql, (request.form['matricula'])) Database.getConn().commit() return_data['success'] = True return jsonify(return_data) finally: Database.closeConn()
def post_aluno(): try: if not request.json: abort(400) request_data = (request.json['nome'], request.json['email'], request.json['endereco']) from classes.Aluno import Aluno aluno = Aluno(request_data) matricula = random.randint(100, 2000) return_data = {"success": False} with Database.getConn().cursor() as cursor: sql = "INSERT INTO aluno (nome, email, endereco, matricula) VALUES (%s, %s, %s, %s)" cursor.execute( sql, (aluno.name, aluno.email, aluno.endereco, matricula)) Database.getConn().commit() aluno.matricula = matricula return_data['success'] = True return_data['aluno'] = aluno.__dict__ return jsonify(return_data) finally: Database.closeConn()