db

type DB interface {
	GuildSettings() GuildSettingsDB
	LikedSongs() LikedSongsDB
	PlayHistory() PlayHistoriesDB
	Tags() TagsDB
	Voters() VotersDB
	Reports() ReportsDB
	Close() error
}

type DatabaseConfig struct {
	Host     string `json:"host"`
	Port     int    `json:"port"`
	User     string `json:"user"`
	Password string `json:"password"`
	DBName   string `json:"db_name"`
	SSLMode  string `json:"ssl_mode"`
}

type GuildSettingsDB interface {
	CreateIfNotExist(guildID snowflake.ID) error
	Get(guildID snowflake.ID) (GuildSetting, error)
	UpdateModeration(guildID snowflake.ID, webhookID snowflake.ID, webhookToken string) error
	Delete(guildID snowflake.ID) error
}

type LikedSongsDB interface {
	Get(userID snowflake.ID, title string) (LikedSong, error)
	GetAll(userID snowflake.ID) ([]LikedSong, error)
	Add(userID snowflake.ID, query string, title string) error
	Delete(userID snowflake.ID, title string) error
	DeleteAll(userID snowflake.ID) error
}

type PlayHistoriesDB interface {
	Get(userID snowflake.ID) ([]PlayHistory, error)
	Add(userID snowflake.ID, query string, title string) error
}

type ReportsDB interface {
	Get(id int32) (Reports, error)
	GetCount(userID snowflake.ID, guildID snowflake.ID) (int, error)
	GetAll(userID snowflake.ID, guildID snowflake.ID) ([]Reports, error)
	Create(userID snowflake.ID, guildID snowflake.ID, description string, createdAt time.Time, messageID snowflake.ID, channelID snowflake.ID) (int32, error)
	Confirm(id int32) error
	Delete(id int32) error
	DeleteAll(userID snowflake.ID, guildID snowflake.ID) error
}

type TagsDB interface {
	Get(guildID snowflake.ID, name string) (Tag, error)
	GetAll(guildID snowflake.ID) ([]Tag, error)
	Create(guildID snowflake.ID, ownerID snowflake.ID, name string, content string) error
	Edit(guildID snowflake.ID, name string, content string) error
	IncrementUses(guildID snowflake.ID, name string) error
	Delete(guildID snowflake.ID, name string) error
}

type VotersDB interface {
	GetAll(expiresAt time.Time) ([]Voter, error)
	Add(userID snowflake.ID, duration time.Duration) error
	Delete(userID snowflake.ID) error
}