Replacing NFLGame with NFLDB about nfldb

[ochawkeye]

nflldb is actually dependent on nflgame. But it would appear to me based on your error that you did not install nfldb with pip. If you had, pip would have detected the httplib2 dependency and installed that one as well.

https://github.com/BurntSushi/nfldb/wiki/Python-&-pip-Windows-installation
https://github.com/BurntSushi/nfldb/wiki/Windows-Install

[iliketowel]

Do I need to somehow delete nfldb? Or just try reinstalling it with pip? Thanks again.

[ochawkeye]

Dunno - what happens when you try to reinstall with pip? If it works then good. If not, what is error and we'll go from there.

[ochawkeye]

Uninstallation shouldn't be difficult if that is what needs to be done. Just need to uninstall the nfldb Python module and not the database. You can do that be just deleting your C:\Python27\Lib\site-packages\nfldb and nfldb-<version>.egg.info (if present) folders.

[iliketowel]

I deleted the two folders, and when I re-install, I get this message:

Perhaps I need to delete nflgame as well?

[ochawkeye]

There's not an error anywhere in that message :) It is just being verbose about the dependencies and letting you know that everything appears up to date. Successfully installed nfldb is the key there.

[BurntSushi]

Use a hammer.

pip install --upgrade --force-reinstall nflgame
pip install --upgrade --force-reinstall nfldb

It sucks that you have to post screenshots. Does cmd not do copy & paste?

[ochawkeye]

Oh wait - it didn't check httplib2 or beautifulsoup4 dependency...

P:\Projects\Home Computer\Fantasy Football\2014>pip install nfldb
Requirement already satisfied (use --upgrade to upgrade): nfldb in c:\python27\lib\site-packages
Requirement already satisfied (use --upgrade to upgrade): nflgame>=1.2.2 in c:\python27\lib\site-pac
kages (from nfldb)
Requirement already satisfied (use --upgrade to upgrade): psycopg2 in c:\python27\lib\site-packages
(from nfldb)
Requirement already satisfied (use --upgrade to upgrade): enum34 in c:\python27\lib\site-packages (f
rom nfldb)
Requirement already satisfied (use --upgrade to upgrade): pytz in c:\python27\lib\site-packages (fro
m nfldb)
Requirement already satisfied (use --upgrade to upgrade): httplib2 in c:\python27\lib\site-packages
(from nflgame>=1.2.2->nfldb)
Requirement already satisfied (use --upgrade to upgrade): beautifulsoup4 in c:\python27\lib\site-pac
kages (from nflgame>=1.2.2->nfldb)
Cleaning up...

What happens if you pip install httplib2 and pip install beautifulsoup4?

[iliketowel]

Not an error, but earlier there was talk of a missing dependcy (httplib2), I'm still not seeing signs of that at all.

pip install --upgrade --force-reinstall nflgame
pip install --upgrade --force-reinstall nfldb
It sucks that you have to post screenshots. Does cmd not do copy & paste?

Let me see if I can look up a way to do so. One thing I'm noticing, I'm not seeing some of the site-> packages I need to see. In issue #33, you had written about needing to see the following:

C:\Users\Ben>pip install nfldb
Requirement already satisfied (use --upgrade to upgrade): nfldb in d:\python27\l
ib\site-packages
Requirement already satisfied (use --upgrade to upgrade): nflgame>=1.2.2 in d:\p
ython27\lib\site-packages (from nfldb)
Requirement already satisfied (use --upgrade to upgrade): psycopg2 in d:\python2
7\lib\site-packages (from nfldb)
Requirement already satisfied (use --upgrade to upgrade): enum34 in d:\python27
lib\site-packages (from nfldb)
Requirement already satisfied (use --upgrade to upgrade): pytz in d:\python27\li
b\site-packages (from nfldb)
Requirement already satisfied (use --upgrade to upgrade): httplib2 in d:\python2
7\lib\site-packages (from nflgame>=1.2.2->nfldb)
Requirement already satisfied (use --upgrade to upgrade): beautifulsoup4 in d:\p
ython27\lib\site-packages (from nflgame>=1.2.2->nfldb)
Cleaning up...

But I don't see the httplib2 or beautifulsoup4 when I reinstalled.

[iliketowel]

sorry, I wrote that as you were responding, so I pip install httplib2 and beautifulsoup4.

I tried to force install the nfldb and I got the following error

error: Unable to find vcvarsall.bat > ---------------------------------------- Rolling back uninstall of psycopg2 > Cleaning up... Command C:\Python27\python.exe -c > "import setuptools,
tokenize;file='c:\users\eric1.bie\appdata\local\temp\pip_build_Eric.Bieber\psycopg2\setup.> py';exec(compile(getattr(tokenize, 'open', open)(file).read().replace('\r\n', '\n'), file, > 'exec'))" install --record c:\users\eric1.bie\appdata\local\temp\pip-dova7b-record\install-record.txt --> single-version-externally-managed --compile failed with error code 1 in > c:\users\eric~1.bie\appdata\local\temp\pip_build_Eric.Bieber\psycopg2 > Storing debug log for failure in C:\Users\Eric.Bieber\pip\pip.log

[ochawkeye]

That puts you at step 1 of the install wiki.
https://github.com/BurntSushi/nfldb/wiki/Windows-Install
You'll be able to skip steps 4 - 11 since you already have the database installed.

[ochawkeye]

It sucks that you have to post screenshots. Does cmd not do copy & paste?
Let me see if I can look up a way to do so

Right clicking your command prompt window will bring up a context menu where you can "Select All". Right click again will copy, and you can paste into a text editor where you can snip out the relevant potion. Copy into this window and surrounding with three '```' at top and bottom will make some pretty markdown that everyone can read.

Then again, sometimes it's just easy to upload a screenshot ;)

[iliketowel]

So, I ended up completely deleting python and starting over. It looks like that did the trick. Now, I got it, and it has all the data from the game last night included.

I think the issue was related to psycopg2, I tried installing it manually. But I must have already installed pip first, and even trying to delete the script and then installing psycopg2 manually didn't help.

Thanks for your time on this issue.