play_by_play table empty after "successful" database build
throwaway87 opened this issue · 3 comments
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
Hi, thanks for the report. A few questions:
- What version were you using?
- Are you trying to use the 'default-mode' setting to build the
play_by_playtable? - Does building the whole db from scratch without skipping the
play_by_playtable fill it?
I am able to create a new DB from scratch and that table does get populated. I am using SQLite.
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.
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.