diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2025-12-20 15:16:25 +0000 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2025-12-20 15:16:25 +0000 |
| commit | 30a9d45f5322a63c2adf1de7a248ba3a9a0c3903 (patch) | |
| tree | a384473d3be0d5f3fc8c358c827b6cf158d187b3 /src/sql/accessLogPurgeOld.sql | |
| parent | f8276d22b6501e3d6164f9b26df94d2d57f597e5 (diff) | |
| download | webstat-30a9d45f5322a63c2adf1de7a248ba3a9a0c3903.tar.bz2 webstat-30a9d45f5322a63c2adf1de7a248ba3a9a0c3903.tar.xz webstat-30a9d45f5322a63c2adf1de7a248ba3a9a0c3903.zip | |
Diffstat (limited to 'src/sql/accessLogPurgeOld.sql')
| -rw-r--r-- | src/sql/accessLogPurgeOld.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/src/sql/accessLogPurgeOld.sql b/src/sql/accessLogPurgeOld.sql new file mode 100644 index 0000000..8379018 --- /dev/null +++ b/src/sql/accessLogPurgeOld.sql @@ -0,0 +1,11 @@ +WITH scope AS ( + SELECT id + FROM access_log + ORDER BY id + LIMIT ? +), scoperange AS ( + SELECT min(id) minid, max(id) maxid + FROM scope) +DELETE FROM access_log USING scoperange +WHERE request_time < CURRENT_DATE - ?::interval + AND access_log.id BETWEEN scoperange.minid AND scoperange.maxid |