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
	IGDBID           int64
	ModerationStatus string
}

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"`
	IGDBID           int64      `db:"igdb_id"`
	ModerationStatus string     `db:"moderation_status"`
	Weight           float64    `db:"weight"` // Readonly field
}

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 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
	Developers       []int32
	Publishers       []int32
	ReleaseDate      string
	Genres           []int32
	LogoURL          string
	Summary          string
	Slug             string
	PlatformsIDs     []int32
	Screenshots      []string
	Websites         []string
	ModerationStatus string
	IGDBRating       float64
}

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