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

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

98 lines
2.4 KiB
Go

package pgsql
import (
"context"
"time"
"github.com/effective-security/trustyca/internal/db/model"
"github.com/effective-security/trustyca/internal/db/pgsql/query"
"github.com/effective-security/trustyca/internal/db/schema"
"github.com/effective-security/x/slices"
"github.com/effective-security/xdb"
"github.com/effective-security/xlog"
)
// TryCreateEvent creates the event on its own goroutine with a background
// context, so the caller's cancellation does not drop it, and logs a failure
// instead of returning it
func (p *Provider) TryCreateEvent(evt *model.Event) {
go func(evt *model.Event) {
_, err := p.CreateEvent(context.Background(), evt)
if err != nil {
logger.KV(xlog.ERROR,
"reason", "CreateEvent",
"org_id", evt.OrgID.UnderscoreString(),
"type", evt.Type,
"err", err.Error())
}
}(evt)
}
// CreateEvent returns new Event
func (p *Provider) CreateEvent(ctx context.Context, m *model.Event) (*model.Event, error) {
err := xdb.Validate(m)
if err != nil {
return nil, err
}
q, name := query.CreateEvent()
defer DbMeasureQuerySince(name, time.Now())
id := p.NextID()
res, err := xdb.QueryRow[model.Event](ctx, p,
q,
id.UInt64(),
m.OrgID,
m.ProjectID,
m.Type,
slices.StringUpto(m.Title, 254),
m.Description,
query.MetadataArg(m.Metadata),
m.ReferenceID.UInt64(),
m.Email,
m.Source,
)
if err != nil {
p.CheckErrIDConflict(ctx, err, id.UInt64())
return nil, err
}
return res, nil
}
// ListEvents lists events, newest first
func (p *Provider) ListEvents(ctx context.Context, r *query.ListEventsRequest) (*model.EventResult, error) {
err := xdb.Validate(r)
if err != nil {
return nil, err
}
qp := r.QueryParams()
q, name := query.ListEvents(qp)
defer DbMeasureQuerySince(name, time.Now())
var rs model.EventResult
err = listRows(ctx, p, r.Cursor, eventCursor, &rs, q, qp)
if err != nil {
return nil, err
}
return &rs, nil
}
// eventCursor returns the cursor of the page after the row
func eventCursor(last *model.Event) string {
return query.EncodeTimeCursor(last.CreatedAt, last.ID)
}
// GetEvent returns Event
func (p *Provider) GetEvent(ctx context.Context, id uint64) (*model.Event, error) {
q, name := query.GetRowByID(&schema.EventTableInfo)
defer DbMeasureQuerySince(name, time.Now())
res, err := xdb.QueryRow[model.Event](ctx, p, q, id)
if err != nil {
return nil, xdb.CheckNotFoundError(err, schema.EventTableInfo.Name, id)
}
return res, nil
}