diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2026-07-04 20:19:34 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2026-07-04 20:19:34 +0100 |
| commit | 870aa90c005f77a73445f5c39f9fd9bbb7604fe8 (patch) | |
| tree | 21597011d909436aeb94da228dee07da0309cc15 /src/sql | |
| parent | 61e106fe6a15f76b73125682e91d5c17ee875be2 (diff) | |
| download | webstat-870aa90c005f77a73445f5c39f9fd9bbb7604fe8.tar.bz2 webstat-870aa90c005f77a73445f5c39f9fd9bbb7604fe8.tar.xz webstat-870aa90c005f77a73445f5c39f9fd9bbb7604fe8.zip | |
Insert uninsirtable lines using the hostnameId recorded in the bad_lines table
Includes the same fix from the previous commit which stops caching
entities until the inserts are complete.
Updates storeLogLine to take an insert command with the hostnameId
already bound.
Diffstat (limited to 'src/sql')
| -rw-r--r-- | src/sql/selectUninsertableLines.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/sql/selectUninsertableLines.sql b/src/sql/selectUninsertableLines.sql index 060e800..2a57683 100644 --- a/src/sql/selectUninsertableLines.sql +++ b/src/sql/selectUninsertableLines.sql @@ -1,6 +1,7 @@ SELECT id, - value + value, + cast(detail ->> 'hostnameId' AS int) AS hostnameId FROM entities WHERE |