def fill_fixtures_from_api(season, dbsession=session):
"""
Use the FPL API to get a list of fixures.
"""
tag = str(uuid.uuid4())
fetcher = FPLDataFetcher()
fixtures = fetcher.get_fixture_data()
for fixture in fixtures:
try:
f = find_fixture(
fixture["team_h"],
was_home=True,
other_team=fixture["team_a"],
season=season,
dbsession=dbsession,
)
update = True
except ValueError:
f = Fixture()
update = False
f.date = fixture["kickoff_time"]
f.gameweek = fixture["event"]
f.season = season
f.tag = tag
home_id = fixture["team_h"]
away_id = fixture["team_a"]
found_home = False
found_away = False
for k, v in alternative_team_names.items():
if str(home_id) in v:
f.home_team = k
found_home = True
elif str(away_id) in v:
f.away_team = k
found_away = True
if found_home and found_away:
break
error_str = "Can't find team(s) with id(s): {}."
if not found_home and found_away:
raise ValueError(error_str.format(home_id + ", " + away_id))
elif not found_home:
raise ValueError(error_str.format(home_id))
elif not found_away:
raise ValueError(error_str.format(away_id))
else:
pass
if not update:
dbsession.add(f)
dbsession.commit()
return True
def fill_fixtures_from_file(filename, season, session):
"""
use the match results csv files to get a list of matches in a season,
"""
infile = open(filename)
for line in infile.readlines()[1:]:
fields = line.strip().split(",")
f = Fixture()
f.date = fields[0]
f.gameweek = fields[5]
home_team = fields[1]
away_team = fields[2]
for k, v in alternative_team_names.items():
if home_team in v:
f.home_team = k
elif away_team in v:
f.away_team = k
print(" ==> Filling fixture {} {}".format(f.home_team, f.away_team))
f.season = season
f.tag = "latest" # not really needed for past seasons
session.add(f)
session.commit()