Commitdc7fe77

committed

fixup null

1 parent8da3601 commitdc7fe77Copy full SHA for dc7fe77

File tree

-11

lines changed

-11

lines changed

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

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

Lines changed: 3 additions & 2 deletions

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

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -9,7 +9,8 @@ WHERE`
`9`	`9`	`-- To do this manually in SQL, you can construct an array and cast it:`
`10`	`10`	`-- cast(ARRAY[('customrole','ece79dac-926e-44ca-9790-2ff7c5eb6e0c')] AS name_organization_pair[])`
`11`	`11`	`AND CASE WHEN array_length(@lookup_roles :: name_organization_pair[],1)>0 THEN`
`12`		`-(name, organization_id)= ANY (@lookup_roles::name_organization_pair[])`
	`12`	`+-- Using 'coalesce' to avoid troubles with null literals being an empty string.`
	`13`	`+(name, coalesce(organization_id,'00000000-0000-0000-0000-000000000000' ::uuid))= ANY (@lookup_roles::name_organization_pair[])`
`13`	`14`	`ELSE true`
`14`	`15`	`END`
`15`	`16`	`-- This allows fetching all roles, or just site wide roles`

Lines changed: 2 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -160,17 +160,13 @@ func (*NameOrganizationPair) Scan(_ interface{}) error {`
`160`	`160`	`// shell.`
`161`	`161`	`//`
`162`	`162`	`//SELECT ('customrole'::text,'ece79dac-926e-44ca-9790-2ff7c5eb6e0c'::uuid);`
`163`		`-//To see 'null' option`
`164`		`-//SELECT ('customrole',null);`
	`163`	`+//To see 'null' option. Using the nil uuid as null to avoid empty string literals for null.`
	`164`	`+//SELECT ('customrole',00000000-0000-0000-0000-000000000000);`
`165`	`165`	`//`
`166`	`166`	`// This value is usually used as an array, NameOrganizationPair[]. You can see`
`167`	`167`	`// what that literal is as well, with proper quoting.`
`168`	`168`	`//`
`169`	`169`	`//SELECT ARRAY[('customrole'::text,'ece79dac-926e-44ca-9790-2ff7c5eb6e0c'::uuid)];`
`170`	`170`	`func (aNameOrganizationPair)Value() (driver.Value,error) {`
`171`		`-ifa.OrganizationID==uuid.Nil {`
`172`		-returnfmt.Sprintf(`('%s',)`,a.Name),nil
`173`		`-}`
`174`		`-`
`175`	`171`	returnfmt.Sprintf(`(%s,%s)`,a.Name,a.OrganizationID.String()),nil
`176`	`172`	`}`

Comments

(0)