nba-sql icon indicating copy to clipboard operation
nba-sql copied to clipboard

Allow for enhancement of existing DB with older seasons

Open Flavsditz opened this issue 7 months ago • 1 comments

When I first gave it a try I used the existing bash scripts. It created a new DB filled with data. When I went to explore I noticed it was from the latest season only. I went back to see if I could add another season and got some errors in the process. I would like to have the opportunity to add older seasons after I have a DB in place.

Current State: Create a DB and populate with data on first creation only. Subsequently a refresh of data is supported for the latest season

Enhancement Together with the above also add the option to load one or more specific seasons after a DB is initialized

Requirements

  • It needs to see if a season was already loaded to avoid the extra requests
    • Could be overwritten with a force flag
  • Need to add an UPSERT capability in the DB

Flavsditz avatar Jul 17 '24 06:07 Flavsditz