sqlc

type AssignTagToFavoriteParams struct {
	FavoriteID int64 `json:"favorite_id"`
	TagID      int64 `json:"tag_id"`
}

type ContentWhitelist struct {
	ID        int64        `json:"id"`
	Domain    string       `json:"domain"`
	CreatedAt sql.NullTime `json:"created_at"`
}

type CreateFavoriteParams struct {
	Url        string         `json:"url"`
	Title      sql.NullString `json:"title"`
	FaviconUrl sql.NullString `json:"favicon_url"`
	FolderID   sql.NullInt64  `json:"folder_id"`
}

type CreateFolderParams struct {
	Name     string         `json:"name"`
	Icon     sql.NullString `json:"icon"`
	ParentID sql.NullInt64  `json:"parent_id"`
}

type CreateTagParams struct {
	Name  string `json:"name"`
	Color string `json:"color"`
}

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 DeleteHistoryByDomainParams struct {
	Column1 sql.NullString `json:"column_1"`
	Column2 sql.NullString `json:"column_2"`
	Column3 sql.NullString `json:"column_3"`
	Column4 sql.NullString `json:"column_4"`
}

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

type FavoriteFolder struct {
	ID        int64          `json:"id"`
	Name      string         `json:"name"`
	Icon      sql.NullString `json:"icon"`
	ParentID  sql.NullInt64  `json:"parent_id"`
	Position  int64          `json:"position"`
	CreatedAt sql.NullTime   `json:"created_at"`
}

type FavoriteTag struct {
	ID        int64        `json:"id"`
	Name      string       `json:"name"`
	Color     string       `json:"color"`
	CreatedAt sql.NullTime `json:"created_at"`
}

type FavoriteTagAssignment struct {
	FavoriteID int64 `json:"favorite_id"`
	TagID      int64 `json:"tag_id"`
}

type GetDailyVisitCountRow struct {
	Day     interface{}     `json:"day"`
	Entries int64           `json:"entries"`
	Visits  sql.NullFloat64 `json:"visits"`
}

type GetDomainStatsRow struct {
	Domain      string          `json:"domain"`
	PageCount   int64           `json:"page_count"`
	TotalVisits sql.NullFloat64 `json:"total_visits"`
	LastVisit   interface{}     `json:"last_visit"`
}

type GetHistoryStatsRow struct {
	TotalEntries int64       `json:"total_entries"`
	TotalVisits  interface{} `json:"total_visits"`
	UniqueDays   int64       `json:"unique_days"`
}

type GetHourlyDistributionRow struct {
	Hour       int64 `json:"hour"`
	VisitCount int64 `json:"visit_count"`
}

type GetRecentHistoryParams struct {
	Limit  int64 `json:"limit"`
	Offset int64 `json:"offset"`
}

type GetSessionsWithStateRow struct {
	ID             string         `json:"id"`
	Type           string         `json:"type"`
	StartedAt      time.Time      `json:"started_at"`
	EndedAt        sql.NullTime   `json:"ended_at"`
	StateJson      sql.NullString `json:"state_json"`
	TabCount       sql.NullInt64  `json:"tab_count"`
	PaneCount      sql.NullInt64  `json:"pane_count"`
	StateUpdatedAt sql.NullTime   `json:"state_updated_at"`
}

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

type HistoryFt struct {
	Url   string `json:"url"`
	Title string `json:"title"`
}

type InsertSessionParams struct {
	ID        string       `json:"id"`
	Type      string       `json:"type"`
	StartedAt time.Time    `json:"started_at"`
	EndedAt   sql.NullTime `json:"ended_at"`
}

type MarkSessionEndedParams struct {
	EndedAt sql.NullTime `json:"ended_at"`
	ID      string       `json:"id"`
}

type Querier interface {
	AddToWhitelist(ctx context.Context, domain string) error
	AssignTagToFavorite(ctx context.Context, arg AssignTagToFavoriteParams) error
	CreateFavorite(ctx context.Context, arg CreateFavoriteParams) (Favorite, error)
	CreateFolder(ctx context.Context, arg CreateFolderParams) (FavoriteFolder, error)
	CreateTag(ctx context.Context, arg CreateTagParams) (FavoriteTag, error)
	DeleteAllHistory(ctx context.Context) error
	// Deletes exited browser sessions older than the given cutoff time.
	DeleteExitedSessionsBefore(ctx context.Context, endedAt sql.NullTime) (int64, error)
	DeleteFavorite(ctx context.Context, id int64) error
	DeleteFolder(ctx context.Context, id int64) error
	DeleteHistoryByDomain(ctx context.Context, arg DeleteHistoryByDomainParams) error
	DeleteHistoryByID(ctx context.Context, id int64) error
	DeleteHistoryOlderThan(ctx context.Context, lastVisited sql.NullTime) error
	// Deletes exited browser sessions beyond the keep limit, keeping the most recent ones.
	DeleteOldestExitedSessions(ctx context.Context, offset int64) (int64, error)
	DeleteSession(ctx context.Context, id string) error
	DeleteSessionState(ctx context.Context, sessionID string) error
	DeleteTag(ctx context.Context, id int64) error
	DeleteZoomLevel(ctx context.Context, domain string) error
	GetActiveBrowserSession(ctx context.Context) (Session, error)
	GetAllFavorites(ctx context.Context) ([]Favorite, error)
	GetAllFolders(ctx context.Context) ([]FavoriteFolder, error)
	GetAllMostVisited(ctx context.Context) ([]History, error)
	GetAllRecentHistory(ctx context.Context) ([]History, error)
	GetAllSessionStates(ctx context.Context) ([]SessionState, error)
	GetAllTags(ctx context.Context) ([]FavoriteTag, error)
	GetAllWhitelistedDomains(ctx context.Context) ([]string, error)
	GetChildFolders(ctx context.Context, parentID sql.NullInt64) ([]FavoriteFolder, error)
	GetDailyVisitCount(ctx context.Context, date interface{}) ([]GetDailyVisitCountRow, error)
	GetDomainStats(ctx context.Context, limit int64) ([]GetDomainStatsRow, error)
	GetFavoriteByID(ctx context.Context, id int64) (Favorite, error)
	GetFavoriteByShortcut(ctx context.Context, shortcutKey sql.NullInt64) (Favorite, error)
	GetFavoriteByURL(ctx context.Context, url string) (Favorite, error)
	GetFavoritesByFolder(ctx context.Context, folderID sql.NullInt64) ([]Favorite, error)
	GetFavoritesWithoutFolder(ctx context.Context) ([]Favorite, error)
	GetFolderByID(ctx context.Context, id int64) (FavoriteFolder, error)
	GetHistoryByURL(ctx context.Context, url string) (History, error)
	GetHistoryStats(ctx context.Context) (GetHistoryStatsRow, error)
	GetHourlyDistribution(ctx context.Context) ([]GetHourlyDistributionRow, error)
	GetMostVisited(ctx context.Context, datetime interface{}) ([]History, error)
	GetRecentHistory(ctx context.Context, arg GetRecentHistoryParams) ([]History, error)
	GetRecentHistorySince(ctx context.Context, datetime interface{}) ([]History, error)
	GetRecentSessions(ctx context.Context, limit int64) ([]Session, error)
	GetRootFolders(ctx context.Context) ([]FavoriteFolder, error)
	GetSessionByID(ctx context.Context, id string) (Session, error)
	GetSessionState(ctx context.Context, sessionID string) (SessionState, error)
	GetSessionsWithState(ctx context.Context, limit int64) ([]GetSessionsWithStateRow, error)
	GetTagByID(ctx context.Context, id int64) (FavoriteTag, error)
	GetTagByName(ctx context.Context, name string) (FavoriteTag, error)
	GetTagsForFavorite(ctx context.Context, favoriteID int64) ([]FavoriteTag, error)
	GetTotalSessionStatesSize(ctx context.Context) (interface{}, error)
	GetZoomLevel(ctx context.Context, domain string) (ZoomLevel, error)
	IncrementVisitCount(ctx context.Context, url string) error
	InsertSession(ctx context.Context, arg InsertSessionParams) error
	IsWhitelisted(ctx context.Context, domain string) (int64, error)
	ListZoomLevels(ctx context.Context) ([]ZoomLevel, error)
	MarkSessionEnded(ctx context.Context, arg MarkSessionEndedParams) error
	RemoveFromWhitelist(ctx context.Context, domain string) error
	RemoveTagFromFavorite(ctx context.Context, arg RemoveTagFromFavoriteParams) error
	SearchHistory(ctx context.Context, arg SearchHistoryParams) ([]History, error)
	SearchHistoryFTSTitle(ctx context.Context, arg SearchHistoryFTSTitleParams) ([]History, error)
	SearchHistoryFTSUrl(ctx context.Context, arg SearchHistoryFTSUrlParams) ([]History, error)
	SetFavoriteFolder(ctx context.Context, arg SetFavoriteFolderParams) error
	SetFavoriteShortcut(ctx context.Context, arg SetFavoriteShortcutParams) error
	SetZoomLevel(ctx context.Context, arg SetZoomLevelParams) error
	UpdateFavorite(ctx context.Context, arg UpdateFavoriteParams) error
	UpdateFavoritePosition(ctx context.Context, arg UpdateFavoritePositionParams) error
	UpdateFolder(ctx context.Context, arg UpdateFolderParams) error
	UpdateFolderPosition(ctx context.Context, arg UpdateFolderPositionParams) error
	UpdateTag(ctx context.Context, arg UpdateTagParams) error
	UpsertHistory(ctx context.Context, arg UpsertHistoryParams) error
	UpsertSessionState(ctx context.Context, arg UpsertSessionStateParams) error
}

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

type RemoveTagFromFavoriteParams struct {
	FavoriteID int64 `json:"favorite_id"`
	TagID      int64 `json:"tag_id"`
}

type SearchHistoryFTSTitleParams struct {
	Query string `json:"query"`
	Limit int64  `json:"limit"`
}

type SearchHistoryFTSUrlParams struct {
	Query string `json:"query"`
	Limit int64  `json:"limit"`
}

type SearchHistoryParams struct {
	Column1 sql.NullString `json:"column_1"`
	Column2 sql.NullString `json:"column_2"`
	Limit   int64          `json:"limit"`
}

type Session struct {
	ID        string       `json:"id"`
	Type      string       `json:"type"`
	StartedAt time.Time    `json:"started_at"`
	EndedAt   sql.NullTime `json:"ended_at"`
}

type SessionState struct {
	SessionID string    `json:"session_id"`
	StateJson string    `json:"state_json"`
	Version   int64     `json:"version"`
	TabCount  int64     `json:"tab_count"`
	PaneCount int64     `json:"pane_count"`
	UpdatedAt time.Time `json:"updated_at"`
}

type SetFavoriteFolderParams struct {
	FolderID sql.NullInt64 `json:"folder_id"`
	ID       int64         `json:"id"`
}

type SetFavoriteShortcutParams struct {
	ShortcutKey sql.NullInt64 `json:"shortcut_key"`
	ID          int64         `json:"id"`
}

type SetZoomLevelParams struct {
	Domain     string  `json:"domain"`
	ZoomFactor float64 `json:"zoom_factor"`
}

type UpdateFavoriteParams struct {
	Title      sql.NullString `json:"title"`
	FaviconUrl sql.NullString `json:"favicon_url"`
	ID         int64          `json:"id"`
}

type UpdateFavoritePositionParams struct {
	Position int64 `json:"position"`
	ID       int64 `json:"id"`
}

type UpdateFolderParams struct {
	Name string         `json:"name"`
	Icon sql.NullString `json:"icon"`
	ID   int64          `json:"id"`
}

type UpdateFolderPositionParams struct {
	Position int64 `json:"position"`
	ID       int64 `json:"id"`
}

type UpdateTagParams struct {
	Name  string `json:"name"`
	Color string `json:"color"`
	ID    int64  `json:"id"`
}

type UpsertHistoryParams struct {
	Url        string         `json:"url"`
	Title      sql.NullString `json:"title"`
	FaviconUrl sql.NullString `json:"favicon_url"`
}

type UpsertSessionStateParams struct {
	SessionID string    `json:"session_id"`
	StateJson string    `json:"state_json"`
	Version   int64     `json:"version"`
	TabCount  int64     `json:"tab_count"`
	PaneCount int64     `json:"pane_count"`
	UpdatedAt time.Time `json:"updated_at"`
}

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