class CurrentStudentRoster(Base):
__tablename__ = 'ss_current'
__table_args__ = merge_dicts(base_table_args, {"schema": "matviews"})
site_id = foreignkey(Sites.site_id, primary_key=True)
student_id = foreignkey(Students.student_id, primary_key=True)
roster_site = relationship("Sites")
roster_student = relationship("Students")
def section_id(self):
return foreignkey(Sections.section_id)
def course_id(self):
return foreignkey(Courses.course_id)
def user_id(self):
return foreignkey(Users.user_id)
def room_id(self):
return foreignkey(Rooms.room_id)
def site_id(self):
return foreignkey(Sites.site_id)
class DailyRecords(Base):
__table_args__ = merge_dicts(base_table_args, {'schema': 'attendance'})
student_id = foreignkey(Students.student_id, primary_key=True)
attendance_flag_id = foreignkey(AttendanceFlags.attendance_flag_id,
primary_key=True)
date = Column(Date, primary_key=True)
def student_id(self):
return foreignkey(Students.student_id)
def assignment_id(self):
return foreignkey(Assignments.assignment_id)
def category_id(self):
return foreignkey(Categories.category_id)
def gradebook_id(self):
return foreignkey(Gradebooks.gradebook_id)
class Gradebooks(GradebookSchemaMixin, Base):
created_by = foreignkey(Users.user_id)
user = relationship("Users", backref='gradebook')
scores = relationship("OverallScoreCache", backref='gradebook')
assignments = relationship("Assignments", backref='gradebook')