fix: backfill from workspace_agent_log_sources

DanielleMaywood · DanielleMaywood · commit 7858799f7204 · 2024-09-20T12:32:38.000Z
diff --git a/coderd/database/migrations/000256_add_display_name_to_workspace_agent_scripts.up.sql b/coderd/database/migrations/000256_add_display_name_to_workspace_agent_scripts.up.sql
@@ -1 +1,8 @@
-ALTER TABLE workspace_agent_scripts ADD COLUMN display_name text NOT NULL DEFAULT '';
+ALTER TABLE workspace_agent_scripts ADD COLUMN display_name text;
+
+UPDATE workspace_agent_scripts
+	SET display_name = workspace_agent_log_sources.display_name
+FROM workspace_agent_log_sources
+	WHERE workspace_agent_scripts.log_source_id = workspace_agent_log_sources.id;
+
+ALTER TABLE workspace_agent_scripts ALTER COLUMN display_name SET NOT NULL;
