mirror of
https://github.com/hanzoai/ca.git
synced 2026-11-03 18:08:27 +00:00
160 lines
5.3 KiB
Go
160 lines
5.3 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)
|
|
|
|
// the pages by (name, id) list every org once, whatever the other
|
|
// tests register meanwhile
|
|
seen := map[uint64]bool{}
|
|
req := &query.ListOrgsRequest{Limit: 2, Cursor: query.NewCursor(0)}
|
|
for pages := 0; pages < 100; pages++ {
|
|
page, err := provider.ListOrgs(ctx, req)
|
|
require.NoError(t, err)
|
|
assert.Zero(t, page.NextOffset)
|
|
for _, row := range page.Rows {
|
|
assert.False(t, seen[row.ID.UInt64()], "org %s listed twice", row.ID)
|
|
seen[row.ID.UInt64()] = true
|
|
}
|
|
if !page.HasNextPage {
|
|
assert.Empty(t, page.Cursor)
|
|
break
|
|
}
|
|
require.Len(t, page.Rows, 2)
|
|
require.NotEmpty(t, page.Cursor)
|
|
last := page.Rows[1]
|
|
req.Cursor, err = query.ParseNameCursor(page.Cursor)
|
|
require.NoError(t, err)
|
|
assert.Equal(t, []any{last.Name, last.ID.UInt64()}, req.Cursor.Key())
|
|
}
|
|
assert.True(t, seen[org.ID.UInt64()], "the org is listed")
|
|
|
|
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")
|
|
}
|