Error trying to load all seasons at once

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

Error trying to load all seasons at once #111

Open peopleworks opened 2 months ago

peopleworks commented 2 months ago

Hello @mpope9 + Everybody

First, I love this project, is a shame that I am meeting with Python now.

I have a problem trying to load all seasons at once, I tried in Postgres and SQLite. If I do five is great, but I don't know how to do five by five, because the id keys resets to one. Or somebody has the full database in Postgres and can share it, I think from this point it can be updated with the actual season.

Thanks in advance Pedro

mpope9 commented 3 weeks ago

Hi! Sorry for the late reply. What do you mean five vs five by five? Do you have the screenshot of the GUI or command flags you ran? I don't host any databases

peopleworks commented 3 weeks ago

Hello @mpope9

Sorry for my bad explanation, If I try to load all seasons at once I get an error, I tried it both SQLite and PostgreSQL, so I tested with small groups, and I realized that loading five seasons works great, but if I try to load next group I have the problem that all sequence number in the tables begins in one again.

Thank you so much for your response

mpope9 commented 2 weeks ago

That is odd can you post the exact error that you are seeing? Are you using the default mode or current season mode?

peopleworks commented 1 week ago

Hello @mpope9

Here is the error, using a PostgreSQL and loading all seasons

Thank you