Fix SQL query

kylecarbs · kylecarbs · commit 7cf6f0cd8936 · 2023-09-07T20:07:12.000Z
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/workspaceagents.sql b/coderd/database/queries/workspaceagents.sql
@@ -151,7 +151,7 @@ WITH new_length AS (
 	logs_length = logs_length + @output_length WHERE workspace_agents.id = @agent_id
 )
 INSERT INTO
-		workspace_agent_logs (agent_id, created_at, output, level, source)
+		workspace_agent_logs (agent_id, created_at, output, level, log_source_id)
 	SELECT
 		@agent_id :: uuid AS agent_id,
 		unnest(@created_at :: timestamptz [ ]) AS created_at,
diff --git a/coderd/workspaceagents.go b/coderd/workspaceagents.go
@@ -1379,6 +1379,7 @@ func convertWorkspaceAgent(derpMap *tailcfg.DERPMap, coordinator tailnet.Coordin
 		Scripts:                  scripts,
 		LogsLength:               dbAgent.LogsLength,
 		LogsOverflowed:           dbAgent.LogsOverflowed,
+		LogSources:               logSources,
 		Version:                  dbAgent.Version,
 		EnvironmentVariables:     envs,
 		Directory:                dbAgent.Directory,

Original file line number	Diff line number	Diff line change
`@@ -151,7 +151,7 @@ WITH new_length AS (`
`151`	`151`	`logs_length = logs_length + @output_length WHERE workspace_agents.id = @agent_id`
`152`	`152`	`)`
`153`	`153`	`INSERT INTO`
`154`		`- workspace_agent_logs (agent_id, created_at, output, level, source)`
	`154`	`+ workspace_agent_logs (agent_id, created_at, output, level, log_source_id)`
`155`	`155`	`SELECT`
`156`	`156`	`@agent_id :: uuid AS agent_id,`
`157`	`157`	`unnest(@created_at :: timestamptz [ ]) AS created_at,`