summaryrefslogtreecommitdiff
path: root/src/sql.hpp
Commit message (Collapse)AuthorAge
* Include extra details when storing unparsable and uninsertable lines.Dan Goodliffe8 days
| | | | | | | | Now includes the hostnameId, timestamp and optionally error message. Updates idx_entities_retryinsert to account for details not being NULL. Also fixes the issue where the entities inserted and rollback would still be recorded in the entity cache if the access log insert failed. This would have lead to PK violations later on.
* Add job to retry insertion of log lines which had previously failedDan Goodliffe2026-05-18
| | | | | | Entities are reparsed and reinserted, removed on success. Failure to parse updates the entity type to UnparsableLine. Failure to insert again updates the detail with the reason.
* Add job for puring old access log entries from the databaseDan Goodliffe2025-12-20
|
* Create and perform UA lookup curl op when new user agent is encounteredDan Goodliffe2025-09-13
|
* Store utsname details in the host's detail fieldDan Goodliffe2025-09-02
|
* Store log lines in full using entity idsDan Goodliffe2025-08-25
|
* Add helpers and SQL for storing an entityDan Goodliffe2025-08-25