sqls

README

util-sqls

sql util library for Go

Installation

go get gopkg.in/goyy/goyy.v0/util/sqls

Documentation

Index

• func FormatSpace(sql string) string
• func ParseCountSql(sql string) string
• func ParseNamedSql(dia dialect.Interface, sql string, args map[string]interface{}) (sqlout string, argsout []interface{}, err error)
• func ParseTemplateSql(sql string, args map[string]interface{}) (out string, err error)
• func SetPriority(value int)

Functions

func FormatSpace

func FormatSpace(sql string) string

FormatSpace remove superfluous spaces in the SQL statement

func ParseCountSql

func ParseCountSql(sql string) string

ParseCountSql select ... from ... -> select count(1) from ...

func ParseNamedSql

func ParseNamedSql(dia dialect.Interface, sql string, args map[string]interface{}) (sqlout string, argsout []interface{}, err error)

ParseNamedSql takes a query using named parameters and an argument and returns a new query with a list of args that can be executed by a database.

func ParseTemplateSql

func ParseTemplateSql(sql string, args map[string]interface{}) (out string, err error)

ParseTemplateSql takes a query using named parameters and an argument and returns a new query with a list of args that can be executed by a database.

func SetPriority

func SetPriority(value int)

SetPriority set the priority of the logger.