Commit22db0d2

authored

migrate existing templates (#4353)

1 parent9bfa415 commit22db0d2Copy full SHA for 22db0d2

File tree

+30

-4

lines changed

+30

-4

lines changed

Lines changed: 26 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -19,4 +19,30 @@ CREATE TABLE group_members (`
`19`	`19`	`UNIQUE(user_id, group_id)`
`20`	`20`	`);`
`21`	`21`
	`22`	`+-- Insert a group for every organization (which should just be 1).`
	`23`	`+INSERT INTO groups (`
	`24`	`+id,`
	`25`	`+name,`
	`26`	`+organization_id`
	`27`	`+)SELECT`
	`28`	`+id,'Everyone'as name, id`
	`29`	`+FROM`
	`30`	`+organizations;`
	`31`	`+`
	`32`	`+-- Insert allUsers groups into every existing template to avoid breaking`
	`33`	`+-- existing deployments.`
	`34`	`+UPDATE`
	`35`	`+templates`
	`36`	`+SET`
	`37`	`+group_acl= (`
	`38`	`+SELECT`
	`39`	`+json_build_object(`
	`40`	`+organizations.id, array_to_json('{"read"}'::text[])`
	`41`	`+)`
	`42`	`+FROM`
	`43`	`+organizations`
	`44`	`+WHERE`
	`45`	`+templates.organization_id=organizations.id`
	`46`	`+);`
	`47`	`+`
`22`	`48`	`COMMIT;`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@ import (`
`7`	`7`	`"github.com/coder/coder/coderd/rbac"`
`8`	`8`	`)`
`9`	`9`
`10`		`-constAllUsersGroup="allUsers"`
	`10`	`+constAllUsersGroup="Everyone"`
`11`	`11`
`12`	`12`	`// TemplateACL is a map of user_ids to permissions.`
`13`	`13`	`typeTemplateACLmap[string][]rbac.Action`

Lines changed: 1 addition & 1 deletion

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

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -89,7 +89,7 @@ INSERT INTO groups (`
`89`	`89`	`organization_id`
`90`	`90`	`)`
`91`	`91`	`VALUES`
`92`		`-(sqlc.arg(organization_id),'allUsers',sqlc.arg(organization_id)) RETURNING*;`
	`92`	`+(sqlc.arg(organization_id),'Everyone',sqlc.arg(organization_id)) RETURNING*;`
`93`	`93`
`94`	`94`	`-- name: UpdateGroupByID :one`
`95`	`95`	`UPDATE`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -195,7 +195,7 @@ func TestAuthorizeDomain(t *testing.T) {`
`195`	`195`	`t.Parallel()`
`196`	`196`	`defOrg:=uuid.New()`
`197`	`197`	`unuseID:=uuid.New()`
`198`		`-allUsersGroup:="allUsers"`
	`198`	`+allUsersGroup:="Everyone"`
`199`	`199`
`200`	`200`	`user:=subject{`
`201`	`201`	`UserID:"me",`

Comments

(0)