def update_results(session, results):
for game in results:
try:
result = session.query(Result).filter_by(
matchday=game.split("_")[0],
home_team=game.split("_")[1],
away_team=game.split("_")[2]).first()
if not result:
result = Result(matchday=game.split("_")[0],
home_team=game.split("_")[1],
home_score=results[game]["home_score"],
away_team=game.split("_")[2],
away_score=results[game]["away_score"])
else:
result.home_score = results[game]["home_score"]
result.away_score = results[game]["away_score"]
session.add(result)
session.commit()
except Exception:
session.rollback()
def update_results(session, results):
for game in results:
try:
result = session.query(Result).filter_by(
matchday=game.split("_")[0],
home_team=game.split("_")[1],
away_team=game.split("_")[2]
).first()
if not result:
result = Result(
matchday=game.split("_")[0],
home_team=game.split("_")[1],
home_score=results[game]["home_score"],
away_team=game.split("_")[2],
away_score=results[game]["away_score"]
)
else:
result.home_score = results[game]["home_score"]
result.away_score = results[game]["away_score"]
session.add(result)
session.commit()
except:
session.rollback()
