models

package
v0.1.20 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Jan 16, 2026 License: MIT Imports: 13 Imported by: 0

Documentation

Overview

Code generated by genx:model DO NOT EDIT.

Code generated by genx:model DO NOT EDIT.

Code generated by genx:model DO NOT EDIT.

Code generated by genx:model DO NOT EDIT.

Code generated by genx:model DO NOT EDIT.

Index

Constants

This section is empty.

Variables

View Source 
var Catalog = builder.NewCatalog()
View Source 
var TOrder *tOrder
View Source 
var TOrderSnapshot *tOrderSnapshot
View Source 
var TProduct *tProduct
View Source 
var TShipment *tShipment
View Source 
var TUser *tUser

Functions

This section is empty.

Types

type Order 

type Order struct {
	types.AutoIncID

	RelUser
	RelOrder
	OrderData

	types.CreationModificationTime
}

Order 订单 +genx:model @attr TableName=t_order @attr Register=Catalog @def pk ID @def u_idx ui_order_id OrderID @def idx i_status Status @def idx i_created_at CreatedAt @def idx i_updated_at UpdatedAt

func (*Order) Create 

func (m *Order) Create(ctx context.Context) error

Create inserts Order to database

func (*Order) DeleteByID 

func (m *Order) DeleteByID(ctx context.Context) error

DeleteByID delete Order recode by Order.ID

func (*Order) DeleteByOrderID 

func (m *Order) DeleteByOrderID(ctx context.Context) error

DeleteByOrderID delete Order recode by Order.OrderID

func (*Order) FetchByID 

func (m *Order) FetchByID(ctx context.Context) error

FetchByID fetch Order by Order.ID

func (*Order) FetchByOrderID 

func (m *Order) FetchByOrderID(ctx context.Context) error

FetchByOrderID fetch Order by Order.OrderID

func (Order) Indexes 

func (m Order) Indexes() map[string][]string

Indexes returns index list of Order

func (*Order) List 

func (m *Order) List(ctx context.Context, cond builder.SqlCondition, adds builder.Additions, expects ...builder.Col) ([]Order, error)

List fetch Order datalist with condition and additions

func (Order) PrimaryKey 

func (m Order) PrimaryKey() []string

PrimaryKey returns column list of Order's primary key

func (Order) TableDesc 

func (m Order) TableDesc() []string

TableDesc returns descriptions of Order

func (Order) TableName 

func (m Order) TableName() string

TableName returns database table name of Order

func (Order) UniqueIndexes 

func (m Order) UniqueIndexes() map[string][]string

UniqueIndexes returns unique index list of Order

func (*Order) UpdateAndFetchByID 

func (m *Order) UpdateAndFetchByID(ctx context.Context, targets ...builder.Col) error

UpdateAndFetchByID update Order by Order.ID and retrieve record

func (*Order) UpdateAndFetchByOrderID 

func (m *Order) UpdateAndFetchByOrderID(ctx context.Context, targets ...builder.Col) error

UpdateAndFetchByOrderID update Order by Order.OrderID and retrieve record

func (*Order) UpdateByID 

func (m *Order) UpdateByID(ctx context.Context, expects ...builder.Col) error

UpdateByID update Order by Order.ID

func (*Order) UpdateByOrderID 

func (m *Order) UpdateByOrderID(ctx context.Context, expects ...builder.Col) error

UpdateByOrderID update Order by Order.OrderID

type OrderData 

type OrderData struct {
	// OrderNo 订单编号
	OrderNo string `db:"order_no,width=64"`
	// Amount 订单金额
	Amount types.Decimal `db:"amount,width=22,precision=4"`
	// Currency 结算币种
	Currency enums.Currency `db:"currency"`
	// PaidAt 订单支付时间
	PaidAt sqltime.Timestamp `db:"paid_at,default=0"`
	// CanceledAt 订单取消时间
	CanceledAt sqltime.Timestamp `db:"canceled_at,default=0"`
	// Status 订单状态
	Status enums.OrderStatus `db:"status"`
}

type OrderID 

type OrderID uint64

type OrderSnapshot 

type OrderSnapshot struct {
	types.AutoIncID

	RelOrder
	RelProduct
	OrderSnapshotData

	types.CreationTime
}

OrderSnapshot 订单快照 +genx:model @attr TableName=t_order_snapshot @attr Register=Catalog @def pk ID @def u_idx ui_order_id OrderID @def idx i_product_name ProductName @def idx i_created_at CreatedAt

func (*OrderSnapshot) Create 

func (m *OrderSnapshot) Create(ctx context.Context) error

Create inserts OrderSnapshot to database

func (*OrderSnapshot) DeleteByID 

func (m *OrderSnapshot) DeleteByID(ctx context.Context) error

DeleteByID delete OrderSnapshot recode by OrderSnapshot.ID

func (*OrderSnapshot) DeleteByOrderID 

func (m *OrderSnapshot) DeleteByOrderID(ctx context.Context) error

DeleteByOrderID delete OrderSnapshot recode by OrderSnapshot.OrderID

func (*OrderSnapshot) FetchByID 

func (m *OrderSnapshot) FetchByID(ctx context.Context) error

FetchByID fetch OrderSnapshot by OrderSnapshot.ID

func (*OrderSnapshot) FetchByOrderID 

func (m *OrderSnapshot) FetchByOrderID(ctx context.Context) error

FetchByOrderID fetch OrderSnapshot by OrderSnapshot.OrderID

func (OrderSnapshot) Indexes 

func (m OrderSnapshot) Indexes() map[string][]string

Indexes returns index list of OrderSnapshot

func (*OrderSnapshot) List 

func (m *OrderSnapshot) List(ctx context.Context, cond builder.SqlCondition, adds builder.Additions, expects ...builder.Col) ([]OrderSnapshot, error)

List fetch OrderSnapshot datalist with condition and additions

func (OrderSnapshot) PrimaryKey 

func (m OrderSnapshot) PrimaryKey() []string

PrimaryKey returns column list of OrderSnapshot's primary key

func (OrderSnapshot) TableDesc 

func (m OrderSnapshot) TableDesc() []string

TableDesc returns descriptions of OrderSnapshot

func (OrderSnapshot) TableName 

func (m OrderSnapshot) TableName() string

TableName returns database table name of OrderSnapshot

func (OrderSnapshot) UniqueIndexes 

func (m OrderSnapshot) UniqueIndexes() map[string][]string

UniqueIndexes returns unique index list of OrderSnapshot

func (*OrderSnapshot) UpdateAndFetchByID 

func (m *OrderSnapshot) UpdateAndFetchByID(ctx context.Context, targets ...builder.Col) error

UpdateAndFetchByID update OrderSnapshot by OrderSnapshot.ID and retrieve record

func (*OrderSnapshot) UpdateAndFetchByOrderID 

func (m *OrderSnapshot) UpdateAndFetchByOrderID(ctx context.Context, targets ...builder.Col) error

UpdateAndFetchByOrderID update OrderSnapshot by OrderSnapshot.OrderID and retrieve record

func (*OrderSnapshot) UpdateByID 

func (m *OrderSnapshot) UpdateByID(ctx context.Context, expects ...builder.Col) error

UpdateByID update OrderSnapshot by OrderSnapshot.ID

func (*OrderSnapshot) UpdateByOrderID 

func (m *OrderSnapshot) UpdateByOrderID(ctx context.Context, expects ...builder.Col) error

UpdateByOrderID update OrderSnapshot by OrderSnapshot.OrderID

type OrderSnapshotData 

type OrderSnapshotData struct {
	// ProductSKU 产品SKU
	ProductSKU string `db:"product_sku,width=64"`
	// ProductName 产品名称 Product.Name
	ProductName string `db:"product_name,width=256"`
	// Price 产品单价 Product.Price
	Price types.Decimal `db:"price,width=22,precision=4"`
	// Quantity 订单产品数量
	Quantity int64 `db:"quantity"`
	// Subtotal 订单金额
	Subtotal types.Decimal `db:"subtotal,width=22,precision=4"`
}

type Product 

type Product struct {
	types.AutoIncID

	RelProduct
	ProductData

	types.CreationModificationDeletionTime
}

Product 商品 +genx:model @attr TableName=t_product @attr Register=Catalog @def pk ID @def u_idx ui_product_id ProductID,DeletedAt @def idx i_product_name Name @def idx i_status Status @def idx i_updated_at UpdatedAt

func (*Product) Create 

func (m *Product) Create(ctx context.Context) error

Create inserts Product to database

func (*Product) DeleteByID 

func (m *Product) DeleteByID(ctx context.Context) error

DeleteByID delete Product recode by Product.ID

func (*Product) DeleteByProductID 

func (m *Product) DeleteByProductID(ctx context.Context) error

DeleteByProductID delete Product recode by Product.ProductID

func (*Product) FetchByID 

func (m *Product) FetchByID(ctx context.Context) error

FetchByID fetch Product by Product.ID

func (*Product) FetchByProductID 

func (m *Product) FetchByProductID(ctx context.Context) error

FetchByProductID fetch Product by Product.ProductID

func (Product) Indexes 

func (m Product) Indexes() map[string][]string

Indexes returns index list of Product

func (*Product) List 

func (m *Product) List(ctx context.Context, cond builder.SqlCondition, adds builder.Additions, expects ...builder.Col) ([]Product, error)

List fetch Product datalist with condition and additions

func (*Product) MarkDeletionByID 

func (m *Product) MarkDeletionByID(ctx context.Context) error

MarkDeletionByID marks Product as deleted

func (*Product) MarkDeletionByProductID 

func (m *Product) MarkDeletionByProductID(ctx context.Context) error

MarkDeletionByProductID marks Product as deleted

func (Product) PrimaryKey 

func (m Product) PrimaryKey() []string

PrimaryKey returns column list of Product's primary key

func (Product) TableDesc 

func (m Product) TableDesc() []string

TableDesc returns descriptions of Product

func (Product) TableName 

func (m Product) TableName() string

TableName returns database table name of Product

func (Product) UniqueIndexes 

func (m Product) UniqueIndexes() map[string][]string

UniqueIndexes returns unique index list of Product

func (*Product) UpdateAndFetchByID 

func (m *Product) UpdateAndFetchByID(ctx context.Context, targets ...builder.Col) error

UpdateAndFetchByID update Product by Product.ID and retrieve record

func (*Product) UpdateAndFetchByProductID 

func (m *Product) UpdateAndFetchByProductID(ctx context.Context, targets ...builder.Col) error

UpdateAndFetchByProductID update Product by Product.ProductID and retrieve record

func (*Product) UpdateByID 

func (m *Product) UpdateByID(ctx context.Context, expects ...builder.Col) error

UpdateByID update Product by Product.ID

func (*Product) UpdateByProductID 

func (m *Product) UpdateByProductID(ctx context.Context, expects ...builder.Col) error

UpdateByProductID update Product by Product.ProductID

type ProductData 

type ProductData struct {
	// SKU 库存标签
	SKU string `db:"sku"`
	// Name 产品名称
	Name string `db:"name,width=256"`
	// Description 产品描述
	Description string `db:"description"`
	// Price 单价
	Price types.Decimal `db:"price,width=22,precision=4"`
	// Currency 货币
	Currency enums.Currency `db:"currency"`
	// Status 产品销售状态
	Status enums.ProductStatus `db:"status"`
}

type ProductID 

type ProductID int64

type RelOrder 

type RelOrder struct {
	// @rel Order.OrderID
	OrderID OrderID `db:"order_id"`
}

type RelProduct 

type RelProduct struct {
	// @rel Product.ProductID
	ProductID ProductID `db:"product_id"`
}

type RelUser 

type RelUser struct {
	// @rel User.UserID
	UserID UserID `db:"user_id"`
}

type Shipment 

type Shipment struct {
	types.AutoIncID

	RelOrder
	ShipmentData

	types.CreationModificationTime
}

Shipment 物流 +genx:model @attr TableName=t_shipment @attr Register=Catalog @def pk ID @def u_idx ui_order_id OrderID @def u_idx ui_tracking_no TrackingNo @def idx i_carrier Carrier @def idx i_status Status @def idx i_shipped_at ShippedAt @def idx i_delivered_at DeliveredAt

func (*Shipment) Create 

func (m *Shipment) Create(ctx context.Context) error

Create inserts Shipment to database

func (*Shipment) DeleteByID 

func (m *Shipment) DeleteByID(ctx context.Context) error

DeleteByID delete Shipment recode by Shipment.ID

func (*Shipment) DeleteByOrderID 

func (m *Shipment) DeleteByOrderID(ctx context.Context) error

DeleteByOrderID delete Shipment recode by Shipment.OrderID

func (*Shipment) DeleteByTrackingNo 

func (m *Shipment) DeleteByTrackingNo(ctx context.Context) error

DeleteByTrackingNo delete Shipment recode by Shipment.TrackingNo

func (*Shipment) FetchByID 

func (m *Shipment) FetchByID(ctx context.Context) error

FetchByID fetch Shipment by Shipment.ID

func (*Shipment) FetchByOrderID 

func (m *Shipment) FetchByOrderID(ctx context.Context) error

FetchByOrderID fetch Shipment by Shipment.OrderID

func (*Shipment) FetchByTrackingNo 

func (m *Shipment) FetchByTrackingNo(ctx context.Context) error

FetchByTrackingNo fetch Shipment by Shipment.TrackingNo

func (Shipment) Indexes 

func (m Shipment) Indexes() map[string][]string

Indexes returns index list of Shipment

func (*Shipment) List 

func (m *Shipment) List(ctx context.Context, cond builder.SqlCondition, adds builder.Additions, expects ...builder.Col) ([]Shipment, error)

List fetch Shipment datalist with condition and additions

func (Shipment) PrimaryKey 

func (m Shipment) PrimaryKey() []string

PrimaryKey returns column list of Shipment's primary key

func (Shipment) TableDesc 

func (m Shipment) TableDesc() []string

TableDesc returns descriptions of Shipment

func (Shipment) TableName 

func (m Shipment) TableName() string

TableName returns database table name of Shipment

func (Shipment) UniqueIndexes 

func (m Shipment) UniqueIndexes() map[string][]string

UniqueIndexes returns unique index list of Shipment

func (*Shipment) UpdateAndFetchByID 

func (m *Shipment) UpdateAndFetchByID(ctx context.Context, targets ...builder.Col) error

UpdateAndFetchByID update Shipment by Shipment.ID and retrieve record

func (*Shipment) UpdateAndFetchByOrderID 

func (m *Shipment) UpdateAndFetchByOrderID(ctx context.Context, targets ...builder.Col) error

UpdateAndFetchByOrderID update Shipment by Shipment.OrderID and retrieve record

func (*Shipment) UpdateAndFetchByTrackingNo 

func (m *Shipment) UpdateAndFetchByTrackingNo(ctx context.Context, targets ...builder.Col) error

UpdateAndFetchByTrackingNo update Shipment by Shipment.TrackingNo and retrieve record

func (*Shipment) UpdateByID 

func (m *Shipment) UpdateByID(ctx context.Context, expects ...builder.Col) error

UpdateByID update Shipment by Shipment.ID

func (*Shipment) UpdateByOrderID 

func (m *Shipment) UpdateByOrderID(ctx context.Context, expects ...builder.Col) error

UpdateByOrderID update Shipment by Shipment.OrderID

func (*Shipment) UpdateByTrackingNo 

func (m *Shipment) UpdateByTrackingNo(ctx context.Context, expects ...builder.Col) error

UpdateByTrackingNo update Shipment by Shipment.TrackingNo

type ShipmentData 

type ShipmentData struct {
	// Carrier 物流运营商
	Carrier string `db:"carrier,width=64"`
	// TrackingNo 物流单号
	TrackingNo string `db:"tracking_no"`
	// Status 物流状态
	Status enums.ShipmentStatus `db:"status"`
	// ShippedAt 开始运输时间
	ShippedAt sqltime.Timestamp `db:"shipped_at"`
	// DeliveredAt 抵达时间
	DeliveredAt sqltime.Timestamp `db:"delivered_at"`
}

type User 

type User struct {
	types.AutoIncID

	RelUser
	UserData

	types.OperationDatetime
}

User 用户 +genx:model @attr TableName=t_user @attr Register=Catalog @def pk ID @def u_idx ui_user_id UserID @def idx ui_username Username @def idx i_status Status @def idx i_created_at CreatedAt

func (*User) Create 

func (m *User) Create(ctx context.Context) error

Create inserts User to database

func (*User) DeleteByID 

func (m *User) DeleteByID(ctx context.Context) error

DeleteByID delete User recode by User.ID

func (*User) DeleteByUserID 

func (m *User) DeleteByUserID(ctx context.Context) error

DeleteByUserID delete User recode by User.UserID

func (*User) FetchByID 

func (m *User) FetchByID(ctx context.Context) error

FetchByID fetch User by User.ID

func (*User) FetchByUserID 

func (m *User) FetchByUserID(ctx context.Context) error

FetchByUserID fetch User by User.UserID

func (User) Indexes 

func (m User) Indexes() map[string][]string

Indexes returns index list of User

func (*User) List 

func (m *User) List(ctx context.Context, cond builder.SqlCondition, adds builder.Additions, expects ...builder.Col) ([]User, error)

List fetch User datalist with condition and additions

func (*User) MarkDeletionByID 

func (m *User) MarkDeletionByID(ctx context.Context) error

MarkDeletionByID marks User as deleted

func (*User) MarkDeletionByUserID 

func (m *User) MarkDeletionByUserID(ctx context.Context) error

MarkDeletionByUserID marks User as deleted

func (User) PrimaryKey 

func (m User) PrimaryKey() []string

PrimaryKey returns column list of User's primary key

func (User) TableDesc 

func (m User) TableDesc() []string

TableDesc returns descriptions of User

func (User) TableName 

func (m User) TableName() string

TableName returns database table name of User

func (User) UniqueIndexes 

func (m User) UniqueIndexes() map[string][]string

UniqueIndexes returns unique index list of User

func (*User) UpdateAndFetchByID 

func (m *User) UpdateAndFetchByID(ctx context.Context, targets ...builder.Col) error

UpdateAndFetchByID update User by User.ID and retrieve record

func (*User) UpdateAndFetchByUserID 

func (m *User) UpdateAndFetchByUserID(ctx context.Context, targets ...builder.Col) error

UpdateAndFetchByUserID update User by User.UserID and retrieve record

func (*User) UpdateByID 

func (m *User) UpdateByID(ctx context.Context, expects ...builder.Col) error

UpdateByID update User by User.ID

func (*User) UpdateByUserID 

func (m *User) UpdateByUserID(ctx context.Context, expects ...builder.Col) error

UpdateByUserID update User by User.UserID

type UserData 

type UserData struct {
	// Username 用户名
	Username string `db:"username,width=127"`
	// Email 邮箱
	Email string `db:"email,width=127"`
	// Phone 电话
	Phone string `db:"phone,width=32"`
	// Status 用户状态
	Status enums.UserStatus `db:"status"`
}

type UserID 

type UserID uint64

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.