db

type CertificateQuerier interface {
	ListCertificateValidations(ctx context.Context) ([]CertificateValidation, error)
	GetCertificateValidation(ctx context.Context, hostname string, certificateHash string) (CertificateValidation, error)
	GetCertificateValidationByHostname(ctx context.Context, hostname string) (CertificateValidation, error)
	StoreCertificateValidation(ctx context.Context, hostname string, certificateHash string, userDecision string, expiresAt sql.NullTime) error
	DeleteCertificateValidation(ctx context.Context, hostname string, certificateHash string) error
	DeleteExpiredCertificateValidations(ctx context.Context) error
}

type CertificateValidation struct {
	ID              int64        `json:"id"`
	Hostname        string       `json:"hostname"`
	CertificateHash string       `json:"certificate_hash"`
	UserDecision    string       `json:"user_decision"`
	CreatedAt       sql.NullTime `json:"created_at"`
	ExpiresAt       sql.NullTime `json:"expires_at"`
}

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 DatabaseQuerier interface {
	ZoomQuerier
	HistoryQuerier
	CertificateQuerier
	FavoritesQuerier
}

type Favorite struct {
	ID         int64          `json:"id"`
	Url        string         `json:"url"`
	Title      sql.NullString `json:"title"`
	FaviconUrl sql.NullString `json:"favicon_url"`
	Position   int64          `json:"position"`
	CreatedAt  sql.NullTime   `json:"created_at"`
	UpdatedAt  sql.NullTime   `json:"updated_at"`
}

type FavoritesQuerier interface {
	GetAllFavorites(ctx context.Context) ([]Favorite, error)
	GetFavoriteByURL(ctx context.Context, url string) (Favorite, error)
	CreateFavorite(ctx context.Context, url string, title sql.NullString, faviconUrl sql.NullString) error
	UpdateFavorite(ctx context.Context, title sql.NullString, faviconUrl sql.NullString, url string) error
	DeleteFavorite(ctx context.Context, url string) error
	IsFavorite(ctx context.Context, url string) (int64, error)
	UpdateFavoritePosition(ctx context.Context, position int64, url string) error
	GetFavoriteCount(ctx context.Context) (int64, error)
}

type FuzzyCacheMetadatum struct {
	ID           int64  `json:"id"`
	Version      int64  `json:"version"`
	EntryCount   int64  `json:"entry_count"`
	LastModified int64  `json:"last_modified"`
	EntriesHash  string `json:"entries_hash"`
}

type FuzzyCacheStructure struct {
	ID           int64  `json:"id"`
	TrigramIndex []byte `json:"trigram_index"`
	PrefixTrie   []byte `json:"prefix_trie"`
	SortedIndex  []byte `json:"sorted_index"`
}

type History struct {
	ID          int64          `json:"id"`
	Url         string         `json:"url"`
	Title       sql.NullString `json:"title"`
	VisitCount  sql.NullInt64  `json:"visit_count"`
	LastVisited sql.NullTime   `json:"last_visited"`
	CreatedAt   sql.NullTime   `json:"created_at"`
	FaviconUrl  sql.NullString `json:"favicon_url"`
}

type HistoryQuerier interface {
	GetHistory(ctx context.Context, limit int64) ([]History, error)
	GetHistoryEntry(ctx context.Context, url string) (History, error)
	GetHistoryWithOffset(ctx context.Context, limit int64, offset int64) ([]History, error)
	GetMostVisited(ctx context.Context, limit int64) ([]History, error)
	SearchHistory(ctx context.Context, column1 sql.NullString, column2 sql.NullString, limit int64) ([]History, error)
	AddOrUpdateHistory(ctx context.Context, url string, title sql.NullString) error
	UpdateHistoryFavicon(ctx context.Context, faviconUrl sql.NullString, url string) error
	DeleteHistory(ctx context.Context, id int64) error
	DeleteAllHistory(ctx context.Context) error
}

type Querier interface {
	AddOrUpdateHistory(ctx context.Context, url string, title sql.NullString) error
	// Cleanup zoom level entries older than specified days
	CleanupOldZoomLevels(ctx context.Context, dollar_1 sql.NullString) error
	// Insert a new favorite with auto-incremented position
	CreateFavorite(ctx context.Context, url string, title sql.NullString, faviconUrl sql.NullString) error
	DeleteAllHistory(ctx context.Context) error
	DeleteCertificateValidation(ctx context.Context, hostname string, certificateHash string) error
	DeleteExpiredCertificateValidations(ctx context.Context) error
	// Delete a favorite by URL
	DeleteFavorite(ctx context.Context, url string) error
	DeleteHistory(ctx context.Context, id int64) error
	// Delete zoom level setting for a domain
	DeleteZoomLevel(ctx context.Context, domain string) error
	// Get all favorites ordered by position
	GetAllFavorites(ctx context.Context) ([]Favorite, error)
	GetCertificateValidation(ctx context.Context, hostname string, certificateHash string) (CertificateValidation, error)
	GetCertificateValidationByHostname(ctx context.Context, hostname string) (CertificateValidation, error)
	// Get a specific favorite by URL
	GetFavoriteByURL(ctx context.Context, url string) (Favorite, error)
	// Get total count of favorites
	GetFavoriteCount(ctx context.Context) (int64, error)
	GetHistory(ctx context.Context, limit int64) ([]History, error)
	GetHistoryEntry(ctx context.Context, url string) (History, error)
	GetHistoryWithOffset(ctx context.Context, limit int64, offset int64) ([]History, error)
	GetMostVisited(ctx context.Context, limit int64) ([]History, error)
	// Get zoom level for a specific domain
	GetZoomLevel(ctx context.Context, domain string) (float64, error)
	// Get zoom level for domain with default fallback
	GetZoomLevelWithDefault(ctx context.Context, domain string) (interface{}, error)
	// Check if a URL is favorited
	IsFavorite(ctx context.Context, url string) (int64, error)
	ListCertificateValidations(ctx context.Context) ([]CertificateValidation, error)
	// List all zoom level settings ordered by most recently updated
	ListZoomLevels(ctx context.Context) ([]ZoomLevel, error)
	SearchHistory(ctx context.Context, column1 sql.NullString, column2 sql.NullString, limit int64) ([]History, error)
	// Set or update zoom level for a domain with validation
	SetZoomLevel(ctx context.Context, domain string, zoomFactor float64) error
	StoreCertificateValidation(ctx context.Context, hostname string, certificateHash string, userDecision string, expiresAt sql.NullTime) error
	// Update favorite metadata (title, favicon)
	UpdateFavorite(ctx context.Context, title sql.NullString, faviconUrl sql.NullString, url string) error
	// Update the position of a favorite
	UpdateFavoritePosition(ctx context.Context, position int64, url string) error
	UpdateHistoryFavicon(ctx context.Context, faviconUrl sql.NullString, url string) error
}

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

type ZoomLevel struct {
	Domain     string       `json:"domain"`
	ZoomFactor float64      `json:"zoom_factor"`
	UpdatedAt  sql.NullTime `json:"updated_at"`
}

type ZoomQuerier interface {
	GetZoomLevel(ctx context.Context, domain string) (float64, error)
	SetZoomLevel(ctx context.Context, domain string, zoomLevel float64) error
	DeleteZoomLevel(ctx context.Context, domain string) error
	ListZoomLevels(ctx context.Context) ([]ZoomLevel, error)
}