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'