def index():
session = sql.newSession()
cans = sql.candidateNames(session)
return render_template("index.html", title="Home", candidates=cans)
def candidatePage(canId):
# create the query session
session = sql.newSession()
# get canidates (for nav bar)
cans = sql.candidateNames(session)
# get the canidate info for the table
canInfo = sql.candidateInfo(canId, session)
# get the canidate name
candidate_name = sql.candidateName(canId, session)
# get the google trends
line1 = dict(
data=sql.canidateGoogleTrendYTD(canId, session),
name="Google Trends",
line=dict(color=("rgb(22,96,167)"), width=4),
)
# get opinion polls
line2 = dict(
data=sql.canidateOpinionPollYTD(canId, session),
name="Opinion Polls",
line=dict(color=("rgb(150, 27, 19)"), width=4),
)
# package them up into one graph
lineData = [line1, line2]
fig = plot.multiLineTimePlot(lineData, "", "Performance")
graphData = json.dumps(fig["data"])
graphLayout = json.dumps(fig["layout"])
# top contributer occupation
topContrib = sql.TopContribOccupations(canId, session)
# cadidate top state contributers
contrib = sql.candidateTopContributionState(canId, session)
return render_template(
"candidate.html",
title=candidate_name,
name=candidate_name,
candidates=cans,
canInfo=canInfo,
data=graphData,
layout=graphLayout,
candidateInfo=canInfo,
stateInfo=contrib,
topContrib=topContrib,
)