sqlstring

README

sqlstring

Simple SQL escape and format

Escaping sql values

//Format
sql := sqlstring.Format("select * from users where name=? and age=? limit ?,?", "t'est", 10, 10, 10)

fmt.Printf("sql: %s",sql)

//Escape
sql = "select * from users WHERE name = " + sqlstring.Escape(name);
fmt.Printf("sql: %s",sql)

License

MIT

Documentation

Index

• func Escape(val interface{}) string
• func EscapeInLocation(val interface{}, loc *time.Location) string
• func Format(query string, args ...interface{}) string
• func FormatInLocation(query string, loc *time.Location, args ...interface{}) string
• func SetSingleQuoteEscaper(escaper string)

Functions

func Escape

func Escape(val interface{}) string

Escape escape the val for sql

func EscapeInLocation

func EscapeInLocation(val interface{}, loc *time.Location) string

EscapeInLocation escape the val with time.Location

func Format

func Format(query string, args ...interface{}) string

Format format the sql with args

func FormatInLocation

func FormatInLocation(query string, loc *time.Location, args ...interface{}) string

FormatInLocation format the sql with args

func SetSingleQuoteEscaper

func SetSingleQuoteEscaper(escaper string)

SetSingleQuoteEscaper set the singleQuoteEscaper default:\' , e.g. ” 、 \'