statistics

type BigQueryConfig struct {
	ProjectID string
	DatasetID string
}

type CalendarEntry struct {
	ID       string              `bigquery:"id"`
	EventID  bigquery.NullString `bigquery:"event_id"`
	Title    string              `bigquery:"title"`
	Start    time.Time           `bigquery:"start"`
	End      time.Time           `bigquery:"end"`
	Type     bigquery.NullString `bigquery:"type"`
	IsReplay bool                `bigquery:"is_replay"`
	ItemID   bigquery.NullString `bigquery:"item_id"`
}

type Episode struct {
	ID                    int                 `json:"id"`
	UUID                  uuid.UUID           `json:"uuid"`
	Status                common.Status       `json:"status"`
	Unlisted              bool                `json:"unlisted"`
	Type                  string              `json:"type"`
	PreventPublicIndexing bool                `json:"preventPublicIndexing"`
	SeasonID              bigquery.NullInt64  `json:"seasonId"`
	PublishDate           time.Time           `json:"publishDate"`
	ProductionDate        time.Time           `json:"productionDate"`
	AvailableFrom         time.Time           `json:"availableFrom"`
	AvailableTo           time.Time           `json:"availableTo"`
	Number                int                 `json:"number"`
	ImageIcon             bigquery.NullString `json:"image_icon"`
	ImageFeatured         bigquery.NullString `json:"image_featured"`
	ImagePoster           bigquery.NullString `json:"image_poster"`
	Duration              int                 `json:"duration"`
	AgeRating             string              `json:"ageRating"`
	Tags                  string              `json:"tags"`
	PublicTitle           bigquery.NullString `json:"publicTitle"`
	Title                 bigquery.NullString `json:"title"`
	Description           bigquery.NullString `json:"description"`
	ExtraDescription      bigquery.NullString `json:"extraDescription"`
	Updated               time.Time
	Deleted               *time.Time
	LegacyEpisodeID       bigquery.NullString
	LegacyProgramID       bigquery.NullString
	Audience              bigquery.NullString `json:"audience"`
	ContentType           bigquery.NullString `json:"contentType"`
}

type GetAnswersSinceBQRow struct {
	Message  string    `bigquery:"message"`
	ItemID   uuid.UUID `bigquery:"item_id"`
	Rating   int32     `bigquery:"rating"`
	AgeGroup string    `bigquery:"age_group"`
	OrgID    int       `bigquery:"org_id"`
	Updated  time.Time `bigquery:"updated"`
}

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

type MediaItem struct {
	ID            string               `json:"id"`
	UserCreated   string               `json:"userCreated" bigquery:"user_created"`
	DateCreated   time.Time            `json:"dateCreated" bigquery:"date_created"`
	UserUpdated   string               `json:"userUpdated" bigquery:"user_updated"`
	DateUpdated   time.Time            `json:"dateUpdated" bigquery:"date_updated"`
	Label         string               `json:"label"`
	Title         bigquery.NullString  `json:"title"`
	Description   bigquery.NullString  `json:"description"`
	Type          string               `json:"type"`
	AssetID       string               `json:"assetId" bigquery:"asset_id"`
	ParentEpisode bigquery.NullInt64   `json:"parentEpisode" bigquery:"parent_episode"`
	ParentStarts  bigquery.NullFloat64 `json:"parentStarts" bigquery:"parent_starts"`
	ParentEnds    bigquery.NullFloat64 `json:"parentEnds" bigquery:"parent_ends"`
}

type Season struct {
	ID            int    `json:"id"`
	Tags          string `json:"tags"`
	Number        int
	AgeRating     string
	PublicTitle   bigquery.NullString `json:"publicTitle"`
	Title         bigquery.NullString `json:"title"`
	Description   bigquery.NullString `json:"description"`
	ShowID        int
	ImageIcon     bigquery.NullString `json:"image_icon"`
	ImageFeatured bigquery.NullString `json:"image_featured"`
	ImagePoster   bigquery.NullString `json:"image_poster"`
	Updated       time.Time
	Deleted       *time.Time
}

type Short struct {
	ID          string               `bigquery:"id"`
	MediaID     string               `bigquery:"media_id"`
	AssetID     string               `bigquery:"asset_id"`
	Label       string               `bigquery:"label"`
	EpisodeID   string               `bigquery:"episode_id"`
	Status      string               `bigquery:"status"`
	StartsAt    bigquery.NullFloat64 `bigquery:"starts_at"`
	EndsAt      bigquery.NullFloat64 `bigquery:"ends_at"`
	Image       bigquery.NullString  `bigquery:"image"`
	DateUpdated time.Time            `bigquery:"date_updated"`
	Tags        string               `bigquery:"tags"`
}

type Show struct {
	ID            int                 `json:"id"`
	Type          string              `json:"type"`
	Tags          string              `json:"tags"`
	PublicTitle   bigquery.NullString `json:"publicTitle"`
	Title         bigquery.NullString `json:"title"`
	Description   bigquery.NullString `json:"description"`
	ImageIcon     bigquery.NullString `json:"image_icon"`
	ImageFeatured bigquery.NullString `json:"image_featured"`
	ImagePoster   bigquery.NullString `json:"image_poster"`
	Updated       time.Time
	Deleted       *time.Time
}

type TimedMetadata struct {
	ID          string              `json:"id"`
	Type        string              `json:"type"`
	Timestamp   float64             `json:"timestamp"`
	Title       bigquery.NullString `json:"title"`
	Description bigquery.NullString `json:"description"`
	ContentType bigquery.NullString `json:"contentType"`
	PersonIDs   string              `json:"personIds"`
	SongID      uuid.NullUUID       `json:"songId"`
}