mysql

package

v0.0.16 Latest Latest Go to latest Published: Jun 28, 2022 License: MIT Imports: 10 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

gitee.com/natas-public/beego-utils

Links

Open Source Insights

Documentation ¶

Overview ¶

Package mysql ******************************************************************************

@DESC 数据库实体Entity操作
@AUTH Neo
@DATE 2022-03-14
@CHANGE LOGS
DATE CHANGER DETAIL *****************************************************************************

Package mysql ******************************************************************************

@DESC 数据查询公共操作
@AUTH Neo
@DATE 2022-03-14
@CHANGE LOGS
DATE CHANGER DETAIL *****************************************************************************

Package mysql ******************************************************************************

@DESC 连接MySQL数据库操作
@AUTH Neo
@DATE 2022-03-14
@CHANGE LOGS
DATE CHANGER DETAIL *****************************************************************************

Index ¶

Constants
func Begin(om orm.Ormer) (orm.TxOrmer, error)
func Commit(tx orm.TxOrmer) error
func GetModels() *map[string]*ModelInfo
func GetPagesInfo(tName string, curPage int64, pageSize int64, conditions string) (int64, int64, orm.RawSeter, error)
func MySQLClientLaunch()
func RegisterModelWithPrefix(prefix string, models ...interface{})
func Rollback(tx orm.TxOrmer) error
func RunSyncDB(afterSync AfterSyncFunc, initData InitDataFunc)
func SetQueryOrder(qs orm.QuerySeter, order map[string]bool) orm.QuerySeter
type AfterSyncFunc
type DBConfig
type FieldInfo
- func GetModelByField(mName string, fName string) *FieldInfo
type Fielder
type FilterDateRange
type FilterFloat64Range
type FilterInt64Range
type InitDataFunc
type ModelBase
type ModelBaseAuto
type ModelInfo
type PageInfo
- func QueryPage(qs orm.QuerySeter, pageSize int64, queryRet interface{}) (*PageInfo, error)
type PageQuery
type TagInfo

Constants ¶

View Source

const (
	SqlalterTimeTemplate       = "ALTER TABLE `%s` MODIFY COLUMN `%s` timestamp(3) DEFAULT current_timestamp(3) NULL COMMENT '%s';"
	SqlalterCreatetimeTemplate = "ALTER TABLE `%s` MODIFY COLUMN `create_time` timestamp(3) DEFAULT current_timestamp(3) NULL COMMENT '创建时间';"
	SqlalterUpdatetimeTemplate = "" /* 146-byte string literal not displayed */
)

Variables ¶

This section is empty.

Functions ¶

func Begin ¶ added in v0.0.6

func Begin(om orm.Ormer) (orm.TxOrmer, error)

Begin ******************************************************************************

@DESC Beego ORM事务Begin，增加错误日志处理
@PARAMS om orm.Ormer ORM对象
@RETURN orm.TxOrmer 启动事务的ORM对象
@AUTH Neo
@DATE 2022-03-14
@CHANGE LOGS
DATE CHANGER DETAIL *****************************************************************************

func Commit ¶ added in v0.0.6

func Commit(tx orm.TxOrmer) error

Commit ******************************************************************************

@DESC Beego ORM事务Commit，增加错误日志处理
@PARAMS tx orm.TxOrmer 启动事务的ORM对象
@RETURN
@AUTH Neo
@DATE 2022-03-14
@CHANGE LOGS
DATE CHANGER DETAIL *****************************************************************************

func GetModels ¶ added in v0.0.16

func GetModels() *map[string]*ModelInfo

func GetPagesInfo ¶ added in v0.0.3

func GetPagesInfo(tName string, curPage int64, pageSize int64, conditions string) (int64, int64, orm.RawSeter, error)

GetPagesInfo ******************************************************************************

@DESC 组装用于分页查询的RawSeter
@PARAMS
tName string 表名
curPage int64 当前页数
pageSize int64 每页记录数
condition string 拼接好的WHERE条件语句
@RETURN
int64 总记录数
int64 总页数
orm.RawSeter ORM查询器
@AUTH Neo
@DATE 2022-03-14
@CHANGE LOGS
DATE CHANGER DETAIL *****************************************************************************

func MySQLClientLaunch ¶

func MySQLClientLaunch()

MySQLClientLaunch ******************************************************************************

@DESC 启动创建MySQL数据库连接，读取配置文件中指定的信息，连接数据库
@PARAMS
@RETURN
@AUTH Neo
@DATE 2022-03-14
@CHANGE LOGS
DATE CHANGER DETAIL *****************************************************************************

func RegisterModelWithPrefix ¶ added in v0.0.16

func RegisterModelWithPrefix(prefix string, models ...interface{})

RegisterModelWithPrefix ******************************************************************************

@DESC 注册模型
@PARAMS prefix string 数据库表名前缀
models interface{} 结构体对象
@RETURN
@AUTH Neo
@DATE 2022-03-14
@CHANGE LOGS
DATE CHANGER DETAIL *****************************************************************************

func Rollback ¶ added in v0.0.6

func Rollback(tx orm.TxOrmer) error

Rollback ******************************************************************************

@DESC Beego ORM事务Rollback，增加错误日志处理
@PARAMS tx orm.TxOrmer 启动事务的ORM对象
@RETURN
@AUTH Neo
@DATE 2022-03-14
@CHANGE LOGS
DATE CHANGER DETAIL *****************************************************************************

func RunSyncDB ¶

func RunSyncDB(afterSync AfterSyncFunc, initData InitDataFunc)

RunSyncDB ******************************************************************************

@DESC 根据各Model定义，创建数据库表并初始化数据
@PARAMS afterSyncs []AfterSyncFunc 数据库表自动创建后的修补操作
initData InitDataFunc 数据初始化函数
@RETURN
@AUTH Neo
@DATE 2022-03-14
@CHANGE LOGS
DATE CHANGER DETAIL *****************************************************************************

func SetQueryOrder ¶ added in v0.0.3

func SetQueryOrder(qs orm.QuerySeter, order map[string]bool) orm.QuerySeter

SetQueryOrder ******************************************************************************

@DESC 查询器中设置排序标记
@PARAMS
qs orm.QuerySeter ORM查询器
order map[string]bool 排序表
@RETURN
orm.QuerySeter ORM查询器
@AUTH Neo
@DATE 2022-03-14
@CHANGE LOGS
DATE CHANGER DETAIL *****************************************************************************

Types ¶

type AfterSyncFunc ¶

type AfterSyncFunc func()

type DBConfig ¶

type DBConfig struct {
	Alias    string
	User     string
	Password string
	Host     string
	Database string
	Charset  string
	Loc      string
	Debug    bool
	Force    bool
	Verbose  bool
	Mock     bool
	MaxIdle  int
	MaxConn  int
}

type FieldInfo ¶ added in v0.0.16

type FieldInfo struct {
	JsonTag TagInfo
	OrmTag  TagInfo
	NeoTag  TagInfo
}

func GetModelByField ¶ added in v0.0.16

func GetModelByField(mName string, fName string) *FieldInfo

type Fielder ¶ added in v0.0.16

type Fielder interface {
	String() string
	FieldType() int
	SetRaw(interface{}) error
	RawValue() interface{}
}

Fielder define field info

type FilterDateRange ¶ added in v0.0.3

type FilterDateRange struct {
	Min *ntime.MTime
	Max *ntime.MTime
}

type FilterFloat64Range ¶ added in v0.0.3

type FilterFloat64Range struct {
	Min *float64
	Max *float64
}

type FilterInt64Range ¶ added in v0.0.3

type FilterInt64Range struct {
	Min *int64
	Max *int64
}

type InitDataFunc ¶

type InitDataFunc func()

type ModelBase ¶ added in v0.0.3

type ModelBase struct {
	ID         string      `json:"id"           orm:"column(id);pk;size(32);description(系统ID)"`
	Remark     string      `json:"remark"       orm:"null;column(remark);size(500);description(备注信息)"`
	CreateTime ntime.MTime `` /* 135-byte string literal not displayed */
	CreateUser string      `json:"createUser"   orm:"null;column(create_user);size(32);description(创建者ID)"`
	UpdateTime ntime.MTime `` /* 131-byte string literal not displayed */
	UpdateUser string      `json:"updateUser"   orm:"null;column(update_user);size(32);description(更新者ID)"`
}

type ModelBaseAuto ¶ added in v0.0.14

type ModelBaseAuto struct {
	ID         int32       `json:"id"         orm:"column(id);pk;auto;description(系统ID)"`
	Remark     string      `json:"remark"     orm:"null;column(remark);size(500);description(备注信息)"`
	CreateTime ntime.MTime `` /* 134-byte string literal not displayed */
	CreateUser string      `json:"createUser" orm:"null;column(create_user);size(32);description(创建者ID)"`
	UpdateTime ntime.MTime `` /* 129-byte string literal not displayed */
	UpdateUser string      `json:"updateUser" orm:"null;column(update_user);size(32);description(更新者ID)"`
}

type ModelInfo ¶ added in v0.0.16

type ModelInfo struct {
	TName      string
	FieldInfos map[string]*FieldInfo
}

type PageInfo ¶ added in v0.0.3

type PageInfo struct {
	Total    int64 `json:"total"`
	Page     int64 `json:"page"`
	PageSize int64 `json:"pageSize"`
	Pages    int64 `json:"pages"`
	Count    int64 `json:"count"`
}

func QueryPage ¶ added in v0.0.3

func QueryPage(qs orm.QuerySeter, pageSize int64, queryRet interface{}) (*PageInfo, error)

QueryPage ******************************************************************************

@DESC 查询分页数据
@PARAMS
qs orm.QuerySeter ORM查询器
pageSize int64 每页记录数
queryRet interface{} 查询结果集
@RETURN
*PageInfo 分页信息
@AUTH Neo
@DATE 2022-03-14
@CHANGE LOGS
DATE CHANGER DETAIL *****************************************************************************

type PageQuery ¶ added in v0.0.3

type PageQuery struct {
	Page     int64           `json:"page"`
	PageSize int64           `json:"pageSize"`
	Order    map[string]bool `json:"order"`
}

type TagInfo ¶ added in v0.0.16

type TagInfo struct {
	Attrs map[string]bool
	Tags  map[string]string
}

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL