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()