Commitefec4e6

committed

feat: add shared_with_user_id param to sql query

1 parent4d8dc22 commitefec4e6Copy full SHA for efec4e6

File tree

+20

-7

lines changed

+20

-7

lines changed

Lines changed: 1 addition & 0 deletions

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

Lines changed: 13 additions & 6 deletions

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

Lines changed: 6 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -384,7 +384,12 @@ WHERE`
`384`	`384`	`(workspaces.user_acl!='{}'::jsonbORworkspaces.group_acl!='{}'::jsonb)=sqlc.narg('shared') ::boolean`
`385`	`385`	`ELSE true`
`386`	`386`	`END`
`387`		`-`
	`387`	`+-- Filter by shared_with_user_id`
	`388`	`+AND CASE`
	`389`	`+WHEN @shared_with_user_id :: uuid!='00000000-0000-0000-0000-000000000000'::uuid THEN`
	`390`	`+workspaces.user_acl ? (@shared_with_user_id :: uuid) ::text`
	`391`	`+ELSE true`
	`392`	`+END`
`388`	`393`	`-- Authorize Filter clause will be injected below in GetAuthorizedWorkspaces`
`389`	`394`	`-- @authorize_filter`
`390`	`395`	`), filtered_workspaces_orderAS (`

Comments

(0)