-- © Copyright 2026 The Kahawai Collective
-- SPDX-License-Identifier: MIT
INSERT INTO grooming_rules
VALUES ('LADAM', 'edw', 'landings', 'Flag', 'Landings where the landing date is missing');
CREATE OR REPLACE FUNCTION LADAM() RETURNS VOID AS $$
INSERT INTO groomed.checks(code, "table", "column", id)
SELECT 'LADAM', 'landings', 'landing_datetime', id
FROM groomed.landings
WHERE landing_datetime IS NULL;
UPDATE groomed.landings
SET checks=array_append(checks, 'LADAM')
WHERE landing_datetime IS NULL
AND id IN (SELECT id FROM groomed.checks WHERE code = 'LADAM');
$$ LANGUAGE SQL;
SELECT LADAM();