def default(self, path):
"""
Main Page - redirects to most current election
"""
headers = {}
headers['Content-Type'] = 'text/html; charset=utf-8'
output = []
addline = output.append
query = sql.text("""
select max(election_id) as max_id
from elections
limit 1
""", bind=sql.engine
)
rs = query.execute().fetchall()
if len(rs) > 0:
raise web.seeother('/election/%s' % (rs[0].max_id))
raise web.seeother('/elections')
def get_apidoc_page(path):
"""
Returns API Documentation.
"""
section = 'Site Notes'
title = 'API Documentation'
description = 'Documentation on how to use the RTH Elections API.'
output = []
addline = output.append
query = sql.text("""
select content, last_updated
from election_apidoc
order by doc_id desc
limit 1
""", bind=sql.engine
)
rs = query.execute().fetchall()
if len(rs) == 0:
addline('Sorry, but the API documentation is not currently available.')
else:
addline(rs[0].content)
addline('\n*Last Updated: %s*' % (rs[0].last_updated))
content = markdown('\n'.join(output))
toc = pytoc.Toc(html_in=content)
toc.make_toc()
full_content = '%s\n%s' % (toc.html_toc, toc.html_out)
template = t.default
template = template.replace('[[date]]', get_date())
template = template.replace('[[time]]', get_time())
template = template.replace('[[title]]', title)
template = template.replace('[[section]]', section)
template = template.replace('[[description]]', description)
template = template.replace('[[content]]', full_content)
return title, template
def text(self, text, *args, **kwargs):
"""returns a sql.text() object for performing literal queries."""
return sql.text(text, engine=self, *args, **kwargs)
);
"""
conn = sql.im_db_engine.connect()
conn.execute(create_db)
conn.execute("""USE solutions;""")
conn.execute(drop_tables)
conn.execute(schema_countries)
conn.execute(schema_regions)
conn.execute(schema_cities)
with open('countries.json') as fc:
countries_json = json.load(fc)
conn.execute(
sql.text("""
INSERT INTO `countries` (id, alpha2, alpha3, name, targetable) VALUES
(:id, :alpha2, :alpha3, :name, :targetable);
"""), *countries_json)
with open('regions.json') as fr:
regions_json = json.load(fr)
conn.execute(
sql.text("""
INSERT INTO `regions` (id, country_id, name, iso_code) VALUES
(:id, :country_id, :name, :iso_code);
"""), *regions_json)
with open('cities.json') as fct:
cities_json = json.load(fct)
conn.execute(
sql.text("""
INSERT INTO `cities` (id, country_id, region_id, name, iso_code) VALUES
def all_city_info(city_name):
res = sql.conn.execute(sql.text(q), {'city_name': city_name}).fetchone()
return dict(res)
'state': r.state
} for r in results]
print("Rows to insert: ")
print(rows_to_insert)
sql_conn = sql.conn
sql_conn.execute("""CREATE TABLE IF NOT EXISTS max_min_temp_by_state (
min_temp DECIMAL(12,5),
max_temp DECIMAL(12,5),
state VARCHAR(255)
);""")
table = 'max_min_temp_by_state'
sql_conn.execute("DELETE FROM {};".format(table))
sql_conn.execute(
sql.text("""
INSERT INTO `max_min_temp_by_state` (min_temp, max_temp, state) VALUES (:min_temp, :max_temp, :state);
"""), *rows_to_insert)
res = sql_conn.execute("""
SELECT * FROM `max_min_temp_by_state`;
""").fetchall()
print("Inserted the rows: ")
print(res)
sql_conn.close()
