class Attendance(DB.Model):
"""Класс для сущности 'Посещаемость'"""
__tablename__ = 'attendance'
__table_args__ = (
DB.ForeignKeyConstraint(['attendance_teaching_lesson_id', 'attendance_curriculum_unit_id'],
['teaching_lesson_and_curriculum_unit.teaching_lesson_id',
'teaching_lesson_and_curriculum_unit.curriculum_unit_id']),
)
attendance_teaching_lesson_id = DB.Column(DB.Integer, primary_key=True, autoincrement=True)
attendance_curriculum_unit_id = DB.Column(DB.Integer, primary_key=True, autoincrement=True)
lesson_attendance = DB.Column(DB.Boolean, nullable=False)
lesson_date = DB.Column(DB.Date, nullable=False)
student_id = DB.Column(DB.BigInteger, DB.ForeignKey('student.student_id'), nullable=False)
def __repr__(self):
return "Attendance(attendance_teaching_lesson_id={attendance_teaching_lesson_id}," \
" attendance_curriculum_unit_id={attendance_curriculum_unit_id}," \
" lesson_attendance={lesson_attendance}," \
" lesson_date={lesson_date}, student_id={student_id})". \
format(attendance_teaching_lesson_id=self.attendance_teaching_lesson_id,
attendance_curriculum_unit_id=self.attendance_curriculum_unit_id,
lesson_attendance=self.lesson_attendance,
lesson_date=self.lesson_date,
student_id=self.student_id)
