storage

type InstallationRecord struct {
	Key              string
	AgentID          string
	AgentName        string
	InstallMethod    string
	InstalledVersion string
	LatestVersion    string
	ExecutablePath   string
	InstallPath      string
	FirstDetectedAt  time.Time
	LastCheckedAt    time.Time
	LastUpdatedAt    *time.Time
	Metadata         map[string]string
}

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

type Store interface {
	// Initialize sets up the database and runs migrations.
	Initialize(ctx context.Context) error

	// Close closes the storage connection.
	Close() error

	// Installation operations
	SaveInstallation(ctx context.Context, inst *agent.Installation) error
	GetInstallation(ctx context.Context, key string) (*agent.Installation, error)
	ListInstallations(ctx context.Context, filter *agent.Filter) ([]*agent.Installation, error)
	DeleteInstallation(ctx context.Context, key string) error

	// Update history operations
	SaveUpdateEvent(ctx context.Context, event *UpdateEvent) error
	GetUpdateHistory(ctx context.Context, agentID string, limit int) ([]*UpdateEvent, error)

	// Catalog cache operations
	SaveCatalogCache(ctx context.Context, data []byte, etag string) error
	GetCatalogCache(ctx context.Context) ([]byte, string, time.Time, error)

	// Detection cache operations
	SaveDetectionCache(ctx context.Context, installations []*agent.Installation) error
	GetDetectionCache(ctx context.Context) ([]*agent.Installation, time.Time, error)
	ClearDetectionCache(ctx context.Context) error
	GetDetectionCacheTime(ctx context.Context) (time.Time, error)
	SetLastUpdateCheckTime(ctx context.Context, t time.Time) error
	GetLastUpdateCheckTime(ctx context.Context) (time.Time, error)

	// Settings operations
	GetSetting(ctx context.Context, key string) (string, error)
	SetSetting(ctx context.Context, key, value string) error
	DeleteSetting(ctx context.Context, key string) error
}

type UpdateEvent struct {
	ID            int64
	AgentID       string
	AgentName     string
	InstallMethod string
	FromVersion   string
	ToVersion     string
	Status        UpdateStatus
	ErrorMessage  string
	StartedAt     time.Time
	CompletedAt   *time.Time
}

type UpdateStatus string