postgres

type AgendaEntry struct {
	Event *events.GenconEvent
	Tier  string
}

type CalendarEventCluster struct {
	EventId          string
	Title            string
	StartTime        time.Time
	EndTime          time.Time
	GenconUrl        string
	PlannerUrl       string
	ShortCategory    string
	ShortDescription string
	SimilarCount     int
}

type CategorySummary struct {
	Name  string
	Code  string
	Count int
}

type EventGroup struct {
	Name          string
	EventId       string
	Description   string
	ShortCategory string
	GameSystem    string
	OrgGroup      string
	OrgId         int
	Count         int
	WedTickets    int
	ThursTickets  int
	FriTickets    int
	SatTickets    int
	SunTickets    int
	TotalTickets  int
}

type Game struct {
	Name          string
	Type          string // Will be game, or expansion
	BggId         int64
	FamilyIds     []int64
	LastUpdate    time.Time
	NumRatings    int64
	AvgRatings    float64
	YearPublished int64
}

type GameFamily struct {
	Name       string
	BggId      int64
	GameIds    []int64
	LastUpdate time.Time
}

type MemberInterest struct {
	Email       string `json:"email"`
	DisplayName string `json:"displayName"`
	Tier        string `json:"tier"`
}

type Organizer struct {
	Id        int64
	Aliases   []string
	NumEvents int64
}

type ParsedQuery struct {
	// TODO(alek): make a significantly more robust query parser
	// add exact match on fields,
	TextQueries     []string
	Year            int
	DaysOfWeek      map[string]bool
	RawQuery        string
	StartBeforeHour int
	StartAfterHour  int
	EndBeforeHour   int
	EndAfterHour    int
	OrgId           int
}

type Party struct {
	Id          int64
	Name        string
	Year        int64
	LeaderEmail string
	ShortCode   string
	Members     []*User
}

type SearchQuery struct {
	Year              int
	CategoryShortCode string
	MinWedTickets     int
	MinThuTickets     int
	MinFriTickets     int
	MinSatTickets     int
	MinSunTickets     int
	RawQuery          string
	OrgId             int
}

type SharedInterestGroup struct {
	ClusterId       string           `json:"clusterId"`
	RepEventId      string           `json:"repEventId"`
	AllEventIds     []string         `json:"allEventIds"`
	Title           string           `json:"title"`
	ShortCategory   string           `json:"shortCategory"`
	GameSystem      string           `json:"gameSystem"`
	TotalSessions   int              `json:"totalSessions"`
	TotalTickets    int              `json:"totalTickets"`
	MemberInterests []MemberInterest `json:"memberInterests"`
	GroupScore      int              `json:"groupScore"`
}

type StarredEvent struct {
	EventId    string
	Level      string // "group" or "event"
	Tier       string // "must_have", "very_interested", "somewhat_interested", "not_interested"
	GroupTier  string
	IsOverride bool
}

type UpdateStats struct {
	Seen      int
	Inserted  int
	Updated   int
	Deleted   int
	Unchanged int
}

type User struct {
	Email       string
	DisplayName string
}

type UserStarredEvents struct {
	Email         string
	StarredEvents []StarredEvent
}

type WishlistCacheItem struct {
	EventId   string
	Rank      int
	Status    string
	Reasoning []string
	Score     float64
}

type WishlistConstraint struct {
	DayOfWeek          int // -1 for Every Day, 0-6 for Sun-Sat
	StartHour          int
	StartMinute        int
	EndHour            int
	EndMinute          int
	MinDurationMinutes int // 0 means hard block, > 0 means flexible block
}