postgres

type BatchTx interface {
	Queue(query string, arguments ...any) *pgx.QueuedQuery
}

type ListRankOption struct {
	// Start indicates an inclusive lower bound on the date.
	Start *time.Time

	// End indicates an exclusive upper bound on the date.
	End *time.Time

	Offset, Limit uint

	Recent bool
}

type Match struct {
	ID string `db:"match_id"`

	Date time.Time `db:"date"`

	Duration time.Duration `db:"duration"`

	Version string `db:"version"`

	WinnerID int `db:"winner"`
}

type MatchStore struct{ Tx Tx }

type Migrator struct {
}

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

type Participant struct {
	PUUID string `db:"puuid"`

	MatchID string `db:"match_id"`

	TeamID int `db:"team"`

	ChampionID int `db:"champion"`

	ChampionLevel int `db:"champion_level"`

	TeamPosition string `db:"position"`

	SummonerIDs [2]int `db:"summoners"`

	Runes [11]int `db:"runes"`

	Items [7]int `db:"items"`

	Kills int `db:"kills"`

	Deaths int `db:"deaths"`

	Assists int `db:"assists"`

	KillParticipation float32 `db:"kill_participation"`

	CreepScore int `db:"creep_score"`

	CreepScorePerMinute float32 `db:"creep_score_per_minute"`

	DamageDealt int `db:"damage_dealt"`

	DamageTaken int `db:"damage_taken"`

	DamageDeltaEnemy int `db:"damage_delta_enemy"`

	DamagePercentageTeam float32 `db:"damage_percentage_team"`

	GoldEarned int `db:"gold_earned"`

	GoldDeltaEnemy int `db:"gold_delta_enemy"`

	GoldPercentageTeam float32 `db:"gold_percentage_team"`

	VisionScore int `db:"vision_score"`

	PinkWardsBought int `db:"pink_wards_bought"`
}

type PostgresSearchResult2 struct {
	Summoner Summoner

	Status *RankStatus
	Detail *RankDetail
}

type PostgresToRankStatus struct {
	Status RankStatus
	Detail *RankDetail
}

type PostgresToSummonerMatchMapper struct {
	Match Match

	Participant Participant

	BeforeStatus *RankStatus
	BeforeDetail *RankDetail

	AfterStatus *RankStatus
	AfterDetail *RankDetail
}

type RankDetail struct {
	RankStatusID int `db:"rank_status_id"`

	Wins int `db:"wins"`

	Losses int `db:"losses"`

	Tier string `db:"tier"`

	Division string `db:"division"`

	LP int `db:"lp"`
}

type RankFull struct {
	Status RankStatus
	Detail *RankDetail
}

type RankStatus struct {
	PUUID string `db:"puuid"`

	EffectiveDate time.Time `db:"effective_date"`

	// IsRanked indicates that there exists a [RankDetail] for this status.
	IsRanked bool `db:"is_ranked"`
}

type RankStore struct{ Tx Tx }

type Store struct {
	Pool *pgxpool.Pool
}

type Summoner struct {
	PUUID riot.PUUID

	Name, Tagline string
}

type SummonerStore struct{ Tx Tx }

type Tx interface {
	Exec(ctx context.Context, sql string, args ...any) (commandTag pgconn.CommandTag, err error)

	Query(ctx context.Context, sql string, args ...any) (pgx.Rows, error)

	QueryRow(ctx context.Context, sql string, args ...any) pgx.Row
}