store

type AIResult struct {
	Summary    string
	Tags       []string
	Platforms  []string
	Category   string
	SearchText string
}

type Category struct {
	ID        string
	Name      string
	Keywords  []string
	SortOrder int
	IsCustom  bool
	IsHidden  bool
}

type CustomFields struct {
	Description    string
	Tags           []string
	Category       string
	CategoryLocked bool
}

type FTSResult struct {
	Repo      *Repository
	BM25Score float64
}

type Release struct {
	ID           int64
	RepoID       int64
	RepoFullName string
	TagName      string
	Name         string
	Body         string
	HTMLURL      string
	PublishedAt  string
	IsPrerelease bool
	IsDraft      bool
	IsRead       bool
	Assets       []ReleaseAsset
}

type ReleaseAsset struct {
	Name        string `json:"name"`
	URL         string `json:"url"`
	Size        int64  `json:"size"`
	ContentType string `json:"content_type"`
}

type Repository struct {
	ID                 int64
	FullName           string
	Name               string
	Description        string
	URL                string
	Language           string
	Homepage           string
	StargazersCount    int
	ForksCount         int
	Topics             []string
	OwnerLogin         string
	OwnerAvatar        string
	StarredAt          string
	AISummary          string
	AITags             []string
	AIPlatforms        []string
	AICategory         string
	AISearchText       string
	AnalyzedAt         *time.Time
	AnalysisFailed     bool
	CustomDescription  string
	CustomTags         []string
	CustomCategory     string
	CategoryLocked     bool
	SubscribedReleases bool
	LastReleaseFetch   *time.Time
}

type SearchFilters struct {
	Language string
	Category string
	MinStars int
	MaxStars int
	Platform string
	Limit    int
}

type Store interface {
	Close() error

	UpsertRepository(ctx context.Context, r *Repository) error
	UpsertRepositories(ctx context.Context, rs []*Repository) error
	UpsertReposOnSync(ctx context.Context, rs []*Repository, fullSync bool) error
	GetRepository(ctx context.Context, fullName string) (*Repository, error)
	ListRepositories(ctx context.Context) ([]*Repository, error)
	ListUnanalyzed(ctx context.Context, limit int) ([]*Repository, error)
	ListByCategory(ctx context.Context, category string) ([]*Repository, error)
	UpdateAIResult(ctx context.Context, repoID int64, res *AIResult) error
	UpdateCustomFields(ctx context.Context, repoID int64, f *CustomFields) error
	SetAnalysisFailed(ctx context.Context, repoID int64, failed bool) error
	DeleteAllRepositories(ctx context.Context) error

	SearchFTS(ctx context.Context, query string, filters *SearchFilters) ([]*FTSResult, error)
	RebuildFTSIndex(ctx context.Context) error

	UpsertRelease(ctx context.Context, r *Release) error
	ListUnreadReleases(ctx context.Context) ([]*Release, error)
	ListAllReleases(ctx context.Context) ([]*Release, error)
	ListReleasesByRepo(ctx context.Context, repoFullName string) ([]*Release, error)
	MarkReleaseRead(ctx context.Context, releaseID int64) error
	MarkAllReleasesRead(ctx context.Context) error
	SetReleaseSubscription(ctx context.Context, repoFullName string, subscribed bool) error
	UpdateReleaseWatermark(ctx context.Context, repoID int64, t time.Time) error

	ListCategories(ctx context.Context, visibleOnly bool) ([]*Category, error)
	UpsertCategory(ctx context.Context, c *Category) error
	DeleteCategory(ctx context.Context, id string) error

	GetSyncState(ctx context.Context, key string) (string, error)
	SetSyncState(ctx context.Context, key, value string) error
}