sqls

Documentation

Index

• Variables
• func BatchDelete(table, primaryKey string, count int) string
• func BatchInsert(sql string, num int) string
• func Count(sql string) string
• func Offset(count, limit int) []int
• func Params(sql string) ([]string, string)
• func TableName(sql string) string
• func TableNames(sql string) (schema string, table string)

Variables

var RegSpace = regexp.MustCompile(regSpace)

Functions

func BatchDelete

func BatchDelete(table, primaryKey string, count int) string

BatchDelete 生成批量删除SQL.

func BatchInsert

func BatchInsert(sql string, num int) string

BatchInsert 生成批量插入SQL.

func Count

func Count(sql string) string

Count 计数SQL.

func Offset

func Offset(count, limit int) []int

Offset 倒叙生成offset，防止丢数据.

func Params

func Params(sql string) ([]string, string)

Params 参数及去除参数的SQL.

func TableName

func TableName(sql string) string

TableName sql语句中获取表名.

func TableNames

func TableNames(sql string) (schema string, table string)

TableNames 数据库名及表名.