Files
dissoupovandGitHub 0b6087424e Impove Cursor pagination (#19)
* Impove Cursor pagination

* Upgrade deps
2026-10-24 12:21:21 -05:00

129 lines
3.9 KiB
Go

package query_test
import (
"testing"
"github.com/effective-security/trustyca/api/pb"
"github.com/effective-security/trustyca/internal/db/pgsql/query"
"github.com/effective-security/trustyca/internal/db/schema"
)
func Test_MemberQueries(t *testing.T) {
t.Parallel()
check(t, []tcase{
{
query.ListMemberships, []any{&query.ListMembershipsRequest{UserID: 1, OrgStatus: pb.ItemStatus_Active}},
`SELECT ` + schema.MembershipInfoTableInfo.AllColumns() + `
FROM trustyca.vw_membership_info
WHERE user_id = $1 AND org_status = $2
ORDER BY email ASC, id ASC
LIMIT $3
OFFSET $4`,
},
{
query.ListMemberships, []any{&query.ListMembershipsRequest{OrgID: 1, OrgStatus: pb.ItemStatus_Active}},
`SELECT ` + schema.MembershipInfoTableInfo.AllColumns() + `
FROM trustyca.vw_membership_info
WHERE org_id = $1 AND org_status = $2
ORDER BY email ASC, id ASC
LIMIT $3
OFFSET $4`,
},
{
// Org scope only
query.ListMemberships, []any{&query.ListMembershipsRequest{OrgID: 1, Scope: pb.Scope_Org}},
`SELECT ` + schema.MembershipInfoTableInfo.AllColumns() + `
FROM trustyca.vw_membership_info
WHERE org_id = $1 AND project_id IS NULL
ORDER BY email ASC, id ASC
LIMIT $2
OFFSET $3`,
},
{
// Project scope of a project
query.ListMemberships, []any{&query.ListMembershipsRequest{OrgID: 1, ProjectID: 3}},
`SELECT ` + schema.MembershipInfoTableInfo.AllColumns() + `
FROM trustyca.vw_membership_info
WHERE org_id = $1 AND project_id = $2
ORDER BY email ASC, id ASC
LIMIT $3
OFFSET $4`,
},
{
// any Project scope
query.ListMemberships, []any{&query.ListMembershipsRequest{OrgID: 1, Scope: pb.Scope_Project}},
`SELECT ` + schema.MembershipInfoTableInfo.AllColumns() + `
FROM trustyca.vw_membership_info
WHERE org_id = $1 AND project_id IS NOT NULL
ORDER BY email ASC, id ASC
LIMIT $2
OFFSET $3`,
},
{
query.UpdateMemberRole, []any{&query.UpdateMemberRoleRequest{OrgID: 1, UserID: 2, Role: pb.Role_Admin}},
`UPDATE trustyca.membership
SET role=$1
WHERE org_id = $2 AND user_id = $3 AND project_id IS NULL
RETURNING ` + schema.MembershipTableInfo.AllColumns(),
},
{
query.UpdateMemberRole, []any{&query.UpdateMemberRoleRequest{OrgID: 1, ProjectID: 3, UserID: 2, Role: pb.Role_Admin}},
`UPDATE trustyca.membership
SET role=$1
WHERE org_id = $2 AND user_id = $3 AND project_id = $4
RETURNING ` + schema.MembershipTableInfo.AllColumns(),
},
{
query.AddMember, nil,
`INSERT INTO trustyca.membership
( id, org_id, project_id, user_id, role, created_at
) VALUES ( $1, $2, $3, $4, $5, Now()
)
ON CONFLICT ON CONSTRAINT unique_membership_org_project_user DO UPDATE SET
role = EXCLUDED.role
RETURNING ` + schema.MembershipTableInfo.AllColumns(),
},
{
query.GetRowByID, []any{&schema.MembershipInfoTableInfo},
`SELECT ` + schema.MembershipInfoTableInfo.AllColumns() + `
FROM trustyca.vw_membership_info
WHERE id = $1`,
},
{
query.GetRowByColumn, []any{&schema.MembershipInfoTableInfo, "user_id"},
`SELECT ` + schema.MembershipInfoTableInfo.AllColumns() + `
FROM trustyca.vw_membership_info
WHERE user_id = $1`,
},
{
// all scopes
query.DeleteMember, []any{&query.DeleteMemberRequest{OrgID: 1, UserID: 2}},
`DELETE FROM trustyca.membership
WHERE org_id = $1 AND user_id = $2`,
},
{
// Org scope only
query.DeleteMember, []any{&query.DeleteMemberRequest{OrgID: 1, UserID: 2, Scope: pb.Scope_Org}},
`DELETE FROM trustyca.membership
WHERE org_id = $1 AND user_id = $2 AND project_id IS NULL`,
},
{
// Project scope of a project
query.DeleteMember, []any{&query.DeleteMemberRequest{OrgID: 1, ProjectID: 3, UserID: 2}},
`DELETE FROM trustyca.membership
WHERE org_id = $1 AND user_id = $2 AND project_id = $3`,
},
{
query.DeleteMember, []any{&query.DeleteMemberRequest{OrgID: 1}},
`DELETE FROM trustyca.membership
WHERE org_id = $1`,
},
{
query.DeleteMember, []any{&query.DeleteMemberRequest{UserID: 2}},
`DELETE FROM trustyca.membership
WHERE user_id = $1`,
},
})
}