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)