Commit2542dcd

committed

add comment

1 parent8b1bc7f commit2542dcdCopy full SHA for 2542dcd

File tree

+32

-22

lines changed

+32

-22

lines changed

Lines changed: 4 additions & 0 deletions

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

Lines changed: 14 additions & 11 deletions

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

Lines changed: 14 additions & 11 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,8 @@`
`1`	`1`	`-- name: OrganizationMembers :many`
	`2`	`+-- Arguments are optional with uuid.Nil to ignore.`
	`3`	`+-- - Use just 'organization_id' to get all members of an org`
	`4`	`+-- - Use just 'user_id' to get all orgs a user is a member of`
	`5`	`+-- - Use both to get a specific org member row`
`2`	`6`	`SELECT`
`3`	`7`	`sqlc.embed(organization_members),`
`4`	`8`	`users.username`
`@@ -7,18 +11,17 @@ FROM`
`7`	`11`	`INNER JOIN`
`8`	`12`	`usersONorganization_members.user_id=users.id`
`9`	`13`	`WHERE`
`10`		`-true`
`11`		`--- Filter by organization id`
`12`		`-AND CASE`
`13`		`- WHEN @organization_id :: uuid!='00000000-0000-0000-0000-000000000000'::uuid THEN`
`14`		`- organization_id= @organization_id`
`15`		`- ELSE true`
	`14`	`+-- Filter by organization id`
	`15`	`+CASE`
	`16`	`+WHEN @organization_id :: uuid!='00000000-0000-0000-0000-000000000000'::uuid THEN`
	`17`	`+organization_id= @organization_id`
	`18`	`+ELSE true`
`16`	`19`	`END`
`17`		`--- Filter by user id`
`18`		`-AND CASE`
`19`		`-WHEN @user_id :: uuid!='00000000-0000-0000-0000-000000000000'::uuid THEN`
`20`		`-user_id= @user_id`
`21`		`-ELSE true`
	`20`	`+-- Filter by user id`
	`21`	`+AND CASE`
	`22`	`+WHEN @user_id :: uuid!='00000000-0000-0000-0000-000000000000'::uuid THEN`
	`23`	`+user_id= @user_id`
	`24`	`+ELSE true`
`22`	`25`	`END;`
`23`	`26`
`24`	`27`	`-- name: InsertOrganizationMember :one`

Comments

(0)