database

type Bird struct {
	ID             uuid.UUID
	CreatedAt      time.Time
	UpdatedAt      time.Time
	CommonName     sql.NullString
	ScientificName sql.NullString
	Family         sql.NullString
	Order          sql.NullString
	Status         sql.NullString
	ImageUrls      []string
}

type CreateBirdParams struct {
	CommonName     sql.NullString
	ScientificName sql.NullString
	Family         sql.NullString
	Order          sql.NullString
	Status         sql.NullString
	ImageUrls      []string
}

type CreateMatchSessionParams struct {
	LeftbirdID   uuid.UUID
	RightbirdID  uuid.UUID
	SessionToken string
	ExpiresAt    time.Time
	UserIp       sql.NullString
	UserAgent    sql.NullString
}

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type GetTopRatingsRow struct {
	ID             uuid.UUID
	Matches        sql.NullInt32
	Rating         sql.NullInt32
	CommonName     sql.NullString
	ScientificName sql.NullString
	Status         sql.NullString
}

type Match struct {
	ID           uuid.UUID
	CreatedAt    time.Time
	UpdatedAt    time.Time
	WinnerbirdID uuid.UUID
	LoserbirdID  uuid.UUID
}

type MatchSession struct {
	ID           uuid.UUID
	CreatedAt    time.Time
	LeftbirdID   uuid.UUID
	RightbirdID  uuid.UUID
	SessionToken string
	ExpiresAt    time.Time
	Voted        sql.NullBool
	VotedAt      sql.NullTime
	WinnerbirdID uuid.NullUUID
	UserIp       sql.NullString
	UserAgent    sql.NullString
}

type PopulateRatingParams struct {
	Matches sql.NullInt32
	Rating  sql.NullInt32
	BirdID  uuid.UUID
}

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

type Rating struct {
	ID         uuid.UUID
	CreatedAt  time.Time
	UpdatedAt  time.Time
	Matches    sql.NullInt32
	Rating     sql.NullInt32
	BirdID     uuid.UUID
	CommonName sql.NullString
}

type RecordMatchParams struct {
	WinnerbirdID uuid.UUID
	LoserbirdID  uuid.UUID
}

type TestDB struct {
	Container *postgres.PostgresContainer
	DB        *sql.DB
	Queries   *Queries
	ConnStr   string
}

type UpdateRatingByBirdIDParams struct {
	Rating sql.NullInt32
	BirdID uuid.UUID
}

type VoteMatchParams struct {
	ID           uuid.UUID
	WinnerbirdID uuid.NullUUID
}