From 870aa90c005f77a73445f5c39f9fd9bbb7604fe8 Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
Date: Sat, 4 Jul 2026 20:19:34 +0100
Subject: 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.
---
 src/sql/selectUninsertableLines.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'src/sql/selectUninsertableLines.sql')

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
-- 
cgit v1.3

