def delete(id: int): try: DB.execute( "DELETE FROM group_students WHERE group_students.user_id = " + id + ";") # DB.delete(Group_student.find_by_id(id)) except: DB.rollback()
def get_by_questions(questions: set): """Selecting questions by question_id.""" try: return DB.execute('''SELECT answers.*, questions.question FROM answers LEFT JOIN questions ON answers.question_id=questions.id where answers.question_id in {}'''.format(questions)) # .format(questions))) except Exception: DB.rollback()
def all_students_in(id): return DB.execute( "SELECT users.id,users.first_name,users.last_name,groups.group_name,groups.create_date,group_students.group_id,group_students.active FROM group_students INNER JOIN " "users ON group_students.user_id = users.id JOIN groups ON groups.id = " + id + "" " WHERE group_students.group_id = " + id)
def delete(id: int): try: # DB.delete(Groups).filter_by(id=id) DB.execute("DELETE FROM groups WHERE groups.id = {};".format(id)) except: DB.rollback()
def all(): result = DB.execute( "SELECT groups.id,groups.group_name,users.first_name,courses.course_name FROM groups INNER JOIN " "users ON groups.teacher_id = users.id JOIN courses ON groups.course_id = courses.id") return result
@staticmethod def get_by_quiz_id(quiz_id: int): """Finding record in the table by id.""" try: return DB.query(Student_quizes).\ filter(Student_quizes.quiz_id == quiz_id).all() except Exception: DB.rollback() @staticmethod def all_by_student_id(student_id: int): >>>>>>> Stashed changes """Finding record in the table by id.""" # try: return DB.execute('''SELECT quizes.*, student_quizes.student_id FROM quizes LEFT JOIN student_quizes ON student_quizes.quiz_id=quizes.id where student_quizes.student_id={}'''.format(student_id)) # return DB.query(Student_quizes).filter( # Student_quizes.student_id == student_id).all() @staticmethod def find_by_id(id: int): try: return DB.query(Student_quizes).\ filter(Student_quizes.id == id).first() except Exception: DB.rollback() # def __repr__(self):