mirror of
https://github.com/hanzoai/ca.git
synced 2026-11-03 18:08:27 +00:00
142 lines
4.2 KiB
Go
142 lines
4.2 KiB
Go
package query
|
|
|
|
import (
|
|
"time"
|
|
|
|
"github.com/effective-security/trustyca/api/pb"
|
|
"github.com/effective-security/trustyca/internal/db/schema"
|
|
"github.com/effective-security/xdb"
|
|
"github.com/effective-security/xdb/xsql"
|
|
)
|
|
|
|
// CreateEvent returns SQL query
|
|
func CreateEvent(args ...any) (string, string) {
|
|
const key = "CreateEvent"
|
|
return xsql.Postgres.GetOrCreateQuery(key, func(name string) xsql.Builder {
|
|
q := schema.EventTableInfo.InsertInto().
|
|
Returning(schema.EventTableInfo.AllColumns())
|
|
// set all columns to nil as placeholders
|
|
q.NewRow().
|
|
Set(schema.Event.ID.Name, nil).
|
|
Set(schema.Event.OrgID.Name, nil).
|
|
Set(schema.Event.ProjectID.Name, nil).
|
|
Set(schema.Event.Type.Name, nil).
|
|
Set(schema.Event.Title.Name, nil).
|
|
Set(schema.Event.Description.Name, nil).
|
|
Set(schema.Event.Metadata.Name, nil).
|
|
Set(schema.Event.ReferenceID.Name, nil).
|
|
Set(schema.Event.Email.Name, nil).
|
|
Set(schema.Event.Source.Name, nil).
|
|
SetExpr(schema.Event.CreatedAt.Name, exprNow)
|
|
return q
|
|
})
|
|
}
|
|
|
|
// ListEventsRequest defines request for Events, newest first: the events
|
|
// are sorted by created_at DESC, id DESC, served by the org-led indexes of
|
|
// the event table, and page by offset or by a cursor on that key
|
|
// (ParseTimeCursor, EncodeTimeCursor)
|
|
type ListEventsRequest struct {
|
|
// OrgID specifies the org
|
|
OrgID uint64
|
|
// ProjectID specifies the project
|
|
ProjectID uint64
|
|
// ProjectIDs limits the result to the org-wide events and the events of
|
|
// the projects, for a caller with grants in some projects only; nil
|
|
// applies no project filter and an empty list keeps the org-wide
|
|
// events. ProjectID takes precedence.
|
|
ProjectIDs []uint64
|
|
// After specifies the inclusive start of the created_at range
|
|
After *time.Time
|
|
// Before specifies the exclusive end of the created_at range
|
|
Before *time.Time
|
|
// Type specifies event types to query
|
|
Type pb.EventType_Enum
|
|
// ReferenceID specifies the referenced entity ID to filter by
|
|
ReferenceID uint64
|
|
// Email specifies the email to filter by
|
|
Email string
|
|
// Source specifies the source to filter by
|
|
Source string
|
|
// Limit specifies maximum number of records to return
|
|
Limit uint32
|
|
// Offset specifies the offset for offset pagination
|
|
Offset uint32
|
|
// Cursor specifies the position for cursor pagination, decoded by
|
|
// ParseTimeCursor
|
|
Cursor Cursor
|
|
}
|
|
|
|
// Validate fails a request that carries the cursor of another list
|
|
func (r *ListEventsRequest) Validate() error {
|
|
return r.Cursor.checkKey(keyTime)
|
|
}
|
|
|
|
// QueryParams returns the query params builder
|
|
func (r *ListEventsRequest) QueryParams() xdb.QueryParams {
|
|
b := xdb.NewQueryParams("ListEvents")
|
|
|
|
if r.OrgID > 0 {
|
|
b.Set(schema.Event.OrgID.Position, r.OrgID)
|
|
}
|
|
setProjectScope(b, schema.Event.ProjectID.Position, r.ProjectID, pb.Scope_Undefined)
|
|
setVisibleProjects(b, schema.Event.ProjectID.Position, r.ProjectIDs)
|
|
if r.Type != pb.EventType_Unknown {
|
|
b.Set(schema.Event.Type.Position, r.Type)
|
|
}
|
|
if r.After != nil {
|
|
b.Set(62, r.After.UTC())
|
|
}
|
|
if r.Before != nil {
|
|
// Use 63
|
|
b.Set(63, r.Before.UTC())
|
|
}
|
|
if r.ReferenceID > 0 {
|
|
b.Set(schema.Event.ReferenceID.Position, r.ReferenceID)
|
|
}
|
|
if r.Email != "" {
|
|
b.Set(schema.Event.Email.Position, r.Email)
|
|
}
|
|
if r.Source != "" {
|
|
b.Set(schema.Event.Source.Position, r.Source)
|
|
}
|
|
|
|
setPage(b, r.Limit, r.Offset, r.Cursor)
|
|
return b
|
|
}
|
|
|
|
// ListEvents returns SQL query
|
|
func ListEvents(args ...any) (string, string) {
|
|
p := xdb.GetQueryParams(args...)
|
|
key := p.Name()
|
|
|
|
return xsql.Postgres.GetOrCreateQuery(key, func(name string) xsql.Builder {
|
|
q := schema.EventTableInfo.Select()
|
|
|
|
if p.IsSet(schema.Event.OrgID.Position) {
|
|
q.Where("org_id = ?", nil)
|
|
}
|
|
whereProjectScope(q, p, schema.Event.ProjectID.Position)
|
|
if p.IsSet(schema.Event.Type.Position) {
|
|
q.Where("type = ?", nil)
|
|
}
|
|
if p.IsSet(62) {
|
|
q.Where("created_at >= ?", nil)
|
|
}
|
|
if p.IsSet(63) {
|
|
q.Where("created_at < ?", nil)
|
|
}
|
|
if p.IsSet(schema.Event.ReferenceID.Position) {
|
|
q.Where("ref_id = ?", nil)
|
|
}
|
|
if p.IsSet(schema.Event.Email.Position) {
|
|
q.Where("email = ?", nil)
|
|
}
|
|
if p.IsSet(schema.Event.Source.Position) {
|
|
q.Where("source = ?", nil)
|
|
}
|
|
pageBy(q, p, OrderDirectionDesc, schema.Event.CreatedAt.Name, schema.Event.ID.Name)
|
|
return q
|
|
})
|
|
}
|