models

type ABACAttribute struct {
	Playbook   Playbook
	Connection Connection
	Component  Component
	Config     ConfigItem
	Check      Check
	Canary     Canary
	View       View
}

type AccessReview struct {
	ID              uuid.UUID      `json:"id"`
	ScraperID       uuid.UUID      `json:"scraper_id" gorm:"not null"`
	Aliases         pq.StringArray `json:"aliases" gorm:"type:[]text"`
	ConfigID        uuid.UUID      `json:"config_id"`
	ExternalGroupID *uuid.UUID     `json:"external_group_id"`
	ExternalUserID  *uuid.UUID     `json:"external_user_id"`
	ExternalRoleID  uuid.UUID      `json:"external_role_id"`
	CreatedAt       time.Time      `json:"created_at" gorm:"<-:create"`
	CreatedBy       *uuid.UUID     `json:"created_by"`
	Source          string         `json:"source"`
}

type AccessToken struct {
	ID        uuid.UUID  `json:"id" gorm:"default:generate_ulid()"`
	Name      string     `json:"name" gorm:"not null"`
	Value     string     `json:"-" gorm:"not null"`
	AutoRenew bool       `json:"auto_renew"`
	PersonID  uuid.UUID  `json:"person_id" gorm:"not null"`
	CreatedAt time.Time  `json:"created_at" gorm:"<-:create"`
	CreatedBy *uuid.UUID `json:"created_by,omitempty"`
	ExpiresAt *time.Time `json:"expires_at,omitempty"`
}

type Agent struct {
	ID          uuid.UUID           `json:"id,omitempty" gorm:"default:generate_ulid()"`
	Name        string              `json:"name"`
	Hostname    string              `json:"hostname,omitempty"`
	Description string              `json:"description,omitempty"`
	IP          string              `json:"ip,omitempty"`
	Version     string              `json:"version,omitempty"`
	Username    string              `json:"username,omitempty"`
	PersonID    *uuid.UUID          `json:"person_id,omitempty"`
	Properties  types.JSONStringMap `json:"properties,omitempty"`
	TLS         string              `json:"tls,omitempty"`
	CreatedBy   *uuid.UUID          `json:"created_by,omitempty"`
	CreatedAt   time.Time           `json:"created_at" time_format:"postgres_timestamp"`
	DeletedAt   *time.Time          `json:"deleted_at" time_format:"postgres_timestamp"`
	UpdatedAt   time.Time           `json:"updated_at" time_format:"postgres_timestamp"`

	// Cleanup when set to true will delete all the agent resources when the agent is deleted
	Cleanup bool `json:"cleanup"`

	// LastSeen is the timestamp the agent last sent a heartbeat
	LastSeen *time.Time `json:"last_seen,omitempty" time_format:"postgres_timestamp"`

	// LastReceived is the timestamp the agent last sent a push data
	LastReceived *time.Time `json:"last_received,omitempty" time_format:"postgres_timestamp"`
}

type AnalysisType string

type AppProperty struct {
	Name      string     `json:"name,omitempty"`
	Value     string     `json:"value,omitempty"`
	CreatedBy *uuid.UUID `json:"created_by,omitempty"`
	CreatedAt time.Time  `json:"created_at,omitempty" time_format:"postgres_timestamp" gorm:"default:CURRENT_TIMESTAMP()"`
	UpdatedAt time.Time  `json:"updated_at,omitempty" time_format:"postgres_timestamp" gorm:"default:CURRENT_TIMESTAMP()"`
	DeletedAt *time.Time `json:"deleted_at,omitempty" time_format:"postgres_timestamp" gorm:"default:CURRENT_TIMESTAMP()"`
}

type Application struct {
	ID          uuid.UUID           `json:"id" gorm:"default:generate_ulid()"`
	Name        string              `json:"name"`
	Namespace   string              `json:"namespace,omitempty" gorm:"default:NULL"`
	Description string              `json:"description,omitempty" gorm:"default:NULL"`
	Spec        string              `json:"spec"`
	Source      string              `json:"source,omitempty"`
	Labels      types.JSONStringMap `json:"labels,omitempty" gorm:"default:NULL"`
	CreatedBy   *uuid.UUID          `json:"created_by,omitempty" gorm:"default:NULL"`
	CreatedAt   time.Time           `json:"created_at" gorm:"<-:create"`
	UpdatedAt   *time.Time          `json:"updated_at,omitempty" gorm:"autoUpdateTime:false"`
	DeletedAt   *time.Time          `json:"deleted_at,omitempty"`
}

type Artifact struct {
	ID             uuid.UUID  `json:"id" gorm:"default:generate_ulid()"`
	CheckID        *uuid.UUID `json:"check_id,omitempty"`
	CheckTime      *time.Time `json:"check_time,omitempty" time_format:"postgres_timestamp"`
	ConfigChangeID *uuid.UUID `json:"config_change_id,omitempty"`

	// Playbook action that created this artifact
	PlaybookRunActionID *uuid.UUID `json:"playbook_run_action_id,omitempty"`

	// ScraperID is the durable owner for scraper-generated artifacts.
	ScraperID *uuid.UUID `json:"scraper_id,omitempty"`

	// JobHistoryID records the creating job run provenance for scraper-generated artifacts.
	// It may become nil when job_history retention prunes old rows.
	JobHistoryID *uuid.UUID `json:"job_history_id,omitempty"`

	ConnectionID    uuid.UUID  `json:"connection_id,omitempty"`
	Path            string     `json:"path"`
	IsPushed        bool       `json:"is_pushed"`
	IsDataPushed    bool       `json:"is_data_pushed"`
	Filename        string     `json:"filename"`
	Size            int64      `json:"size"` // Size in bytes
	ContentType     string     `json:"content_type,omitempty"`
	Checksum        string     `json:"checksum"`
	Content         []byte     `json:"-" gorm:"type:bytea"`
	CompressionType string     `json:"compression_type,omitempty"`
	CreatedAt       time.Time  `json:"created_at" yaml:"created_at" time_format:"postgres_timestamp"`
	UpdatedAt       time.Time  `json:"updated_at" yaml:"updated_at" time_format:"postgres_timestamp"`
	DeletedAt       *time.Time `json:"deleted_at,omitempty" yaml:"deleted_at,omitempty" time_format:"postgres_timestamp"`
	ExpiresAt       *time.Time `json:"expires_at,omitempty" yaml:"expires_at,omitempty" time_format:"postgres_timestamp"`
}

type Canary struct {
	ID          uuid.UUID           `json:"id" yaml:"id" gorm:"default:generate_ulid()"`
	Name        string              `json:"name" yaml:"name"`
	Namespace   string              `json:"namespace" yaml:"namespace"`
	AgentID     uuid.UUID           `json:"agent_id" yaml:"agent_id"`
	Spec        types.JSON          `json:"spec" yaml:"spec"`
	Labels      types.JSONStringMap `json:"labels,omitempty" yaml:"labels,omitempty"`
	Annotations types.JSONStringMap `json:"annotations,omitempty" yaml:"annotations,omitempty"`
	Source      string              `json:"source,omitempty" yaml:"source,omitempty"`
	Checks      types.JSONStringMap `gorm:"-" json:"checks,omitempty" yaml:"checks,omitempty"`
	CreatedAt   time.Time           `json:"created_at" yaml:"created_at" time_format:"postgres_timestamp" gorm:"<-:create"`
	UpdatedAt   *time.Time          `json:"updated_at" yaml:"updated_at" time_format:"postgres_timestamp" gorm:"autoUpdateTime:false"`
	DeletedAt   *time.Time          `json:"deleted_at,omitempty" yaml:"deleted_at,omitempty" time_format:"postgres_timestamp"`
}

type CatalogChange struct {
	ID                uuid.UUID           `gorm:"primaryKey;column:id" json:"id"`
	ConfigID          uuid.UUID           `gorm:"column:config_id" json:"config_id"`
	Config            types.JSON          `gorm:"column:config" json:"config"`
	Name              *string             `gorm:"column:name" json:"name"`
	DeletedAt         *time.Time          `gorm:"column:deleted_at" json:"deleted_at"`
	Type              *string             `gorm:"column:type" json:"type"`
	Tags              types.JSONStringMap `gorm:"column:tags" json:"tags"`
	ExternalCreatedBy *string             `gorm:"column:external_created_by" json:"external_created_by"`
	CreatedAt         *time.Time          `gorm:"column:created_at" json:"created_at"`
	Severity          *string             `gorm:"column:severity" json:"severity"`
	ChangeType        string              `gorm:"column:change_type" json:"change_type"`
	Source            *string             `gorm:"column:source" json:"source"`
	Details           types.JSON          `json:"details,omitempty"`
	Summary           *string             `gorm:"column:summary" json:"summary"`
	CreatedBy         *uuid.UUID          `gorm:"column:created_by" json:"created_by"`
	Count             int                 `gorm:"column:count" json:"count"`
	FirstObserved     *time.Time          `gorm:"column:first_observed" json:"first_observed"`
	AgentID           *uuid.UUID          `gorm:"column:agent_id" json:"agent_id"`
	Path              string              `gorm:"column:path" json:"path"`
	InsertedAt        *time.Time          `gorm:"column:inserted_at" json:"inserted_at,omitempty"`
}

type Check struct {
	ID                 uuid.UUID           `json:"id" gorm:"default:generate_ulid()"`
	CanaryID           uuid.UUID           `json:"canary_id"`
	AgentID            uuid.UUID           `json:"agent_id,omitempty"`
	Spec               types.JSON          `json:"-"`
	Type               string              `json:"type"`
	Name               string              `json:"name"`
	Namespace          string              `json:"namespace"`
	Labels             types.JSONStringMap `json:"labels" gorm:"type:jsonstringmap"`
	Description        string              `json:"description,omitempty"`
	Status             CheckHealthStatus   `json:"status,omitempty"`
	Owner              string              `json:"owner,omitempty"`
	Severity           Severity            `json:"severity,omitempty"`
	Icon               string              `json:"icon,omitempty"`
	Transformed        bool                `json:"transformed,omitempty"`
	LastTransitionTime *time.Time          `json:"last_transition_time,omitempty"`
	CreatedAt          *time.Time          `json:"created_at,omitempty" gorm:"<-:create"`
	UpdatedAt          *time.Time          `json:"updated_at,omitempty" gorm:"autoUpdateTime:false"`
	DeletedAt          *time.Time          `json:"deleted_at,omitempty"`
	SilencedAt         *time.Time          `json:"silenced_at,omitempty"`

	// Auxiliary fields
	CanaryName   string        `json:"canary_name,omitempty" gorm:"-"`
	ComponentIDs []string      `json:"components,omitempty"  gorm:"-"` // Linked component ids
	Uptime       types.Uptime  `json:"uptime,omitempty"  gorm:"-"`
	Latency      types.Latency `json:"latency,omitempty"  gorm:"-"`
	Statuses     []CheckStatus `json:"checkStatuses,omitempty"  gorm:"-"`
	DisplayType  string        `json:"display_type,omitempty"  gorm:"-"`

	// These are calculated for the selected date range
	EarliestRuntime *time.Time `json:"earliestRuntime,omitempty" gorm:"-"`
	LatestRuntime   *time.Time `json:"latestRuntime,omitempty" gorm:"-"`
	TotalRuns       int        `json:"totalRuns,omitempty" gorm:"-"`
}

type CheckComponentRelationship struct {
	ComponentID uuid.UUID  `json:"component_id,omitempty"`
	CheckID     uuid.UUID  `json:"check_id,omitempty"`
	CanaryID    uuid.UUID  `json:"canary_id,omitempty"`
	SelectorID  string     `json:"selector_id,omitempty"`
	CreatedAt   time.Time  `json:"created_at,omitempty"`
	UpdatedAt   time.Time  `json:"updated_at,omitempty" gorm:"autoUpdateTime:false"`
	DeletedAt   *time.Time `json:"deleted_at,omitempty"`
}

type CheckConfigRelationship struct {
	ConfigID   uuid.UUID  `json:"config_id,omitempty"`
	CheckID    uuid.UUID  `json:"check_id,omitempty"`
	CanaryID   uuid.UUID  `json:"canary_id,omitempty"`
	SelectorID string     `json:"selector_id,omitempty"`
	CreatedAt  time.Time  `json:"created_at,omitempty"`
	UpdatedAt  time.Time  `json:"updated_at,omitempty"`
	DeletedAt  *time.Time `json:"deleted_at,omitempty"`
}

type CheckHealthStatus string

type CheckStatus struct {
	CheckID   uuid.UUID `json:"check_id" gorm:"primaryKey"`
	Status    bool      `json:"status"`
	Invalid   bool      `json:"invalid,omitempty"`
	Time      string    `json:"time" gorm:"primaryKey"`
	Duration  int       `json:"duration"`
	Message   string    `json:"message,omitempty"`
	Error     string    `json:"error,omitempty"`
	Detail    any       `json:"-" gorm:"-"`
	CreatedAt time.Time `json:"created_at,omitempty" gorm:"<-:create"`
	// IsPushed when set to true indicates that the check status has been pushed to upstream.
	IsPushed bool `json:"is_pushed,omitempty"`
}

type CheckStatusAggregate1d struct {
	CheckID   string    `gorm:"column:check_id"`
	CreatedAt time.Time `gorm:"column:created_at"`
	Duration  int       `gorm:"column:duration"`
	Total     int       `gorm:"column:total"`
	Passed    int       `gorm:"column:passed"`
	Failed    int       `gorm:"column:failed"`
}

type CheckStatusAggregate1h struct {
	CheckID   string    `gorm:"column:check_id"`
	CreatedAt time.Time `gorm:"column:created_at"`
	Duration  int       `gorm:"column:duration"`
	Total     int       `gorm:"column:total"`
	Passed    int       `gorm:"column:passed"`
	Failed    int       `gorm:"column:failed"`
}

type CheckSummary struct {
	ID                 uuid.UUID           `json:"id"`
	CanaryID           uuid.UUID           `json:"canary_id"`
	CanaryName         string              `json:"canary_name"`
	CanaryNamespace    string              `json:"canary_namespace"`
	AgentID            uuid.UUID           `json:"agent_id"`
	Description        string              `json:"description,omitempty"`
	Icon               string              `json:"icon,omitempty"`
	Labels             types.JSONStringMap `json:"labels"`
	LastTransitionTime *time.Time          `json:"last_transition_time,omitempty"`
	Latency            types.Latency       `json:"latency,omitempty"`
	Name               string              `json:"name"`
	Namespace          string              `json:"namespace"`
	Owner              string              `json:"owner,omitempty"`
	Severity           string              `json:"severity,omitempty"`
	Status             string              `json:"status"`
	Type               string              `json:"type"`
	Uptime             types.Uptime        `json:"uptime,omitempty"`
	LastRuntime        *time.Time          `json:"last_runtime,omitempty"`
	CreatedAt          time.Time           `json:"created_at"`
	UpdatedAt          time.Time           `json:"updated_at"`
	DeletedAt          *time.Time          `json:"deleted_at,omitempty"`
	SilencedAt         *time.Time          `json:"silenced_at,omitempty"`
}

type Checks []*Check

type ChecksUnlogged struct {
	CheckID     uuid.UUID  `json:"check_id" gorm:"primaryKey"`
	CanaryID    uuid.UUID  `json:"canary_id"`
	Status      string     `json:"status"`
	LastRuntime *time.Time `json:"last_runtime,omitempty"`
	NextRuntime *time.Time `json:"next_runtime,omitempty"`
}

type ColumnType string

type Comment struct {
	ID                uuid.UUID  `json:"id" gorm:"primaryKey"`
	CreatedBy         uuid.UUID  `json:"created_by,omitempty"`
	Comment           string     `json:"comment,omitempty"`
	ExternalID        *string    `json:"external_id,omitempty"`
	ExternalCreatedBy *string    `json:"external_created_by,omitempty"`
	IncidentID        uuid.UUID  `json:"incident_id,omitempty"`
	ResponderID       *uuid.UUID `json:"responder_id,omitempty"`
	HypothesisID      *uuid.UUID `json:"hypothesis_id,omitempty"`
	Read              []int16    `json:"read,omitempty" gorm:"type:smallint[]"`
	CreatedAt         time.Time  `json:"created_at,omitempty" time_format:"postgres_timestamp" gorm:"default:CURRENT_TIMESTAMP()"`
	UpdatedAt         time.Time  `json:"updated_at,omitempty" time_format:"postgres_timestamp" gorm:"default:CURRENT_TIMESTAMP()"`
}

type Component struct {
	ID              uuid.UUID               `json:"id,omitempty" gorm:"default:generate_ulid()"` //nolint
	TopologyID      *uuid.UUID              `json:"topology_id,omitempty"`
	AgentID         uuid.UUID               `json:"agent_id,omitempty"`
	ExternalId      string                  `json:"external_id,omitempty"` //nolint
	ParentId        *uuid.UUID              `json:"parent_id,omitempty"`   //nolint
	Name            string                  `json:"name"`
	Text            string                  `json:"text,omitempty"`
	TopologyType    string                  `json:"topology_type,omitempty"`
	Namespace       string                  `json:"namespace"`
	Labels          types.JSONStringMap     `json:"labels,omitempty" gorm:"default:null"`
	Hidden          bool                    `json:"hidden,omitempty"`
	Silenced        bool                    `json:"silenced,omitempty"`
	Status          types.ComponentStatus   `json:"status"`
	Health          *Health                 `json:"health,omitempty"`
	Description     string                  `json:"description"`
	Lifecycle       string                  `json:"lifecycle,omitempty"`
	LogSelectors    types.LogSelectors      `json:"logs,omitempty" gorm:"column:log_selectors;default:null"`
	Tooltip         string                  `json:"tooltip,omitempty"`
	StatusReason    string                  `json:"status_reason,omitempty" gorm:"default:null"`
	Schedule        string                  `json:"schedule,omitempty"`
	Icon            string                  `json:"icon,omitempty"`
	Type            string                  `json:"type"`
	Owner           string                  `json:"owner,omitempty"`
	Selectors       types.ResourceSelectors `json:"selectors,omitempty" gorm:"resourceSelectors;default:null" swaggerignore:"true"`
	Configs         types.ConfigQueries     `json:"configs,omitempty" gorm:"default:null"`
	ComponentChecks types.ComponentChecks   `json:"componentChecks,omitempty" gorm:"default:null"`
	Properties      Properties              `json:"properties,omitempty" gorm:"type:properties;default:null"`
	Path            string                  `json:"path,omitempty"`
	Summary         types.Summary           `json:"summary,omitempty" gorm:"type:summary;default:null"`
	IsLeaf          bool                    `json:"is_leaf"`
	CostPerMinute   float64                 `json:"cost_per_minute,omitempty" gorm:"column:cost_per_minute"`
	CostTotal1d     float64                 `json:"cost_total_1d,omitempty" gorm:"column:cost_total_1d"`
	CostTotal7d     float64                 `json:"cost_total_7d,omitempty" gorm:"column:cost_total_7d"`
	CostTotal30d    float64                 `json:"cost_total_30d,omitempty" gorm:"column:cost_total_30d"`
	CreatedBy       *uuid.UUID              `json:"created_by,omitempty"`
	CreatedAt       time.Time               `json:"created_at,omitempty" time_format:"postgres_timestamp" gorm:"default:CURRENT_TIMESTAMP();<-:create"`
	UpdatedAt       *time.Time              `json:"updated_at,omitempty" time_format:"postgres_timestamp" gorm:"autoUpdateTime:false"`
	DeletedAt       *time.Time              `json:"deleted_at,omitempty" time_format:"postgres_timestamp" swaggerignore:"true"`

	// ConfigID is the id of the config from which this component is derived
	ConfigID *uuid.UUID `json:"config_id,omitempty"`

	// StatusExpr allows defining a cel expression to evaluate the status of a component
	// based on the summary.
	StatusExpr string `json:"status_expr,omitempty" gorm:"column:status_expr;default:null"`

	// HealthExpr allows defining a cel expression to evaluate the health of a component
	// based on the summary.
	HealthExpr string `json:"health_expr,omitempty" gorm:"column:health_expr;default:null"`

	// Auxiliary fields
	Checks         map[string]int            `json:"checks,omitempty" gorm:"-"`
	Incidents      map[string]map[string]int `json:"incidents,omitempty" gorm:"-"`
	Analysis       map[string]map[string]int `json:"analysis,omitempty" gorm:"-"`
	Components     Components                `json:"components,omitempty" gorm:"-"`
	Order          int                       `json:"order,omitempty"  gorm:"-"`
	SelectorID     string                    `json:"-" gorm:"-"`
	RelationshipID *uuid.UUID                `json:"relationship_id,omitempty" gorm:"-"`
	Children       []string                  `json:"children,omitempty" gorm:"-"`
	Parents        []string                  `json:"parents,omitempty" gorm:"-"`

	// Mark it as true when the component is processed
	// during topology tree creation
	NodeProcessed bool `json:"-" gorm:"-"`
}

type ComponentRelationship struct {
	ComponentID      uuid.UUID  `json:"component_id,omitempty" gorm:"primaryKey"`
	RelationshipID   uuid.UUID  `json:"relationship_id,omitempty" gorm:"primaryKey"`
	SelectorID       string     `json:"selector_id,omitempty" gorm:"primaryKey"`
	RelationshipPath string     `json:"relationship_path,omitempty"`
	CreatedAt        time.Time  `json:"created_at,omitempty"`
	UpdatedAt        time.Time  `json:"updated_at,omitempty" gorm:"autoUpdateTime:false"`
	DeletedAt        *time.Time `json:"deleted_at,omitempty"`
}

type Components []*Component

type ConfigAccess struct {
	ID            string     `json:"id" gorm:"not null"`
	ApplicationID *uuid.UUID `json:"application_id" gorm:"default:null"`
	ScraperID     *uuid.UUID `json:"scraper_id" gorm:"default:null"`
	Source        *string    `json:"source" gorm:"default:null"`

	ConfigID        uuid.UUID  `json:"config_id"`
	ExternalUserID  *uuid.UUID `json:"external_user_id,omitempty"`
	ExternalGroupID *uuid.UUID `json:"external_group_id,omitempty"`
	ExternalRoleID  *uuid.UUID `json:"external_role_id,omitempty"`

	CreatedAt time.Time  `json:"created_at"`
	DeletedAt *time.Time `json:"deleted_at,omitempty"`
	DeletedBy *uuid.UUID `json:"deleted_by,omitempty"`
	CreatedBy *uuid.UUID `json:"created_by,omitempty"`

	LastReviewedAt *time.Time `json:"last_reviewed_at,omitempty"`
	LastReviewedBy *uuid.UUID `json:"last_reviewed_by,omitempty"`
}

type ConfigAccessLog struct {
	ConfigID       uuid.UUID     `json:"config_id" gorm:"primaryKey"`
	ExternalUserID uuid.UUID     `json:"external_user_id" gorm:"primaryKey"`
	ScraperID      uuid.UUID     `json:"scraper_id" gorm:"primaryKey"`
	CreatedAt      time.Time     `json:"created_at"`
	MFA            bool          `json:"mfa,omitempty" gorm:"default:null"`
	Properties     types.JSONMap `json:"properties,omitempty" gorm:"default:null"`
	Count          *int          `json:"count,omitempty" gorm:"default:1"`
}

type ConfigAccessSummary struct {
	ConfigID        uuid.UUID      `json:"config_id"`
	ConfigName      string         `json:"config_name"`
	ConfigType      string         `json:"config_type"`
	ExternalGroupID *uuid.UUID     `json:"external_group_id,omitempty"`
	ExternalUserID  uuid.UUID      `json:"external_user_id,omitempty"`
	Role            string         `json:"role"`
	RoleExternalIDs pq.StringArray `json:"role_external_ids,omitempty" gorm:"type:[]text"`
	User            string         `json:"user"`
	UserType        string         `json:"user_type"`
	Email           string         `json:"email"`
	CreatedAt       time.Time      `json:"created_at"`
	DeletedAt       *time.Time     `json:"deleted_at,omitempty"`
	CreatedBy       *uuid.UUID     `json:"created_by,omitempty"`
	LastSignedInAt  *time.Time     `json:"last_signed_in_at,omitempty"`
	LastReviewedAt  *time.Time     `json:"last_reviewed_at,omitempty"`
	LastReviewedBy  *uuid.UUID     `json:"last_reviewed_by,omitempty"`
}

type ConfigAnalysis struct {
	ID            uuid.UUID         `gorm:"primaryKey;unique_index;not null;column:id;default:generate_ulid()" json:"id"`
	ExternalID    string            `gorm:"-"`
	ConfigType    string            `gorm:"-"`
	ConfigID      uuid.UUID         `gorm:"column:config_id;default:''" json:"config_id"`
	ScraperID     *uuid.UUID        `gorm:"column:scraper_id;default:null" json:"scraper_id"`
	Analyzer      string            `gorm:"column:analyzer" json:"analyzer" faker:"oneof: ec2-instance-no-public-ip, eks-endpoint-no-public-access"`
	Message       string            `gorm:"column:message" json:"message"`
	Summary       string            `gorm:"column:summary;default:null" json:"summary,omitempty"`
	Status        string            `gorm:"column:status;default:null" json:"status,omitempty" faker:"oneof: open, resolved, silenced"`
	Severity      Severity          `gorm:"column:severity" json:"severity" faker:"oneof: critical, high, medium, low, info"`
	AnalysisType  AnalysisType      `gorm:"column:analysis_type" json:"analysis_type" faker:"oneof: availability, compliance, cost, security, performance"`
	Analysis      types.JSONMap     `gorm:"column:analysis" json:"analysis,omitempty"`
	Properties    *types.Properties `gorm:"column:properties;default:null" json:"properties,omitempty"`
	Source        string            `gorm:"column:source" json:"source,omitempty"`
	FirstObserved *time.Time        `gorm:"column:first_observed;default:now();<-:create" json:"first_observed"`

	// LastObserved is the timestamp the sraper last observed this analysis
	LastObserved *time.Time `gorm:"column:last_observed;default:no()" json:"last_observed"`

	// IsPushed when set to true indicates that the check status has been pushed to upstream.
	IsPushed bool `json:"is_pushed,omitempty"`
}

type ConfigChange struct {
	// ExternalID is the external identifier for the configuration change.
	// Note: This field is not stored in the database.
	ExternalID string `gorm:"-" json:"-"`

	// ConfigType represents the type of configuration.
	// Note: This field is not stored in the database.
	ConfigType string `gorm:"-" json:"-"`

	// Action describes the pipeline lifecycle action taken for this change
	// (e.g. inserted, updated, unchanged, move-up, copy-up, move, copy).
	// Note: This field is not stored in the database.
	Action string `gorm:"-" json:"action,omitempty"`

	// ExternalChangeID is the identifier for the change from an external system.
	ExternalChangeID *string `gorm:"column:external_change_id;default:null" json:"external_change_id"`

	// ID is the unique identifier for the configuration change.
	// It is automatically generated using ULID if not provided.
	ID string `gorm:"primaryKey;unique_index;not null;column:id;default:generate_ulid()" json:"id"`

	// ConfigID is the identifier of the associated configuration item.
	ConfigID string `gorm:"column:config_id;default:''" json:"config_id"`

	// ChangeType describes the nature of the configuration change.
	// Example values: RunInstances, diff
	ChangeType string `gorm:"column:change_type" json:"change_type" faker:"oneof:  RunInstances, diff" `

	// Severity indicates the importance or impact level of the change.
	// Possible values: critical, high, medium, low, info
	Severity Severity `json:"severity"  faker:"oneof: critical, high, medium, low, info"`

	// Source indicates the origin of the configuration change, e.g. Kubernetes, Cloudtrail
	Source string `json:"source"`

	// Summary provides a brief description of the change.
	Summary string `json:"summary,omitempty"`

	// Patches contains a JSON strategic merge patch
	Patches string `gorm:"column:patches;default:null" json:"patches,omitempty"`

	// Diff represents the differences introduced by this change.
	Diff *string `gorm:"column:diff;default:null" json:"diff,omitempty"`

	// Fingerprint is a uniquest identifier for the change, it ignores all UUID, numbers and timestamps to enable de-duplication of equivalent changes.
	Fingerprint *string `gorm:"column:fingerprint;default:null" json:"fingerprint,omitempty"`

	// Details contains additional information about the change in JSON format.
	Details types.JSON `json:"details,omitempty"`

	// CreatedAt represents the timestamp when the change was created or last observed
	CreatedAt *time.Time `json:"created_at"`

	// FirstObserved represents the timestamp when this change was first observed.
	FirstObserved *time.Time `gorm:"first_observed;default:now()" json:"first_observed,omitempty"`

	// Count is the number of occurrences of this change, including duplicates detected by fingerprinting
	Count int `json:"count"`

	// IsPushed indicates whether the change has been pushed to upstream.
	// When set to true, it means the status has been synchronized.
	IsPushed bool `json:"is_pushed,omitempty"`

	// CreatedBy is the UUID of the local user who created this change.
	CreatedBy *uuid.UUID `gorm:"column:created_by" json:"created_by,omitempty"`

	// ExternalCreatedBy is the name/email from the external system that created this change.
	ExternalCreatedBy *string `gorm:"column:external_created_by" json:"external_created_by,omitempty"`

	// Artifacts associated with this change (screenshots, HAR files, etc.)
	Artifacts []Artifact `gorm:"foreignKey:ConfigChangeID" json:"artifacts,omitempty"`
}

type ConfigChangeUpdate struct {
	Change         *ConfigChange
	CountIncrement int
	FirstInBatch   bool // First occurrence in current batch (not found in cache)
}

type ConfigComponentRelationship struct {
	ComponentID uuid.UUID  `json:"component_id,omitempty" gorm:"primaryKey"`
	ConfigID    uuid.UUID  `json:"config_id,omitempty" gorm:"primaryKey"`
	SelectorID  string     `json:"selector_id,omitempty"`
	CreatedAt   time.Time  `json:"created_at,omitempty"`
	UpdatedAt   *time.Time `json:"updated_at,omitempty" gorm:"autoUpdateTime:false"`
	DeletedAt   *time.Time `json:"deleted_at,omitempty"`
}

type ConfigCost struct {
	types.NoOpResourceSelectable `json:"-"`

	ID                      uuid.UUID     `json:"id" gorm:"default:generate_ulid()"`
	ConfigID                uuid.UUID     `json:"config_id"`
	ScraperID               *uuid.UUID    `json:"scraper_id,omitempty"`
	SourceKey               string        `json:"source_key"`
	ExternalID              *string       `json:"external_id,omitempty"`
	ExternalConfigType      *string       `json:"external_config_type,omitempty"`
	ExternalConfigScraperID *string       `json:"external_config_scraper_id,omitempty"`
	ExternalConfigLabels    types.JSONMap `json:"external_config_labels,omitempty" gorm:"type:jsonb"`

	PeriodStart time.Time `json:"period_start"`
	PeriodEnd   time.Time `json:"period_end"`
	Grain       string    `json:"grain"`

	ChargeCategory  string  `json:"charge_category"`
	ChargeClass     *string `json:"charge_class,omitempty"`
	ServiceName     *string `json:"service_name,omitempty"`
	ServiceCategory *string `json:"service_category,omitempty"`
	SkuID           *string `json:"sku_id,omitempty"`
	RegionID        *string `json:"region_id,omitempty"`
	BillingCurrency string  `json:"billing_currency"`

	BilledCost      decimal.Decimal  `json:"billed_cost"`
	EffectiveCost   decimal.Decimal  `json:"effective_cost"`
	ListCost        *decimal.Decimal `json:"list_cost,omitempty"`
	ContractedCost  *decimal.Decimal `json:"contracted_cost,omitempty"`
	PricingQuantity *decimal.Decimal `json:"pricing_quantity,omitempty"`
	PricingUnit     *string          `json:"pricing_unit,omitempty"`

	// Focus holds every dimension without a dedicated column: the FOCUS long tail
	// (Tags, SkuPriceDetails, CommitmentDiscount*, ...), all x_* custom columns, and the
	// demoted billing_account_id / sub_account_id.
	//
	// Demoted here does not mean demoted out of identity — the fingerprint still reads
	// the account keys back out by name, so spend from two sub-accounts never merges.
	Focus types.JSONMap `json:"focus,omitempty" gorm:"type:jsonb"`

	// Fingerprint is a deterministic hash of the dimension tuple. Together with
	// (source_key, config_id, period_start, period_end) it is the merge key.
	Fingerprint string `json:"fingerprint"`

	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type ConfigCostCompact struct {
	ConfigCost
}

type ConfigCostSummary struct {
	ConfigID        uuid.UUID       `json:"config_id" gorm:"column:config_id"`
	BillingCurrency string          `json:"billing_currency" gorm:"column:billing_currency"`
	Cost1h          decimal.Decimal `json:"cost_1h" gorm:"column:cost_1h"`
	Cost1d          decimal.Decimal `json:"cost_1d" gorm:"column:cost_1d"`
	Cost30d         decimal.Decimal `json:"cost_30d" gorm:"column:cost_30d"`
	Billed30d       decimal.Decimal `json:"billed_30d" gorm:"column:billed_30d"`
	LastCostAt      time.Time       `json:"last_cost_at" gorm:"column:last_cost_at"`
}

type ConfigItem struct {
	ID           uuid.UUID            `json:"id" faker:"uuid_hyphenated" gorm:"default:generate_ulid()"`
	ScraperID    *string              `json:"scraper_id,omitempty"`
	AgentID      uuid.UUID            `json:"agent_id,omitempty"`
	ConfigClass  string               `json:"config_class" faker:"oneof:File,EC2Instance,KubernetesPod" `
	ExternalID   pq.StringArray       `gorm:"type:[]text" json:"external_id,omitempty"`
	Type         *string              `json:"type"`
	Status       *string              `json:"status" gorm:"default:null"`
	Ready        bool                 `json:"ready"`
	Health       *Health              `json:"health"`
	Name         *string              `json:"name,omitempty" faker:"name"`
	Description  *string              `json:"description"`
	Config       *string              `json:"config"`
	Source       *string              `json:"source,omitempty"`
	ParentID     *uuid.UUID           `json:"parent_id,omitempty" faker:"-"`
	Path         string               `json:"path,omitempty" faker:"-"`
	Labels       *types.JSONStringMap `json:"labels,omitempty" faker:"labels"`
	Tags         types.JSONStringMap  `json:"tags,omitempty" faker:"tags"`
	Properties   *types.Properties    `json:"properties,omitempty"`
	CreatedAt    time.Time            `json:"created_at" gorm:"<-:create"`
	InsertedAt   time.Time            `json:"inserted_at" gorm:"->;default:now()"`
	UpdatedAt    *time.Time           `json:"updated_at" gorm:"autoUpdateTime:false"`
	DeletedAt    *time.Time           `json:"deleted_at,omitempty"`
	DeleteReason string               `json:"delete_reason,omitempty"`
	// contains filtered or unexported fields
}

type ConfigItemLastScrapedTime struct {
	ConfigID        uuid.UUID  `json:"config_id" gorm:"primaryKey"`
	LastScrapedTime *time.Time `json:"last_scraped_time,omitempty"`
}

type ConfigItemSummary struct {
	ID              uuid.UUID            `json:"id" gorm:"primaryKey"`
	ScraperID       *string              `json:"scraper_id,omitempty"`
	ConfigClass     string               `json:"config_class"`
	ExternalID      pq.StringArray       `gorm:"type:[]text" json:"external_id,omitempty"`
	Type            *string              `json:"type"`
	Name            *string              `json:"name,omitempty"`
	Namespace       *string              `json:"namespace,omitempty"`
	Description     *string              `json:"description"`
	Source          *string              `json:"source,omitempty"`
	Labels          *types.JSONStringMap `json:"labels,omitempty"`
	Tags            types.JSONStringMap  `json:"tags,omitempty"`
	CreatedBy       *uuid.UUID           `json:"created_by,omitempty"`
	CreatedAt       time.Time            `json:"created_at"`
	UpdatedAt       *time.Time           `json:"updated_at"`
	DeletedAt       *time.Time           `json:"deleted_at,omitempty"`
	CostPerMinute   *float64             `gorm:"column:cost_per_minute" json:"cost_per_minute,omitempty"`
	CostTotal1h     *float64             `gorm:"column:cost_total_1h" json:"cost_total_1h,omitempty"`
	CostTotal1d     *float64             `gorm:"column:cost_total_1d" json:"cost_total_1d,omitempty"`
	CostTotal30d    *float64             `gorm:"column:cost_total_30d" json:"cost_total_30d,omitempty"`
	BillingCurrency *string              `gorm:"column:billing_currency" json:"billing_currency,omitempty"`
	MixedCurrency   bool                 `gorm:"column:mixed_currency" json:"mixed_currency"`
	AgentID         uuid.UUID            `json:"agent_id,omitempty"`
	Status          *string              `json:"status"`
	Health          *Health              `json:"health"`
	Ready           bool                 `json:"ready"`
	Path            string               `json:"path,omitempty"`
	Changes         int                  `json:"changes,omitempty"`
	Analysis        *types.JSONMap       `json:"analysis,omitempty"`
}

type ConfigLocation struct {
	ID       uuid.UUID `json:"id"`
	Location string    `json:"location"`
}

type ConfigRelationship struct {
	ConfigID  string `json:"config_id"`
	RelatedID string `json:"related_id"`
	Relation  string `json:"relation"`
	// ScraperID identifies the scraper that owns this relationship.
	ScraperID  *uuid.UUID `json:"scraper_id"`
	SelectorID string     `json:"selector_id"`
	CreatedAt  time.Time  `json:"created_at,omitempty"`
	UpdatedAt  time.Time  `json:"updated_at,omitempty" gorm:"autoUpdateTime:false"`
	DeletedAt  *time.Time `json:"deleted_at,omitempty"`
}

type ConfigScraper struct {
	ID            uuid.UUID  `json:"id"`
	AgentID       uuid.UUID  `json:"agent_id,omitempty"`
	Name          string     `json:"name"`
	Namespace     string     `json:"namespace"`
	Description   string     `json:"description,omitempty"`
	Spec          string     `json:"spec,omitempty"`
	Source        string     `json:"source,omitempty"`
	ApplicationID *uuid.UUID `json:"application_id,omitempty" gorm:"default:null"`
	CreatedBy     *uuid.UUID `json:"created_by,omitempty"`
	CreatedAt     time.Time  `json:"created_at" gorm:"<-:create"`
	UpdatedAt     *time.Time `json:"updated_at" gorm:"autoUpdateTime:false"`
	DeletedAt     *time.Time `json:"deleted_at,omitempty"`
}

type Connection struct {
	ID          uuid.UUID           `gorm:"primaryKey;unique_index;not null;column:id;default:generate_ulid()" json:"id" faker:"uuid_hyphenated"  `
	Name        string              `gorm:"column:name" json:"name" faker:"name"  `
	Namespace   string              `gorm:"column:namespace" json:"namespace"`
	Source      string              `json:"source"`
	Type        string              `gorm:"column:type" json:"type" faker:"oneof:  postgres, mysql, aws, gcp, http" `
	URL         string              `gorm:"column:url" json:"url,omitempty" faker:"url" template:"true"`
	Username    string              `gorm:"column:username" json:"username,omitempty" faker:"username"  `
	Password    string              `gorm:"column:password" json:"password,omitempty" faker:"password"  `
	Properties  types.JSONStringMap `gorm:"column:properties" json:"properties,omitempty" faker:"-" template:"true"`
	Certificate string              `gorm:"column:certificate" json:"certificate,omitempty" faker:"-"  `
	InsecureTLS bool                `gorm:"column:insecure_tls;default:false" json:"insecure_tls,omitempty" faker:"-"  `
	CreatedAt   time.Time           `gorm:"column:created_at;default:now();<-:create" json:"created_at,omitempty" faker:"-"  `
	UpdatedAt   time.Time           `gorm:"column:updated_at;default:now()" json:"updated_at,omitempty" faker:"-"  `
	CreatedBy   *uuid.UUID          `gorm:"column:created_by" json:"created_by,omitempty" faker:"-"  `
}

type Contextable interface {
	Context() map[string]any
}

type DBTable interface {
	PK() string
	TableName() string
}

type Deleteable interface {
	Delete(db *gorm.DB) error
}

type EnvPrep struct {
	// Env is the connection credentials in environment variables
	Env []string

	// CmdEnvs is a list of env vars that will be passed to the command
	CmdEnvs []string

	// List of commands that need to be run before the actual command.
	// These commands will setup the connection.
	PreRuns []*exec.Cmd

	// File contains the content of the configuration file based on the connection
	Files map[string]bytes.Buffer
}

type Event struct {
	ID          uuid.UUID           `gorm:"default:generate_ulid()"`
	EventID     uuid.UUID           `json:"event_id"`
	Name        string              `json:"name"`
	CreatedAt   time.Time           `json:"created_at"`
	Properties  types.JSONStringMap `json:"properties"`
	Delay       *time.Duration      `json:"delay,omitempty"`
	Error       *string             `json:"error,omitempty"`
	Attempts    int                 `json:"attempts"`
	LastAttempt *time.Time          `json:"last_attempt"`
	Priority    int                 `json:"priority"`
}

type EventQueueSummary struct {
	EventID       uuid.UUID  `json:"event_id"`
	Name          string     `json:"name"`
	Pending       int64      `json:"pending"`
	Failed        int64      `json:"failed"`
	AvgAttempts   int64      `json:"average_attempts"`
	FirstFailure  *time.Time `json:"first_failure,omitempty"`
	LastFailure   *time.Time `json:"last_failure,omitempty"`
	MostCommonErr string     `json:"most_common_error,omitempty"`
}

type Events []Event

type Evidence struct {
	ID               uuid.UUID     `json:"id"`
	HypothesisID     uuid.UUID     `json:"hypothesis_id"`
	ConfigID         *uuid.UUID    `json:"config_id"`
	ConfigChangeID   *uuid.UUID    `json:"config_change_id"`
	ConfigAnalysisID *uuid.UUID    `json:"config_analysis_id"`
	ComponentID      *uuid.UUID    `json:"component_id"`
	CheckID          *uuid.UUID    `json:"check_id"`
	Description      string        `json:"description"`
	DefinitionOfDone bool          `json:"definition_of_done"`
	Done             bool          `json:"done"`
	Factor           bool          `json:"factor"`
	Mitigator        bool          `json:"mitigator"`
	CreatedBy        uuid.UUID     `json:"created_by"`
	Type             string        `json:"type"`
	Script           string        `json:"script"`
	ScriptResult     string        `json:"script_result"`
	Evidence         types.JSONMap `json:"evidence"`
	Properties       types.JSONMap `json:"properties"`
	CreatedAt        time.Time     `json:"created_at"`
	UpdatedAt        time.Time     `json:"updated_at"`
}

type EvidenceCanaryCheck struct {
}

type EvidenceComponent struct {
}

type EvidenceConfig struct {
	ID            uuid.UUID           `json:"id"`
	Lines         []string            `json:"lines"`
	SelectedLines types.JSONStringMap `json:"selected_lines"`
}

type EvidenceConfigAnalysis struct {
	ID uuid.UUID `json:"id"`
}

type EvidenceConfigChange struct {
	ID uuid.UUID `json:"id"`
}

type EvidenceLogs struct {
	Lines []LogLine `json:"lines"`
}

type ExtendedDBTable interface {
	DBTable
	Value() any
	PKCols() []clause.Column
}

type ExternalGroup struct {
	types.NoOpResourceSelectable `json:"-"`

	ID        uuid.UUID      `json:"id"`
	ScraperID uuid.UUID      `json:"scraper_id" gorm:"not null"`
	Tenant    string         `json:"account_id" gorm:"column:account_id"`
	Aliases   pq.StringArray `json:"aliases,omitempty" gorm:"type:[]text"`
	Name      string         `json:"name"`
	CreatedAt time.Time      `json:"created_at" gorm:"not null"`
	UpdatedAt *time.Time     `json:"updated_at" gorm:"autoUpdateTime:false"`
	DeletedAt *time.Time     `json:"deleted_at,omitempty"`
	GroupType string         `json:"group_type"`
}

type ExternalID struct {
	ConfigType string
	ExternalID []string
}