示例#1
0
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)