Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit25d7864

Browse files
committed
introduce dedicated queries for workspaces and workspace agents metrics
Signed-off-by: Callum Styan <callumstyan@gmail.com>
1 parent41de4ad commit25d7864

File tree

8 files changed

+348
-10
lines changed

8 files changed

+348
-10
lines changed

‎coderd/database/dbauthz/dbauthz.go‎

Lines changed: 21 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -3545,6 +3545,13 @@ func (q *querier) GetWorkspaceAgentsByWorkspaceAndBuildNumber(ctx context.Contex
35453545
returnq.db.GetWorkspaceAgentsByWorkspaceAndBuildNumber(ctx,arg)
35463546
}
35473547

3548+
func (q*querier)GetWorkspaceAgentsByWorkspaceIDAndBuildNumber(ctx context.Context,arg database.GetWorkspaceAgentsByWorkspaceIDAndBuildNumberParams) ([]database.WorkspaceAgent,error) {
3549+
iferr:=q.authorizeContext(ctx,policy.ActionRead,rbac.ResourceSystem);err!=nil {
3550+
returnnil,err
3551+
}
3552+
returnq.db.GetWorkspaceAgentsByWorkspaceIDAndBuildNumber(ctx,arg)
3553+
}
3554+
35483555
func (q*querier)GetWorkspaceAgentsCreatedAfter(ctx context.Context,createdAt time.Time) ([]database.WorkspaceAgent,error) {
35493556
iferr:=q.authorizeContext(ctx,policy.ActionRead,rbac.ResourceSystem);err!=nil {
35503557
returnnil,err
@@ -3885,6 +3892,20 @@ func (q *querier) InsertAIBridgeUserPrompt(ctx context.Context, arg database.Ins
38853892
returnq.db.InsertAIBridgeUserPrompt(ctx,arg)
38863893
}
38873894

3895+
func (q*querier)GetWorkspacesForAgentMetrics(ctx context.Context,deletedbool) ([]database.GetWorkspacesForAgentMetricsRow,error) {
3896+
iferr:=q.authorizeContext(ctx,policy.ActionRead,rbac.ResourceSystem);err!=nil {
3897+
returnnil,err
3898+
}
3899+
returnq.db.GetWorkspacesForAgentMetrics(ctx,deleted)
3900+
}
3901+
3902+
func (q*querier)GetWorkspacesForWorkspaceMetrics(ctx context.Context,deletedbool) ([]database.GetWorkspacesForWorkspaceMetricsRow,error) {
3903+
iferr:=q.authorizeContext(ctx,policy.ActionRead,rbac.ResourceSystem);err!=nil {
3904+
returnnil,err
3905+
}
3906+
returnq.db.GetWorkspacesForWorkspaceMetrics(ctx,deleted)
3907+
}
3908+
38883909
func (q*querier)InsertAPIKey(ctx context.Context,arg database.InsertAPIKeyParams) (database.APIKey,error) {
38893910
// TODO(Cian): ideally this would be encoded in the policy, but system users are just members and we
38903911
// don't currently have a capability to conditionally deny creating resources by owner ID in a role.

‎coderd/database/dbmetrics/querymetrics.go‎

Lines changed: 21 additions & 0 deletions
Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

‎coderd/database/dbmock/dbmock.go‎

Lines changed: 45 additions & 0 deletions
Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

‎coderd/database/querier.go‎

Lines changed: 3 additions & 0 deletions
Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

‎coderd/database/queries.sql.go‎

Lines changed: 196 additions & 0 deletions
Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

‎coderd/database/queries/workspaceagents.sql‎

Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -365,3 +365,17 @@ WHERE
365365
id= $1
366366
AND parent_idIS NOT NULL
367367
AND deleted= FALSE;
368+
369+
-- name: GetWorkspaceAgentsByWorkspaceIDAndBuildNumber :many
370+
SELECT
371+
workspace_agents.*
372+
FROM
373+
workspace_agents
374+
JOIN
375+
workspace_resourcesONworkspace_agents.resource_id=workspace_resources.id
376+
JOIN
377+
workspace_buildsONworkspace_resources.job_id=workspace_builds.job_id
378+
WHERE
379+
workspace_builds.workspace_id= @workspace_id :: uuid
380+
ANDworkspace_builds.build_number= @build_number ::integer
381+
ANDworkspace_agents.deleted= FALSE;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp