storage

type ActivityStats struct {
	ActiveHelpsCount int `db:"helps"`
	ActiveSubsCount  int `db:"subs"`
}

type Categories []CategoryNames

type Category struct {
	ID     uuid.UUID `db:"id"`
	NameUA string    `db:"name_ua"`
	NameRU string    `db:"name_ru"`
	NameEN string    `db:"name_en"`
}

type CategoryNames struct {
	NameUA string `json:"name_ua"`
	NameRU string `json:"name_ru"`
	NameEN string `json:"name_en"`
}

type Config struct {
	DSN string `yaml:"dsn"`
}

type Help struct {
	ID                   uuid.UUID  `db:"id"`
	CreatorID            uuid.UUID  `db:"creator_id"`
	Categories           Categories `db:"categories"`
	LocalityPublicNameEN string     `db:"loc_public_name_en"`
	LocalityPublicNameRU string     `db:"loc_public_name_ru"`
	LocalityPublicNameUA string     `db:"loc_public_name_ua"`
	Language             string     `db:"language"`
	Description          string     `db:"description"`
	CreatedAt            time.Time  `db:"created_at"`
	UpdatedAt            *time.Time `db:"updated_at"`
	DeletedAt            *time.Time `db:"deleted_at"`
}

type HelpInsert struct {
	CreatorID   uuid.UUID
	CategoryIDs []uuid.UUID
	LocalityID  int
	Description string
}

type Interface interface {
	MigrateUp() error

	UpsertUser(context.Context, *User) (*User, error)
	SelectLocalityRegions(context.Context, string) ([]*LocalityRegion, error)
	SelectCategories(context.Context) ([]*Category, error)

	InsertHelp(context.Context, *HelpInsert) (uuid.UUID, error)
	SelectHelpByID(context.Context, uuid.UUID) (*Help, error)
	SelectHelpsByUser(context.Context, uuid.UUID) ([]*Help, error)
	SelectHelpsByLocalityCategory(context.Context, int, uuid.UUID) ([]*Help, error)
	SelectHelpsBySubscription(ctx context.Context, sid uuid.UUID) ([]*Help, error)
	SelectHelpsCountByUser(context.Context, uuid.UUID) (int, error)
	DeleteHelp(ctx context.Context, uuid2 uuid.UUID) error
	SelectExpiredHelps(context.Context, time.Time) ([]*Help, error)
	KeepHelp(ctx context.Context, requestID uuid.UUID) error

	InsertSubscription(context.Context, *SubscriptionInsert) error
	SelectSubscriptionsByUser(context.Context, uuid.UUID) ([]*SubscriptionValue, error)
	SelectSubscriptionsByLocalityCategories(context.Context, int, []uuid.UUID) ([]*SubscriptionValue, error)
	SelectSubscriptionsCountByUser(context.Context, uuid.UUID) (int, error)
	DeleteSubscription(context.Context, uuid.UUID) error

	SelectActivityStats(context.Context) (*ActivityStats, error)
	SelectSubscriptionExists(context.Context, uuid.UUID) (bool, error)
}

type LocalityRegion struct {
	ID         int    `db:"id"`
	Leven      int    `db:"leven"`
	Type       string `db:"type"`
	Name       string `db:"public_name_ua"`
	RegionName string `db:"region_public_name_ua"`
}

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

type SubscriptionInsert struct {
	CreatorID  uuid.UUID
	CategoryID uuid.UUID
	LocalityID int
}

type SubscriptionValue struct {
	ID                   uuid.UUID `db:"id"`
	CreatorID            uuid.UUID `db:"creator_id"`
	CategoryID           uuid.UUID `db:"category_id"`
	ChatID               int64     `db:"chat_id"`
	Language             string    `db:"language"`
	CategoryNameEN       string    `db:"name_en"`
	CategoryNameRU       string    `db:"name_ru"`
	CategoryNameUA       string    `db:"name_ua"`
	LocalityPublicNameEN string    `db:"public_name_en"`
	LocalityPublicNameRU string    `db:"public_name_ru"`
	LocalityPublicNameUA string    `db:"public_name_ua"`
	CreatedAt            time.Time `db:"created_at"`
}

type User struct {
	ID        uuid.UUID `db:"id"`
	TgID      int       `db:"tg_id"`
	ChatID    int64     `db:"chat_id"`
	Name      string    `db:"name"`
	Language  string    `db:"language"`
	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}