Enhancement 5074 (Adding possibility to cleanup_database.pl to purge only older sessi...
authorMarcel de Rooy <M.de.Rooy@rijksmuseum.nl>
Thu, 28 Oct 2010 13:05:20 +0000 (09:05 -0400)
committerChris Nighswonger <chris.nighswonger@gmail.com>
Tue, 2 Nov 2010 01:19:09 +0000 (21:19 -0400)
commitbc08e8cf6b2fb58c51a785bee132d35b0be946e5
tree656c91ca935a214e6c51024d2521423ef7ad883e
parent430b609ee64af303e31f083cc0891e4b6c8bc28e
Enhancement 5074 (Adding possibility to cleanup_database.pl to purge only older sessions) [UPDATED for master]

Currently, the misc/cronjobs script cleanup_database truncates the session table (deleting all records, including active sessions).
With an additional parameter sessdays, this behavior could be changed or (perhaps better) extended. If the parameter sessdays is passed along with a number of days, the script only deletes older session records. This is accomplished by examining the values of lasttime, atime or ctime in the record.
So, calling the script like:
  ./cleanup_database.pl -v -sessions -sessdays 7
will only delete sessions records older than 7 days. The "old style" call
  ./cleanup_database.pl -v -sessions
still works too and truncates the table as before.

Signed-off-by: Galen Charlton <gmcharlt@gmail.com>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
Signed-off-by: Chris Nighswonger <chris.nighswonger@gmail.com>
misc/cronjobs/cleanup_database.pl