mirror of
https://github.com/hanzoai/ca.git
synced 2026-11-03 18:08:27 +00:00
135 lines
4.5 KiB
Go
135 lines
4.5 KiB
Go
package pgsql_test
|
|
|
|
import (
|
|
"fmt"
|
|
"testing"
|
|
|
|
"github.com/effective-security/trustyca/api/pb"
|
|
"github.com/effective-security/trustyca/internal/db/model"
|
|
"github.com/effective-security/trustyca/internal/db/pgsql/query"
|
|
"github.com/stretchr/testify/assert"
|
|
"github.com/stretchr/testify/require"
|
|
)
|
|
|
|
func Test_Org(t *testing.T) {
|
|
userID := provider.NextID()
|
|
login := &model.Login{
|
|
ID: userID,
|
|
ExternalID: userID.String(),
|
|
Name: "Test User",
|
|
Email: userID.String() + "@example.com",
|
|
Provider: pb.IDP_Github,
|
|
}
|
|
login, user, err := provider.LoginUser(ctx, login)
|
|
require.NoError(t, err)
|
|
defer func() {
|
|
_, err := provider.DeleteUserByEmail(ctx, login.Email)
|
|
assert.NoError(t, err)
|
|
}()
|
|
|
|
org := &model.Org{
|
|
Name: "Test Org",
|
|
}
|
|
org, err = provider.RegisterOrg(ctx, org, user.ID.UInt64())
|
|
require.NoError(t, err)
|
|
defer func() {
|
|
_, err := provider.DeleteOrg(ctx, org.ID.UInt64())
|
|
assert.NoError(t, err)
|
|
}()
|
|
assert.Equal(t, pb.ItemStatus_Active, org.Status)
|
|
|
|
org2, err := provider.GetOrg(ctx, org.ID.UInt64())
|
|
require.NoError(t, err)
|
|
assert.Equal(t, org, org2)
|
|
|
|
org2, err = provider.FindOrg(ctx, org.Alias)
|
|
require.NoError(t, err)
|
|
assert.Equal(t, org, org2)
|
|
|
|
orgs, err := provider.ListOrgs(ctx, &query.ListOrgsRequest{})
|
|
require.NoError(t, err)
|
|
assert.GreaterOrEqual(t, len(orgs.Rows), 1)
|
|
|
|
memberships, err := provider.ListMemberships(ctx, &query.ListMembershipsRequest{OrgID: org.ID.UInt64()})
|
|
require.NoError(t, err)
|
|
require.Equal(t, 1, len(memberships))
|
|
assert.Equal(t, org.ID.UInt64(), memberships[0].OrgID.UInt64())
|
|
assert.Equal(t, user.ID.UInt64(), memberships[0].UserID.UInt64())
|
|
assert.Equal(t, pb.Role_Owner, memberships[0].Role)
|
|
|
|
userOrgs, err := provider.GetUserOrgs(ctx, user.ID.UInt64())
|
|
require.NoError(t, err)
|
|
require.Len(t, userOrgs, 1)
|
|
assert.Equal(t, org.ID.UInt64(), userOrgs[0].ID.UInt64())
|
|
|
|
updated, err := provider.UpdateOrg(ctx, &query.UpdateOrgRequest{ID: org.ID.UInt64(), Name: "new name", Description: "new description"})
|
|
require.NoError(t, err)
|
|
assert.Equal(t, "new name", updated.Name)
|
|
assert.Equal(t, "new description", string(updated.Description))
|
|
assert.Equal(t, org.Alias, updated.Alias)
|
|
|
|
updated, err = provider.UpdateOrg(ctx, &query.UpdateOrgRequest{ID: org.ID.UInt64(), Status: pb.ItemStatus_Inactive})
|
|
require.NoError(t, err)
|
|
assert.Equal(t, pb.ItemStatus_Inactive, updated.Status)
|
|
}
|
|
|
|
func Test_Org_NotFound(t *testing.T) {
|
|
_, err := provider.GetOrg(ctx, 123)
|
|
assert.EqualError(t, err, "record not found: org: 123")
|
|
|
|
_, err = provider.FindOrg(ctx, "cp_does-not-exist")
|
|
assert.EqualError(t, err, "record not found: org: cp_does-not-exist")
|
|
}
|
|
|
|
func Test_RegisterOrg_OwnerFails(t *testing.T) {
|
|
// no user has this ID: the owner grant violates its foreign key, and the
|
|
// org insert must roll back with it
|
|
ownerID := provider.NextID().UInt64()
|
|
orgID := provider.NextID()
|
|
_, err := provider.RegisterOrg(ctx, &model.Org{ID: orgID, Name: "Ownerless Org"}, ownerID)
|
|
require.Error(t, err)
|
|
assert.ErrorContains(t, err, "unable to add owner")
|
|
|
|
_, err = provider.GetOrg(ctx, orgID.UInt64())
|
|
if !assert.EqualError(t, err, fmt.Sprintf("record not found: org: %d", orgID.UInt64())) {
|
|
_, err = provider.DeleteOrg(ctx, orgID.UInt64())
|
|
assert.NoError(t, err)
|
|
}
|
|
}
|
|
|
|
func Test_UpdateOrg(t *testing.T) {
|
|
userID := provider.NextID()
|
|
login := &model.Login{
|
|
ID: userID,
|
|
ExternalID: userID.String(),
|
|
Name: "Test Update Org User",
|
|
Email: userID.String() + "@example.com",
|
|
Provider: pb.IDP_Github,
|
|
}
|
|
_, user, err := provider.LoginUser(ctx, login)
|
|
require.NoError(t, err)
|
|
defer func() {
|
|
_, err := provider.DeleteUserByEmail(ctx, login.Email)
|
|
assert.NoError(t, err)
|
|
}()
|
|
|
|
org, err := provider.RegisterOrg(ctx, &model.Org{Name: "Original Name"}, user.ID.UInt64())
|
|
require.NoError(t, err)
|
|
defer func() {
|
|
_, err := provider.DeleteOrg(ctx, org.ID.UInt64())
|
|
assert.NoError(t, err)
|
|
}()
|
|
|
|
updated, err := provider.UpdateOrg(ctx, &query.UpdateOrgRequest{ID: org.ID.UInt64(), Name: "Updated Name", Description: "Updated description"})
|
|
require.NoError(t, err)
|
|
assert.Equal(t, "Updated Name", updated.Name)
|
|
assert.Equal(t, "Updated description", string(updated.Description))
|
|
assert.Equal(t, org.Alias, updated.Alias)
|
|
|
|
_, err = provider.UpdateOrg(ctx, &query.UpdateOrgRequest{ID: org.ID.UInt64(), Name: "", Description: ""})
|
|
assert.EqualError(t, err, "no changes to update")
|
|
|
|
_, err = provider.UpdateOrg(ctx, &query.UpdateOrgRequest{ID: 123, Name: "Some Name", Description: ""})
|
|
assert.EqualError(t, err, "record not found: org: 123")
|
|
}
|