where

Documentation

Index

• type Clause
  • func And(exp ...Expression) Clause
  • func Or(exp ...Expression) Clause
  • func (wh Clause) And(exp Expression) Clause
  • func (wh Clause) Build(dialect Dialect) (string, []interface{})
  • func (wh Clause) Or(exp Expression) Clause
• type Condition
  • func Between(column string, a, b interface{}) Condition
  • func Eq(column string, value interface{}) Condition
  • func Gt(column string, value interface{}) Condition
  • func GtEq(column string, value interface{}) Condition
  • func In(column string, values ...interface{}) Condition
  • func Lt(column string, value interface{}) Condition
  • func LtEq(column string, value interface{}) Condition
  • func NotEq(column string, value interface{}) Condition
  • func Null(column string) Condition
  • func (cl Condition) And(c2 Expression) Clause
  • func (cl Condition) Build(dialect Dialect) (string, []interface{})
  • func (cl Condition) Or(c2 Expression) Clause
• type Dialect
• type Expression
  • func NoOp() Expression
  • func Not(el Expression) Expression

Types

type Clause

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

Clause is a compound expression.

func And

func And(exp ...Expression) Clause

And combines some expressions into a clause that requires they are all true.

func Or

func Or(exp ...Expression) Clause

Or combines some expressions into a clause that requires that any is true.

func (Clause) And

func (wh Clause) And(exp Expression) Clause

And combines two clauses into a clause that requires they are both true. SQL implementation note: AND has higher precedence than OR.

func (Clause) Build

func (wh Clause) Build(dialect Dialect) (string, []interface{})

func (Clause) Or

func (wh Clause) Or(exp Expression) Clause

Or combines two clauses into a clause that requires either is true. SQL implementation note: AND has higher precedence than OR.

type Condition

type Condition struct {
	Sql  string
	Args []interface{}
}

Condition is a simple condition such as an equality test.

func Between

func Between(column string, a, b interface{}) Condition

Between returns a between condition on a column.

func Eq

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

Eq returns an equality condition on a column.

func Gt

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

Gt returns a greater than condition on a column.

func GtEq

func GtEq(column string, value interface{}) Condition

GtEq returns a greater than or equal condition on a column.

func In

func In(column string, values ...interface{}) Condition

In returns an in condition on a column.

func Lt

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

Lt returns a less than condition on a column.

func LtEq

func LtEq(column string, value interface{}) Condition

LtEq returns a less than or equal than condition on a column.

func NotEq

func NotEq(column string, value interface{}) Condition

NotEq returns a not equal condition on a column.

func Null

func Null(column string) Condition

Null returns an 'ISNULL' condition on a column.

func (Condition) And

func (cl Condition) And(c2 Expression) Clause

And combines two conditions into a clause that requires they are both true.

func (Condition) Build

func (cl Condition) Build(dialect Dialect) (string, []interface{})

func (Condition) Or

func (cl Condition) Or(c2 Expression) Clause

Or combines two conditions into a clause that requires either is true.

type Dialect

type Dialect interface {
	ReplacePlaceholders(sql string) string
}

Dialect provides a method to convert named argument placeholders to the dialect needed for the database in use.

type Expression

type Expression interface {
	Build(dialect Dialect) (string, []interface{})
	// contains filtered or unexported methods
}

Expression is an element in a WHERE clause. Expressions may be nested in various ways.

func NoOp

func NoOp() Expression

NoOp creates an empty expression.

func Not

func Not(el Expression) Expression

Not negates an expression.