def write_bills_pages():
logger_html.info("Generating bills html pages.")
per_bill_template = templates.get_template("bill_D_S_template.html")
billcur = db.cursor()
billcur.execute("""SELECT * FROM bills""")
count = 0
for name, sig, date, original_url in billcur:
print count
count += 1
chroncur = db.cursor()
chroncur.execute(
"""SELECT event, event_date FROM bill_history
WHERE bill_signature = %s""",
(sig,),
)
authcur = db.cursor()
authcur.execute(
"""SELECT bill_author FROM bill_authors
WHERE bill_signature = %s""",
(sig,),
)
authors = [(a, "mp_%s.html" % unicode2urlsafe(a)) for (a,) in authcur]
authcur.execute(
"""SELECT COUNT(*) FROM bills_by_government
WHERE bill_signature = %s""",
(sig,),
)
if authcur.fetchone()[0]:
authors.append((u"Mинистерски съвет", "http://www.government.bg/"))
with open("generated_html/bill_%s_%s.html" % (date.strftime("%Y%m%d"), sig), "w") as html_file:
html_file.write(
per_bill_template.render(
name=name, chronology=chroncur.fetchall(), authors=authors, original_url=original_url
)
)
sitemap.add("bill_%s_%s.html" % (date.strftime("%Y%m%d"), sig), 0.7)
def write_MPs_overview_page():
load_votes_regs_data()
############
# Summary. #
############
logger_html.info("Generating summary html page with MP details.")
# Plots
alltime_regs(*np.sum(mps_all_reg, 0))
alltime_votes(*np.sum(all_sessions_vote, 0))
# HTML
mps_template = templates.get_template("mps_template.html")
with open("generated_html/mps.html", "w") as html_file:
html_file.write(
mps_template.render(
mps=mps,
mps_all_reg=mps_all_reg,
mps_all_vote=mps_all_vote,
mps_all_with_against_party=mps_all_with_against_party,
mps_all_with_against_all=mps_all_with_against_all,
)
)
sitemap.add(
"mps.html",
0.8,
[
("alltimeregs.png", u"Oтсъствия на депутати по време на регистрация."),
("alltimevotes.png", u"Гласове и отсъствия на депутати по време на гласувания."),
],
)
#################
# Per MP pages. #
#################
per_mp_template = templates.get_template("mp_N_template.html")
only_dates = [d[0] for d in session_dates]
for mp_i, (name, party, party_now, original_url) in enumerate(mps):
logger_html.info("Generating page for MP %d of %d." % (mp_i, len(mps)))
asciiname = unicode2urlsafe(name)
alltime_regs_singleMP(mps_all_reg[mp_i, :], name, asciiname)
alltime_votes_singleMP_compare_all(mps_all_with_against_all[mp_i, :], mps_all_vote[mp_i, 2:], name, asciiname)
alltime_votes_singleMP_compare_party(
mps_all_with_against_party[mp_i, :], mps_all_vote[mp_i, 2:], name, asciiname
)
evolution_of_votes_singleMP(
only_dates,
mps_dates_vote[mp_i, :, :],
mps_dates_with_against_all[mp_i, :, :],
mps_dates_with_against_party[mp_i, :, :],
name,
asciiname,
)
with open("generated_html/mp_%s.html" % asciiname, "w") as html_file:
html_file.write(
per_mp_template.render(
name=name,
asciiname=asciiname,
party=party,
party_now=party_now,
vote=mps_all_vote[mp_i, :],
with_against_p=mps_all_with_against_party[mp_i, :],
with_against_a=mps_all_with_against_all[mp_i, :],
reg=mps_all_reg[mp_i, :],
original_url=original_url,
)
)
sitemap.add(
"mp_%s.html" % asciiname,
0.7,
[
("vote_evol_%s.png" % asciiname, u"Гласовете и отсъствията на %s през годините." % name),
("alltimeregs_%s.png" % asciiname, u"Oтсъствия на %s по време на регистрация." % name),
(
"alltimevotes_compare_all_%s.png" % asciiname,
u"Гласове и отсъствия на %s по време на гласувания (сравнение с мнозинството)." % name,
),
(
"alltimevotes_compare_party_%s.png" % asciiname,
u"Гласове и отсъствия на %s по време на гласувания (сравнение с позицията на партията)." % name,
),
],
)
