sqx

Documentation

Index

• Variables
• func EndsLike(s string, escape ...rune) string
• func EscapeLike(s string, escape ...rune) string
• func EscapeString(s string) string
• func In(col string, arg any) (sql string, args []any)
• func NotIn(col string, arg any) (sql string, args []any)
• func Question(n int) string
• func Questions(n int) []string
• func QuoteDriver(driverName string, quoter Quoter)
• func StartsLike(s string, escape ...rune) string
• func StringLike(s string, escape ...rune) string
• type Builder
  • func (b *Builder) Build() (string, []any)
  • func (b *Builder) Columns(cols ...string) *Builder
  • func (b *Builder) Delete(tb string) *Builder
  • func (b *Builder) Distinct(cols ...string) *Builder
  • func (b *Builder) From(tb string) *Builder
  • func (b *Builder) In(col string, arg any) *Builder
  • func (b *Builder) Insert(tb string) *Builder
  • func (b *Builder) Limit(limit int) *Builder
  • func (b *Builder) NotIn(col string, arg any) *Builder
  • func (b *Builder) Offset(offset int) *Builder
  • func (b *Builder) Order(order string) *Builder
  • func (b *Builder) Params() []any
  • func (b *Builder) SQL() string
  • func (b *Builder) Select(cols ...string) *Builder
  • func (b *Builder) Set(col string, args ...any) *Builder
  • func (b *Builder) Update(tb string) *Builder
  • func (b *Builder) Values(vals ...string) *Builder
  • func (b *Builder) Where(q string, args ...any) *Builder
• type QuoteMarks
• type Quoter
  • func GetQuoter(driverName string) Quoter
  • func (quoter Quoter) Marks() QuoteMarks
  • func (quoter Quoter) Quote(s string) string
  • func (quoter Quoter) Quotes(ss ...string) []string
• type SqlReader
  • func NewSqlReader(r io.Reader) *SqlReader
  • func (sr *SqlReader) Error() error
  • func (sr *SqlReader) ReadSql() (string, error)

Variables

var (
	QuoteMarksDefault = QuoteMarks{'"', '"'}
	QuoteMarksMSSQL   = QuoteMarks{'[', ']'}
	QuoteMarksMYSQL   = QuoteMarks{'`', '`'}
)

Functions

func EndsLike

func EndsLike(s string, escape ...rune) string

StartsLike build a string for like suffix '%' + s The default escape char is backslach '\\'.

func EscapeLike

func EscapeLike(s string, escape ...rune) string

EscapeLike escape sql like string. The default escape char is backslach '\\'.

func EscapeString

func EscapeString(s string) string

At present, this method only turns single-quotes into doubled single-quotes ( <code>"McHale's Navy"</code> => <code>"McHale”s Navy"</code>). It does not handle the cases of percent (%) or underscore (_) for use in LIKE clauses. </p> see http://www.jguru.com/faq/view.jsp?EID=8881

func In

func In(col string, arg any) (sql string, args []any)

func NotIn

func NotIn(col string, arg any) (sql string, args []any)

func Question

func Question(n int) string

func Questions

func Questions(n int) []string

func QuoteDriver

func QuoteDriver(driverName string, quoter Quoter)

QuoteDriver sets the Quoter for driverName to quoter.

func StartsLike

func StartsLike(s string, escape ...rune) string

StartsLike build a string for like prefix s + '%' The default escape char is backslach '\\'.

func StringLike

func StringLike(s string, escape ...rune) string

StringLike build a string for like '%' + s + '%' The default escape char is backslach '\\'.

Types

type Builder

type Builder struct {
	// contains filtered or unexported fields
}

func (*Builder) Build

func (b *Builder) Build() (string, []any)

func (*Builder) Columns

func (b *Builder) Columns(cols ...string) *Builder

func (*Builder) Delete

func (b *Builder) Delete(tb string) *Builder

func (*Builder) Distinct

func (b *Builder) Distinct(cols ...string) *Builder

func (*Builder) From

func (b *Builder) From(tb string) *Builder

func (*Builder) In

func (b *Builder) In(col string, arg any) *Builder

func (*Builder) Insert

func (b *Builder) Insert(tb string) *Builder

func (*Builder) Limit

func (b *Builder) Limit(limit int) *Builder

func (*Builder) NotIn

func (b *Builder) NotIn(col string, arg any) *Builder

func (*Builder) Offset

func (b *Builder) Offset(offset int) *Builder

func (*Builder) Order

func (b *Builder) Order(order string) *Builder

func (*Builder) Params

func (b *Builder) Params() []any

func (*Builder) SQL

func (b *Builder) SQL() string

func (*Builder) Select

func (b *Builder) Select(cols ...string) *Builder

func (*Builder) Set

func (b *Builder) Set(col string, args ...any) *Builder

func (*Builder) Update

func (b *Builder) Update(tb string) *Builder

func (*Builder) Values

func (b *Builder) Values(vals ...string) *Builder

func (*Builder) Where

func (b *Builder) Where(q string, args ...any) *Builder

type QuoteMarks

type QuoteMarks []rune

type Quoter

type Quoter int

const (
	QuoteDefault Quoter = iota
	QuoteMYSQL
	QuoteMSSQL
)

func GetQuoter

func GetQuoter(driverName string) Quoter

GetQuoteer returns the quoter for a given database given a drivername.

func (Quoter) Marks

func (quoter Quoter) Marks() QuoteMarks

func (Quoter) Quote

func (quoter Quoter) Quote(s string) string

Quote quote string 's' with quote marks [2]rune, return (m[0] + s + m[1])

func (Quoter) Quotes

func (quoter Quoter) Quotes(ss ...string) []string

Quotes quote string 's' in 'ss' with quote marks [2]rune, return (m[0] + s + m[1])

type SqlReader

type SqlReader struct {
	// contains filtered or unexported fields
}

func NewSqlReader

func NewSqlReader(r io.Reader) *SqlReader

func (*SqlReader) Error

func (sr *SqlReader) Error() error

func (*SqlReader) ReadSql

func (sr *SqlReader) ReadSql() (string, error)