fix: actually fix template version created by migration

coder · coadler · Nov 1, 2022 · Nov 1, 2022 · Nov 1, 2022 · Nov 1, 2022
commit 8f569dfc7057b25dedb2edd9ef170eac2540b5ec
diff --git a/coderd/database/migrations/000068_update_template_version_created_by.up.sql b/coderd/database/migrations/000068_update_template_version_created_by.up.sql
@@ -1,6 +1,17 @@
 BEGIN;
 
-UPDATE template_versions SET created_by = '00000000-0000-0000-0000-000000000000'::uuid WHERE created_by IS NULL;
+UPDATE
+    template_versions
+SET
+    created_by = COALESCE(
+        -- Best effort to convert all unowned template versions to the first owner.
+        (SELECT id FROM users WHERE rbac_roles @> '{owner}' AND deleted = 'f' ORDER BY created_at ASC LIMIT 1),
+        -- If there are no owners, assign to the first user.
+        (SELECT id FROM users WHERE deleted = 'f' ORDER BY created_at ASC LIMIT 1)
+    )
+WHERE
+    created_by IS NULL;
+
 ALTER TABLE template_versions ALTER COLUMN created_by SET NOT NULL;
 
 COMMIT;