db

type DBChangeset struct {
	Id            int         `db:"id"`
	ChangeId      string      `db:"changeId"`
	NextChangeId  string      `db:"nextChangeId"`
	StashCount    int         `db:"stashCount"`
	ProcessedAt   time.Time   `db:"processedAt"`
	TimeTakenMs   int64       `db:"timeTaken"`
	DriftFromHead pgtype.Int4 `db:"driftFromHead"`
}

type DBJewel struct {
	Id                int       `db:"id"`
	JewelType         string    `db:"jewelType"`
	JewelClass        string    `db:"jewelClass"`
	AllocatedNode     string    `db:"allocatedNode"`
	ItemId            string    `db:"itemId"`
	StashId           string    `db:"stashId"`
	League            string    `db:"league"`
	ListPriceAmount   float64   `db:"listPriceAmount"`
	ListPriceCurrency string    `db:"listPriceCurrency"`
	LastChangeId      string    `db:"lastChangeId"`
	RecordedAt        time.Time `db:"recordedAt"`
}

type DBJewelSnapshot struct {
	Id                 int       `db:"id"`
	SetId              int       `db:"setId"`
	JewelType          string    `db:"jewelType"`
	JewelClass         string    `db:"jewelClass"`
	AllocatedNode      string    `db:"allocatedNode"`
	MinPrice           float64   `db:"minPrice"`
	FirstQuartilePrice float64   `db:"firstQuartilePrice"`
	MedianPrice        float64   `db:"medianPrice"`
	ThirdQuartilePrice float64   `db:"thirdQuartilePrice"`
	MaxPrice           float64   `db:"maxPrice"`
	WindowPrice        float64   `db:"windowPrice"`
	Confidence         float64   `db:"confidence"`
	Stddev             float64   `db:"stddev"`
	NumListed          int       `db:"numListed"`
	GeneratedAt        time.Time `db:"generatedAt"`
}

type DBSnapshotSet struct {
	Id            int                `db:"id"`
	League        string             `db:"league"`
	ExchangeRates map[string]float64 `db:"exchangeRates"`
	GeneratedAt   time.Time          `db:"generatedAt"`
}

type PGXScanner interface {
	Scan(dest ...interface{}) (err error)
}