def delete(self, id):
execute_query(StudentQueries.delete(), (id,))
def get_all(self):
rows = [row for row in execute_query(StudentQueries.get_all())]
return rows
def insert(self, first_name, last_name, email):
execute_query(StudentQueries.insert(), (first_name, last_name, email))
def update(self, id, first_name, last_name, email):
execute_query(StudentQueries.update(), (first_name, last_name, email, id))
def insert(self, student_id, course_id):
execute_query(StudentCourseQueries.insert(), (student_id, course_id))
def get_by_id(self, id):
rows = [row for row in execute_query(StudentQueries.get_by_id(), (id,))]
return rows
def insert(self, name, teacher_id):
execute_query(CourseQueries.insert(), (name, teacher_id))
def get_all(self):
rows = [row for row in execute_query(CourseQueries.get_all())]
return rows
def get_all(self):
rows = [row for row in execute_query(TeacherQueries.get_all())]
return rows
def delete(self, id):
execute_query(TeacherQueries.delete(), (id,))
def update(self, id, first_name, last_name, email):
execute_query(TeacherQueries.update(), (first_name, last_name, email, id))
def insert(self, first_name, last_name, email):
execute_query(TeacherQueries.insert(), (first_name, last_name, email))
def get_all_with_student_count(self):
rows = [row for row in execute_query(TeacherQueries.get_all_with_student_count())]
return rows