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