diff options
| author | Ted Trask <ttrask01@yahoo.com> | 2011-09-09 15:37:03 +0000 |
|---|---|---|
| committer | Ted Trask <ttrask01@yahoo.com> | 2011-09-09 15:37:03 +0000 |
| commit | 570fb191bcb47342f1fc0158c317b1d49c84de3b (patch) | |
| tree | 6f61888e5cc23d6e65be451826f47b7b7b41e6c6 | |
| parent | 2300869792f39dd73422b21e0ae7b96c0e19204c (diff) | |
| download | acf-weblog-570fb191bcb47342f1fc0158c317b1d49c84de3b.tar.bz2 acf-weblog-570fb191bcb47342f1fc0158c317b1d49c84de3b.tar.xz | |
Purge the pubweblog_history table after one year
| -rw-r--r-- | weblog-model.lua | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/weblog-model.lua b/weblog-model.lua index 619a538..ae2fa60 100644 --- a/weblog-model.lua +++ b/weblog-model.lua @@ -275,7 +275,7 @@ local groompublogs = function() local now = os.time() local temp = os.date("%Y-%m-%d %H:%M:%S", now - purgedays*86400) - logme("Purgedate is " .. temp .. ". Nothing will exist in pubweblog beyond purgedate.") + logme("Purgedate is " .. temp .. ". Nothing will exist in pubweblog from before purgedate.") -- Move flagged records to histoy and then purge anything older than purgedate sql = "Insert into pubweblog_history select * from pubweblog where logdatetime < '" .. temp .."' and (badyesno > 0 or deniedyesno > 0 or bypassyesno > 0 or selected = 'true')" @@ -284,7 +284,11 @@ local groompublogs = function() sql = "Delete from pubweblog where logdatetime < '" .. temp .."'" res = assert (con:execute(sql)) - logme("Deleted " .. res .. " old records to from pubweblog") + logme("Deleted " .. res .. " old records from pubweblog") + + sql = "delete from pubweblog_history where logdatetime < (now() - INTERVAL '1 year')" + res = assert (con:execute(sql)) + logme("Deleted " .. res .. " old records from pubweblog_history") end local generatewhereclause = function(clientuserid, starttime, endtime, clientip, badyesno, deniedyesno, bypassyesno, score, urisearch, selected) |