--mapping "/media/david/SSD4/Manu o Kahurangi kiwi survey (10)/NEW - MOK kiwi survey 20260306/tx51/mapping_2026-03-15.json"
DELETE FROM cluster
WHERE dataset_id = 'la-JpAf2nLKG'
AND location_id IN (
SELECT l.id FROM location l WHERE l.dataset_id = 'QZ0tlUrX4Nyi'
)
AND id NOT IN (SELECT cluster_id FROM file);
SELECT c.id, c.name as cluster_name, l.name as
location_name, l.dataset_id as location_dataset_id, (SELECT COUNT(*)
FROM file f WHERE f.cluster_id = c.id) as file_count FROM cluster c
JOIN location l ON c.location_id = l.id WHERE c.dataset_id =
'la-JpAf2nLKG' AND l.dataset_id != 'la-JpAf2nLKG';
D UPDATE file_dataset SET dataset_id = 'QZ0tlUrX4Nyi' WHERE file_id IN (SELECT id FROM file WHERE
cluster_id = 'wnrpJmhumf6n') AND dataset_id = 'la-JpAf2nLKG';
D UPDATE cluster SET dataset_id = 'QZ0tlUrX4Nyi' WHERE id = 'wnrpJmhumf6n';
Constraint Error:
Violates foreign key constraint because key "cluster_id: wnrpJmhumf6n" is still referenced by a foreign key in a different table. If this is an unexpected constraint violation, please refer to our foreign key limitations in the documentation