sqlTemplate

Documentation

Index

• Constants
• func Delete(sql string, param map[string]interface{}, cacheSql bool) error
• func Insert(sql string, param map[string]interface{}, cacheSql bool) error
• func ParseSql(sql string, param map[string]interface{}) (string, []interface{})
• func SelectList(sql string, param map[string]interface{}, callback func(db *gorm.DB), ...)
• func SelectOne(sql string, param map[string]interface{}, callback func(db *gorm.DB), ...)
• func Update(sql string, param map[string]interface{}, cacheSql bool) error

Constants

const (
	Cache_sqlite = "sqlite"
	Cache_mysql  = "local"
)

Functions

func Delete

func Delete(sql string, param map[string]interface{}, cacheSql bool) error

* 封装 删除数据

func Insert

func Insert(sql string, param map[string]interface{}, cacheSql bool) error

* 封装 新增数据

func ParseSql

func ParseSql(sql string, param map[string]interface{}) (string, []interface{})

* 解析sql 引擎

`select * count from host_group t
				where
				1=1
				$if name != '' then
				and t.name = #name#
				$endif
				$if name != '' then
				and t.name = #name#
				$endif

func SelectList

func SelectList(sql string, param map[string]interface{}, callback func(db *gorm.DB), cacheSql bool)

* 封装 查询列表

func SelectOne

func SelectOne(sql string, param map[string]interface{}, callback func(db *gorm.DB), cacheSql bool)

* 封装 查询单个

func Update

func Update(sql string, param map[string]interface{}, cacheSql bool) error

* 封装 修改数据