storage

type Abonnement struct {
	Feed
	Chats []Chat
}

type AbonnementStorage interface {
	Create(chatId int64, chatTitle string, feedUrl string, lastEntry *string) error
	Delete(chatId int64, feedId int64) error
	ExistsByFeedUrl(chatId int64, feedUrl string) (bool, error)
	ExistsById(chatId int64, feedId int64) (bool, error)
	GetByUser(chatId int64) ([]Feed, error)
	GetAll() ([]Abonnement, error)
	SetLastEntry(feedUrl string, lastEntry *string) error
}

type Abonnements struct {
	*sqlx.DB
}

type Chat struct {
	ID        int64     `db:"chat_id"`
	Title     string    `db:"title"`
	CreatedAt time.Time `db:"chat_created_at"`
}

type DB struct {
	*sqlx.DB
	Abonnements  AbonnementStorage
	Replacements ReplacementsStorage
}

type Feed struct {
	ID        int64          `db:"id"`
	Url       string         `db:"url"`
	LastEntry sql.NullString `db:"last_entry"`
	CreatedAt time.Time      `db:"created_at"`
	UpdatedAt sql.NullTime   `db:"updated_at"`
}

type Replacement struct {
	ID        int64     `db:"id"`
	Value     string    `db:"value"`
	IsRegex   bool      `db:"is_regex"`
	CreatedAt time.Time `db:"created_at"`
}

type Replacements struct {
	*sqlx.DB
}

type ReplacementsStorage interface {
	Create(value string, isRegex bool) error
	Delete(replacementId int64) error
	List() ([]Replacement, error)
}