models

type Channel struct {
	// ChannelID is the ID of the Slack channel
	ChannelID string `gorm:"primaryKey"`

	// Inviter is the ID of the user who has invited the bot to the Slack channel
	Inviter string

	// Interval is the interval for chat roulette rounds for the channel (ie. weekly, biweekly, triweekly, monthly)
	Interval IntervalEnum

	// Weekday is the weekday in which new chat roulette rounds are started for the channel (ie. Sunday, Monday, etc.)
	Weekday time.Weekday

	// Hour is the hour in which new chat roulette rounds are started for the channel (ie. 10, 12, 18)
	Hour int

	// NextRound is the timestamp of the next chat roulette round
	NextRound time.Time

	// CreatedAt is the timestamp of when the record was first created
	CreatedAt time.Time

	// UpdatedAt is the timestamp of when the record was last updated
	UpdatedAt time.Time
}

type GenericJob[T any] struct {
	// JobType is the type of background job.
	JobType jobTypeEnum
	// Params are the parameters for the job.
	// This must match the job type.
	Params T
	// Priority is the priority in the queue.
	// This is optional and will default to JobPriorityStandard.
	Priority int
	// ExecAt is the execution time.
	// This is optional and will default to time.Now().
	ExecAt time.Time
}

type IntervalEnum int64

type Job struct {
	// ID is the primary key of the record
	ID int32 `gorm:"primaryKey"`

	// JobID is the unique ID for the job
	JobID ksuid.KSUID `gorm:"column:job_id"`

	// JobType is the type of job
	JobType jobTypeEnum

	// Priority is the execution priority (1 - 10) for the job in the queue, with 10 being highest
	Priority int

	// Status is the completion status (success, failed, etc.) for a job
	Status jobStatusEnum

	// IsCompleted is a boolean flag for checking if the job has been completed
	IsCompleted bool

	// Data is the JSON data for the job
	Data datatypes.JSON

	// ExecAt is the timestamp of when the job should be executed
	ExecAt time.Time

	// CreatedAt is the timestamp of when the record was first created
	CreatedAt time.Time

	// UpdatedAt is the timestamp of when the record was last updated
	UpdatedAt time.Time
}

type Match struct {
	// ID is the primary key for the table
	ID int32 `gorm:"primaryKey"`

	// RoundID is the ID of the chat roulette round
	RoundID int32 `gorm:"foreignKey:RoundID;references:Round"`

	// MpimID is the ID of the Slack group DM
	MpimID string `gorm:"column:mpim_id"`

	// HasMet is a boolean flag for if the match has met for chat roulette
	HasMet bool

	// WasNotified is a boolean flag for if the match has been notified
	WasNotified bool

	// CreatedAt is the timestamp of when the record was first created
	CreatedAt time.Time

	// UpdatedAt is the timestamp of when the record was last updated
	UpdatedAt time.Time
}

type Member struct {
	// ID is the primary key for the table
	ID int32 `gorm:"primaryKey"`

	// UserID is the ID of the Slack user
	UserID string

	// ChannelID is the ID of the Slack channel that the user is a member of
	ChannelID string `gorm:"foreignKey:ChannelID;references:Channel"`

	// Country is the country in which the Slack user resides
	Country sqlcrypter.EncryptedBytes

	// City is the city in which the Slack user resides
	City sqlcrypter.EncryptedBytes

	// Timezone is the timezone that the Slack user is in
	Timezone sqlcrypter.EncryptedBytes

	// ProfileType is the Slack user's social profile type
	ProfileType sqlcrypter.EncryptedBytes

	// ProfileLink is the link to the Slack user's social profile
	ProfileLink sqlcrypter.EncryptedBytes

	// CalendlyLink is a link for the user's Calendly
	CalendlyLink sqlcrypter.EncryptedBytes

	// IsActive is a boolean flag for if the user is participating in chat roulette
	//
	// A pointer is used here to ensure non-zero value (ie. false) is saved.
	IsActive *bool

	// CreatedAt is the timestamp of when the record was first created
	CreatedAt time.Time

	// UpdatedAt is the timestamp of when the record was last updated
	UpdatedAt time.Time
}

type Pairing struct {
	// ID is an auto-incrementing identifier for the table
	ID int32 `gorm:"autoIncrement"`

	// MatchID is the ID of the chat roulette match
	MatchID int32 `gorm:"primaryKey;foreignKey:MatchID;references:Match"`

	// MemberID is the ID of the Slack user in this chat roulette match
	MemberID int32 `gorm:"primaryKey;foreignKey:MemberID;references:Members"`

	// CreatedAt is the timestamp of when the record was first created
	CreatedAt time.Time
}

type Round struct {
	// ID is the primary key for the table
	ID int32 `gorm:"primaryKey"`

	// ChannelID is the ID of the Slack channel for this round
	ChannelID string `gorm:"foreignKey:ChannelID;references:Channel"`

	// HasEnded is a boolean flag for if the chat roulette round has concluded
	HasEnded bool

	// CreatedAt is the timestamp of when the record was first created
	CreatedAt time.Time

	// UpdatedAt is the timestamp of when the record was last updated
	UpdatedAt time.Time
}