models

type Category struct {
	orm.BaseModel
	ParentID *uint
	Name     string

	Parent   orm.BelongsTo[Category] `orm:"foreignKey:parent_id"`
	Children orm.HasMany[Category]   `orm:"foreignKey:parent_id"`
	Posts    orm.HasMany[Post]
}

type Comment struct {
	orm.BaseModel
	UserID          uint
	CommentableType string
	CommentableID   uint
	Body            string

	User        orm.BelongsTo[User]
	Commentable orm.MorphTo `orm:"morph:commentable"`
}

type Country struct {
	orm.BaseModel
	Code string
	Name string

	Users orm.HasMany[User]
	Posts orm.HasManyThrough[Post, User]
}

type Order struct {
	orm.BaseModel
	UserID   uint
	Status   string
	Total    float64
	PlacedAt *time.Time

	User  orm.BelongsTo[User]
	Items orm.HasMany[OrderItem]
}

type OrderItem struct {
	OrderID   uint `gorm:"primaryKey"`
	LineNo    uint `gorm:"primaryKey;autoIncrement:false"`
	ProductID uint
	Quantity  int
	UnitPrice float64

	Order   orm.BelongsTo[Order]
	Product orm.BelongsTo[Product]
}

type Post struct {
	orm.BaseModel
	UserID     uint
	CategoryID *uint
	Slug       string
	Title      string
	Published  bool
	Archived   bool

	User     orm.BelongsTo[User]
	Category orm.BelongsTo[Category]
	Comments orm.MorphMany[Comment] `orm:"morph:commentable"`
	Tags     orm.MorphToMany[Tag]   `orm:"morph:taggable"`
}

type Product struct {
	orm.BaseModel
	SKU   string `gorm:"column:sku"`
	Name  string
	Price float64
	Stock int
}

type Profile struct {
	orm.BaseModel
	UserID uint
	Bio    *string

	User orm.BelongsTo[User]
}

type Role struct {
	orm.BaseModel
	Name string

	Users orm.BelongsToMany[User]
}

type Tag struct {
	orm.BaseModel
	Name string

	Posts  orm.MorphedByMany[Post]  `orm:"morph:taggable"`
	Videos orm.MorphedByMany[Video] `orm:"morph:taggable"`
}

type User struct {
	orm.SoftDeleteModel
	CountryID uint
	Email     string
	Name      string
	Password  string
	Role      string `gorm:"default:member"`
	APIToken  string
	Birthday  *time.Time
	Settings  orm.JSONColumn[UserSettings]

	Country  orm.BelongsTo[Country]
	Profile  orm.HasOne[Profile]
	Posts    orm.HasMany[Post]
	Videos   orm.HasMany[Video]
	Comments orm.HasMany[Comment]
	Orders   orm.HasMany[Order]
	Roles    orm.BelongsToMany[Role]
}

type UserSettings struct {
	Theme         string `json:"theme"`
	Notifications bool   `json:"notifications"`
}

type Video struct {
	orm.BaseModel
	UserID  uint
	Title   string
	Seconds int

	User     orm.BelongsTo[User]
	Comments orm.MorphMany[Comment] `orm:"morph:commentable"`
	Tags     orm.MorphToMany[Tag]   `orm:"morph:taggable"`
}