From 30a9d45f5322a63c2adf1de7a248ba3a9a0c3903 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Sat, 20 Dec 2025 15:16:25 +0000 Subject: Add job for puring old access log entries from the database --- src/sql.cpp | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'src/sql.cpp') diff --git a/src/sql.cpp b/src/sql.cpp index 9c0d992..da95f18 100644 --- a/src/sql.cpp +++ b/src/sql.cpp @@ -8,6 +8,9 @@ namespace WebStat::SQL { const std::string ACCESS_LOG_INSERT { #embed "sql/accessLogInsert.sql" + }; + const std::string ACCESS_LOG_PURGE_OLD { +#embed "sql/accessLogPurgeOld.sql" }; const std::string ENTITY_INSERT { #embed "sql/entityInsert.sql" @@ -21,6 +24,7 @@ namespace WebStat::SQL { #define HASH_OPTS(VAR) \ const DB::CommandOptionsPtr VAR##_OPTS = std::make_shared(std::hash {}(VAR)) HASH_OPTS(ACCESS_LOG_INSERT); + HASH_OPTS(ACCESS_LOG_PURGE_OLD); HASH_OPTS(ENTITY_INSERT); HASH_OPTS(ENTITY_UPDATE_DETAIL); HASH_OPTS(HOST_UPSERT); -- cgit v1.2.3