mysql_gorm

Documentation

Index

• func NewDefaultGormDb(config Config) *gorm.DB
• func NewGormDbWithDriverConfig(driverConfig mysql.Config, config Config) *gorm.DB
• type Config
  • func (m *Config) Dsn() string
• type DefaultPage
• type GormBaseModel
• type GormBaseModelWithId
• type GormBaseModelWithOutLogicDelete
• type Page
• type PageData
  • func FindPageData[T any, M any](db *gorm.DB, page Page) (pagedata PageData[T], err error)
  • func FindPageDataNilModel[T any](db *gorm.DB, page Page) (pagedata PageData[T], err error)
  • func GetPageData[T any, M any](db *gorm.DB, page Page, isScan bool) (pagedata PageData[T], err error)
  • func GetPageDataNilModel[T any](db *gorm.DB, page Page, isScan bool) (pagedata PageData[T], err error)
  • func ScanPageData[T any, M any](db *gorm.DB, page Page) (pagedata PageData[T], err error)
  • func ScanPageDataNilModel[T any](db *gorm.DB, page Page) (pagedata PageData[T], err error)
  • func (p PageData[T]) MarshalBinary() ([]byte, error)

Functions

func NewDefaultGormDb

func NewDefaultGormDb(config Config) *gorm.DB

NewDefaultGormDb new a default gorm db,generally used in svc.NewServiceContext(c config.Config) *ServiceContext

func NewGormDbWithDriverConfig

func NewGormDbWithDriverConfig(driverConfig mysql.Config, config Config) *gorm.DB

Types

type Config

type Config struct {
	Path         string          // 服务器地址:端口
	Port         int             `json:",default=3306"` // 端口
	Config       string          // 高级配置
	Dbname       string          // 数据库名
	Username     string          // 数据库用户名
	Password     string          // 数据库密码
	MaxIdleConns int             // 空闲中的最大连接数
	MaxOpenConns int             // 打开到数据库的最大连接数
	LogMode      logger.LogLevel // 是否开启Gorm全局日志
	LogZap       bool            `json:"LogZap,optional,default=false"` // 是否通过zap写入日志文件
}

func (*Config) Dsn

func (m *Config) Dsn() string

type DefaultPage

type DefaultPage struct {
	Count int `json:"size"` //大小
	Page  int `json:"page"` //页码
}

type GormBaseModel

type GormBaseModel struct {
	CreatedAt int64          `json:"created_at" gorm:"autoCreateTime:milli"`
	UpdatedAt int64          `json:"updated_at" gorm:"autoUpdateTime:milli"`
	DeletedAt gorm.DeletedAt `json:"-" gorm:"index"`
}

type GormBaseModelWithId

type GormBaseModelWithId struct {
	Id uint `json:"id" gorm:"primaryKey"` //id
	GormBaseModel
}

type GormBaseModelWithOutLogicDelete

type GormBaseModelWithOutLogicDelete struct {
	CreatedAt int64 `json:"created_at" gorm:"autoCreateTime:milli"`
	UpdatedAt int64 `json:"updated_at" gorm:"autoUpdateTime:milli"`
}

type Page

type Page interface {
	GetCount() int
	GetPage() int
}

type PageData

type PageData[T any] struct {
	Total int64       `json:"total"` //总数
	Page  DefaultPage `json:"page"`  //页数信息
	Data  T           `json:"data"`  //数据
}

func FindPageData

func FindPageData[T any, M any](db *gorm.DB, page Page) (pagedata PageData[T], err error)

func FindPageDataNilModel

func FindPageDataNilModel[T any](db *gorm.DB, page Page) (pagedata PageData[T], err error)

func GetPageData

func GetPageData[T any, M any](db *gorm.DB, page Page, isScan bool) (pagedata PageData[T], err error)

func GetPageDataNilModel

func GetPageDataNilModel[T any](db *gorm.DB, page Page, isScan bool) (pagedata PageData[T], err error)

func ScanPageData

func ScanPageData[T any, M any](db *gorm.DB, page Page) (pagedata PageData[T], err error)

func ScanPageDataNilModel

func ScanPageDataNilModel[T any](db *gorm.DB, page Page) (pagedata PageData[T], err error)

func (PageData[T]) MarshalBinary

func (p PageData[T]) MarshalBinary() ([]byte, error)