move column to workspace_agents table

coder · sreya · May 18, 2023 · May 17, 2023 · May 17, 2023 · May 17, 2023
commit 9ca40fcf8dea696e5e89a08538cc81f5f95066ce
diff --git a/agent/agent.go b/agent/agent.go
@@ -491,6 +491,7 @@ func (a *agent) run(ctx context.Context) error {
 	err = a.client.PostStartup(ctx, agentsdk.PostStartupRequest{
 		Version:           buildinfo.Version(),
 		ExpandedDirectory: manifest.Directory,
+		Subsystem:         a.subsystem,
 	})
 	if err != nil {
 		return xerrors.Errorf("update workspace agent version: %w", err)
@@ -1180,7 +1181,6 @@ func (a *agent) startReportingConnectionStats(ctx context.Context) {
 		stats := &agentsdk.Stats{
 			ConnectionCount:    int64(len(networkStats)),
 			ConnectionsByProto: map[string]int64{},
-			Subsystem:          a.subsystem,
 		}
 		for conn, counts := range networkStats {
 			stats.ConnectionsByProto[conn.Proto.String()]++

diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000123_workspace_agent_subsystem.up.sql b/coderd/database/migrations/000123_workspace_agent_subsystem.up.sql
@@ -1,4 +1,4 @@
 BEGIN;
 CREATE TYPE workspace_agent_subsystem AS ENUM ('envbuilder', 'envbox', 'none');
-ALTER TABLE workspace_agent_stats ADD COLUMN subsystem workspace_agent_subsystem NOT NULL default 'none';
+ALTER TABLE workspace_agents ADD COLUMN subsystem workspace_agent_subsystem NOT NULL default 'none';
 COMMIT;
diff --git a/coderd/database/models.go b/coderd/database/models.go