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

Commit34003dc

Browse files
committed
feat: create new sql query and generate code
1 parente97c9db commit34003dc

File tree

11 files changed

+298
-0
lines changed

11 files changed

+298
-0
lines changed

‎coderd/apidoc/docs.go‎

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

‎coderd/apidoc/swagger.json‎

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

‎coderd/database/dbauthz/dbauthz.go‎

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -3581,6 +3581,10 @@ func (q *querier) OrganizationMembers(ctx context.Context, arg database.Organiza
35813581
returnfetchWithPostFilter(q.auth,policy.ActionRead,q.db.OrganizationMembers)(ctx,arg)
35823582
}
35833583

3584+
func (q*querier)PaginatedOrganizationMembers(ctx context.Context,arg database.PaginatedOrganizationMembersParams) ([]database.PaginatedOrganizationMembersRow,error) {
3585+
panic("not implemented")
3586+
}
3587+
35843588
func (q*querier)ReduceWorkspaceAgentShareLevelToAuthenticatedByTemplate(ctx context.Context,templateID uuid.UUID)error {
35853589
template,err:=q.db.GetTemplateByID(ctx,templateID)
35863590
iferr!=nil {

‎coderd/database/dbmem/dbmem.go‎

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -9584,6 +9584,15 @@ func (q *FakeQuerier) OrganizationMembers(_ context.Context, arg database.Organi
95849584
returntmp,nil
95859585
}
95869586

9587+
func (q*FakeQuerier)PaginatedOrganizationMembers(ctx context.Context,arg database.PaginatedOrganizationMembersParams) ([]database.PaginatedOrganizationMembersRow,error) {
9588+
err:=validateDatabaseType(arg)
9589+
iferr!=nil {
9590+
returnnil,err
9591+
}
9592+
9593+
panic("not implemented")
9594+
}
9595+
95879596
func (q*FakeQuerier)ReduceWorkspaceAgentShareLevelToAuthenticatedByTemplate(_ context.Context,templateID uuid.UUID)error {
95889597
err:=validateDatabaseType(templateID)
95899598
iferr!=nil {

‎coderd/database/dbmetrics/querymetrics.go‎

Lines changed: 7 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: 15 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: 1 addition & 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: 75 additions & 0 deletions
Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

‎coderd/database/queries/organizationmembers.sql‎

Lines changed: 23 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -66,3 +66,26 @@ WHERE
6666
user_id= @user_id
6767
AND organization_id= @org_id
6868
RETURNING*;
69+
70+
-- name: PaginatedOrganizationMembers :many
71+
SELECT
72+
sqlc.embed(organization_members),
73+
users.username,users.avatar_url,users.name,users.email,users.rbac_rolesas"global_roles",
74+
COUNT(*) OVER()AS count
75+
FROM
76+
organization_members
77+
INNER JOIN
78+
usersONorganization_members.user_id=users.idANDusers.deleted= false
79+
WHERE
80+
-- Filter by organization id
81+
CASE
82+
WHEN @organization_id :: uuid!='00000000-0000-0000-0000-000000000000'::uuid THEN
83+
organization_id= @organization_id
84+
ELSE true
85+
END
86+
ORDER BY
87+
-- Deterministic and consistent ordering of all users. This is to ensure consistent pagination.
88+
LOWER(username)ASC OFFSET @offset_opt
89+
LIMIT
90+
-- A null limit means "no limit", so 0 means return all
91+
NULLIF(@limit_opt ::int,0);

‎docs/reference/api/members.md‎

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

0 commit comments

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