coder/000273_workspace_updates.down.sql at fix/agent-freedom-setting-docs - coder - Ahri Cloud Code

synced/coder

mirror of https://github.com/coder/coder.git synced 2025-07-03 16:13:58 +00:00

Files

Ethan f941e78079 chore: add db query to retrieve workspaces & their agents (#14792 )

Second PR for #14716.

Adds a query that, given a user ID, returns all the workspaces they own, that can also be `ActionRead` by the requesting user.

```
type GetWorkspacesAndAgentsByOwnerIDRow struct {
	WorkspaceID      uuid.UUID            `db:"workspace_id" json:"workspace_id"`
	WorkspaceName    string               `db:"workspace_name" json:"workspace_name"`
	JobStatus        ProvisionerJobStatus `db:"job_status" json:"job_status"`
	Transition       WorkspaceTransition  `db:"transition" json:"transition"`
	Agents           []AgentIDNamePair    `db:"agents" json:"agents"`
}
```
 `JobStatus` and `Transition` are set using the latest build/job of the workspace. Deleted workspaces are not included.

2024-11-01 14:36:12 +11:00

2 lines

30 B

SQL

Raw Permalink Blame History

DROP TYPE agent_id_name_pair;