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

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

67 lines
2.2 KiB
Go

package admin
import (
"context"
"github.com/effective-security/porto/xhttp/httperror"
"github.com/effective-security/trustyca/api/pb"
"github.com/effective-security/trustyca/internal/db/pgsql/query"
"github.com/effective-security/trustyca/privpb"
"github.com/effective-security/xdb"
"google.golang.org/grpc/codes"
)
// ListCertificates lists the certificates of the org the request names, of
// the platform, or of every org and the platform, newest first, for
// support staff
func (s *Service) ListCertificates(ctx context.Context, req *privpb.ListAllCertificatesRequest) (*pb.CertificatesResponse, error) {
if req == nil {
return nil, httperror.NewGrpcFromCtx(ctx, codes.InvalidArgument, "missing request")
}
scope, err := parseListScope(ctx, req.OrgID, req.ProjectID, req.Platform)
if err != nil {
return nil, err
}
cursor, err := query.ListCursor(ctx, req.Cursor, query.ParseCursor)
if err != nil {
return nil, err
}
expiringBefore, err := parseTime(ctx, req.ExpiringBefore, "ExpiringBefore")
if err != nil {
return nil, err
}
if req.IKID != "" && scope.allOrgs {
// an issuer belongs to one org: the list by issuer is served by the
// index that the org leads, so the org of the issuer is resolved
// first. A key identifier of no registered issuer keeps the list
// across orgs: a deleted issuer keeps the certificates it issued,
// and support staff look for them.
issuer, err := s.ca.GetIssuerBySKID(ctx, req.IKID)
switch {
case err == nil:
scope.allOrgs = false
scope.orgID = issuer.OrgID.UInt64()
scope.platform = issuer.OrgID.IsZero()
case !xdb.IsNotFoundError(err):
return nil, httperror.WrapWithCtx(ctx, err, "unable to find issuer")
}
}
res, err := s.ca.ListCertificates(ctx, &query.ListCertificatesRequest{
OrgID: scope.orgID,
Platform: scope.platform,
AllOrgs: scope.allOrgs,
ProjectID: scope.projectID,
IKID: req.IKID,
Profile: req.Profile,
Status: req.Status,
ExpiringBefore: expiringBefore,
Limit: req.Limit,
Offset: req.Offset,
Cursor: cursor,
})
if err != nil {
return nil, httperror.WrapWithCtx(ctx, err, "failed to list certificates")
}
return res.Pb(), nil
}