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)