models

type Account struct {
	ID        int      `gorm:"primary_key"` // primary key
	Bottles   []Bottle // has many Bottles
	CreatedAt time.Time
	DeletedAt *time.Time
	Name      string
	UpdatedAt time.Time
}

type AccountDB struct {
	Db *gorm.DB
}

type AccountStorage interface {
	DB() interface{}
	List(ctx context.Context) ([]*Account, error)
	Get(ctx context.Context, id int) (*Account, error)
	Add(ctx context.Context, account *Account) error
	Update(ctx context.Context, account *Account) error
	Delete(ctx context.Context, id int) error

	ListAccount(ctx context.Context) []*app.Account
	OneAccount(ctx context.Context, id int) (*app.Account, error)

	ListAccountLink(ctx context.Context) []*app.AccountLink
	OneAccountLink(ctx context.Context, id int) (*app.AccountLink, error)

	ListAccountTiny(ctx context.Context) []*app.AccountTiny
	OneAccountTiny(ctx context.Context, id int) (*app.AccountTiny, error)
}

type Bottle struct {
	ID        int `gorm:"primary_key"` // primary key
	AccountID int // Belongs To Account
	Color     string
	Country   *string
	CreatedAt time.Time
	DeletedAt *time.Time
	Name      string
	Rating    int
	Region    *string
	Review    *string
	Sweetness *int
	UpdatedAt time.Time
	Varietal  string
	Vineyard  string
	Vintage   int
	Account   Account
}

type BottleDB struct {
	Db *gorm.DB
}

type BottleStorage interface {
	DB() interface{}
	List(ctx context.Context) ([]*Bottle, error)
	Get(ctx context.Context, id int) (*Bottle, error)
	Add(ctx context.Context, bottle *Bottle) error
	Update(ctx context.Context, bottle *Bottle) error
	Delete(ctx context.Context, id int) error

	ListBottle(ctx context.Context, accountID int) []*app.Bottle
	OneBottle(ctx context.Context, id int, accountID int) (*app.Bottle, error)

	ListBottleFull(ctx context.Context, accountID int) []*app.BottleFull
	OneBottleFull(ctx context.Context, id int, accountID int) (*app.BottleFull, error)

	ListBottleTiny(ctx context.Context, accountID int) []*app.BottleTiny
	OneBottleTiny(ctx context.Context, id int, accountID int) (*app.BottleTiny, error)

	BottleFromCreateBottlePayload(payload *app.CreateBottlePayload) *Bottle
	UpdateFromBottlePayload(ctx context.Context, payload *app.BottlePayload, id int) error
	UpdateFromCreateBottlePayload(ctx context.Context, payload *app.CreateBottlePayload, id int) error
}