def updateMark(session, mark):
result = session.query(Mark).filter(Mark.markId == mark.markId).first()
result = mark
session.commit()
result = session.query(Mark).filter(Mark.markId == mark.markId).first()
result.teacher = getTeachersByTeacherId(session, result.teacherId)[0]
result.student = getStudentsByStudentId(session, result.studentId)[0]
result.classe = getClassesByClasseId(session, result.classeId)[0]
return result
def addAbsente(session, absente):
absente.creationTime = datetime.datetime.utcnow()
session.add(absente)
session.commit()
#this must stay because sqlalchemy query the database because of this line
print('Value inserted with absenteId=', absente.absenteId)
absente.teacher = getTeachersByTeacherId(session, absente.teacherId)[0]
absente.student = getStudentsByStudentId(session, absente.studentId)[0]
absente.classe = getClassesByClasseId(session, absente.classeId)[0]
return absente
def addMark(session, mark):
mark.creationTime = datetime.datetime.utcnow()
session.add(mark)
session.commit()
#this must stay because sqlalchemy query the database because of this line
print('Value inserted with markId=', mark.markId)
mark.teacher = getTeachersByTeacherId(session, mark.teacherId)[0]
mark.student = getStudentsByStudentId(session, mark.studentId)[0]
mark.classe = getClassesByClasseId(session, mark.classeId)[0]
return mark
def updateAbsente(session, absente):
result = session.query(Absente).filter(
Absente.absenteId == absente.absenteId).first()
result = absente
session.commit()
result = session.query(Absente).filter(
Absente.absenteId == absente.absenteId).first()
result.teacher = getTeachersByTeacherId(session, result.teacherId)[0]
result.student = getStudentsByStudentId(session, result.studentId)[0]
result.classe = getClassesByClasseId(session, result.classeId)[0]
return result
def updateStudentClasse(session, studentClasse):
result = session.query(StudentClasse).filter(
StudentClasse.studentClasseId ==
studentClasse.studentClasseId).first()
result = studentClasse
session.commit()
result = session.query(StudentClasse).filter(
StudentClasse.studentClasseId ==
studentClasse.studentClasseId).first()
result.classe = getClassesByClasseId(session, result.classeId)[0]
result.student = getStudentsByStudentId(session, result.studentId)[0]
return result
def addStudentClasse(session, studentClasse):
studentClasse.creationTime = datetime.datetime.utcnow()
session.add(studentClasse)
session.commit()
#this must stay because sqlalchemy query the database because of this line
print('Value inserted with studentClasseId=',
studentClasse.studentClasseId)
studentClasse.classe = getClassesByClasseId(session,
studentClasse.classeId)[0]
studentClasse.student = getStudentsByStudentId(session,
studentClasse.studentId)[0]
return studentClasse