def get_instructor_terms(self):
instructor_id = self.get_payload()['id']
query = (Section.select(Term.title, Term.id).distinct().join(
Term, on=(Section.term_id == Term.id)).where(
Section.instructor_id == instructor_id).dicts())
return query
def get_instructor_term_sections(self):
instructor_id = self.get_payload()['id']
term_id = self.get_payload()['term_id']
query = (Section.select(Course.name, Course.title, Section.number,
Section.id).join(
Course,
on=(Section.course_id == Course.id)).where(
Section.instructor_id == instructor_id,
Section.term_id == term_id).dicts())
return query
def query(section_id):
query = (Section.select(Section.number, Course.name, Course.title).join(
Course, on=(Section.course_id == Course.id)).where(
Section.id == section_id).dicts())
return query
def instructor_has_section(self, instructor_id, section_id):
query = (Section.select().where(
Section.id == section_id,
Section.instructor_id == instructor_id).exists())
return query
