sqb

func And ¶

func And(left, right stmt.Expr, exprs ...stmt.Expr) *stmt.And

And creates statement for the AND boolean expression. If you want to know more details, See at stmt.And.

func AndFromMap ¶

func AndFromMap(f ConditionalFunc, m map[string]interface{}) stmt.Expr

AndFromMap Creates a concatenated string of AND boolean expression from a map.

If there is no first argument then occurs panic. If map length is zero it returns nil. If map length is 1 it returns *stmt.Condition created by ConditionalFunc.

func Between ¶

func Between(column string, left, right interface{}) *stmt.Condition

Between creates condition `column BETWEEN ? AND ?`.

func Eq ¶

func Eq(column string, value interface{}) *stmt.Condition

Eq creates condition `column = ?`.

func Ge ¶

func Ge(column string, value interface{}) *stmt.Condition

Ge creates condition `column >= ?`.

func Gt ¶

func Gt(column string, value interface{}) *stmt.Condition

Gt creates condition `column > ?`.

func In ¶

func In(column string, args ...interface{}) *stmt.Condition

In creates condition `column IN (?, ?, ?, ...)`.

func Le ¶

func Le(column string, value interface{}) *stmt.Condition

Le creates condition `column <= ?`.

func Like ¶

func Like(column string, value interface{}) *stmt.Condition

Like creates condition `column LIKE ?`.

func Lt ¶

func Lt(column string, value interface{}) *stmt.Condition

Lt creates condition `column < ?`.

func Ne ¶

func Ne(column string, value interface{}) *stmt.Condition

Ne creates condition `column != ?`.

func NotBetween ¶

func NotBetween(column string, left, right interface{}) *stmt.Condition

NotBetween creates condition `column NOT BETWEEN ? AND ?`.

func NotIn ¶

func NotIn(column string, args ...interface{}) *stmt.Condition

NotIn creates condition `column NOT IN (?, ?, ?, ...)`.

func NotLike ¶

func NotLike(column string, value interface{}) *stmt.Condition

NotLike creates condition `column NOT LIKE ?`.

func Op ¶

func Op(op, column string, value interface{}) *stmt.Condition

Op creates flexible compare operation.

func Or ¶

func Or(left, right stmt.Expr, exprs ...stmt.Expr) *stmt.Or

Or creates statement for the OR boolean expression with parentheses. If you want to know more details, See at stmt.Or.

func OrFromMap ¶

func OrFromMap(f ConditionalFunc, m map[string]interface{}) stmt.Expr

OrFromMap Creates a concatenated string of OR boolean expression from a map.

If there is no first argument then occurs panic. If map length is zero it returns nil. If map length is 1 it returns *stmt.Condition created by ConditionalFunc.

func Paren ¶

func Paren(expr stmt.Expr) *stmt.Paren

Paren creates the expression with parentheses.