def create_answer(self, question_id, text, is_correct):
"""create a new answer and add it to the store and to the quiz"""
new_answers = Answer(question_id, text, is_correct)
self.get_question_by_id(question_id).add_answer_by_id(
new_answers.answer_id)
self.answers[new_answers.answer_id] = new_answers
return new_answers.answer_id
def get_answers(self):
query = Answer.all()
cookies = h.get_default_cookies(self)
current_user = h.get_current_user(cookies)
query.filter("user =", current_user)
answers = query.fetch(1000)
return answers
def addQuestion(qId: str, answer: Answer):
answer.aId = str(uuid.uuid1())
data = answer.__dict__
data["author"] = answer.author.__dict__
for question in qaDb["questions"]:
if question["qId"] == qId:
question["answerList"].append(data)
with open('qaDb.json', 'w') as f:
f.write(json.dumps(qaDb, indent=4, sort_keys=True))
return True
def createAnswer(questionId, accountId, answer, pollStatus):
answ = Answer()
answ.QuestionId = questionId
answ.AccountId = accountId
account = Account.query.filter_by(Id=accountId).first()
account.setDomainExpertise()
if len(account.DomainExpertise) > 0:
answ.IsExpert = True
else:
answ.IsExpert = False
answ.Answer = answer
answ.TimeStamp = datetime.date.today()
answ.Score = 0
poll = PollOption.query.filter_by(PollOptionName=pollStatus).first()
answ.PollOptionId = poll.Id
db.session.add(answ)
db.session.commit()
return answ
def post(self):
args = parser.parse_args()
d = {
'title': args['title'],
'content': args['content'],
'user_id': args['user_id'],
'question_id': args['question_id']
}
a = Answer.new(d)
a.save()
return a.json(), 201
def put(self):
payload = request.get_json(force=True)
if payload is None:
payload = {}
new_answer = Answer(text=payload.get('answer'))
db.session.add(new_answer)
db.session.commit()
return {'message': 'Successfully added'}, 200
def get(self):
parser = reqparse.RequestParser()
parser.add_argument('device_id',
required=True,
type=str,
help='Device ID missing in query parameter')
device_id = parser.parse_args().get('device_id')
results = Answer.find_by_device_id(device_id)
if results:
return_list = [{
'session_id':
session,
'answer_ids': [
i.answer_id for i in Answer.find_by_session_and_device_id(
session, device_id)
],
'session_start_time':
min([
i.answered_time
for i in Answer.find_by_session_and_device_id(
session, device_id)
]),
'session_end_time':
max([
i.answered_time
for i in Answer.find_by_session_and_device_id(
session, device_id)
])
} for session in list(
set([result.session_id for result in results]))]
return {'results': return_list}, 200
else:
return {
'message':
'no sessions found for device_id {}'.format(device_id)
}, 404
def add_answer(self, atext, qkey):
answer = Answer()
cookies = h.get_default_cookies(self)
current_user = h.get_current_user(cookies)
if current_user:
answer.user = current_user
answer.atext = atext
answer.qkey = db.Key(qkey)
answer.put()
return answer
def delete(self, question_id):
Answer.delete(id=int(question_id))
return '', 204
def get(self, question_id):
a = Answer.find_by(id=int(question_id))
abort_if_answer_doesnt_exist(a)
return a.json()
id=1,
name="Conseil d'administration",
description=
"Vote de confiance pour les postes saisonniers au conseil d'administration de l'AGEG."
)
groups = [groupe_exec, groupe_admin]
questions = generer_questions_exec(groupe_exec.gid)
question_admin = Question(
id=100,
code="CASA19",
gid=groupe_admin.gid,
title="Qui voulez-vous comme administrateurs saisonniers de l'AGEG?",
type='F')
question_admin.add_answer(
Answer(qid=question_admin.qid, value="Oui", code="A1", order=1))
question_admin.add_answer(
Answer(qid=question_admin.qid, value="Non", code="A2", order=2))
sousquestions_admin = generer_sousquestion_admin(question_admin)
options_admin = generer_options_admin()
for option in options_admin:
question_admin.add_option(option)
questions.append(question_admin)
mylookup = TemplateLookup(directories=['.'],
input_encoding="utf-8",
output_encoding="utf-8")
mytemplate = Template(filename='templates/base.mako',
lookup=mylookup,
def showQuestion(question_id, methods=['GET', 'POST']):
# Shows the respective question related to the current survey (latest active one).
# If there already is a feedback id stored in cookie, the controller's action retrieves it and
# fills the form/question if there was already an answer to that question.
# The page has links to next and previous question.
# Renders a different view based on the question type.
# Get feedback object
cookie = request.cookies['feedback_id']
feedback = session.query(Feedback).filter_by(id_=int(cookie)).one()
# Form dict - can this be factored out of each function?
qtype_forms = {
'Freeform': AnswerFormFree(request.form), # can this be removed?
'Text': AnswerFormFree(request.form),
'Thumbs': AnswerFormThumbs(request.form),
'Stars': AnswerFormStars(request.form),
'Smileys': AnswerFormSmileys(request.form),
'Choices': AnswerFormChoices(request.form),
'Picture': AnswerFormFree(request.form)
}
progress = 0
# GET: Show question with prefilled answer
if request.method == 'GET':
# Get list of survey questions
q = session.query(Question).filter_by(id_=question_id).one()
q_list = session.query(Question).filter_by(
survey_id_=q.survey_id_).all()
q_list_ids = [question.id_ for question in q_list]
# Figure out next_url and prev_url
prev_q_ix = q_list_ids.index(
q.id_) - 1 if q_list_ids.index(q.id_) - 1 >= 0 else None
next_q_ix = q_list_ids.index(
q.id_) + 1 if q_list_ids.index(q.id_) + 1 < len(q_list) else None
prev_url = url_for('controllers.showQuestion',
question_id=q_list_ids[prev_q_ix]
) if prev_q_ix != None else None # <---
next_url = url_for(
'controllers.showQuestion', question_id=q_list_ids[next_q_ix]
) if next_q_ix != None else url_for('controllers.thankYou')
is_first = prev_url == None
# Set up proper template and form_action_url
template = templates.get(
q.type_, 'freeform.html') # Freeform is default fallback
form_action_url = '/feedback/questions/' + str(q.id_)
# Set up question form and fetch possible pre-existing answer
form = qtype_forms.get(q.type_, AnswerFormFree(request.form))
# Check for pre-existing answers
try:
pre_existing_answer = session.query(Answer).filter_by(
question_id_=q.id_,
feedback_id_=request.cookies['feedback_id']).order_by(
Answer.created_at_.desc()).first()
except:
pre_existing_answer = None
if pre_existing_answer != None:
# Parse answer in db to response parameters for displaying it
form.value_.data = pre_existing_answer.value_
if q.type_ == 'Choices':
form.setChoices(q.questionchoices)
# Get progress
progress, missing = get_progress(feedback)
response = make_response(
render_template(template,
form=form,
form_action_url=form_action_url,
question_id=q.id_,
question_title=q.title_,
question_type=q.type_,
prev_url=prev_url,
next_url=next_url,
is_first=is_first,
progress=progress,
answer=pre_existing_answer))
return response
# POST: Write answer to database
elif request.method == 'POST':
# Get question type
question = session.query(Question).filter_by(
id_=request.form['question_id']).first()
# Parse new answer from form if it exists
if request.form.get('value_'):
new_answer_val = str(request.form['value_'])
# If mandatory question is missing answer
elif bool(question.optional_) == False:
flash('Please answer this question.')
this_url = url_for('controllers.showQuestion',
question_id=question.id_)
return redirect(this_url)
# If optional question is missing answer, create empty answer value
else:
new_answer_val = ''
# Get possible pre-existing answer
answers = session.query(Answer).filter_by(
feedback_id_=int(request.cookies['feedback_id']),
question_id_=int(request.form['question_id'])).all()
# If pre-existing answer found, take the answer object for updating
if len(answers) > 0:
answer_object = answers[0]
# If no pre-existing answer found
else:
# Add placeholder '' to value_
answer_object = Answer('', int(request.cookies['feedback_id']),
int(request.form['question_id']))
# Special question type (Picture)
if question.type_ == 'Picture':
# user gave a new file:
if request.files.get('userPicture'):
file = request.files['userPicture']
if file:
fileName = 'F' + str(answer_object.feedback_id_) + 'A' + str(question.id_) + \
'_' + str(datetime.datetime.now().hour) + \
'_' + str(datetime.datetime.now().minute) + \
'_' + str(datetime.datetime.now().second) + '.PNG'
imgPath = '/static/' + fileName
file.save(parentdir + imgPath)
answer_object.image_source_ = imgPath
answer_object.value_ = imgPath
session.add(answer_object)
session.commit()
# All other question types:
else:
answer_object.value_ = new_answer_val
session.add(answer_object)
session.commit()
#----------------------------------------------------------------------
# NOTE: Replacing value_ with '' will only removes path to img, img data has to be removed separately
#----------------------------------------------------------------------
# Redirect to previous if 'Prev' was clicked
if 'Previous' in request.form.keys():
return redirect(request.form['prev_url'])
# Redirect to next if 'Next' was clicked
if 'Next' in request.form.keys():
return redirect(request.form['next_url'])
return 'POST redirection to next/prev failed'
def showQuestion(question_id, methods=['GET', 'POST']):
# Shows the respective question related to the current survey (latest active one).
# If there already is a feedback id stored in cookie, the controller's action retrieves it and
# fills the form/question if there was already an answer to that question.
# The page has links to next and previous question.
# Renders a different view based on the question type.
print('\n--- ENTERING showQuestion WITH METHOD {}: {}'.format(
request.method, 70 * '*'))
# Get feedback object
cookie = request.cookies['feedback_id']
feedback = session.query(Feedback).filter_by(id_=int(cookie)).one()
print('\n--- COOKIE / SESSION ID: {}'.format(cookie))
print('---FEEDBACK: {}'.format(feedback.serialize))
# Form dict - can this be factored out of each function?
qtype_forms = {
'Freeform': AnswerFormFree(request.form), # can this be removed?
'Text': AnswerFormFree(request.form),
'Thumbs': AnswerFormThumbs(request.form),
'Stars': AnswerFormStars(request.form),
'Smileys': AnswerFormSmileys(request.form),
'Choices': AnswerFormChoices(request.form),
'Picture': AnswerFormFree(request.form)
}
progress = 0
# GET: Show question with prefilled answer
if request.method == 'GET':
print('GET')
print('request.form: {}'.format(request.form))
# Get list of survey questions
q = session.query(Question).filter_by(id_=question_id).one()
q_list = session.query(Question).filter_by(
survey_id_=q.survey_id_).all()
q_list_ids = [question.id_ for question in q_list]
# Figure out next_url and prev_url
prev_q_ix = q_list_ids.index(
q.id_) - 1 if q_list_ids.index(q.id_) - 1 >= 0 else None
next_q_ix = q_list_ids.index(
q.id_) + 1 if q_list_ids.index(q.id_) + 1 < len(q_list) else None
prev_url = url_for('controllers.showQuestion',
question_id=q_list_ids[prev_q_ix]
) if prev_q_ix != None else None # <---
next_url = url_for(
'controllers.showQuestion', question_id=q_list_ids[next_q_ix]
) if next_q_ix != None else url_for('controllers.thankYou')
is_first = prev_url == None
# Set up proper template and form_action_url
template = templates.get(
q.type_, 'freeform.html') # Freeform is default fallback
print('Chose template {} from templates: {}'.format(
template, templates))
form_action_url = '/feedback/questions/' + str(q.id_)
# Set up question form and fetch possible pre-existing answer
form = qtype_forms.get(q.type_, AnswerFormFree(request.form))
print('Chose form {} from qtype_forms'.format(form))
print('---FORM.value_: {}'.format(form.value_))
print('---FORM.value_.data: {}'.format(form.value_.data))
# flash('Feedback_id == Cookie == {}'.format(feedback.id_))
# flash('form.value_.data: {}'.format(form.value_.data))
# Check for pre-existing answers
try:
print('---CHECK FOR PRE-EXISTING ANSWER:')
pre_existing_answer = session.query(Answer).filter_by(
question_id_=q.id_,
feedback_id_=request.cookies['feedback_id']).order_by(
Answer.created_at_.desc()).first()
print('---FOUND PRE-EXISTING ANSWER:', pre_existing_answer)
except:
pre_existing_answer = None
if pre_existing_answer != None:
print('---PRE-EXISTING ANSWER FOUND WITH VALUE {}'.format(
pre_existing_answer.value_))
# Parse answer in db to response parameters for displaying it
print('--- CREATING RESPONSE PARAMS FROM PRE-EXISTING ANSWER:')
print(
'--- PRE-EXISTING ANSWER: {}, QTYPE: {}, FORM.VALUE_.DATA: {}'.
format(pre_existing_answer.value_, q.type_, form.value_.data))
form.value_.data = pre_existing_answer.value_
print('form.value_.data is now {} "{}"'.format(
type(form.value_.data), form.value_.data))
else:
print('---NO PRE-EXISTING ANSWER FOUND.')
if q.type_ == 'Choices':
form.setChoices(q.questionchoices)
# Debug statements
print('---TEMPLATE: {}, {}'.format(type(template), template))
print('---FORM: {}, {}'.format(type(form), form))
print('---FORM.VALUE_: {}'.format(form.value_))
print('---FORM.VALUE_.DATA: {}'.format(form.value_.data))
print('---FORM_ACTION_URL: {}, {}'.format(type(form_action_url),
form_action_url))
print('---LIST OF QUESTION IDS: {}'.format(q_list_ids))
print('---QUESTION: {}, {}'.format(type(q), q))
print('---QUESTION TYPE: {}, {}'.format(type(q.type_), q.type_))
print('---IS_FIRST: {}, {}'.format(type(is_first), is_first))
print('---QUESTION_ID: {}, {}'.format(type(q.id_), q.id_))
print('---QUESTION_TITLE: {}, {}'.format(type(q.title_), q.title_))
print('---NEXT_URL: {}, {}'.format(type(next_url), next_url))
print('---PREV_URL: {}, {}'.format(type(prev_url), prev_url))
# Get progress
progress, missing = get_progress(feedback)
# print('---PROGRESS {}'.format(progress))
# print('---MISSING {}'.format(missing))
# print('---MISSING MANDATORY {}'.format(missing))
# flash('progress: {}'.format(progress))
# flash('missing: {}'.format(missing))
# flash('missing: {}'.format(missing))
#
#--------- DEBUG HERE Thumbs form!!!
# form = qtype_forms.get('Thumb', AnswerFormFree(request.form))
print('form.value_: "{}"'.format(form.value_))
print('form.value_.data: "{}"'.format(form.value_.data))
if q.type_ not in ['Freeform', 'Text', 'Picture', 'Thankyou']:
print('form.value_.choices: "{}"'.format(form.value_.choices))
print('---FORM: {}'.format(form))
print('---FORM.VALUE_.DATA: {}'.format(form.value_.data))
response = make_response(
render_template(template,
form=form,
form_action_url=form_action_url,
question_id=q.id_,
question_title=q.title_,
question_type=q.type_,
prev_url=prev_url,
next_url=next_url,
is_first=is_first,
progress=progress,
answer=pre_existing_answer))
print('---RESPONSE CREATED. EXITING showQuestion AND RENDERING {}'.
format(template))
return response
# POST: Write answer to database
elif request.method == 'POST':
print('POST')
print('request.form: {}'.format(request.form))
print('request.cookies: {}'.format(request.cookies))
# Get question type
question = session.query(Question).filter_by(
id_=request.form['question_id']).first()
# Parse new answer from form if it exists
if request.form.get('value_'):
new_answer_val = str(request.form['value_'])
# If mandatory question is missing answer
elif bool(question.optional_) == False:
print('---THIS QUESTION ({}) IS MANDATORY!'.format(question.id_))
flash('Please answer this question.')
this_url = url_for('controllers.showQuestion',
question_id=question.id_)
return redirect(this_url)
# If optional question is missing answer, create empty answer value
else:
new_answer_val = ''
print('---GOT new_answer_val FROM FORM: {}'.format(new_answer_val))
# Get possible pre-existing answer
print('---GET POSSIBLE PRE-EXISTING ANSWER')
answers = session.query(Answer).filter_by(
feedback_id_=int(request.cookies['feedback_id']),
question_id_=int(request.form['question_id'])).all()
print('len(answer_object): {}'.format(len(answers)))
# If pre-existing answer found, take the answer object for updating
if len(answers) > 0:
answer_object = answers[0]
print('---FOUND PRE-EXISTING ANSWER: {}'.format(answer_object))
print('---PRE-EXISTING answer.value_: {}'.format(
answer_object.value_))
# If no pre-existing answer found
else:
print('---NO PRE-EXISTING ANSWER FOUND!')
# Add placeholder '' to value_
answer_object = Answer('', int(request.cookies['feedback_id']),
int(request.form['question_id']))
print('---CREATED NEW ANSWER OBJECT:')
# Special question type (Picture)
if question.type_ == 'Picture':
# user gave a new file:
if request.files.get('userPicture'):
file = request.files['userPicture']
if file:
fileName = 'F' + str(answer_object.feedback_id_) + 'A' + str(question.id_) + \
'_' + str(datetime.datetime.now().hour) + \
'_' + str(datetime.datetime.now().minute) + \
'_' + str(datetime.datetime.now().second) + '.PNG'
imgPath = '/static/' + fileName
file.save(parentdir + imgPath)
answer_object.image_source_ = imgPath
answer_object.value_ = imgPath
session.add(answer_object)
session.commit()
# All other question types:
else:
answer_object.value_ = new_answer_val
print('answer.serialize {}'.format(answer_object.serialize))
print('---ANSWER_OBJECT.value_ type: {}, len {} value_ {}'.format(
type(answer_object.value_),
len(answer_object.value_),
answer_object.value_,
))
session.add(answer_object)
session.commit()
#----------------------------------------------------------------------
# TODO: Maybe allow for zero length answer if user wants to remove answer?
# NOTE: Replacing value_ with '' will only removes path to img, img data has to be removed separately
#----------------------------------------------------------------------
# Redirect to previous if 'Prev' was clicked
if 'Previous' in request.form.keys():
print('---EXITING showQuestion [POST], REDIRECTING TO PREV: {}'.
format(request.form['prev_url']))
return redirect(request.form['prev_url'])
# Redirect to next if 'Next' was clicked
if 'Next' in request.form.keys():
print('---EXITING showQuestion [POST], REDIRECTING TO NEXT: {}'.
format(request.form['next_url']))
return redirect(request.form['next_url'])
return 'POST redirection to next/prev failed'
q4 = Question(type_='Smileys',
title_="Q2: Air quality",
survey_id_=1,
optional_=True)
q4_c1 = QuestionChoice(title_="frown", question_id_=3)
q4_c2 = QuestionChoice(title_="meh", question_id_=3)
q4_c3 = QuestionChoice(title_="incredible", question_id_=3)
# Feedbacks
fb_1 = Feedback(survey_id_=1)
fb_2 = Feedback(survey_id_=1)
fb_3 = Feedback(survey_id_=1)
fb_4 = Feedback(survey_id_=1)
# Answers from first feedback (survey was 1)
a_f1_q1 = Answer(value_=q1_c1.title_, feedback_id_=1, question_id_=1)
a_f1_q2 = Answer(value_='Wow, I feel fabulous, thank you!',
feedback_id_=1,
question_id_=2)
# Answers from second feedback (survey was 1)
a_f2_q1 = Answer(value_=q1_c2.title_, feedback_id_=2, question_id_=1)
a_f2_q2 = Answer(value_='I feel miserable. The bus ride ruined my day.',
feedback_id_=2,
question_id_=2)
# Answers from third feedback (survey was 2)
a_f3_q3 = Answer(value_=q3_c4.title_, feedback_id_=3, question_id_=3)
a_f3_q4 = Answer(value_=q4_c1.title_, feedback_id_=3, question_id_=4)
# Answers from fourth feedback (survey was 2)
def interact(self, msg, token, user):
result = self.luis.message(msg)
self.db.add_message(
token,
Answer('my_message',
msg,
user=user,
createdAt=datetime.now().strftime('%H:%M')))
try:
if result.score >= 0.5:
if result.intent == 'Travel.Flight':
if len(result.entities) == 0:
res = self.data.get_flights('Moscow')
res = self.magic_sorted(res)
self.save_flight(token, res,
Iata().get_city_name(res.destination))
self.db.set_places(token, [])
self.db.set_hotel(token, None)
return Answer('flights_from', data=res)
else:
res = self.data.get_flights(
'Moscow', dest=result.entities[0].entity)
res = self.magic_sorted(res)
self.save_flight(token, res, result.entities[0].entity)
self.db.set_places(token, [])
self.db.set_hotel(token, None)
return Answer('flights_to', data=res)
elif result.intent == 'Travel.Hotel':
topic = self.db.get_topic(token)
if topic.destination:
res = self.data.get_hotels(topic.destination)
if result.entities[0].entity in self.poi:
res = self.poi_sorted(res,
result.entities[0].entity)
else:
res = self.magic_sorted(res)
topic = self.db.get_topic(token)
topic.topic = 'hotel_found'
self.db.set_topic(token, topic)
self.db.set_hotel(token, res)
return Answer('hotel', data=res)
else:
return Answer('no_topic')
elif result.intent == 'Travel.Places':
topic = self.db.get_topic(token)
if topic.destination:
res = self.data.get_places(topic.destination)[:5]
topic = self.db.get_topic(token)
topic.topic = 'places_found'
self.db.set_topic(token, topic)
self.db.set_places(token, res)
return Answer('places', data=res)
else:
return Answer('no_topic')
elif result.intent == 'Travel.Price':
topic = self.db.get_topic(token)
if topic.topic == 'flight_found':
res = self.data.get_flights(topic.origin,
dest=topic.destination)
res.sort(key=lambda p: p.price)
self.save_flight(
token, res[0],
Iata().get_city_name(res[0].destination))
return Answer('flights_to', data=res[0])
elif topic.topic == 'hotel_found':
res = self.data.get_hotels(topic.destination)
res.sort(key=lambda p: p.price)
self.db.set_hotel(token, res[0])
return Answer('hotel', data=res[0])
else:
return Answer('not_understand')
elif result.intent == 'Travel.Food':
topic = self.db.get_topic(token)
if topic.destination:
res = self.data.get_food(topic.destination)[:1]
topic = self.db.get_topic(token)
topic.topic = 'food_found'
self.db.set_topic(token, topic)
self.db.set_food(token, res)
return Answer('food', data=res)
else:
return Answer('no_topic')
else:
return Answer('not_understand')
else:
return Answer('not_understand')
except Exception as e:
print(e)
return Answer('not_understand')
