Mihai Doarna
9d9dca3208
* implement team creation for legacy store * add generated code * add basic integration test * add new fields to get and list teams * fix sql tests for teams * register dual writer for team resource * add generated code * add more sql tests for team creation * address feedback * add integration tests
12 lines
368 B
SQL
12 lines
368 B
SQL
SELECT id, uid, name, email, external_uid, is_provisioned, created, updated
|
|
FROM {{ .Ident .TeamTable }}
|
|
WHERE org_id = {{ .Arg .Query.OrgID }}
|
|
{{ if .Query.UID }}
|
|
AND uid = {{ .Arg .Query.UID }}
|
|
{{ end }}
|
|
{{ if .Query.Pagination.Continue }}
|
|
AND id >= {{ .Arg .Query.Pagination.Continue }}
|
|
{{ end }}
|
|
ORDER BY id asc
|
|
LIMIT {{ .Arg .Query.Pagination.Limit }}
|