sqlitegorm

Documentation

Index

• func Add(entity interface{}) (int64, error)
• func Count(sql string, params ...interface{}) (int, error)
• func FindOneMap(text string, params ...interface{}) (map[string]interface{}, int, error)
• func FindToMap(text string, params ...interface{}) ([]map[string]interface{}, int, error)
• func GetDbName(name string) string
• func GetVariable(name string) string
• func InitDB()
• func Query(sql string, dest interface{}, where ...interface{}) (interface{}, error)
• func RawRows(sql string, params ...interface{}) (*sql.Rows, error)
• func ReplaceVariable(sqlstr string) string
• func ScanRows2mapI(rows *sql.Rows) []map[string]interface{}
• type GormDB
  • func Exec(sql string, params ...interface{}) (tx GormDB)
  • func Find(sql string, params ...interface{}) (tx GormDB)
  • func GetDB() GormDB
  • func Raw(sql string, params ...interface{}) (tx GormDB)

Functions

func Add

func Add(entity interface{}) (int64, error)

添加记录,返回影响行数及错误信息

func Count

func Count(sql string, params ...interface{}) (int, error)

调用数据查询数量

func FindOneMap

func FindOneMap(text string, params ...interface{}) (map[string]interface{}, int, error)

调用数据查询一条记录 返回规则: 发生错误时: {数据为nil,错误码值,错误信息} 正确时: {数据,数据数量,nil}

func FindToMap

func FindToMap(text string, params ...interface{}) ([]map[string]interface{}, int, error)

调用数据查询 返回规则: 发生错误时: {数据为nil,错误码值,错误信息} 正确时: {数据,数据数量,nil}

func GetDbName

func GetDbName(name string) string

取数据库名称

func GetVariable

func GetVariable(name string) string

取数据库全局变量

func InitDB

func InitDB()

初始化数据库加载配置

func Query

func Query(sql string, dest interface{}, where ...interface{}) (interface{}, error)

调用数据查询

func RawRows

func RawRows(sql string, params ...interface{}) (*sql.Rows, error)

调用数据查询

func ReplaceVariable

func ReplaceVariable(sqlstr string) string

替换字符串中的所有全局变量

func ScanRows2mapI

func ScanRows2mapI(rows *sql.Rows) []map[string]interface{}

将查询结果转换成map数组,常用于原生sql查询

Types

type GormDB

type GormDB = *gg.DB

func Exec

func Exec(sql string, params ...interface{}) (tx GormDB)

调用数据更新

func Find

func Find(sql string, params ...interface{}) (tx GormDB)

调用数据查询

func GetDB

func GetDB() GormDB

取gorm操作对象

func Raw

func Raw(sql string, params ...interface{}) (tx GormDB)

调用数据查询