Commitf53b85b

committed

feat: add shared_with_group_id param to sql query

1 parent3789a52 commitf53b85bCopy full SHA for f53b85b

File tree

+20

-5

lines changed

+20

-5

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -277,6 +277,7 @@ func (q *sqlQuerier) GetAuthorizedWorkspaces(ctx context.Context, arg GetWorkspa`
`277`	`277`	`arg.HasExternalAgent,`
`278`	`278`	`arg.Shared,`
`279`	`279`	`arg.SharedWithUserID,`
	`280`	`+arg.SharedWithGroupID,`
`280`	`281`	`arg.RequesterID,`
`281`	`282`	`arg.Offset,`
`282`	`283`	`arg.Limit,`

Lines changed: 13 additions & 5 deletions

Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -390,6 +390,12 @@ WHERE`
`390`	`390`	`workspaces.user_acl ? (@shared_with_user_id :: uuid) ::text`
`391`	`391`	`ELSE true`
`392`	`392`	`END`
	`393`	`+-- Filter by shared_with_group_id`
	`394`	`+AND CASE`
	`395`	`+WHEN @shared_with_group_id :: uuid!='00000000-0000-0000-0000-000000000000'::uuid THEN`
	`396`	`+workspaces.group_acl ? (@shared_with_group_id :: uuid) ::text`
	`397`	`+ELSE true`
	`398`	`+END`
`393`	`399`	`-- Authorize Filter clause will be injected below in GetAuthorizedWorkspaces`
`394`	`400`	`-- @authorize_filter`
`395`	`401`	`), filtered_workspaces_orderAS (`

Comments

(0)