models

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

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)
}

type Bottle struct {
	ID               int              `gorm:"primary_key"` // primary key
	AccountID        int              // Belongs To Account
	BottleCategories []BottleCategory // has many BottleCategories
	Categories       []Category       `gorm:"many2many:bottle_categories"` // many to many Bottle/Category
	Name             string
	Quantity         int
	CreatedAt        time.Time  // timestamp
	DeletedAt        *time.Time // nullable timestamp (soft delete)
	UpdatedAt        time.Time  // timestamp
	Account          Account
}

type BottleCategory struct {
	ID         int        `gorm:"primary_key"` // primary key
	BottleID   int        // Belongs To Bottle
	CategoryID int        // has many BottleCategory
	CreatedAt  time.Time  // timestamp
	DeletedAt  *time.Time // nullable timestamp (soft delete)
	UpdatedAt  time.Time  // timestamp
	Bottle     Bottle
	Category   Category
}

type BottleCategoryDB struct {
	Db *gorm.DB
}

type BottleCategoryStorage interface {
	DB() interface{}
	List(ctx context.Context) ([]*BottleCategory, error)
	Get(ctx context.Context, id int) (*BottleCategory, error)
	Add(ctx context.Context, bottlecategory *BottleCategory) error
	Update(ctx context.Context, bottlecategory *BottleCategory) error
	Delete(ctx context.Context, id int) error
}

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)

	ListBottleRelation(ctx context.Context, accountID int) []*app.BottleRelation
	OneBottleRelation(ctx context.Context, id int, accountID int) (*app.BottleRelation, error)
}

type Category struct {
	ID               int              `gorm:"primary_key"` // primary key
	BottleCategories []BottleCategory // has many BottleCategories
	Bottles          []Bottle         `gorm:"many2many:Bottles"` // many to many Category/Bottle
	Name             string
	CreatedAt        time.Time  // timestamp
	DeletedAt        *time.Time // nullable timestamp (soft delete)
	UpdatedAt        time.Time  // timestamp
}

type CategoryDB struct {
	Db *gorm.DB
}

type CategoryStorage interface {
	DB() interface{}
	List(ctx context.Context) ([]*Category, error)
	Get(ctx context.Context, id int) (*Category, error)
	Add(ctx context.Context, category *Category) error
	Update(ctx context.Context, category *Category) error
	Delete(ctx context.Context, id int) error

	ListCategory(ctx context.Context) []*app.Category
	OneCategory(ctx context.Context, id int) (*app.Category, error)
}