def get_match_data(match_id):
try:
navbar_status = ["","","active"]
from match_extraction import popflash_scraper as ps
match = ps.get_match_data(match_id)
return render_template("tenman/match_page.html",match=match,navbar_status=navbar_status)
except Exception as e:
return str(e)
def get_match_data(match_id):
try:
from match_extraction import popflash_scraper as ps
from database_management import db_interaction as dbi
from match_extraction.Match import Match
from match_extraction.Team import Team
from match_extraction.Player import Player
navbar_status = [""] * NUM_TABS
navbar_status[2] = "active"
match = ps.get_match_data(match_id)
# Get team balance ratings
team1 = match.get_team_1()
team2 = match.get_team_2()
team1_total = 0
team2_total = 0
his_avg_team_1 = Team()
his_avg_team_2 = Team()
for player in team1:
p1 = dbi.get_player_data(int(player.get_pop_id()))
team1_total += p1.get_hltv_rating()
his_avg_team_1.add_player(p1)
for player in team2:
p2 = dbi.get_player_data(int(player.get_pop_id()))
team2_total += p2.get_hltv_rating()
his_avg_team_2.add_player(p2)
team1_avg_rating = float(team1_total) / 5.0
team2_avg_rating = float(team2_total) / 5.0
team1_percentage = 100 * (team1_avg_rating /
(team1_avg_rating + team2_avg_rating))
team2_percentage = 100 * (team2_avg_rating /
(team1_avg_rating + team2_avg_rating))
return render_template("tenman/match_page.html",
match=match,
navbar_status=navbar_status,
team1_avg_rating=team1_avg_rating,
team2_avg_rating=team2_avg_rating,
team1_percentage=team1_percentage,
team2_percentage=team2_percentage,
his_avg_team_1=his_avg_team_1,
his_avg_team_2=his_avg_team_2)
except Exception as e:
return handle_error(e)
def update_matches(startmatch=0):
conn = dbi.get_database_connection()
matches = dbi.get_table_data(conn, "matches")
count = 0
for row in matches:
if count < startmatch:
count += 1
continue
match_id = int(row[0])
print("Getting data for match", match_id)
m = ps.get_match_data(match_id)
print("Updating data for match", match_id)
dbi.update_match_data(m)
print("Done!")
def add_match_after_flag(match_id):
from database_management import db_interaction as dbi
from match_extraction import popflash_scraper as ps
conn = dbi.get_database_connection()
# To protect against users entering url not from add match page
if not dbi.exists_in_table(conn, "matches", int(match_id)):
pop_match = ps.get_match_data(match_id)
dbi.add_match_data(conn, pop_match)
if not pop_match.is_tie():
dbi.update_season_player_data(conn, pop_match)
flash_str = "Successfully added match " + str(
match_id) + " and updated player data."
flash(flash_str)
conn.close()
dbi.relase_database_flag()
return redirect("/tenman")
def add_pop_match():
try:
if request.method == "GET":
return "Dissallowed, GET"
elif request.method == "POST":
try:
from database_management import db_interaction as dbi
except Exception as e:
return "db_interaction Import failed: " + str(e)
try:
from match_extraction import popflash_scraper as ps
except Exception as e:
return "ps Import failed: " + str(e)
try:
pop_id = request.form["pop_id"]
conn = dbi.get_database_connection()
if dbi.exists_in_table(conn,"matches",int(pop_id)):
flash_str = "Match " + str(pop_id) + " has already been added to the database! Player data has not been updated."
flash(flash_str)
return redirect("/tenman")
else:
pop_match = ps.get_match_data(pop_id)
dbi.add_match_data(conn,pop_match)
flash_str = "Successfully added match " + str(pop_id) + " and updated player data."
flash(flash_str)
return redirect("/tenman")
except Exception as e:
return str(e)
except Exception as e:
return str(e)
from database_management import db_interaction as dbi
from match_extraction.Match import Match
from match_extraction import popflash_scraper as ps
def update_matches(startmatch=0):
conn = dbi.get_database_connection()
matches = dbi.get_table_data(conn, "matches")
count = 0
for row in matches:
if count < startmatch:
count += 1
continue
match_id = int(row[0])
print("Getting data for match", match_id)
m = ps.get_match_data(match_id)
print("Updating data for match", match_id)
dbi.update_match_data(m)
print("Done!")
# Remove weekday from match date column
def update_match_dates():
pass
if __name__ == "__main__":
#update_matches()
m = ps.get_match_data(1125941)
dbi.update_match_data(m)