models

type APIKey struct {
	ID         uuid.UUID  `db:"id"           json:"id"`
	Name       string     `db:"name"         json:"name"`
	KeyHash    string     `db:"key_hash"     json:"-"`
	Prefix     string     `db:"prefix"       json:"prefix"`
	CreatedAt  time.Time  `db:"created_at"   json:"created_at"`
	LastUsedAt *time.Time `db:"last_used_at" json:"last_used_at,omitempty"`
	ExpiresAt  *time.Time `db:"expires_at"   json:"expires_at,omitempty"`
	RevokedAt  *time.Time `db:"revoked_at"   json:"revoked_at,omitempty"`
	Active     bool       `db:"active"       json:"active"`
	OrgID      *uuid.UUID `db:"org_id"     json:"org_id,omitempty"`
}

type AuditLog struct {
	ID        uuid.UUID  `db:"id"         json:"id"`
	Timestamp time.Time  `db:"timestamp"  json:"timestamp"`
	Actor     string     `db:"actor"      json:"actor"`
	SessionID *uuid.UUID `db:"session_id" json:"session_id,omitempty"`
	RunID     *uuid.UUID `db:"run_id"     json:"run_id,omitempty"`
	Action    string     `db:"action"     json:"action"`
	Metadata  JSONB      `db:"metadata"   json:"metadata"`
	// Sig is an HMAC-SHA256 hex digest over the immutable fields of this entry.
	// It is empty when AUDIT_HMAC_KEY is not configured. Non-empty values can be
	// verified with VerifyAuditSig to detect tampering after the fact.
	Sig string `db:"sig" json:"sig,omitempty"`
}

type File struct {
	ID          uuid.UUID `db:"id"           json:"id"`
	SessionID   uuid.UUID `db:"session_id"   json:"session_id"`
	Path        string    `db:"path"         json:"path"`
	SizeBytes   int64     `db:"size_bytes"   json:"size_bytes"`
	ContentType string    `db:"content_type" json:"content_type"`
	CreatedAt   time.Time `db:"created_at"   json:"created_at"`
	UpdatedAt   time.Time `db:"updated_at"   json:"updated_at"`
}

type JSONB map[string]interface{}

type OrgMember struct {
	OrgID     uuid.UUID `db:"org_id"    json:"org_id"`
	Principal string    `db:"principal" json:"principal"`
	Role      string    `db:"role"      json:"role"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`
}

type Organization struct {
	ID        uuid.UUID `db:"id"         json:"id"`
	Name      string    `db:"name"       json:"name"`
	Slug      string    `db:"slug"       json:"slug"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`
	UpdatedAt time.Time `db:"updated_at" json:"updated_at"`
}

type Run struct {
	ID             uuid.UUID   `db:"id"              json:"id"`
	SessionID      uuid.UUID   `db:"session_id"      json:"session_id"`
	Command        string      `db:"command"         json:"command"`
	Args           StringArray `db:"args"            json:"args"`
	Env            JSONB       `db:"env"             json:"-"` // may contain secrets — never expose to callers
	WorkingDir     string      `db:"working_dir"     json:"working_dir"`
	Status         string      `db:"status"          json:"status"`
	ExitCode       *int        `db:"exit_code"       json:"exit_code,omitempty"`
	Stdout         *string     `db:"stdout"          json:"stdout,omitempty"`
	Stderr         *string     `db:"stderr"          json:"stderr,omitempty"`
	DurationMS     *int64      `db:"duration_ms"     json:"duration_ms,omitempty"`
	TimeoutSeconds int         `db:"timeout_seconds" json:"timeout_seconds"`
	CreatedAt      time.Time   `db:"created_at"      json:"created_at"`
	UpdatedAt      time.Time   `db:"updated_at"      json:"updated_at"`
	StartedAt      *time.Time  `db:"started_at"       json:"started_at,omitempty"`
	FinishedAt     *time.Time  `db:"finished_at"      json:"finished_at,omitempty"`
	// CallbackURL is stored but never returned in API responses (may contain secrets).
	CallbackURL *string `db:"callback_url"     json:"-"`
	// OutputTruncated is not persisted; set in-memory when docker capped output.
	OutputTruncated bool `db:"-"                json:"output_truncated,omitempty"`
}

type SSOUser struct {
	ID          uuid.UUID  `db:"id"            json:"id"`
	Email       string     `db:"email"         json:"email"`
	Name        string     `db:"name"          json:"name"`
	Provider    string     `db:"provider"      json:"provider"`
	ExternalID  string     `db:"external_id"   json:"-"` // OIDC sub or SAML NameID
	APIKeyID    *uuid.UUID `db:"api_key_id"    json:"-"`
	CreatedAt   time.Time  `db:"created_at"    json:"created_at"`
	LastLoginAt time.Time  `db:"last_login_at" json:"last_login_at"`
}

type Session struct {
	ID             uuid.UUID `db:"id"               json:"id"`
	Name           *string   `db:"name"             json:"name,omitempty"`
	Image          string    `db:"image"            json:"image"`
	Status         string    `db:"status"           json:"status"`
	ContainerID    *string   `db:"container_id"     json:"container_id,omitempty"`
	NetworkEnabled bool      `db:"network_enabled"  json:"network_enabled"`
	CPULimit       float64   `db:"cpu_limit"        json:"cpu_limit"`
	MemoryLimitMB  int       `db:"memory_limit_mb"  json:"memory_limit_mb"`
	TimeoutSeconds int       `db:"timeout_seconds"  json:"timeout_seconds"`
	WorkspacePath  string    `db:"workspace_path"   json:"-"` // internal host path — never expose to callers
	Labels         JSONB     `db:"labels"           json:"labels"`
	// AllowedHosts is an optional list of hostnames or CIDRs the container may
	// reach when NetworkEnabled is true. An empty list means unrestricted bridge
	// access. Entries are resolved to /etc/hosts at container creation time.
	// For full egress enforcement, operators should pair this with host iptables.
	AllowedHosts StringArray `db:"allowed_hosts"    json:"allowed_hosts,omitempty"`
	CreatedBy    string      `db:"created_by"       json:"created_by"`
	CreatedAt    time.Time   `db:"created_at"       json:"created_at"`
	UpdatedAt    time.Time   `db:"updated_at"       json:"updated_at"`
	StoppedAt    *time.Time  `db:"stopped_at"       json:"stopped_at,omitempty"`
	OrgID        *uuid.UUID  `db:"org_id"           json:"org_id,omitempty"`
}

type SharedArtifact struct {
	ID           uuid.UUID  `db:"id"            json:"id"`
	Name         string     `db:"name"          json:"name"`
	ArtifactPath string     `db:"artifact_path" json:"-"` // host path — never expose
	SizeBytes    int64      `db:"size_bytes"    json:"size_bytes"`
	ContentType  string     `db:"content_type"  json:"content_type"`
	CreatedBy    string     `db:"created_by"    json:"created_by"`
	SessionID    *uuid.UUID `db:"session_id"    json:"session_id,omitempty"`
	CreatedAt    time.Time  `db:"created_at"    json:"created_at"`
}

type Snapshot struct {
	ID          uuid.UUID `db:"id"           json:"id"`
	SessionID   uuid.UUID `db:"session_id"   json:"session_id"`
	Name        string    `db:"name"         json:"name"`
	CreatedBy   string    `db:"created_by"   json:"created_by"`
	SizeBytes   int64     `db:"size_bytes"   json:"size_bytes"`
	ArchivePath string    `db:"archive_path" json:"-"` // host path — never expose
	CreatedAt   time.Time `db:"created_at"   json:"created_at"`
}

type StringArray []string