hostsqlitedb

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type ListPrimaryAgentsParams struct {
	Backend    string
	ProjectDir string
	WorktreeID string
}

type PrimaryAgent struct {
	Backend           string
	ProjectDir        string
	WorktreeID        string
	PrimaryAgentsJson string
	UpdatedAt         int64
}

type Querier interface {
	DeleteSession(ctx context.Context, id string) error
	// Removes every session belonging to a worktree. Used when a worktree is
	// deleted (full cleanup), alongside removing its materialized ~/work/<id>.
	DeleteSessionsByWorktree(ctx context.Context, worktreeID string) error
	FindSessionByExternalID(ctx context.Context, externalID string) (Session, error)
	GetSession(ctx context.Context, id string) (Session, error)
	ListPrimaryAgents(ctx context.Context, arg ListPrimaryAgentsParams) (string, error)
	ListSessions(ctx context.Context) ([]Session, error)
	// Used by session-sync to enumerate sessions in a worktree for export.
	// worktree_id is the host-minted worktree ULID; cross-machine stable identity.
	ListSessionsByWorktree(ctx context.Context, worktreeID string) ([]Session, error)
	// Filtered list. Empty filter values are treated as "no filter" by
	// the query (NULL/empty matches anything for that column). Visibility
	// filter is exact match.
	SearchSessions(ctx context.Context, arg SearchSessionsParams) ([]Session, error)
	UpsertPrimaryAgents(ctx context.Context, arg UpsertPrimaryAgentsParams) error
	UpsertSession(ctx context.Context, arg UpsertSessionParams) error
}

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

type SearchSessionsParams struct {
	Q          string
	Visibility string
	Since      interface{}
	Until      interface{}
	Lim        int64
}

type Session struct {
	ID             string
	ExternalID     string
	Backend        string
	Status         string
	Visibility     string
	FollowUp       int64
	ProjectDir     string
	WorktreeID     string
	WorktreeBranch string
	Prompt         string
	Title          string
	TicketID       string
	Agent          string
	Draft          string
	CreatedAt      int64
	UpdatedAt      int64
	LastReadAt     sql.NullInt64
	Subdir         string
	DisplayName    string
	Config         string
}

type UpsertPrimaryAgentsParams struct {
	Backend           string
	ProjectDir        string
	WorktreeID        string
	PrimaryAgentsJson string
	UpdatedAt         int64
}

type UpsertSessionParams struct {
	ID             string
	ExternalID     string
	Backend        string
	Status         string
	Visibility     string
	FollowUp       int64
	ProjectDir     string
	WorktreeID     string
	WorktreeBranch string
	Subdir         string
	DisplayName    string
	Prompt         string
	Title          string
	TicketID       string
	Agent          string
	Draft          string
	Config         string
	CreatedAt      int64
	UpdatedAt      int64
	LastReadAt     sql.NullInt64
}