db

type AppState struct {
	AppName   string    `gorm:"primaryKey;type:text" json:"app_name"`
	Key       string    `gorm:"primaryKey;type:text" json:"key"`
	Value     []byte    `json:"value"`
	UpdatedAt time.Time `gorm:"not null" json:"updated_at"`
}

type Approval struct {
	ID            string     `gorm:"primaryKey;type:text" json:"id"`
	ThreadID      string     `gorm:"type:text;not null;index:idx_approvals_thread" json:"thread_id"`
	RunID         string     `gorm:"type:text;not null" json:"run_id"`
	TenantID      string     `gorm:"type:text;default:'';index:idx_approvals_tenant" json:"tenant_id,omitempty"`
	ToolName      string     `gorm:"type:text;not null" json:"tool_name"`
	Args          string     `gorm:"type:text;not null;default:''" json:"args"`
	Status        string     `gorm:"type:text;not null;default:'pending';index:idx_approvals_status" json:"status"`
	CreatedAt     time.Time  `gorm:"not null" json:"created_at"`
	ExpiresAt     *time.Time `gorm:"index:idx_approvals_expires" json:"expires_at,omitempty"`
	ResolvedAt    *time.Time `json:"resolved_at,omitempty"`
	ResolvedBy    string     `gorm:"type:text;default:''" json:"resolved_by,omitempty"`
	CreatedBy     string     `gorm:"type:text;default:''" json:"created_by,omitempty"`
	Feedback      string     `gorm:"type:text;default:''" json:"feedback,omitempty"`
	SenderContext string     `gorm:"type:text;default:''" json:"sender_context,omitempty"`
	Question      string     `gorm:"type:text;default:''" json:"question,omitempty"`
}

type Clarification struct {
	ID            uuid.UUID     `gorm:"primaryKey;type:text" json:"id"`
	Question      string        `gorm:"type:text;not null" json:"question"`                                                 // the question shown to the user
	Context       string        `gorm:"type:text;default:''" json:"context,omitempty"`                                      // optional LLM-provided context
	Answer        string        `gorm:"type:text;default:''" json:"answer,omitempty"`                                       // the user's response (empty until answered)
	Status        ClarifyStatus `gorm:"type:text;not null;default:'pending';index:idx_clarifications_status" json:"status"` // pending → answered | expired
	SenderContext string        `gorm:"type:text;default:''" json:"sender_context,omitempty"`                               // opaque platform sender ID (e.g. "slack:U1234:C5678")
	CreatedAt     time.Time     `gorm:"not null" json:"created_at"`
	AnsweredAt    *time.Time    `json:"answered_at,omitempty"` // set when status transitions to answered or expired
}

type ClarifyStatus string

type Config struct {
	// DBFile is the path to the SQLite database file.
	// Defaults to ~/.genie/genie.db when neither DBFile nor DSN is set.
	DBFile string `json:"db_file" toml:"db_file,omitempty" yaml:"db_file,omitempty"`

	// DSN is a PostgreSQL connection string (e.g. "postgres://user:pass@host:5432/dbname?sslmode=disable").
	// When set, PostgreSQL is used instead of SQLite.
	DSN string `json:"dsn,omitempty" toml:"dsn,omitempty" yaml:"dsn,omitempty"`
}

type CronHistory struct {
	ID         uuid.UUID  `gorm:"primaryKey;type:text" json:"id"`
	TaskID     uuid.UUID  `gorm:"type:text;not null;index:idx_cron_history_task" json:"task_id"`
	TaskName   string     `gorm:"type:text;not null" json:"task_name"`
	StartedAt  time.Time  `gorm:"not null" json:"started_at"`
	FinishedAt *time.Time `json:"finished_at,omitempty"`
	Status     CronStatus `gorm:"type:text;not null;default:'running';index:idx_cron_history_status" json:"status"` // running, success, failed
	Error      string     `gorm:"type:text;default:''" json:"error,omitempty"`
	RunID      string     `gorm:"type:text;default:''" json:"run_id,omitempty"` // BackgroundWorker run ID
}

type CronStatus string

type CronTask struct {
	ID              uuid.UUID  `gorm:"primaryKey;type:text" json:"id"`
	Name            string     `gorm:"type:text;not null;uniqueIndex" json:"name"`
	Expression      string     `gorm:"type:text;not null" json:"expression"`
	Action          string     `gorm:"type:text;not null" json:"action"`
	Enabled         bool       `gorm:"not null;default:true" json:"enabled"`
	Source          string     `gorm:"type:text;not null;default:'config'" json:"source"` // "config" or "tool"
	LastTriggeredAt *time.Time `json:"last_triggered_at,omitempty"`                       // last successful dispatch
	NextRunAt       *time.Time `gorm:"index:idx_cron_tasks_next_run" json:"next_run_at"`  // pre-computed next due time
	CreatedAt       time.Time  `gorm:"not null" json:"created_at"`
	UpdatedAt       time.Time  `gorm:"not null" json:"updated_at"`
}

type GormCheckpointSaver struct {
	// contains filtered or unexported fields
}

type Memory struct {
	ID        uuid.UUID `gorm:"primaryKey;type:text" json:"id"`
	AppName   string    `gorm:"type:text;not null;index:idx_memories_key" json:"app_name"`
	UserID    string    `gorm:"type:text;not null;index:idx_memories_key" json:"user_id"`
	Content   string    `gorm:"type:text;not null" json:"content"`
	Topics    string    `gorm:"type:text;not null;default:'[]'" json:"topics"` // JSON encoded string array
	CreatedAt time.Time `gorm:"not null" json:"created_at"`
	UpdatedAt time.Time `gorm:"not null" json:"updated_at"`
}

type MemoryStore struct {
	// contains filtered or unexported fields
}

type RetryOption func(*retryCheckpointSaver)

type SessionEvent struct {
	ID        uint      `gorm:"primaryKey;autoIncrement" json:"id"`
	AppName   string    `gorm:"type:text;not null;index:idx_session_events_key" json:"app_name"`
	UserID    string    `gorm:"type:text;not null;index:idx_session_events_key" json:"user_id"`
	SessionID string    `gorm:"type:text;not null;index:idx_session_events_key" json:"session_id"`
	EventData string    `gorm:"type:text;not null" json:"event_data"` // JSON-encoded event.Event
	CreatedAt time.Time `gorm:"not null" json:"created_at"`
}

type SessionRow struct {
	AppName   string    `gorm:"primaryKey;type:text" json:"app_name"`
	UserID    string    `gorm:"primaryKey;type:text" json:"user_id"`
	SessionID string    `gorm:"primaryKey;type:text" json:"session_id"`
	CreatedAt time.Time `gorm:"not null" json:"created_at"`
	UpdatedAt time.Time `gorm:"not null;index:idx_sessions_updated" json:"updated_at"`
}

type SessionState struct {
	AppName   string    `gorm:"primaryKey;type:text" json:"app_name"`
	UserID    string    `gorm:"primaryKey;type:text" json:"user_id"`
	SessionID string    `gorm:"primaryKey;type:text" json:"session_id"`
	Key       string    `gorm:"primaryKey;type:text" json:"key"`
	Value     []byte    `json:"value"`
	UpdatedAt time.Time `gorm:"not null" json:"updated_at"`
}

type SessionStore struct {
	// contains filtered or unexported fields
}

type SessionStoreBuilder func(ctx context.Context, db *gorm.DB, opts ...SessionStoreOption) *SessionStore

type SessionStoreOption func(*sessionStoreOpts)

type SessionSummaryRow struct {
	AppName   string    `gorm:"primaryKey;type:text" json:"app_name"`
	UserID    string    `gorm:"primaryKey;type:text" json:"user_id"`
	SessionID string    `gorm:"primaryKey;type:text" json:"session_id"`
	FilterKey string    `gorm:"primaryKey;type:text" json:"filter_key"` // "" = full-session summary
	Summary   string    `gorm:"type:text;not null" json:"summary"`
	Topics    string    `gorm:"type:text;default:'[]'" json:"topics"` // JSON-encoded []string
	UpdatedAt time.Time `gorm:"not null" json:"updated_at"`
}

type ShortMemory struct {
	// Key is the primary lookup key (e.g. a message ID for reaction correlation).
	Key string `gorm:"primaryKey;type:text" json:"key"`
	// MemoryType logically separates different subsystems sharing this table
	// (e.g. "reaction_ledger", "cooldown_tracker").
	MemoryType string `gorm:"primaryKey;type:text;index:idx_short_memory_type" json:"memory_type"`
	// Value stores the subsystem-specific data as JSON.
	Value string `gorm:"type:text;not null" json:"value"`
	// ExpiresAt is when this entry should be considered expired.
	// Queries should filter WHERE expires_at > NOW().
	ExpiresAt time.Time `gorm:"not null;index:idx_short_memory_expires" json:"expires_at"`
	// CreatedAt tracks when the entry was first created.
	CreatedAt time.Time `gorm:"not null" json:"created_at"`
}

type ShortMemoryStore struct {
	// contains filtered or unexported fields
}

type UserState struct {
	AppName   string    `gorm:"primaryKey;type:text" json:"app_name"`
	UserID    string    `gorm:"primaryKey;type:text" json:"user_id"`
	Key       string    `gorm:"primaryKey;type:text" json:"key"`
	Value     []byte    `json:"value"`
	UpdatedAt time.Time `gorm:"not null" json:"updated_at"`
}