model

type Company struct {
	ID     int32         `db:"id"`
	Name   string        `db:"name"`
	IGDBID sql.NullInt64 `db:"igdb_id"`
}

type CreateGame struct {
	Name         string
	ReleaseDate  string
	GenresIDs    []int32
	LogoURL      string
	Summary      string
	Slug         string
	PlatformsIDs []int32
	Screenshots  []string
	Websites     []string
	Developer    string // helper field
	Publisher    string // helper field
}

type CreateGameData struct {
	Name             string
	DevelopersIDs    []int32
	PublishersIDs    []int32
	ReleaseDate      string
	GenresIDs        []int32
	LogoURL          string
	Summary          string
	Slug             string
	PlatformsIDs     []int32
	Screenshots      []string
	Websites         []string
	IGDBRating       float64
	IGDBRatingCount  int32
	IGDBID           int64
	ModerationStatus ModerationStatus
}

type CreateModeration struct {
	GameID   int32
	GameData ModerationData
	Status   ModerationStatus
}

type CreateRating struct {
	Rating uint8
	UserID string
	GameID int32
}

type File struct {
	FileName string
	FileID   string
	FileURL  string
	Type     string
}

type Game struct {
	ID               int32            `db:"id"`
	Name             string           `db:"name"`
	DevelopersIDs    []int32          `db:"developers"`
	PublishersIDs    []int32          `db:"publishers"`
	ReleaseDate      types.Date       `db:"release_date"`
	GenresIDs        []int32          `db:"genres"`
	LogoURL          string           `db:"logo_url"`
	Rating           float64          `db:"rating"`
	Summary          string           `db:"summary"`
	Slug             string           `db:"slug"`
	PlatformsIDs     []int32          `db:"platforms"`
	Screenshots      []string         `db:"screenshots"`
	Websites         []string         `db:"websites"`
	IGDBRating       float64          `db:"igdb_rating"`
	IGDBRatingCount  int32            `db:"igdb_rating_count"`
	IGDBID           int64            `db:"igdb_id"`
	ModerationStatus ModerationStatus `db:"moderation_status"`
	ModerationID     sql.NullInt32    `db:"moderation_id"`
	TrendingIndex    float64          `db:"trending_index"`
}

type GameModerationData struct {
	Game        Game
	Moderations []Moderation
}

type GameTrendingData struct {
	Year            int     `db:"release_year"`
	Month           int     `db:"release_month"`
	IGDBRating      float64 `db:"igdb_rating"`
	IGDBRatingCount int32   `db:"igdb_rating_count"`
	Rating          float64 `db:"rating"`
	RatingCount     int32   `db:"rating_count"`
}

type GamesFilter struct {
	Name        string
	DeveloperID int32
	PublisherID int32
	GenreID     int32
	OrderBy     OrderBy
}

type Genre struct {
	ID     int32  `db:"id"`
	Name   string `db:"name"`
	IGDBID int64  `db:"igdb_id"`
}

type Moderation struct {
	ID        int32          `db:"id"`
	GameID    int32          `db:"game_id"`
	Status    string         `db:"status"`
	Details   string         `db:"details"`
	Attempts  int32          `db:"attempts"`
	GameData  ModerationData `db:"game_data"`
	CreatedAt sql.NullTime   `db:"created_at"`
	UpdatedAt sql.NullTime   `db:"updated_at"`
}

type ModerationData struct {
	Name        string   `json:"name"`
	Developers  []string `json:"developers"`
	Publisher   string   `json:"publisher"`
	ReleaseDate string   `json:"releaseDate"`
	Genres      []string `json:"genres"`
	LogoURL     string   `json:"logoUrl"`
	Summary     string   `json:"summary"`
	Screenshots []string `json:"screenshots"`
	Websites    []string `json:"websites"`
}

type ModerationIDGameID struct {
	ModerationID int32 `db:"id"`
	GameID       int32 `db:"game_id"`
}

type ModerationStatus string

type OrderBy struct {
	Field string
	Order SortOrder
}

type Platform struct {
	ID           int32  `db:"id"`
	Name         string `db:"name"`
	Abbreviation string `db:"abbreviation"`
	IGDBID       int64  `db:"igdb_id"`
}

type RemoveRating struct {
	UserID string
	GameID int32
}

type SortOrder string

type Task struct {
	Name     string       `db:"name"`
	Status   TaskStatus   `db:"status"`
	RunCount int64        `db:"run_count"`
	LastRun  sql.NullTime `db:"last_run"`
	Settings TaskSettings `db:"settings"`
}

type TaskInfo struct {
	Schedule string
	Fn       func() error
}

type TaskSettings []byte

type TaskStatus string

type UpdateGame struct {
	Name         *string
	Developer    *string
	Publisher    string
	ReleaseDate  *string
	GenresIDs    *[]int32
	LogoURL      *string
	Summary      *string
	PlatformsIDs *[]int32
	Screenshots  *[]string
	Websites     *[]string
}

type UpdateGameData struct {
	Name             string
	DevelopersIDs    []int32
	PublishersIDs    []int32
	ReleaseDate      string
	GenresIDs        []int32
	LogoURL          string
	Summary          string
	Slug             string
	PlatformsIDs     []int32
	Screenshots      []string
	Websites         []string
	ModerationStatus ModerationStatus
}

type UpdateGameIGDBData struct {
	Name            string
	PlatformsIDs    []int32
	Websites        []string
	IGDBRating      float64
	IGDBRatingCount int32
}

type UpdateModerationResult struct {
	ResultStatus ModerationStatus
	Details      string
}

type UserRating struct {
	GameID int32  `db:"game_id"`
	UserID string `db:"user_id"`
	Rating uint8  `db:"rating"`
}