search

mpope9 / nba-sql

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

Fixing duplicate row error -- PGTT and Player Season #81

Closed mpope9 closed 1 year ago

mpope9 commented 1 year ago

A reproduction of this is loading multiple seasons at once for the PGTT table.

The PR removes the row cache. Seems it needs to be blown away between multiple seasons being loaded. Also two minor optimizations of converting the season string to an int outside of the inner loop.