def get_pregame_hitting_stats_wrapper(game): database_session = MlbDatabase().open_session() for current_hitter in game.away_lineup: pitcher_hand = game.home_pitcher.hand print "Mining %s." % current_hitter.name try: pregame_hitter_entry = get_hitter_stats(current_hitter.rotowire_id, game.home_pitcher.rotowire_id, current_hitter.team, pitcher_hand, database_session) pregame_hitter_entry.game_date = date.today() pregame_hitter_entry.opposing_team = game.home_pitcher.team predict_draftkings_points(pregame_hitter_entry) database_session.add(pregame_hitter_entry) database_session.commit() except HitterNotFound as e: print e except IntegrityError: print "Attempt to duplicate hitter entry: %s %s %s" % (current_hitter.name, pregame_hitter_entry.team, pregame_hitter_entry.opposing_team) database_session.rollback() for current_hitter in game.home_lineup: pitcher_hand = game.away_pitcher.hand print "Mining %s." % current_hitter.name try: pregame_hitter_entry = get_hitter_stats(current_hitter.rotowire_id, game.away_pitcher.rotowire_id, current_hitter.team, pitcher_hand, database_session) pregame_hitter_entry.game_date = date.today() pregame_hitter_entry.opposing_team = game.away_pitcher.team predict_draftkings_points(pregame_hitter_entry) database_session.add(pregame_hitter_entry) database_session.commit() except HitterNotFound as e: print e except IntegrityError: print "Attempt to duplicate hitter entry: %s %s %s" % (current_hitter.name, pregame_hitter_entry.team, pregame_hitter_entry.opposing_team) database_session.rollback() database_session.close()
def get_pregame_hitting_stats_wrapper(game): database_session = MlbDatabase().open_session() for current_hitter in game.away_lineup: pitcher_hand = game.home_pitcher.hand print "Mining %s." % current_hitter.name try: pregame_hitter_entry = get_hitter_stats( current_hitter.rotowire_id, game.home_pitcher.rotowire_id, current_hitter.team, pitcher_hand, database_session) pregame_hitter_entry.game_date = date.today() pregame_hitter_entry.opposing_team = game.home_pitcher.team predict_draftkings_points(pregame_hitter_entry) database_session.add(pregame_hitter_entry) database_session.commit() except HitterNotFound as e: print e except IntegrityError: print "Attempt to duplicate hitter entry: %s %s %s" % ( current_hitter.name, pregame_hitter_entry.team, pregame_hitter_entry.opposing_team) database_session.rollback() for current_hitter in game.home_lineup: pitcher_hand = game.away_pitcher.hand print "Mining %s." % current_hitter.name try: pregame_hitter_entry = get_hitter_stats( current_hitter.rotowire_id, game.away_pitcher.rotowire_id, current_hitter.team, pitcher_hand, database_session) pregame_hitter_entry.game_date = date.today() pregame_hitter_entry.opposing_team = game.away_pitcher.team predict_draftkings_points(pregame_hitter_entry) database_session.add(pregame_hitter_entry) database_session.commit() except HitterNotFound as e: print e except IntegrityError: print "Attempt to duplicate hitter entry: %s %s %s" % ( current_hitter.name, pregame_hitter_entry.team, pregame_hitter_entry.opposing_team) database_session.rollback() database_session.close()
def get_pregame_pitching_stats_wrapper(game): database_session = MlbDatabase().open_session() current_pitcher = game.away_pitcher print "Mining %s." % current_pitcher.name try: pregame_pitcher_entry = get_pitcher_stats(current_pitcher.rotowire_id, current_pitcher.team, game.home_pitcher.team, database_session) predict_draftkings_points(pregame_pitcher_entry) database_session.add(pregame_pitcher_entry) database_session.commit() except IntegrityError: print "Attempt to duplicate pitcher entry: %s %s %s" % ( current_pitcher.name, pregame_pitcher_entry.team, pregame_pitcher_entry.opposing_team) database_session.rollback() except PitcherNotFound as e: print e current_pitcher = game.home_pitcher print "Mining %s." % current_pitcher.name try: pregame_pitcher_entry = get_pitcher_stats(current_pitcher.rotowire_id, current_pitcher.team, game.away_pitcher.team, database_session) predict_draftkings_points(pregame_pitcher_entry) database_session.add(pregame_pitcher_entry) database_session.commit() except IntegrityError: print "Attempt to duplicate pitcher entry: %s %s %s" % ( current_pitcher.name, pregame_pitcher_entry.team, pregame_pitcher_entry.opposing_team) database_session.rollback() except PitcherNotFound as e: print e database_session.close()
def get_pregame_pitching_stats_wrapper(game): database_session = MlbDatabase().open_session() current_pitcher = game.away_pitcher print "Mining %s." % current_pitcher.name try: pregame_pitcher_entry = get_pitcher_stats(current_pitcher.rotowire_id, current_pitcher.team, game.home_pitcher.team, database_session) predict_draftkings_points(pregame_pitcher_entry) database_session.add(pregame_pitcher_entry) database_session.commit() except IntegrityError: print "Attempt to duplicate pitcher entry: %s %s %s" % (current_pitcher.name, pregame_pitcher_entry.team, pregame_pitcher_entry.opposing_team) database_session.rollback() except PitcherNotFound as e: print e current_pitcher = game.home_pitcher print "Mining %s." % current_pitcher.name try: pregame_pitcher_entry = get_pitcher_stats(current_pitcher.rotowire_id, current_pitcher.team, game.away_pitcher.team, database_session) predict_draftkings_points(pregame_pitcher_entry) database_session.add(pregame_pitcher_entry) database_session.commit() except IntegrityError: print "Attempt to duplicate pitcher entry: %s %s %s" % (current_pitcher.name, pregame_pitcher_entry.team, pregame_pitcher_entry.opposing_team) database_session.rollback() except PitcherNotFound as e: print e database_session.close()