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

Commite49e5db

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

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
@@ -3494,6 +3494,13 @@ func (q *querier) GetWorkspaceAgentsByWorkspaceAndBuildNumber(ctx context.Contex
34943494
returnq.db.GetWorkspaceAgentsByWorkspaceAndBuildNumber(ctx,arg)
34953495
}
34963496

3497+
func (q*querier)GetWorkspaceAgentsByWorkspaceIDAndBuildNumber(ctx context.Context,arg database.GetWorkspaceAgentsByWorkspaceIDAndBuildNumberParams) ([]database.WorkspaceAgent,error) {
3498+
iferr:=q.authorizeContext(ctx,policy.ActionRead,rbac.ResourceSystem);err!=nil {
3499+
returnnil,err
3500+
}
3501+
returnq.db.GetWorkspaceAgentsByWorkspaceIDAndBuildNumber(ctx,arg)
3502+
}
3503+
34973504
func (q*querier)GetWorkspaceAgentsCreatedAfter(ctx context.Context,createdAt time.Time) ([]database.WorkspaceAgent,error) {
34983505
iferr:=q.authorizeContext(ctx,policy.ActionRead,rbac.ResourceSystem);err!=nil {
34993506
returnnil,err
@@ -3834,6 +3841,20 @@ func (q *querier) InsertAIBridgeUserPrompt(ctx context.Context, arg database.Ins
38343841
returnq.db.InsertAIBridgeUserPrompt(ctx,arg)
38353842
}
38363843

3844+
func (q*querier)GetWorkspacesForAgentMetrics(ctx context.Context,deletedbool) ([]database.GetWorkspacesForAgentMetricsRow,error) {
3845+
iferr:=q.authorizeContext(ctx,policy.ActionRead,rbac.ResourceSystem);err!=nil {
3846+
returnnil,err
3847+
}
3848+
returnq.db.GetWorkspacesForAgentMetrics(ctx,deleted)
3849+
}
3850+
3851+
func (q*querier)GetWorkspacesForWorkspaceMetrics(ctx context.Context,deletedbool) ([]database.GetWorkspacesForWorkspaceMetricsRow,error) {
3852+
iferr:=q.authorizeContext(ctx,policy.ActionRead,rbac.ResourceSystem);err!=nil {
3853+
returnnil,err
3854+
}
3855+
returnq.db.GetWorkspacesForWorkspaceMetrics(ctx,deleted)
3856+
}
3857+
38373858
func (q*querier)InsertAPIKey(ctx context.Context,arg database.InsertAPIKeyParams) (database.APIKey,error) {
38383859
// TODO(Cian): ideally this would be encoded in the policy, but system users are just members and we
38393860
// 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