def new_game(self, **kwargs):
        default = {}
        default.update(kwargs)

        game = Game(**default)
        db.session.add(game)
        db.session.commit()
        return game
Exemple #2
0
                        debut_date=debut_date)
        player.save()

if import_type == 'gamelog':
    for row in rows:
        print("Processing %(date)s..." % {'date': row[0]})
        game_date = date_or_none(row[0], "%Y%m%d")
        attendance = int(row[17])
        day_of_week = row[2]
        duration_in_minutes = int(row[18])
        winning_pitcher = Player.objects.get(retrosheet_id=row[93])
        losing_pitcher = Player.objects.get(retrosheet_id=row[95])

        game = Game(attendance=attendance,
                    date=game_date,
                    day_of_week=day_of_week,
                    winning_pitcher=winning_pitcher,
                    losing_pitcher=losing_pitcher)

        game.save()

        away_team = Team.objects.get(team_abbreviation=row[3], league=row[4])
        away_team_game_number = int(row[5])
        away_team_runs_scored = int(row[9])
        away_team_starting_pitcher = Player.objects.get(retrosheet_id=row[101])
        away_participant = game.gameparticipant_set.create(
            team=away_team,
            game_number_for_season=away_team_game_number,
            team_location_status='away',
            runs_scored_count=away_team_runs_scored,
            starting_pitcher=away_team_starting_pitcher)