qb

Mar 21, 2022

Changes in this version

+ const Like

type TableField

+ func (tf TableField) Like(obj interface{}) *ConditionExpression

May 18, 2021

Changes in this version

type SelectQuery

+ func (q *SelectQuery) SelectFrom(selectExpressions ...SelectExpression) *SelectQuery

Oct 12, 2020

Changes in this version

+ const And

+ const Ascending

+ const Cross

+ const Descending

+ const Equal

+ const GreaterThan

+ const GreaterThanEqual

+ const In

+ const Inner

+ const Is

+ const IsNot

+ const Left

+ const LessThan

+ const LessThanEqual

+ const NoLimit

+ const NotEqual

+ const NullSafeEqual

+ const Or

+ const Outer

+ const Right

+ const SQLNow

+ const SQLNull

+ const XOr

+ func NewMissingTablesError(tables []string) errors.TracerError

+ func NewValidationFromNotSetError() errors.TracerError

+ type Comparison string

+ type ConditionExpression struct

+ func FieldComparison(left TableField, comparison Comparison, right interface{}) *ConditionExpression

+ func FieldIn(left TableField, in ...interface{}) *ConditionExpression

+ func (exp *ConditionExpression) And(expression *ConditionExpression) *ConditionExpression

+ func (exp *ConditionExpression) Or(expression *ConditionExpression) *ConditionExpression

+ func (exp *ConditionExpression) SQL() (string, []interface{})

+ func (exp *ConditionExpression) Tables() []string

+ func (exp *ConditionExpression) XOr(expression *ConditionExpression) *ConditionExpression

+ type DeleteQuery struct

+ func Delete(rowsIn ...Table) *DeleteQuery

+ func (q *DeleteQuery) From(table Table) *DeleteQuery

+ func (q *DeleteQuery) GetAlias(tableName string) string

+ func (q *DeleteQuery) InnerJoin(table Table) *Join

+ func (q *DeleteQuery) OuterJoin(direction JoinDirection, table Table) *Join

+ func (q *DeleteQuery) SQL() (string, []interface{}, error)

+ func (q *DeleteQuery) Validate() bool

+ func (q *DeleteQuery) Where(condition *ConditionExpression) *DeleteQuery

+ type InsertQuery struct

+ func Insert(columns ...TableField) *InsertQuery

+ func (q *InsertQuery) GetAlias(tableName string) string

+ func (q *InsertQuery) OnDuplicate(fields []TableField, values ...interface{}) *InsertQuery

+ func (q *InsertQuery) ParameterizedSQL() (string, error)

+ func (q *InsertQuery) SQL() (string, []interface{}, error)

+ func (q *InsertQuery) Values(values ...interface{}) *InsertQuery

+ type Join struct

+ func NewJoin(joinType JoinType, joinDirection JoinDirection, table Table) *Join

+ func (join *Join) On(left TableField, comparison Comparison, right interface{}) *ConditionExpression

+ func (join *Join) SQL() (string, []interface{})

+ type JoinDirection string

+ type JoinError struct

+ func (err *JoinError) Error() string

+ type JoinType string

+ type MissingTablesError struct

+ Tables []string

+ func (err *MissingTablesError) Error() string

+ func (err *MissingTablesError) Trace() []string

+ type OrderDirection string

+ type SelectExpression interface

+ GetName func() string

+ GetTables func() []string

+ SQL func() string

+ func Alias(tableField TableField, aliasName string) SelectExpression

+ func Coalesce(column TableField, defaultValue string, alias string) SelectExpression

+ func NotNull(tableField TableField, alias string) SelectExpression

+ type SelectQuery struct

+ Seperator string

+ func Select(selectExpressions ...SelectExpression) *SelectQuery

+ func SelectDistinct(selectExpressions ...SelectExpression) *SelectQuery

+ func (q *SelectQuery) From(table Table) *SelectQuery

+ func (q *SelectQuery) GetAlias(tableName string) string

+ func (q *SelectQuery) GroupBy(expressions ...SelectExpression) *SelectQuery

+ func (q *SelectQuery) InnerJoin(table Table) *Join

+ func (q *SelectQuery) OrderBy(field TableField, direction OrderDirection) *SelectQuery

+ func (q *SelectQuery) OuterJoin(direction JoinDirection, table Table) *Join

+ func (q *SelectQuery) SQL(limit, offset uint) (string, []interface{}, error)

+ func (q *SelectQuery) Validate() bool

+ func (q *SelectQuery) Where(condition *ConditionExpression) *SelectQuery

+ type Table interface

+ AllColumns func() TableField

+ GetAlias func() string

+ GetName func() string

+ PrimaryKey func() TableField

+ ReadColumns func() []TableField

+ SortBy func() (TableField, OrderDirection)

+ WriteColumns func() []TableField

+ type TableField struct

+ Name string

+ Table string

+ func (tf TableField) Equal(obj interface{}) *ConditionExpression

+ func (tf TableField) GetName() string

+ func (tf TableField) GetTables() []string

+ func (tf TableField) GreaterThan(obj interface{}) *ConditionExpression

+ func (tf TableField) GreaterThanEqual(obj interface{}) *ConditionExpression

+ func (tf TableField) In(objs ...interface{}) *ConditionExpression

+ func (tf TableField) IsNotNull() *ConditionExpression

+ func (tf TableField) IsNull() *ConditionExpression

+ func (tf TableField) LessThan(obj interface{}) *ConditionExpression

+ func (tf TableField) LessThanEqual(obj interface{}) *ConditionExpression

+ func (tf TableField) NotEqual(obj interface{}) *ConditionExpression

+ func (tf TableField) NullSafeEqual(obj interface{}) *ConditionExpression

+ func (tf TableField) SQL() string

+ type UpdateQuery struct

+ func Update(table Table) *UpdateQuery

+ func (q *UpdateQuery) GetAlias(tableName string) string

+ func (q *UpdateQuery) OrderBy(field TableField, direction OrderDirection) *UpdateQuery

+ func (q *UpdateQuery) ParameterizedSQL(limit int) (string, error)

+ func (q *UpdateQuery) SQL(limit int) (string, []interface{}, error)

+ func (q *UpdateQuery) Set(field TableField, value interface{}) *UpdateQuery

+ func (q *UpdateQuery) SetParam(field TableField) *UpdateQuery

+ func (q *UpdateQuery) Where(condition *ConditionExpression) *UpdateQuery

+ type ValidationFromNotSetError struct

+ func (err *ValidationFromNotSetError) Error() string

+ func (err *ValidationFromNotSetError) Trace() []string