def removeNota(self, request, context): cursor.execute( """ DELETE FROM Matricula WHERE RA = ? and cod_disciplina = ? and ano = ? and semestre = ? """, (request.RA, request.cod_disciplina, request.ano, request.semestre)) return matricula_pb2.Mess(mess='inserido com sucesso')
def cadastraNota(self, request, context): # lista = [(int(request[2]), request[3], int(request[4]), int(request[5]), int(request[6]), int(request[7].split("\"")[0]))] lista = [(request.RA, request.cod_disciplina, request.ano, request.semestre, request.nota, request.faltas)] cursor.executemany( """ INSERT INTO Matricula (RA, cod_disciplina, ano, semestre, nota, faltas) VALUES (?,?,?,?,?,?) """, lista) conn.commit() print("inserido com sucesso") return matricula_pb2.Mess(mess='inserido com sucesso')
def atualizaNota(self, request, context): lista = (request.Nota, request.RA, request.cod_disciplina, request.ano, request.semestre) cursor.execute( """ UPDATE Matricula SET nota = ? WHERE RA = ? and cod_disciplina = ? and ano = ? and semestre = ? """, lista) conn.commit() return matricula_pb2.Mess(mess='inserido com sucesso')
def consultaNota(self, request, context): lista = (request.RA, ) cursor.execute( """ SELECT m.cod_disciplina, d.nome, m.nota, m.faltas FROM Disciplina d, Matricula m WHERE m.RA = ? and m.cod_disciplina = d.codigo """, lista) records = cursor.fetchall() valor = '' for row in records: for value in row: valor = valor + str(value) + ', ' valor = valor + '\n' return matricula_pb2.Mess(mess=valor)
def consultaAluno(self, request, context): lista = (request.cod_disciplina, request.ano, request.semestre) cursor.execute( """ SELECT m.RA, a.nome, a.periodo FROM Aluno a, Matricula m WHERE m.cod_disciplina = ? and m.ano = ? and m.semestre = ? and a.RA = m.RA """, lista) records = cursor.fetchall() valor = '' for row in records: for value in row: valor = valor + str(value) + ', ' valor = valor + '\n' return matricula_pb2.Mess(mess=valor)