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 add(student_id, quiz_id, questions): """Adding record to the table.""" # try: DB.add(Student_quizes(student_id=student_id, quiz_id=quiz_id, questions=questions)) 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 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 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 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 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 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_id, title, description, file_path, lesson_date): lesson = Lessons( group_id = group_id, title=title, description=description, file_path=file_path, lesson_date=lesson_date ) DB.add(lesson) DB.commit()
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 new(fields: list): try: DB.add(Courses( course_name=fields[0], description=fields[1], create_date=fields[2])) DB.commit() 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 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 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 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 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 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 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 delete(id: int): try: DB.delete(Users.find_by_id(id)) DB.commit() except: DB.rollback()
group_name=fields[0], course_id=fields[1], start_date=fields[2], end_date=fields[3], <<<<<<< Updated upstream create_date = fields[4], teacher_id = fields[5])) # # DB.execute("INSERT INTO groups (group_name,course_id, start_date, end_date, create_date, teacher_id)" # "VALUES ("+fields[0]+","+fields[1]+","+fields[2]+","+fields[3]+","+fields[4]+","+fields[5]+")") ======= create_date=fields[4], teacher_id=fields[5])) >>>>>>> Stashed changes DB.commit() @staticmethod 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() except: DB.rollback()