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 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 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 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 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(fields: list):
try:
DB.add(Courses(
course_name=fields[0],
description=fields[1],
create_date=fields[2]))
DB.commit()
except:
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 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 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()
@staticmethod
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 __repr__(self):
"""Representation of single row."""
return "submission_id = {}\n" \
"answer_id = {}".format(self.submission_id,
self.answer_id)
if __name__ == "__main__":
question = Questions(question='What is the capital of Austria?')
print(question.question)
DB.add(question)
answer = Answers(question_id=1, answer='Vienna', is_right=1)
print(answer.answer, answer.is_right)
DB.add(answer)
quiz = Quizes(start_time=String.now())
print(quiz.start_time)
DB.add(quiz)
DB.commit()
print(answer.id)