feat: add backend support for workspace_apps

blink-so[bot] · blink-so[bot] · commit 7b9597b47785 · 2025-07-19T19:34:50.000Z
- Add database migration for workspace_apps column
- Update SQL queries to include workspace_apps
- Update provisioner server to pass workspace_apps from terraform
- Still needs: database code regeneration and API updates
diff --git a/coderd/database/migrations/000350_workspace_apps.down.sql b/coderd/database/migrations/000350_workspace_apps.down.sql
@@ -0,0 +1,2 @@
+-- Remove workspace_apps column from workspace_agents table
+ALTER TABLE workspace_agents DROP COLUMN workspace_apps;
diff --git a/coderd/database/migrations/000350_workspace_apps.up.sql b/coderd/database/migrations/000350_workspace_apps.up.sql
@@ -0,0 +1,4 @@
+-- Add workspace_apps column to workspace_agents table
+ALTER TABLE workspace_agents ADD COLUMN workspace_apps text[] DEFAULT NULL;
+
+COMMENT ON COLUMN workspace_agents.workspace_apps IS 'List of app IDs to display in the workspace table, configured via terraform';
diff --git a/coderd/database/queries/workspaceagents.sql b/coderd/database/queries/workspaceagents.sql
@@ -58,11 +58,12 @@ INSERT INTO
 		troubleshooting_url,
 		motd_file,
 		display_apps,
+		workspace_apps,
 		display_order,
 		api_key_scope
 	)
 VALUES
-	($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20) RETURNING *;
+	($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21) RETURNING *;
 
 -- name: UpdateWorkspaceAgentConnectionByID :exec
 UPDATE
diff --git a/coderd/provisionerdserver/provisionerdserver.go b/coderd/provisionerdserver/provisionerdserver.go
@@ -2428,6 +2428,7 @@ func InsertWorkspaceResource(ctx context.Context, db database.Store, jobID uuid.
 			TroubleshootingURL:       prAgent.GetTroubleshootingUrl(),
 			MOTDFile:                 prAgent.GetMotdFile(),
 			DisplayApps:              convertDisplayApps(prAgent.GetDisplayApps()),
+			WorkspaceApps:            prAgent.GetWorkspaceApps(),
 			InstanceMetadata:         pqtype.NullRawMessage{},
 			ResourceMetadata:         pqtype.NullRawMessage{},
 			// #nosec G115 - Order represents a display order value that's always small and fits in int32
diff --git a/site/src/pages/WorkspacesPage/WorkspacesTable.tsx b/site/src/pages/WorkspacesPage/WorkspacesTable.tsx
@@ -718,10 +718,12 @@ const WorkspaceApps: FC<WorkspaceAppsProps> = ({ workspace }) => {
 		return null;
 	}
 
-	// If workspace_apps is configured, use that list instead of display_apps
+	// Check if workspace_apps is configured via terraform
+	// Note: This field is only available if the template uses the workspace_apps configuration
 	const configuredApps = (agent as any).workspace_apps as string[] | undefined;
 	const buttons: ReactNode[] = [];
 
+	// Use configured apps if available, otherwise fall back to default behavior
 	if (configuredApps && configuredApps.length > 0) {
 		// Use the configured apps list
 		for (const appId of configuredApps.slice(0, WORKSPACE_APPS_SLOTS)) {

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+-- Remove workspace_apps column from workspace_agents table`
	`2`	`+ALTER TABLE workspace_agents DROP COLUMN workspace_apps;`