Page 1 of 1

SQLite Free Agent Signings

Posted: Tue Jun 14, 2016 4:09 pm
by Foo
Will be useful to have a SQLite table just like the Next Year Free Agent to record and log every signings done by the commish with automatic and manual free agent. The Next Year Free Agent table is great but
1) it is just for player with one year contract left and
2) it erase itself after each season so it's impossible to keep track of signings unless going back to previous databases.

Re: SQLite Free Agent Signings

Posted: Tue Jun 14, 2016 6:31 pm
by SimonT
I don't keep track of this STHS except maybe transaction history but that not reliable. :(

Re: SQLite Free Agent Signings

Posted: Tue Jun 14, 2016 6:46 pm
by Foo
What's the difference between writing it in the log OR writing it in a special SQLite table ???

Re: SQLite Free Agent Signings

Posted: Wed Jun 15, 2016 7:37 pm
by SimonT
The SQLite database is delete recreate at every output. So I would need to keep it a seperate SQLite Database, not table...

Re: SQLite Free Agent Signings

Posted: Mon Jun 20, 2016 10:14 pm
by JimToupet
SimonT wrote:The SQLite database is delete recreate at every output. So I would need to keep it a seperate SQLite Database, not table...
Not possible to drop all table except some "historical" table instead of a "drop" database ? That will permit the addition of free agent stuff, boxscore, etc... in the SQLite database.