mirror of
https://github.com/hanzoai/ca.git
synced 2026-11-03 18:08:27 +00:00
129 lines
3.9 KiB
Go
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`,
|
|
},
|
|
})
|
|
}
|