def delete_full_quiz(id):
if id != None:
# create the quiz name in the database
try:
quiz = Quiz.get(Quiz.id == id)
except:
return Response(status=416)
else:
return Response(status=404)
# first deleting all the questions
for qt in QuestionText.select().where(QuestionText.quizid == quiz.id):
try:
QuestionAnswer.delete().where(
QuestionAnswer.questiontextid == qt.id).execute()
except:
return Response(status=403)
# then deleting the questiontext
try:
QuestionText.delete().where(QuestionText.quizid == quiz.id).execute()
except:
return Response(status=403)
# finally deleting the quiz
delete_id = quiz.id
try:
Quiz.delete().where(Quiz.id == id).execute()
except:
return Response(status=403)
return Response(status=200)
def create_quiz():
'''
basic creation of quizes publish is a new field so it is checked for before
being changed.
'''
content = format_json(request.get_json())
user = None
try:
user = User.get(User.id == content['userid'])
except:
return Response(status=404)
# checking database for the existance of the quiz the user is trying to create.
if len(
list(Quiz.select().where(
Quiz.userid == user, Quiz.quizname.contains(
content['quizname'])))) > 0:
return Response(status=216)
new_quiz = Quiz()
new_quiz.quizname = content['quizname']
new_quiz.userid = content['userid']
if "published" in content.keys():
new_quiz.published = content["published"]
try:
new_quiz.save()
except IntegrityError:
return Response(status=409)
return json.dumps(new_quiz.to_dict())
def get_quizes_by_user(name):
try:
query = Quiz.select().where(Quiz.userid == userid)
query.execute()
query = list(query)
except:
return Response(status=500)
return json.dumps([quiz.to_dict() for quiz in query])
def get_published_quizes():
try:
query = Quiz.select().where(Quiz.published == True)
query.execute()
query = list(query)
except:
return Response(status=500)
return json.dumps([quiz.to_dict() for quiz in query])
def get_all_quizes():
try:
query = Quiz.select()
query.execute()
query = list(query)
except:
return Response(status=500)
return json.dumps([quiz.to_dict() for quiz in query])
def inject_answers():
content = request.get_json()
# get quiz
try:
quiz = Quiz.get(Quiz.id == content['id'])
except:
return Response(status=404)
# get user
try:
user = User.get(User.id == content['userid'])
except:
return Response(status=404)
# not the owner and quiz is published
for question in content['questions']:
# get the questions
try:
qt = QuestionText.get(QuestionText.id == question['id'])
except:
return Response(status=414)
for answer in question['answers']:
# if the answers does not have an id then make a full answer
user_answers = [
x for x in QuestionAnswer.select().where(
QuestionAnswer.user == user, QuestionAnswer.questiontextid
== qt)
]
if 'id' not in answer.keys() and len(user_answers) == 0:
try:
qa = QuestionAnswer(text=answer['text'],
user=user,
questiontextid=qt)
qa.save()
return_answer = qa.to_dict()
except:
return Response(status=418)
elif 'id' not in answer.keys():
try:
qa = user_answers[0]
qa.text = answer['text']
qa.save()
return_answer = qa.to_dict()
except:
return Response(status=444)
return json.dumps(get_full_quizdb(quiz.id))
def update_quiz_by_id_or_name():
quiz = None
content = format_json(request.get_json())
if "id" in content.keys():
try:
quiz = Quiz.get(Quiz.id == content["id"])
if "newquizname" in content.keys():
quiz.quizname = content["newquizname"]
if "published" in content.keys():
quiz.published = content["published"]
quiz.save()
except:
return Response(status=405)
return json.dumps(quiz.to_dict())
def create_a_questiontext():
content = format_json(request.get_json())
if "quizid" in content.keys():
try:
quiz = Quiz.get(Quiz.id == content["quizid"])
print(quiz)
questiontext = QuestionText()
questiontext.quizid = quiz
questiontext.text = content["questiontext"]
questiontext.save()
except:
return Response(status=409)
return json.dumps(questiontext.to_dict())
else:
return Response(status=405)
def create_questionanswer():
content = format_json(request.get_json())
# this is the answe that is getting modified
answer = QuestionAnswer()
# this finds the user sending the request and the information in the request
user = User.get(User.id == content['userid'])
qtext = QuestionText.get(QuestionText.id == content['questiontextid'])
quiz = Quiz.get(Quiz.id == qtext.quizid)
if quiz.userid != user.id:
quiz_creator = User.get(User.id == quiz.userid)
# this check needs to be here so
# the user may not be able to set their answer to true.
# this will set their answer to right or not.
# providing instant feedback
for x in QuestionAnswer.select().where(
(QuestionAnswer.user_id == quiz_creator)
& (QuestionAnswer.isRight == True)):
if x.to_dict()['text'].lower() == content['answertext']:
answer.isRight = True
break
else:
# the question creator and the answer are the same thust they may change what they want.
if 'isright' in content.keys():
if content['isright'] == True:
answer.isRight = True
elif content['isright'] == False:
answer.isRight = False
answer.text = content['answertext']
answer.user = user
answer.questiontextid = qtext
answer.save()
return json.dumps(answer.to_dict())
def get_full_quizdb(id, owner=True):
got_quiz = None
full_quiz = {}
got_quiz = Quiz.get(Quiz.id == id)
full_quiz.update(got_quiz.to_dict())
questions = []
for text in QuestionText.select().where(QuestionText.quizid == id):
currenttext = text.to_dict()
if owner == True:
currenttext.update({
"answers": [
answer.to_dict()
for answer in QuestionAnswer.select().where(
QuestionAnswer.questiontextid == text.id,
QuestionAnswer.user == got_quiz.userid)
]
})
else:
currenttext.update({
"answers": [
answer.to_dict()
for answer in QuestionAnswer.select().where(
QuestionAnswer.questiontextid == text.id)
]
})
questions.append(currenttext)
# questions.reverse()
questions = sorted(questions, key=lambda k: k['id'])
full_quiz.update({"questions": questions})
return full_quiz
def mass_assignment():
content = format_json(request.get_json())
try:
user = User.get(User.id == content['userid'])
except:
return Response(status=404)
quiz = None
return_quiz = []
# if the id is not in the json create the quiz this should not be the case the quiz will typically be gotten
if 'id' not in content.keys():
pass
# create the quiz name in the database
try:
query = Quiz.select().where(Quiz.quizname == content['quizname'],
Quiz.userid == user)
query.execute()
query = list(query)
if len(query) == 0:
quiz = Quiz(quizname=content['quizname'], userid=user)
quiz.save()
else:
quiz = query[0]
except:
return Response(status=416)
else:
try:
quiz = Quiz.get(Quiz.id == content['id'])
if quiz.quizname != content['quizname']:
quiz.quizname = content['quizname']
try:
quiz.save()
except:
return Response(status=403)
except:
return Response(status=404)
if quiz.published == False and int(user.id) == int(quiz.userid.id):
# if the quiz is not published and the user is not the quiz maker
# first items will be deleted
query = QuestionText.select().where(QuestionText.quizid == quiz.id)
query.execute()
all_questions = list(query)
request_questions = [x['text'] for x in content['questions']]
remove_this = []
for quest in all_questions:
if quest.text not in request_questions:
remove_this.append(quest)
for quest in remove_this:
try:
QuestionAnswer.delete().where(
QuestionAnswer.questiontextid == quest.id).execute()
except:
return Response(status=433)
try:
QuestionText.delete().where(
QuestionText.id == quest.id).execute()
except:
return Response(status=423)
for question in content['questions']:
qt = None
if user.id == quiz.userid.id:
# if they are they make change the questions
# then created
if 'id' not in question.keys():
try:
query = QuestionText.select().where(
QuestionText.text == question['text'],
QuestionText.quizid == quiz)
query.execute()
query = list(query)
if len(query) == 0:
qt = QuestionText(text=question['text'],
quizid=quiz)
qt.save()
else:
qt = query[0]
except:
return Response(status=417)
else:
try:
qt = QuestionText.get(
QuestionText.id == question['id'])
qt.text = question['text']
qt.save()
except:
return Response(status=404)
else:
# if the user.id is not quiz.id then the question exists
try:
qt = QuestionText.get(QuestionText.id == question['id'])
except:
return Response(status=404)
# anyone may make changes to their answers
for answer in question['answers']:
qa = None
query = []
if user.id != quiz.userid.id:
query = QuestionAnswer.select().where(
QuestionAnswer.user == user,
QuestionAnswer.questiontextid == qt)
query.execute()
query = list(query)
if len(query) == 0:
if 'id' not in answer.keys():
try:
qa = QuestionAnswer(text=answer['text'],
user=user,
questiontextid=qt)
qa.save()
except:
return Response(status=418)
else:
try:
qa = QuestionAnswer.get(
QuestionAnswer.id == answer['id'])
qa.text = answer['text']
qa.save()
except:
return Response(status=404)
return Response(json.dumps(get_full_quizdb(quiz.id)))