def listallsurveys(user_name, action_text):
"""
List All the surveys. Including closed.
"""
database = db.get_db()
cur = database.execute('SELECT id, question, author, options, open FROM survey')
surveys = cur.fetchall()
count_surveys = len(surveys)
list_msg = "Hi %s, there are %i surveys. \n This is the list:" % (user_name, count_surveys)
for row in surveys:
list_msg = list_msg + "\n %s *%s* *%s* asks *%s*, the survey is *%s* and options are: *[%s]*" % (":clipboard:" if row[4] == 'true' else ":x:", row[0], row[2], row[1], "open" if row[4] == 'true' else "close", row[3])
return list_msg
"""
survey_id = ""
option = ""
try:
parameters = action_text.split(' ',1)[1]
survey_id = parameters.split(' ')[0]
option = parameters.split(' ')[1]
app.logger.debug("%s %s %s " % (user, survey_id, option))
except Exception, e:
return('Parameters ERROR - Example to vote option Green for survey #2: `/survey reply 2 Green`')
try:
database = db.get_db()
cur = database.execute('select id, question, author from survey where id = ? and open is "true"', [survey_id])
survey = cur.fetchone()
if survey is None:
return "No %s, the survey %s is closed! " % (user, survey_id)
database.execute('delete from vote where survey_id = ? and user = ?', [survey_id, user])
database.execute('insert into vote (survey_id, user, option) values (?, ?, ?)', [survey_id, user, option])
database.commit()
except Exception, e:
app.logger.debug(e)
return('DB ERROR')
finally:
database.close()
return "Hi %s, you voted the survey %s with option %s." % (user, survey_id, option)
