src/sql/selectUninsertableLines.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

SELECT
	id,
	value,
	cast(detail ->> 'hostnameId' AS int) AS hostnameId
FROM
	entities
WHERE
	type = 'uninsertable_line'
	AND detail ->> 'retriedAt' IS NULL
ORDER BY
	id
LIMIT ?
FOR UPDATE