Thank you! I appreciate it, sorry about the late response :)
Been trying to figure this one out for a little while. This query sort of works but not really- I get about a third of the pitches from a certain pitcher and the rest are duplicates. Does anyone have a script that works for them? SELECT t1.first, t1.last, t3.spin_rate, t3.start_speed, t3.end_speed, t3.pitch_type, t3.gamedayPitchID, t3.pfx_z, t3.gameName, t1.id, t2.pitcher, t2.gameName, t2.num, t3.gameAtBatID FROM gameday.players t1, gameday.atbats t2, gameday.pitches t3 WHERE t1.id = t2.pitcher AND...
It's working! Yay! But all the values for break_z and break_x are missing. Are those supposed to be there? Also, some of the games in the games table are clearly missing. What do I do when there are missing values/rows in the tables?
Thanks for putting together a new version of this! I have all of 2017 in my DB, but I downloaded files that someone else exported for me (because of the links issue) and there's errors in the data, so I definitely need to start fresh. You said that it's as simple as deleting all of the old BBOS files and replacing them with the new ones. Does that mean I need to go through the whole installation process again? Thanks
Hi, when someone here figures it out, may you please post the solution to the issue? Am I going to have to go into the files and fix errors in the code? Still super new to this.
Has anyone been able to figure out what's going on with the games all missing? Is MLB going to put them back up at some point? I have a friend that suggested maybe MLB is just making changes to it or something. I tried downloading individual games like deez nuts said, but that didn't work for me either.
I'm getting the same message when I try to load a game: INFO 2018-01-21 10:59:06,367 MainThread bbos.main.42 Distributing 0 urls to 8 threads But then it says the load is complete? INFO 2018-01-21 10:59:06,927 MainThread bbos.main.47 load complete! Just there's no information in any of the tables. I was messing around and I deleted the few games I had accidently, and I somehow managed to delete my bbos.py information in the src file, but I got the bbos.py file back. I just can't download any games...
I have the command prompt open, I just need to know what to type in. I'm defintitely going to keep working at this, I want to make it work. And yes, it is windows, windows 10.