-
Notifications
You must be signed in to change notification settings - Fork 263
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Issue with Hall-of-Fame Game #29
Comments
OK I've pushed a fix for this that will support all hall-of-fame games. This fix required modifying both Once that's done, you should be able to just run import nfldb
db = nfldb.connect()
q = nfldb.Query(db)
q.game(season_type='Preseason', week=0).sort(('gsis_id', 'asc'))
print '\n'.join(map(str, q.as_games())) My output: [andrew@Liger nfldb] python2 29.py
Preseason 2009 week 0 on 08/09 at 08:00PM, BUF (18) at TEN (21)
Preseason 2010 week 0 on 08/08 at 08:00PM, DAL (16) at CIN (7)
Preseason 2012 week 0 on 08/05 at 08:00PM, ARI (10) at NO (17)
Preseason 2013 week 0 on 08/04 at 08:00PM, MIA (20) at DAL (24)
Preseason 2014 week 0 on 08/03 at 08:00PM, NYG (0) at BUF (0) |
Fixed in 8897dba |
Trying to load the rest of the 2014 schedule into the DB but throwing an error:
return super(RealDictCursor, self).execute(query, vars)
psycopg2.IntegrityError: new row for relation "game" violates check constraint "game_week_check"
DETAIL: Failing row contains (2014080300, 56426, 2014-08-04 00:00:00+00, 0, Sunday, 2014, Preseason, f, BUF, 0, 0, 0, 0, 0, 0, 0, NYG, 0, 0, 0, 0, 0, 0, 0, 2014-07-13 02:16:40.294716+00, 2014-07-13 02:16:40.294716+00).
The text was updated successfully, but these errors were encountered: