def getPolls(request, uid): conn = mysql.connect() cursor = conn.cursor() cursor.execute(request, uid) data = cursor.fetchall() polls = [] for entry in data: poll = Poll(entry[0], entry[1], entry[4], entry[5], entry[6] != None, entry[7], entry[8]) options = entry[2].split('|') votes = entry[3].split('|') for i in range(len(options)): poll.addOption(options[i], votes[i]) polls.append(poll.toJSON()) return jsonify(polls)