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

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

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")
}