constituency.py 文件源码

def get_constituency_info(db,constituency_id):
    cursor = db.cursor()
    cursor.execute('''Select c.id, c.name, c.constituency_code, c.state_id, s.name, c.result_status 
        from constituency c inner join state s on s.id = c.state_id 
        where c.id = ''' + constituency_id + ''';''')
    row = cursor.fetchone()
    voting_status=cgi.escape(row[5])

    voting_status=voting_status.title() if (voting_status!="NOT_STARTED") else "Not Started"
    constituency = {"id": row[0], "name": row[1], \
                    "constituency_code": cgi.escape(row[2]), \
                    "state_id": row[3], "state_name": cgi.escape(row[4]),\
                    "voting_status":voting_status}
    result = get_constituency_result_1(db,constituency_id)
    for result_item in result.iterkeys():
        constituency[result_item]=result[result_item]
    return json.dumps(constituency)