mysqltool

Documentation

Index

• func NewMySQLFromConfig(c *Config, opts ...Option) (*gorm.DB, error)
• func SetMultiDb(db *gorm.DB)
• type Config
• type IdType
• type IsDelType
• type Option
  • func WithIdleConn(idleConn int) Option
  • func WithMaxConn(maxConn int) Option
• type Order
• type OrderGoods

Functions

func NewMySQLFromConfig

func NewMySQLFromConfig(c *Config, opts ...Option) (*gorm.DB, error)

NewMySQLFromConfig 创建gorm mysql DB

func SetMultiDb

func SetMultiDb(db *gorm.DB)

Types

type Config

type Config struct {
	Host     string //mysql host
	Port     int    //mysql port
	Username string //mysql user
	Password string //mysql pwd
	DbName   string //db name
	MaxConn  int    //最大连接数 默认200
	IdleConn int    //空闲时连接数 默认20
	LogFile  string `json:",default=log/db"`
	Dsn      string
}

type IdType

type IdType struct {
	Id        int64      `gorm:"primarykey" json:"id"`
	CreatedAt time.Time  `json:"created_at"`
	UpdatedAt *time.Time `json:"updated_at"`
	IsDelType
}

type IsDelType

type IsDelType struct {
	DeletedAt *time.Time            `json:"deleted_at"`
	IsDeleted soft_delete.DeletedAt `gorm:"type:tinyint(4);softDelete:flag,DeletedAtField:DeletedAt;default:0" json:"is_deleted"`
}

type Option

type Option func(c *Config)

func WithIdleConn

func WithIdleConn(idleConn int) Option

func WithMaxConn

func WithMaxConn(maxConn int) Option

type Order

type Order struct {
	OrderId string       `gorm:"primarykey;type:varchar(50);" json:"orderId"`
	Amount  int64        `json:"amount"`
	Goods   []OrderGoods `json:"goods"`
}

type OrderGoods

type OrderGoods struct {
	OrderId string `gorm:"primarykey;type:varchar(50);" json:"orderId"`
	SkuId   string `gorm:"primarykey;type:varchar(50);" json:"skuId"`
	Num     int    `json:"num"`
	Price   int64  `json:"price"`
}