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()
def find_by_id(id: int):
try:
return DB.query(Group_student).filter(
Group_student.user_id == id).first()
except:
DB.rollback()
def edit(fields: list, id: int):
try:
DB.query(Group_student).filter(Group_student.id == id).update(
dict(group_name=fields[0], description=fields[1]))
DB.commit()
except:
DB.rollback()
def all_by_student_id(student_id: int):
"""Finding record in the table by id."""
try:
return DB.query(Quizes).filter(
Quizes.student_id == student_id).all()
except Exception:
DB.rollback()
def add(submission_id, answer_id):
"""Adding record to the table."""
try:
DB.add(Submitted_answers(submission_id=submission_id,
answer_id=answer_id))
DB.commit()
except Exception:
DB.rollback()
def edit(fields: list, id: int):
try:
DB.query(Courses).filter(Courses.id == id).update(dict(
course_name=fields[0],
description=fields[1]))
DB.commit()
except:
DB.rollback()
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 add(question_id, answer, is_right):
"""Adding record to the table."""
try:
DB.add(Answers(question_id=question_id,
answer=answer,
is_right=is_right))
DB.commit()
except Exception:
DB.rollback()
def add(student_quiz_id, start_date, submission_date):
"""Adding record to the table."""
try:
DB.add(Quiz_submission(student_quiz_id=student_quiz_id,
start_date=start_date,
submission_date=submission_date))
DB.commit()
except Exception:
DB.rollback()
def get_by_lessons(lesson_ids: set):
"""Selecting questions by lesson_ids."""
try:
return DB.query(Questions).filter(
Questions.lesson_id.in_(lesson_ids)
).all()
except Exception:
DB.rollback()
def edit(title, description, file_path, lesson_date):
try:
DB.query(Lessons).filter(Lessons.id == id).update(dict(title=title,
description=description,
file_path=file_path,
lesson_date=lesson_date
))
DB.commit()
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 add(lesson_id, question):
"""Adding record to the table."""
try:
question = Questions(lesson_id=lesson_id,
question=question)
DB.add(question)
DB.commit()
return question.id
except Exception:
DB.rollback()
def new(group_name, course_id, start_date, end_date, teacher_id, modified):
try:
DB.add(
Groups(group_name=group_name,
course_id=course_id,
start_date=start_date,
end_date=end_date,
teacher_id=teacher_id,
modified=modified))
except:
DB.rollback()
def new(fields: list):
try:
DB.add(
Group_student(group_id=fields[0],
active=fields[1],
user_id=fields[2],
create_date=fields[3])),
DB.commit()
except:
DB.rollback()
def new(fields: list):
try:
DB.add(Courses(
course_name=fields[0],
description=fields[1],
create_date=fields[2]))
DB.commit()
except:
DB.rollback()
def edit(id: int, lesson_id: int, title: str, description: str,
file_path: str, deadline: str):
DB.query(Homeworks).filter(Homeworks.id == id).update(
dict(lesson_id=lesson_id,
title=title,
description=description,
file_path=file_path,
deadline=deadline))
try:
DB.commit()
except:
DB.rollback()
def edit(fields: list, id: int):
try:
DB.query(Users).filter(Users.id == id).update(
dict(email=fields[0],
first_name=fields[1],
last_name=fields[2],
middle_name=fields[3],
birth_date=fields[4],
role=fields[5]))
DB.commit()
except:
DB.rollback()
def add(lesson_id: int, title: str, description: str, file_path: str,
deadline: str):
try:
homework = Homeworks(lesson_id=lesson_id,
title=title,
description=description,
file_path=file_path,
deadline=deadline)
DB.add(homework)
DB.commit()
except:
DB.rollback()
def change_password(id: int, password: str):
try:
our_user = DB.query(Users).filter_by(id=id).first()
if our_user is not None:
print(id, password)
print(our_user.first_name)
our_user.password = hashlib.sha512(
password.encode('utf-8')).hexdigest()
DB.commit()
return our_user
except:
DB.rollback()
def new(fields: list):
try:
user = Users(
first_name=fields[0],
last_name=fields[1],
email=fields[2],
role=fields[3],
token=str(uuid4()),
create_date=datetime.now().strftime('%Y-%m-%d %H:%M:%S'))
DB.add(user)
DB.commit()
return user
except:
DB.rollback()
def add(homework_id: int, user_id: int, file_path: str, description: str, submission_date: str):
try:
completed_homework = CompletedHomeworks(
homework_id=homework_id,
user_id=user_id,
file_path=file_path,
description=description,
submission_date=submission_date)
DB.add(completed_homework)
DB.commit()
return completed_homework
except:
DB.rollback()
print('rollback')
def edit(quiz_id, teacher_id, group_id, title, lessons, start_time,
duration, modified_date, count):
"""Adding record to the table."""
try:
DB.query(Quizes).filter(Quizes.id == quiz_id).update(
dict(teacher_id=teacher_id,
group_id=group_id,
title=title,
lessons=lessons,
start_time=start_time,
duration=duration,
modified_date=modified_date,
count=count)
)
DB.commit()
except Exception:
DB.rollback()
def add(teacher_id, group_id, title, lessons, start_time,
duration, create_date, count):
"""Adding record to the table."""
try:
quiz = Quizes(teacher_id=teacher_id,
group_id=group_id,
title=title,
lessons=lessons,
start_time=start_time,
duration=duration,
create_date=create_date,
count=count)
DB.add(quiz)
DB.commit()
return quiz.id
except Exception:
DB.rollback()
def find_by_id(id: int):
try:
return DB.query(Courses).filter(Courses.id == id).first()
except:
DB.rollback()
def delete(id: int):
try:
DB.delete(Courses.find_by_id(id))
except:
DB.rollback()
def all():
try:
return DB.query(Homeworks).all()
except:
DB.rollback()
def remove(id: int):
try:
DB.remove(Homeworks.find_by_id(id))
except:
DB.rollback()
def all():
try:
all = DB.query(Courses).all()
return all
except:
DB.rollback()
def find_by_id(id: int):
try:
return DB.query(Homeworks).filter(Homeworks.id == id).first()
except:
DB.rollback()