db

Documentation

Overview

MySql引擎层

Index

• Variables
• func CreateLike(column string) string
• func CreatePage(page, limit int) uint64
• func Model2Map(m Model2MapParmas) (res map[string]interface{})
• func NewSQLX(driverName, dbSource string, maxOpenConns, maxIdleConns int) (db *sqlx.DB, err error)
• type And
• type Eq
• type Gt
• type GtOrEq
• type Gte
• type InsertBuilder
• type Like
• type Lt
• type LtOrEq
• type Lte
• type Model2MapParmas
• type NotEq
• type Or
• type SelectBuilder
• type UpdateBuilder

Variables

var SqlBuilder = squirrel.StatementBuilder

用squirrel生成sql语句

var Sqlx *sqlx.DB

sqlx 全局变量

Functions

func CreateLike

func CreateLike(column string) string

创建模糊查询

func CreatePage

func CreatePage(page, limit int) uint64

创建分页查询

func Model2Map

func Model2Map(m Model2MapParmas) (res map[string]interface{})

func NewSQLX

func NewSQLX(driverName, dbSource string, maxOpenConns, maxIdleConns int) (db *sqlx.DB, err error)

NewMySQL 创建一个连接MySQL的实体池

Types

type And

type And = squirrel.And

type Eq

type Eq = squirrel.Eq

type Gt

type Gt = squirrel.Gt

type GtOrEq

type GtOrEq = squirrel.GtOrEq

type Gte

type Gte = squirrel.GtOrEq

type InsertBuilder

type InsertBuilder = squirrel.InsertBuilder

type Like

type Like = squirrel.Like

type Lt

type Lt = squirrel.Lt

type LtOrEq

type LtOrEq = squirrel.LtOrEq

type Lte

type Lte = squirrel.LtOrEq

type Model2MapParmas

type Model2MapParmas struct {
	M                interface{}
	NeedZeroByInt    bool
	NeedZeroByString bool
	CreateTimeCol    string
	UpdateTimeCol    string
}

type NotEq

type NotEq = squirrel.NotEq

type Or

type Or = squirrel.Or

type SelectBuilder

type SelectBuilder = squirrel.SelectBuilder

type UpdateBuilder

type UpdateBuilder = squirrel.UpdateBuilder