def remove_by_quiz_id(quiz_id: int):
"""Removing record from the table."""
# try:
DB.query(Student_quizes).filter(
Student_quizes.quiz_id == quiz_id
).delete()
DB.commit()
def remove(id: int):
"""Removing record from the table."""
# try:
DB.query(Quizes).filter(
Quizes.id == id
).delete()
DB.commit()
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 get_course_name(teacher_id: int):
course_id = DB.query(Groups.course_id).filter_by(teacher_id=teacher_id).first()
course_name = DB.query(Courses.course_name).filter_by(id=course_id).first()
# course_name = DB.execute("select groups.group_name, courses.course_name from groups "
# "INNER JOIN courses ON groups.course_id = courses.id "
# "where groups.teacher_id = ?", teacher_id)
return course_name
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 get_group(id: int):
gid = DB.query(Group_student).filter(
Group_student.user_id == id).first()
group_st = DB.query(Groups).filter(Groups.id == gid.group_id).first()
# groups = []
# for gid in group_st:
# groups.append(DB.query(Groups).filter(Groups.id == gid.group_id).first())
return group_st
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 edit(fields: list, id: int):
try:
DB.query(Groups).filter(Groups.id == id).update(dict(
group_name=fields[0],
course_id=fields[1],
start_date=fields[2],
end_date=fields[3],
create_date=fields[4],
teacher_id=fields[5]))
DB.commit()
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 get_coures(id: int):
print(id, 'ssssssssresult')
#result = DB.execute("SELECT * FROM groups INNER JOIN "
# "courses ON groups.course_id = courses.id where groups.teacher_id = {}".format(id))
cid = DB.query(Groups).filter(Groups.teacher_id == id).first()
course_st = DB.query(Courses).filter(
Courses.id == cid.course_id).first()
print(course_st, 'result')
# groups = []
# for gid in group_st:
# groups.append(DB.query(Groups).filter(Groups.id == gid.group_id).first())
return course_st
def find_by_id(id: int):
try:
return DB.query(Group_student).filter(
Group_student.user_id == id).first()
except:
DB.rollback()
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 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 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 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 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 all():
try:
all = DB.query(Courses).all()
return all
except:
DB.rollback()
def get_lessons(group_id):
return DB.query(Groups).filter(Groups.group_id == group_id).all()
def find_by_id(id: int):
try:
return DB.query(Homeworks).filter(Homeworks.id == id).first()
except:
DB.rollback()
def all():
try:
return DB.query(Homeworks).all()
except:
DB.rollback()
def find_by_id(id: int):
try:
return DB.query(CompletedHomeworks).filter_by(id=id).first()
except:
DB.rollback()
def get_all_by_user_id(user_id: int):
return DB.query(CompletedHomeworks).filter_by(user_id=user_id).all()
def get_all_by_lesson_id(lesson_id: int):
hw_id = DB.query(Homeworks.id).filter_by(lesson_id=lesson_id).first()
id = hw_id.id
result = DB.query(CompletedHomeworks).filter_by(homework_id=id).all()
return result
def get_all(homework_id: int):
return DB.query(CompletedHomeworks).filter_by(homework_id=homework_id).all()
def get_all():
try:
return DB.query(Users).all()
except:
DB.rollback()
def check_token(token: str):
return DB.query(Users).filter_by(token=token).first()
def all_students():
return DB.query(Users.id, Users.first_name,
Users.last_name).filter(Users.role == "student").all()
def find_by_id(id: int):
try:
return DB.query(Courses).filter(Courses.id == id).first()
except:
DB.rollback()
def login(email: str, pwd: str):
password = hashlib.sha512(pwd.encode('utf-8')).hexdigest()
user = DB.query(Users).filter(Users.email == email,
Users.password == password).first()
return user