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