def generate_season_nav_page(connection, s3, env):
content = "<p>Seasons</p>"
# content["title"] = f'Baseball seasons'
with open("html/templates/base.html") as file:
base = file.read()
query = 'SELECT season FROM seasons ORDER BY season ASC'
print(query)
rows = get_rows(query)
for row in rows:
content += f'<p><a href = "/seasons/{row["season"]}">{row["season"]}</a></p>\n'
page = base.replace("{main}", content)
page = page.replace("{title}", "Baseball seasons")
page = page.replace("{page_generated}", str(datetime.datetime.now()))
if env["create_local_files"]:
write_to_local_disk(page, "season_nav", 0)
if env["push_to_s3"]:
write_to_s3(page, "season_nav", 0, s3)
def generate_players_page(connection, season, s3, push_to_s3,
create_local_files):
query = f'SELECT * FROM player_x_season_detail WHERE season={season} ORDER BY lnf'
print(query)
rows = get_rows(query)
with open("html/templates/trade_row.html") as file:
template = file.read()
vals = [
"added_player_fnf", "date", "dropped_player_fnf", "nickname", "pos"
]
table_rows = ""
for row in rows:
print(row)
content = get_players_page_content(connection, season)
if create_local_files:
write_to_local_disk(content, "players", season)
if push_to_s3:
write_to_s3(content, "players", season, s3)
def generate_trades_page(connection, season, s3, push_to_s3, create_local_files): content = get_trades_content(connection, season) if create_local_files: write_to_local_disk(content, "trades", season) if push_to_s3: write_to_s3(content, "trades", season, s3)
def generate_season_home_page(connection, season, season_is_current, s3, env):
content = get_season_home_page_content(connection, season,
season_is_current)
if env["create_local_files"]:
write_to_local_disk(content, "season", season)
if env["push_to_s3"]:
write_to_s3(content, "season", season, s3)
def generate_player_page(connection, season, s3, push_to_s3,
create_local_files, player_id):
content = get_player_content(connection, season, s3, push_to_s3,
create_local_files, player_id)
if create_local_files:
write_to_local_disk(content, "player", season, player_id)
if push_to_s3:
write_to_s3(content, "player", season, s3, player_id)