fix: actually fix template version created by migration (#4850)

coadler · web-flow · commit e26bc2072341 · 2022-11-01T22:19:58.000Z
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,18 @@
 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)
+        -- If you have no users I'm not sure what else to tell you.
+    )
+WHERE
+    created_by IS NULL;
+
 ALTER TABLE template_versions ALTER COLUMN created_by SET NOT NULL;
 
 COMMIT;
