search

mpope9 / nba-sql

:basketball: An application to build an NBA database backed by MySQL, Postgres, or SQLite
Apache License 2.0
177 stars 22 forks source link

play_by_play table empty after "successful" database build #90

Open throwaway87 opened 1 year ago

throwaway87 commented 1 year ago

using the application to build the database works for other tables but using the same settings and only building the play_by_play table results in the application acting like it was successful but the resulting table has zero rows

mpope9 commented 1 year ago

Hi, thanks for the report. A few questions:

I am able to create a new DB from scratch and that table does get populated. I am using SQLite.

throwaway87 commented 1 year ago

Sorry. Been a while since I wrote up a bug

the app is nba_sql_v0.0.9 on postgresql 15 on windows 10 Yes. I'm using the default mode and since the rest of the db built fine, I'm just attempting that table for the 2022-2023 season. Previously, I could not get a successful build by doing all tables for the current season, so I built the database without building the play_by_play or shot_chart_detail. That worked fine. So now I'm just trying to get the play by play table.

No it does not. When I just build the whole db, it fails on the play by play. I have only built for this season in all circumstances though. Technically, I don't know if doing it for all the seasons would work.

mpope9 commented 1 year ago

Sorry for the late reply on this. I have trouble reproducing this on the most recent version. Is it possible for you to update and try this again? I've tested it on SQLite, MySQL, and Postgres.