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