db

Documentation

Index

• Variables
• func ConnDb() *xorm.Engine
• func Del(conn string)
• func Exec(sql string, Args ...interface{}) int64
• func Exec2(XX *xorm.Engine, sql string, Args ...interface{}) int64
• func Exec3(XX *xorm.Engine, debug, uid, username, module, ip, sql string, ...) int64
• func First(sqlorArgs ...interface{}) map[string]string
• func First2(XX *xorm.Engine, sqlorArgs ...interface{}) map[string]string
• func First3(XX *xorm.Engine, debug, uid, username, module, ip string, ...) map[string]string
• func FirstOrNil(sqlorArgs ...interface{}) map[string]string
• func FirstOrNil2(XX *xorm.Engine, sqlorArgs ...interface{}) map[string]string
• func InitX()
• func Insert(sql string, tb string, Args ...interface{}) int64
• func Insert2(XX *xorm.Engine, sql string, tb string, Args ...interface{}) int64
• func Insert3(XX *xorm.Engine, debug, uid, username, module, ip, sql string, tb string, ...) int64
• func NewDb(constr string) *xorm.Engine
• func NewDbMssql(conn string, server, port, uid, pwd, dbname string) *xorm.Engine
• func NewDbMysql(conn string, server, port, uid, pwd, dbname string) *xorm.Engine
• func NewDbSqlite(conn string, dbname string) *xorm.Engine
• func Page(page int, pageSize int, sqlorArgs ...interface{}) ([]map[string]string, int, int)
• func Pager(page int, pageSize int, sqlorArgs ...interface{}) interface{}
• func ParseByte(drivername string, beans []map[string][]byte) []map[string]string
• func Query(sqlorArgs ...interface{}) []map[string]string
• func Query2(XX *xorm.Engine, sqlorArgs ...interface{}) []map[string]string
• func Query3(XX *xorm.Engine, debug, uid, username, module, ip string, ...) []map[string]string
• func RandomString(lenght int) string
• func Substring(str, starting, ending string) string
• func TimeoutWarning(tag, msg string, start time.Time, timeLimit float64)
• type PageData
  • func Pager2(XX *xorm.Engine, page int, pageSize int, sqlorArgs ...interface{}) PageData
  • func Pager2MsSql(XX *xorm.Engine, page int, pageSize int, tbname string, sql string, ...) PageData
  • func Pager3(XX *xorm.Engine, debug, uid, username, module, ip string, page int, ...) PageData

Variables

var X *xorm.Engine

X 数据引擎

var XLog *xorm.Engine

Functions

func ConnDb

func ConnDb() *xorm.Engine

ConnDb 连接数据库的连接

func Del

func Del(conn string)

从连接池删除某个连接

func Exec

func Exec(sql string, Args ...interface{}) int64

Exec 执行SQL语句

func Exec2

func Exec2(XX *xorm.Engine, sql string, Args ...interface{}) int64

Exec 执行SQL语句 --指定数据库链接

func Exec3

func Exec3(XX *xorm.Engine, debug, uid, username, module, ip, sql string, Args ...interface{}) int64

Exec 执行SQL语句 --指定数据库链接

func First

func First(sqlorArgs ...interface{}) map[string]string

First SQL语句查询第一条记录

func First2

func First2(XX *xorm.Engine, sqlorArgs ...interface{}) map[string]string

First2 SQL语句查询第一条记录 --指定数据库链接

func First3

func First3(XX *xorm.Engine, debug, uid, username, module, ip string, sqlorArgs ...interface{}) map[string]string

First3 SQL语句查询第一条记录 --指定数据库链接

func FirstOrNil

func FirstOrNil(sqlorArgs ...interface{}) map[string]string

FirstOrNil 第一条或空

func FirstOrNil2

func FirstOrNil2(XX *xorm.Engine, sqlorArgs ...interface{}) map[string]string

FirstOrNil2 第一条或空

func InitX

func InitX()

初始化X数据库

func Insert

func Insert(sql string, tb string, Args ...interface{}) int64

Insert 执行插入语句

func Insert2

func Insert2(XX *xorm.Engine, sql string, tb string, Args ...interface{}) int64

Insert2 执行插入语句 --指定数据库链接

func Insert3

func Insert3(XX *xorm.Engine, debug, uid, username, module, ip, sql string, tb string, Args ...interface{}) int64

Insert3 执行插入语句 --指定数据库链接

func NewDb

func NewDb(constr string) *xorm.Engine

生成新的数据库链接

func NewDbMssql

func NewDbMssql(conn string, server, port, uid, pwd, dbname string) *xorm.Engine

生成新的mssql数据库链接,conn连接标识

func NewDbMysql

func NewDbMysql(conn string, server, port, uid, pwd, dbname string) *xorm.Engine

生成新的mysql数据库链接,conn连接标识

func NewDbSqlite

func NewDbSqlite(conn string, dbname string) *xorm.Engine

生成新的sqlite数据库链接,conn连接标识,dbname数据库名称

func Page

func Page(page int, pageSize int, sqlorArgs ...interface{}) ([]map[string]string, int, int)

Page 分页查询,分别返回数据、总页数、总记录数

func Pager

func Pager(page int, pageSize int, sqlorArgs ...interface{}) interface{}

Pager 分页查询,返回easyui分页数据结构

func ParseByte

func ParseByte(drivername string, beans []map[string][]byte) []map[string]string

ParseByte 字典字节类型转换

func Query

func Query(sqlorArgs ...interface{}) []map[string]string

Query SQL语句查询

func Query2

func Query2(XX *xorm.Engine, sqlorArgs ...interface{}) []map[string]string

Query2 SQL语句查询 --指定链接

func Query3

func Query3(XX *xorm.Engine, debug, uid, username, module, ip string, sqlorArgs ...interface{}) []map[string]string

Query3 SQL语句查询 --指定链接

func RandomString

func RandomString(lenght int) string

MD5加密方式

data := []byte("admin") has := md5.Sum(data) md5str1 := fmt.Sprintf("%x", has) //将[]byte转成16进制 fmt.Println("md5:",md5str1)

随机字符串

func Substring

func Substring(str, starting, ending string) string

Substring 提取子字符串

func TimeoutWarning

func TimeoutWarning(tag, msg string, start time.Time, timeLimit float64)

超时告警

Types

type PageData

type PageData struct {
	Total  int                 `json:"total"`
	Pages  int                 `json:"pages"`
	Rows   []map[string]string `json:"rows"`
	Footer []map[string]string `json:"footer"`
	Extra  string              `json:"extra"`
}

func Pager2

func Pager2(XX *xorm.Engine, page int, pageSize int, sqlorArgs ...interface{}) PageData

Pager2 分页查询,返回easyui分页数据结构

func Pager2MsSql

func Pager2MsSql(XX *xorm.Engine, page int, pageSize int, tbname string, sql string, where string, orderstr string, sqlorArgs ...interface{}) PageData

Pager2 mssql分页查询,返回easyui分页数据结构

func Pager3

func Pager3(XX *xorm.Engine, debug, uid, username, module, ip string, page int, pageSize int, sqlorArgs ...interface{}) PageData

Pager3 分页查询,返回easyui分页数据结构