Page 1 of 1

SQLite DB Stuff

PostPosted: Sun Jun 28, 2020 3:52 am
by 21C
Looking at the Ratings table from career.pbb in SQLiteStudio, the PlayerID is showing Integer for the Data Type but the actual data is a String (e.g. smitsc01).

I don't know if that is an error in SQLiteStudio (it opened the file as a SQLite 3 file) or the Ratings table in career.pbb is messed up. I was trying to get my team's player ratings changes over several seasons. I was able to work around it but I thought that I would mention it anyway.

Running version 9.12.

Re: Ratings table career.pbb shows wrong data type for Playe

PostPosted: Tue Jun 30, 2020 5:47 pm
by Gary Gorski
I see what you are saying - that probably should be a string in the database but it seems to work as it is. I will investigate more

Re: Ratings table career.pbb shows wrong data type for Playe

PostPosted: Sat Jul 04, 2020 10:59 pm
by 21C
New issue but I thought that I would post it here rather than starting a new thread.

I was looking for player stats in the middle of a season to do some extended data manipulation - I am currently at December 24, 2028. I am looking at the following files in SQLiteStudio - career.pbb, commish.coa, [MyName].coa and the exported [MyLeague]Edit.db in the DB folder - exported on the same date Dec 24.

I see SeasonStats tables in career and [MyLeague]Edit but the [MyLeague]Edit one has no data - the same for the PlayoffStats table in [MyLeague]Edit. The tables for Cities, Coaches, Players and Teams are fully populated.

When I open SeasonStats in career, it appears fine for past seasons but the current season only shows players who have been involved in trades.

Am I looking in the wrong place? Is the current season data only available at the end of the season?

Re: SQLite DB Stuff

PostPosted: Mon Jul 06, 2020 6:32 pm
by Gary Gorski
Yes the current season data will only be exported there at the end of the season