database

type Config struct {
	ID        int64
	Key       string
	Value     string
	CreatedAt time.Time
	UpdatedAt sql.NullTime
}

type CreateConfigParams struct {
	Key   string
	Value string
}

type CreateNarFileParams struct {
	Hash        string
	Compression string
	Query       string
	FileSize    uint64
}

type LinkNarInfoToNarFileParams struct {
	NarInfoID int64
	NarFileID int64
}

type NarFile struct {
	ID             int64
	Hash           string
	Compression    string
	FileSize       uint64
	Query          string
	CreatedAt      time.Time
	UpdatedAt      sql.NullTime
	LastAccessedAt sql.NullTime
}

type NarInfo struct {
	ID             int64
	Hash           string
	CreatedAt      time.Time
	UpdatedAt      sql.NullTime
	LastAccessedAt sql.NullTime
}

type PoolConfig struct {
	// MaxOpenConns is the maximum number of open connections to the database.
	// If <= 0, defaults are used based on database type.
	MaxOpenConns int
	// MaxIdleConns is the maximum number of connections in the idle connection pool.
	// If <= 0, defaults are used based on database type.
	MaxIdleConns int
}

type Querier interface {
	CreateConfig(ctx context.Context, arg CreateConfigParams) (Config, error)
	CreateNarFile(ctx context.Context, arg CreateNarFileParams) (NarFile, error)
	CreateNarInfo(ctx context.Context, hash string) (NarInfo, error)
	DeleteNarFileByHash(ctx context.Context, hash string) (int64, error)
	DeleteNarFileByID(ctx context.Context, id int64) (int64, error)
	DeleteNarInfoByHash(ctx context.Context, hash string) (int64, error)
	DeleteNarInfoByID(ctx context.Context, id int64) (int64, error)
	DeleteOrphanedNarFiles(ctx context.Context) (int64, error)
	DeleteOrphanedNarInfos(ctx context.Context) (int64, error)
	GetConfigByID(ctx context.Context, id int64) (Config, error)
	GetConfigByKey(ctx context.Context, key string) (Config, error)
	GetLeastUsedNarFiles(ctx context.Context, fileSize uint64) ([]NarFile, error)
	GetLeastUsedNarInfos(ctx context.Context, fileSize uint64) ([]NarInfo, error)
	GetNarFileByHash(ctx context.Context, hash string) (NarFile, error)
	GetNarFileByID(ctx context.Context, id int64) (NarFile, error)
	GetNarFileByNarInfoID(ctx context.Context, narinfoID int64) (NarFile, error)
	GetNarInfoByHash(ctx context.Context, hash string) (NarInfo, error)
	GetNarInfoByID(ctx context.Context, id int64) (NarInfo, error)
	GetNarInfoHashesByNarFileID(ctx context.Context, narFileID int64) ([]string, error)
	GetNarTotalSize(ctx context.Context) (int64, error)
	GetOrphanedNarFiles(ctx context.Context) ([]NarFile, error)
	LinkNarInfoToNarFile(ctx context.Context, arg LinkNarInfoToNarFileParams) error
	SetConfig(ctx context.Context, arg SetConfigParams) error
	TouchNarFile(ctx context.Context, hash string) (int64, error)
	TouchNarInfo(ctx context.Context, hash string) (int64, error)

	WithTx(tx *sql.Tx) Querier
	DB() *sql.DB
}

type SetConfigParams struct {
	Key   string
	Value string
}

type Type uint8