db

type BannedUser struct {
	ID         int32
	UserID     uuid.UUID
	CreatedAt  time.Time
	Reason     string
	LiftedAt   sql.NullTime
	LiftReason sql.NullString
}

type CountInstanceForUserAndFilterParams struct {
	UserID     uuid.UUID
	FilterName string
}

type CreateInstanceForUserAndFilterParams struct {
	UserID     uuid.UUID
	FilterName string
	Params     pgtype.JSONB
}

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type DeleteInstanceForUserAndFilterParams struct {
	UserID     uuid.UUID
	FilterName string
}

type FilterInstance struct {
	ID           int32
	UserID       uuid.UUID
	FilterListID int32
	FilterName   string
	Params       pgtype.JSONB
	CreatedAt    time.Time
	UpdatedAt    sql.NullTime
}

type FilterList struct {
	ID           int32
	UserID       uuid.UUID
	Token        uuid.UUID
	CreatedAt    time.Time
	Downloaded   bool
	DownloadedAt sql.NullTime
}

type GetActiveFiltersForUserRow struct {
	FilterName string
	Params     pgtype.JSONB
}

type GetInstanceForUserAndFilterParams struct {
	UserID     uuid.UUID
	FilterName string
}

type GetInstanceStatsRow struct {
	Count      int64
	FilterName string
}

type GetInstancesForListRow struct {
	FilterName string
	Params     pgtype.JSONB
}

type GetListForTokenRow struct {
	ID         int32
	UserID     uuid.UUID
	Downloaded bool
}

type GetListForUserRow struct {
	Token         uuid.UUID
	Downloaded    bool
	InstanceCount int64
}

type GetStatsRow struct {
	ListsTotal  int64
	ListsActive int64
	ListsFresh  int64
}

type Querier interface {
	CountInstanceForUserAndFilter(ctx context.Context, arg CountInstanceForUserAndFilterParams) (int64, error)
	CountListsForUser(ctx context.Context, userID uuid.UUID) (int64, error)
	CreateInstanceForUserAndFilter(ctx context.Context, arg CreateInstanceForUserAndFilterParams) error
	CreateListForUser(ctx context.Context, userID uuid.UUID) (uuid.UUID, error)
	DeleteInstanceForUserAndFilter(ctx context.Context, arg DeleteInstanceForUserAndFilterParams) error
	GetActiveFiltersForUser(ctx context.Context, userID uuid.UUID) ([]GetActiveFiltersForUserRow, error)
	GetBannedUsers(ctx context.Context) ([]uuid.UUID, error)
	GetInstanceForUserAndFilter(ctx context.Context, arg GetInstanceForUserAndFilterParams) (pgtype.JSONB, error)
	GetInstanceStats(ctx context.Context) ([]GetInstanceStatsRow, error)
	GetInstancesForList(ctx context.Context, filterListID int32) ([]GetInstancesForListRow, error)
	GetListForToken(ctx context.Context, token uuid.UUID) (GetListForTokenRow, error)
	GetListForUser(ctx context.Context, userID uuid.UUID) (GetListForUserRow, error)
	GetStats(ctx context.Context) (GetStatsRow, error)
	GetUserPreferences(ctx context.Context, userID uuid.UUID) (UserPreference, error)
	HasUserDownloadedList(ctx context.Context, userID uuid.UUID) (bool, error)
	InitUserPreferences(ctx context.Context, userID uuid.UUID) (UserPreference, error)
	MarkListDownloaded(ctx context.Context, id int32) error
	RotateListToken(ctx context.Context, arg RotateListTokenParams) error
	UpdateInstanceForUserAndFilter(ctx context.Context, arg UpdateInstanceForUserAndFilterParams) error
	UpdateNewsCursor(ctx context.Context, arg UpdateNewsCursorParams) error
}

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

type RotateListTokenParams struct {
	UserID uuid.UUID
	Token  uuid.UUID
}

type Store interface {
	Querier
	RunTx(e echo.Context, f TxFunc) error
}

type TxFunc func(context.Context, Querier) error

type UpdateInstanceForUserAndFilterParams struct {
	UserID     uuid.UUID
	FilterName string
	Params     pgtype.JSONB
}

type UpdateNewsCursorParams struct {
	UserID     uuid.UUID
	NewsCursor time.Time
}

type UserPreference struct {
	UserID     uuid.UUID
	NewsCursor time.Time
}