def setUp(self): add_pitcher_entry() database_session = MlbDatabase(DB_PATH).open_session() entry = GameEntry(date.today(), date.today().ctime(), CommitNewPregamePitcherTest.HOME_TEAM, 'MIA') database_session.add(entry) database_session.commit() database_session.close()
def add_pitcher_entries(): database_session = MlbDatabase(DB_PATH).open_session() starting_pitcher_1 = PitcherEntry('Andrew', 'Cashner', '10468') database_session.add(starting_pitcher_1) starting_pitcher_2 = PitcherEntry('Jeff', 'Samardzija', '9374') database_session.add(starting_pitcher_2) database_session.commit() database_session.close()
def setUp(self): add_hitter_entry() add_pitcher_entry() database_session = MlbDatabase(DB_PATH).open_session() entry = GameEntry(date.today(), date.today().ctime(), 'SD', 'BOS') database_session.add(entry) database_session.commit() database_session.close()
def runTest(self): database_session = MlbDatabase(DB_PATH).open_session() starting_pitcher_1 = PitcherEntry('Andrew', 'Cashner', '10468') starting_pitcher_1.baseball_reference_id = 'cashnan01' starting_pitcher_1.home_team = 'MIA' starting_pitcher_1.pitching_hand = 'R' database_session.add(starting_pitcher_1) database_session.commit() database_session.close()
def add_hitter_entry(): database_session = MlbDatabase(DB_PATH).open_session() hitter = HitterEntry('Wil', 'Myers', '10972') hitter.baseball_reference_id = 'myerswi01' hitter.team = 'SD' hitter.batting_hand = 'R' database_session.add(hitter) database_session.commit() database_session.close()
def runTest(self): database_session = MlbDatabase(DB_PATH).open_session() entry = PregamePitcherGameEntry() entry.rotowire_id = '10468' entry.game_date = date.today() entry.game_time = date.today().ctime() entry.home_team = CommitNewPregamePitcherTest.HOME_TEAM database_session.add(entry) database_session.commit() 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_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()
def runTest(self): database_session = MlbDatabase(DB_PATH).open_session() lineup = LineupEntry() lineup.starting_pitcher_1 = '10468' lineup.starting_pitcher_2 = '9374' lineup.catcher = '8047' lineup.first_baseman = '8620' lineup.second_baseman = '6508' lineup.third_baseman = '9862' lineup.shortstop = '11437' lineup.outfielder_1 = '7140' lineup.outfielder_2 = '13190' lineup.outfielder_3 = '7618' lineup.game_date = date.today() lineup.game_time = date.today().ctime() database_session.add(lineup) database_session.commit() database_session.close()
def add_hitter_entries(): """ Just add some hitter entries to the test database to satisfy foreign key constraints """ database_session = MlbDatabase(DB_PATH).open_session() catcher = HitterEntry('Russell', 'Martin', '8047') database_session.add(catcher) first_baseman = HitterEntry('Ryan', 'Zimmerman', '8620') database_session.add(first_baseman) second_baseman = HitterEntry('Chase', 'Utley', '6508') database_session.add(second_baseman) third_baseman = HitterEntry('Josh', 'Donaldson', '9862') database_session.add(third_baseman) shortstop = HitterEntry('Manny', 'Machado', '11437') database_session.add(shortstop) outfielder_1 = HitterEntry('Melvin', 'Upton Jr.', '7140') database_session.add(outfielder_1) outfielder_2 = HitterEntry('Jose', 'Peraza', '13190') database_session.add(outfielder_2) outfielder_3 = HitterEntry('Nick', 'Markakis', '7618') database_session.add(outfielder_3) database_session.commit() database_session.close()
park_entry.park_pitcher_score = team_info[1] try: database_session.add(park_entry) database_session.commit() except IntegrityError: database_session.rollback() """ """ start_date = date(day=2, month=4, year=2016) end_date = date(day=1, month=11, year=2016) current_date = start_date while current_date <= end_date: get_game_data(current_date) current_date += timedelta(days=1) """ """ database_session = MlbDatabase().open_session() postgame_hitter_entries = database_session.query(PostgameHitterGameEntry) for hitter in postgame_hitter_entries: game_entry = database_session.query(GameEntry).filter((GameEntry.game_date == hitter.game_date) & ((GameEntry.away_team == hitter.hitter_entry.team) | (GameEntry.home_team == hitter.hitter_entry.team))) print game_entry.count() if game_entry.count() == 1: print "%s going to %s" % (hitter.game_time, game_entry[0].game_time) hitter.game_time = game_entry[0].game_time #hitter.game_time = "12:00:00:34" hitter.game_date = game_entry[0].game_date if hitter.team == game_entry[0].away_team: hitter.opposing_team = game_entry[0].home_team