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):