sq

package

Go to main page

Versions in this module

v1

v1.2.3

May 24, 2022

Changes in this version

+ type Literal string

+ func (l Literal) AppendSQLExclude(buf *strings.Builder, _ *[]interface{}, _ map[string]int, _ []string)

type Predicate

+ func In(f1 interface{}, f2 []interface{}) Predicate

type Row

+ func (r *Row) ScanJSON(dest interface{}, field Field)

+ type SQLAppender interface

+ AppendSQL func(buf *strings.Builder, args *[]interface{}, params map[string]int)

+ type SQLExcludeAppender interface

+ AppendSQLExclude func(buf *strings.Builder, args *[]interface{}, params map[string]int, ...)

v1.2.2

Jul 18, 2021

v1.2.1

Jul 18, 2021

Changes in this version

type Column

+ func (col *Column) SetUUID(field UUIDField, value [16]byte)

type Row

+ func (r *Row) UUID(field UUIDField) [16]byte

+ type UUIDField struct

+ func NewUUIDField(name string, table Table) UUIDField

+ func UUID(u [16]byte) UUIDField

+ func (f UUIDField) AppendSQLExclude(buf *strings.Builder, args *[]interface{}, params map[string]int, ...)

+ func (f UUIDField) Asc() UUIDField

+ func (f UUIDField) Desc() UUIDField

+ func (f UUIDField) Eq(field UUIDField) Predicate

+ func (f UUIDField) EqUUID(u [16]byte) Predicate

+ func (f UUIDField) GetAlias() string

+ func (f UUIDField) GetName() string

+ func (f UUIDField) In(v interface{}) Predicate

+ func (f UUIDField) IsNotNull() Predicate

+ func (f UUIDField) IsNull() Predicate

+ func (f UUIDField) Ne(field UUIDField) Predicate

+ func (f UUIDField) NeUUID(u [16]byte) Predicate

+ func (f UUIDField) Set(value interface{}) FieldAssignment

+ func (f UUIDField) SetUUID(u [16]byte) FieldAssignment

+ func (f UUIDField) String() string

v1.1.1

Nov 27, 2020

v1.1.0

Oct 10, 2020

v1.0.0

Sep 30, 2020

v0

v0.5.0

Sep 23, 2020

v0.4.1

Sep 22, 2020

Changes in this version

type CustomField

+ func FirstValueOver(field interface{}, window Window) CustomField

+ func LagOver(field interface{}, offset interface{}, fallback interface{}, window Window) CustomField

+ func LastValueOver(field interface{}, window Window) CustomField

+ func LeadOver(field interface{}, offset interface{}, fallback interface{}, window Window) CustomField

+ func NthValueOver(field interface{}, n int, window Window) CustomField

type NumberField

+ func CumeDistOver(window Window) NumberField

+ func DenseRankOver(window Window) NumberField

+ func NtileOver(n int, window Window) NumberField

+ func PercentRankOver(window Window) NumberField

+ func RankOver(window Window) NumberField

+ func RowNumberOver(window Window) NumberField

v0.4.0

Sep 22, 2020

Changes in this version

+ type Column struct

+ func (col *Column) Set(field Field, value interface{})

+ func (col *Column) SetBool(field BooleanField, value bool)

+ func (col *Column) SetFloat64(field NumberField, value float64)

+ func (col *Column) SetInt(field NumberField, value int)

+ func (col *Column) SetInt64(field NumberField, value int64)

+ func (col *Column) SetString(field StringField, value string)

+ func (col *Column) SetTime(field TimeField, value time.Time)

type DeleteQuery

+ RowMapper func(*Row)

type InsertQuery

+ ColumnMapper func(*Column)

+ RowMapper func(*Row)

+ func (q InsertQuery) Valuesx(mapper func(*Column)) InsertQuery

type RowValue

+ func (r RowValue) GetAlias() string

+ func (r RowValue) GetName() string

type SelectQuery

+ RowMapper func(*Row)

type UpdateQuery

+ ColumnMapper func(*Column)

+ RowMapper func(*Row)

+ func (q UpdateQuery) Setx(mapper func(*Column)) UpdateQuery

v0.2.3

Sep 18, 2020

Changes in this version

+ type IntermediateCTE map[string]CustomField

+ func (cte IntermediateCTE) Union(queries ...Query) CTE

+ func (cte IntermediateCTE) UnionAll(queries ...Query) CTE

v0.2.1

Sep 18, 2020

Changes in this version

+ type InsertConflict struct

+ func (c InsertConflict) DoNothing() InsertQuery

+ func (c InsertConflict) DoUpdateSet(assignments ...Assignment) InsertQuery

+ func (c InsertConflict) Where(predicates ...Predicate) InsertConflict

v0.2.0

Sep 17, 2020

Changes in this version

+ func AppendCTEs(buf *strings.Builder, args *[]interface{}, CTEs []CTE, fromTable Table, ...)

+ func RowFloat64(r *Row, field Field) float64

+ func RowFloat64Valid(r *Row, field Field) bool

+ func RowInt(r *Row, field Field) int

+ func RowInt64(r *Row, field NumberField) int64

+ func RowInt64Valid(r *Row, field NumberField) bool

+ func RowIntValid(r *Row, field Field) bool

+ func RowNullFloat64(r *Row, field Field) sql.NullFloat64

+ func RowNullInt64(r *Row, field Field) sql.NullInt64

+ func RowNullString(r *Row, field Field) sql.NullString

+ func RowNullTime(r *Row, field Field) sql.NullTime

+ func RowString(r *Row, field Field) string

+ func RowStringValid(r *Row, field Field) bool

+ func RowTime(r *Row, field Field) time.Time

+ func RowTimeValid(r *Row, field Field) bool

type BaseQuery

+ func (q BaseQuery) Union(queries ...Query) VariadicQuery

+ func (q BaseQuery) UnionAll(queries ...Query) VariadicQuery

type CTE

+ func RecursiveCTE(name string, columns ...string) CTE

+ func (cte CTE) GetColumns() []string

+ func (cte CTE) GetQuery() Query

+ func (cte CTE) Initial(query Query) intermediateCTE

+ func (cte CTE) IsRecursive() bool

type DeleteQuery

+ func (q DeleteQuery) CTE(name string, columns ...string) CTE

+ func (q DeleteQuery) Subquery(alias string) Subquery

type InsertQuery

+ func (q InsertQuery) CTE(name string, columns ...string) CTE

+ func (q InsertQuery) Subquery(alias string) Subquery

type Predicate

+ func Eq(f1, f2 interface{}) Predicate

+ func Ge(f1, f2 interface{}) Predicate

+ func Gt(f1, f2 interface{}) Predicate

+ func Le(f1, f2 interface{}) Predicate

+ func Lt(f1, f2 interface{}) Predicate

+ func Ne(f1, f2 interface{}) Predicate

type Query

+ AppendSQL func(buf *strings.Builder, args *[]interface{})

type SelectQuery

+ func (q SelectQuery) CTE(name string, columns ...string) CTE

+ func (q SelectQuery) Subquery(alias string) Subquery

+ type Subquery map[string]CustomField

+ func (subq Subquery) AppendSQL(buf *strings.Builder, args *[]interface{})

+ func (subq Subquery) GetAlias() string

+ func (subq Subquery) GetName() string

+ func (subq Subquery) GetQuery() Query

+ func (subq Subquery) NestThis() Query

+ func (subq Subquery) ToSQL() (string, []interface{})

type UpdateQuery

+ func (q UpdateQuery) CTE(name string, columns ...string) CTE

+ func (q UpdateQuery) Subquery(alias string) Subquery

type VariadicQuery

+ Accumulator func()

+ DB DB

+ Log Logger

+ LogFlag LogFlag

+ LogSkip int

+ Mapper func(*Row)

+ TopLevel bool

+ func (vq VariadicQuery) CTE(name string, columns ...string) CTE

+ func (vq VariadicQuery) Subquery(name string) Subquery

v0.1.1

Sep 3, 2020

v0.1.0

Jun 22, 2020

Changes in this version

+ func AppendSQLDisplay(arg interface{}) string

+ func AppendSQLValue(buf Buffer, args *[]interface{}, excludedTableQualifiers []string, ...)

+ func DollarInterpolate(query string, args ...interface{}) string

+ func ExpandValues(buf Buffer, args *[]interface{}, excludedTableQualifiers []string, ...)

+ func InterpolateSQLValue(arg interface{}) string

+ func QuestionInterpolate(query string, args ...interface{}) string

+ func QuestionToDollarPlaceholders(buf Buffer, query string)

+ func RandomString(n int) string

+ func SelectDistinctOn(distinctFields ...Field) func(...Field) SelectQuery

+ type AliasedCTE struct

+ Alias string

+ Name string

+ func (cte AliasedCTE) AppendSQL(buf Buffer, _ *[]interface{})

+ func (cte AliasedCTE) Get(fieldName string) CustomField

+ func (cte AliasedCTE) GetAlias() string

+ func (cte AliasedCTE) GetName() string

+ type ArrayField struct

+ func Array(slice interface{}) ArrayField

+ func NewArrayField(name string, table Table) ArrayField

+ func (f ArrayField) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (f ArrayField) As(alias string) ArrayField

+ func (f ArrayField) Asc() ArrayField

+ func (f ArrayField) Concat(field ArrayField) Field

+ func (f ArrayField) ContainedBy(field ArrayField) Predicate

+ func (f ArrayField) Contains(field ArrayField) Predicate

+ func (f ArrayField) Desc() ArrayField

+ func (f ArrayField) Eq(field ArrayField) Predicate

+ func (f ArrayField) Ge(field ArrayField) Predicate

+ func (f ArrayField) GetAlias() string

+ func (f ArrayField) GetName() string

+ func (f ArrayField) Gt(field ArrayField) Predicate

+ func (f ArrayField) IsNotNull() Predicate

+ func (f ArrayField) IsNull() Predicate

+ func (f ArrayField) Le(field ArrayField) Predicate

+ func (f ArrayField) Lt(field ArrayField) Predicate

+ func (f ArrayField) Ne(field ArrayField) Predicate

+ func (f ArrayField) NullsFirst() ArrayField

+ func (f ArrayField) NullsLast() ArrayField

+ func (f ArrayField) Overlaps(field ArrayField) Predicate

+ func (f ArrayField) Set(value ArrayField) FieldAssignment

+ func (f ArrayField) String() string

+ type Assignment interface

+ AppendSQLExclude func(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ AssertAssignment func()

+ type Assignments []Assignment

+ func (assignments Assignments) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ type BaseQuery struct

+ CTEs CTEs

+ DB DB

+ Log Logger

+ LogFlag LogFlag

+ func With(CTEs ...CTE) BaseQuery

+ func WithDB(db DB) BaseQuery

+ func WithDefaultLog(flag LogFlag) BaseQuery

+ func WithLog(logger Logger, flag LogFlag) BaseQuery

+ func (q BaseQuery) DeleteFrom(table BaseTable) DeleteQuery

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

+ func (q BaseQuery) InsertInto(table BaseTable) InsertQuery

+ func (q BaseQuery) Select(fields ...Field) SelectQuery

+ func (q BaseQuery) SelectAll() SelectQuery

+ func (q BaseQuery) SelectCount() SelectQuery

+ func (q BaseQuery) SelectDistinct(fields ...Field) SelectQuery

+ func (q BaseQuery) SelectDistinctOn(distinctFields ...Field) func(...Field) SelectQuery

+ func (q BaseQuery) SelectOne() SelectQuery

+ func (q BaseQuery) SelectRowx(mapper func(*Row)) SelectQuery

+ func (q BaseQuery) Selectx(mapper func(*Row), accumulator func()) SelectQuery

+ func (q BaseQuery) Update(table BaseTable) UpdateQuery

+ func (q BaseQuery) With(CTEs ...CTE) BaseQuery

+ func (q BaseQuery) WithDB(db DB) BaseQuery

+ func (q BaseQuery) WithDefaultLog(flag LogFlag) BaseQuery

+ func (q BaseQuery) WithLog(logger Logger, flag LogFlag) BaseQuery

+ type BaseTable interface

+ AssertBaseTable func()

+ type BinaryField struct

+ func Bytes(b []byte) BinaryField

+ func NewBinaryField(name string, table Table) BinaryField

+ func (f BinaryField) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (f BinaryField) GetAlias() string

+ func (f BinaryField) GetName() string

+ func (f BinaryField) IsNotNull() Predicate

+ func (f BinaryField) IsNull() Predicate

+ func (f BinaryField) Set(v interface{}) FieldAssignment

+ func (f BinaryField) SetBytes(b []byte) FieldAssignment

+ type BooleanField struct

+ func Bool(b bool) BooleanField

+ func NewBooleanField(name string, table Table) BooleanField

+ func (f BooleanField) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (f BooleanField) As(alias string) BooleanField

+ func (f BooleanField) Asc() BooleanField

+ func (f BooleanField) Desc() BooleanField

+ func (f BooleanField) Eq(field BooleanField) Predicate

+ func (f BooleanField) GetAlias() string

+ func (f BooleanField) GetName() string

+ func (f BooleanField) IsNotNull() Predicate

+ func (f BooleanField) IsNull() Predicate

+ func (f BooleanField) Ne(field BooleanField) Predicate

+ func (f BooleanField) Not() Predicate

+ func (f BooleanField) NullsFirst() BooleanField

+ func (f BooleanField) NullsLast() BooleanField

+ func (f BooleanField) Set(val interface{}) FieldAssignment

+ func (f BooleanField) SetBool(val bool) FieldAssignment

+ func (f BooleanField) String() string

+ type Buffer interface

+ Reset func()

+ String func() string

+ type CTE struct

+ Columns []string

+ Name string

+ Query Query

+ Recursive bool

+ func NewCTE(name string, query Query, columns ...string) CTE

+ func NewRecursiveCTE(name string, query Query, columns ...string) CTE

+ func (cte CTE) AppendSQL(buf Buffer, args *[]interface{})

+ func (cte CTE) As(alias string) AliasedCTE

+ func (cte CTE) Get(fieldName string) CustomField

+ func (cte CTE) GetAlias() string

+ func (cte CTE) GetName() string

+ type CTEs []CTE

+ func (ctes CTEs) AppendSQL(buf Buffer, args *[]interface{})

+ type CustomAssignment struct

+ Format string

+ Values []interface{}

+ func (set CustomAssignment) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (set CustomAssignment) AssertAssignment()

+ type CustomField struct

+ Alias string

+ Format string

+ IsDesc *bool

+ IsNullsFirst *bool

+ Values []interface{}

+ func Excluded(field Field) CustomField

+ func Fieldf(format string, values ...interface{}) CustomField

+ func (f CustomField) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (f CustomField) As(alias string) CustomField

+ func (f CustomField) Asc() CustomField

+ func (f CustomField) Desc() CustomField

+ func (f CustomField) Eq(v interface{}) Predicate

+ func (f CustomField) Ge(v interface{}) Predicate

+ func (f CustomField) GetAlias() string

+ func (f CustomField) GetName() string

+ func (f CustomField) Gt(v interface{}) Predicate

+ func (f CustomField) In(v interface{}) Predicate

+ func (f CustomField) IsNotNull() Predicate

+ func (f CustomField) IsNull() Predicate

+ func (f CustomField) Le(v interface{}) Predicate

+ func (f CustomField) Lt(v interface{}) Predicate

+ func (f CustomField) Ne(v interface{}) Predicate

+ func (f CustomField) NullsFirst() CustomField

+ func (f CustomField) NullsLast() CustomField

+ func (f CustomField) String() string

+ type CustomPredicate struct

+ Alias string

+ Format string

+ Negative bool

+ Values []interface{}

+ func Exists(query Query) CustomPredicate

+ func Predicatef(format string, values ...interface{}) CustomPredicate

+ func (p CustomPredicate) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (p CustomPredicate) As(alias string) CustomPredicate

+ func (p CustomPredicate) GetAlias() string

+ func (p CustomPredicate) GetName() string

+ func (p CustomPredicate) Not() Predicate

+ type CustomQuery struct

+ Alias string

+ Format string

+ Nested bool

+ Values []interface{}

+ func Queryf(format string, values ...interface{}) CustomQuery

+ func (q CustomQuery) AppendSQL(buf Buffer, args *[]interface{})

+ func (q CustomQuery) As(alias string) CustomQuery

+ func (q CustomQuery) GetAlias() string

+ func (q CustomQuery) GetName() string

+ func (q CustomQuery) NestThis() Query

+ func (q CustomQuery) ToSQL() (string, []interface{})

+ type DB interface

+ Exec func(query string, args ...interface{}) (sql.Result, error)

+ ExecContext func(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ Query func(query string, args ...interface{}) (*sql.Rows, error)

+ QueryContext func(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ type DeleteQuery struct

+ Accumulator func()

+ Alias string

+ CTEs CTEs

+ DB DB

+ FromTable BaseTable

+ JoinTables JoinTables

+ Log Logger

+ LogFlag LogFlag

+ LogSkip int

+ Mapper func(*Row)

+ Nested bool

+ ReturningFields Fields

+ UsingTable Table

+ WherePredicate VariadicPredicate

+ func DeleteFrom(table BaseTable) DeleteQuery

+ func (q DeleteQuery) AppendSQL(buf Buffer, args *[]interface{})

+ func (q DeleteQuery) As(alias string) DeleteQuery

+ func (q DeleteQuery) CustomJoin(joinType JoinType, table Table, predicates ...Predicate) DeleteQuery

+ func (q DeleteQuery) DeleteFrom(table BaseTable) DeleteQuery

+ func (q DeleteQuery) Exec(db DB, flag ExecFlag) (rowsAffected int64, err error)

+ func (q DeleteQuery) ExecContext(ctx context.Context, db DB, flag ExecFlag) (rowsAffected int64, err error)

+ func (q DeleteQuery) Fetch(db DB) (err error)

+ func (q DeleteQuery) FetchContext(ctx context.Context, db DB) (err error)

+ func (q DeleteQuery) FullJoin(table Table, predicate Predicate, predicates ...Predicate) DeleteQuery

+ func (q DeleteQuery) Get(fieldName string) CustomField

+ func (q DeleteQuery) GetAlias() string

+ func (q DeleteQuery) GetName() string

+ func (q DeleteQuery) Join(table Table, predicate Predicate, predicates ...Predicate) DeleteQuery

+ func (q DeleteQuery) LeftJoin(table Table, predicate Predicate, predicates ...Predicate) DeleteQuery

+ func (q DeleteQuery) NestThis() Query

+ func (q DeleteQuery) Returning(fields ...Field) DeleteQuery

+ func (q DeleteQuery) ReturningOne() DeleteQuery

+ func (q DeleteQuery) ReturningRowx(mapper func(*Row)) DeleteQuery

+ func (q DeleteQuery) Returningx(mapper func(*Row), accumulator func()) DeleteQuery

+ func (q DeleteQuery) RightJoin(table Table, predicate Predicate, predicates ...Predicate) DeleteQuery

+ func (q DeleteQuery) ToSQL() (string, []interface{})

+ func (q DeleteQuery) Using(table Table) DeleteQuery

+ func (q DeleteQuery) Where(predicates ...Predicate) DeleteQuery

+ func (q DeleteQuery) With(ctes ...CTE) DeleteQuery

+ type EnumField = StringField

+ func NewEnumField(name string, table Table) EnumField

+ type ExecFlag int

+ const ElastInsertID

+ const ErowsAffected

+ type ExitCode int

+ const ExitPeacefully

+ func (e ExitCode) Error() string

+ type Field interface

+ AppendSQLExclude func(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ GetAlias func() string

+ GetName func() string

+ type FieldAssignment struct

+ Field Field

+ Value interface{}

+ func (set FieldAssignment) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (set FieldAssignment) AssertAssignment()

+ type FieldLiteral string

+ func (f FieldLiteral) AppendSQLExclude(buf Buffer, _ *[]interface{}, _ []string)

+ func (f FieldLiteral) GetAlias() string

+ func (f FieldLiteral) GetName() string

+ type Fields []Field

+ func (fs Fields) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (fs Fields) AppendSQLExcludeWithAlias(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ type FunctionInfo struct

+ Alias string

+ Arguments []interface{}

+ Name string

+ Schema string

+ func Functionf(name string, args ...interface{}) *FunctionInfo

+ func (f *FunctionInfo) AppendSQL(buf Buffer, args *[]interface{})

+ func (f *FunctionInfo) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (f *FunctionInfo) GetAlias() string

+ func (f *FunctionInfo) GetName() string

+ type InsertQuery struct

+ Accumulator func()

+ Alias string

+ CTEs CTEs

+ ConflictConstraint string

+ ConflictFields Fields

+ ConflictPredicate VariadicPredicate

+ DB DB

+ HandleConflict bool

+ InsertColumns Fields

+ IntoTable BaseTable

+ Log Logger

+ LogFlag LogFlag

+ LogSkip int

+ Mapper func(*Row)

+ Nested bool

+ Resolution Assignments

+ ResolutionPredicate VariadicPredicate

+ ReturningFields Fields

+ RowValues RowValues

+ SelectQuery *SelectQuery

+ func InsertInto(table BaseTable) InsertQuery

+ func (q InsertQuery) AppendSQL(buf Buffer, args *[]interface{})

+ func (q InsertQuery) As(alias string) InsertQuery

+ func (q InsertQuery) Columns(fields ...Field) InsertQuery

+ func (q InsertQuery) Exec(db DB, flag ExecFlag) (rowsAffected int64, err error)

+ func (q InsertQuery) ExecContext(ctx context.Context, db DB, flag ExecFlag) (rowsAffected int64, err error)

+ func (q InsertQuery) Fetch(db DB) (err error)

+ func (q InsertQuery) FetchContext(ctx context.Context, db DB) (err error)

+ func (q InsertQuery) GetAlias() string

+ func (q InsertQuery) GetName() string

+ func (q InsertQuery) InsertInto(table BaseTable) InsertQuery

+ func (q InsertQuery) InsertRow(assignments ...FieldAssignment) InsertQuery

+ func (q InsertQuery) NestThis() Query

+ func (q InsertQuery) OnConflict(fields ...Field) insertConflict

+ func (q InsertQuery) OnConflictOnConstraint(name string) insertConflict

+ func (q InsertQuery) Returning(fields ...Field) InsertQuery

+ func (q InsertQuery) ReturningOne() InsertQuery

+ func (q InsertQuery) ReturningRowx(mapper func(*Row)) InsertQuery

+ func (q InsertQuery) Returningx(mapper func(*Row), accumulator func()) InsertQuery

+ func (q InsertQuery) Select(selectQuery SelectQuery) InsertQuery

+ func (q InsertQuery) ToSQL() (string, []interface{})

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

+ func (q InsertQuery) Where(predicates ...Predicate) InsertQuery

+ func (q InsertQuery) With(ctes ...CTE) InsertQuery

+ type JSONField struct

+ func JSON(val interface{}) (JSONField, error)

+ func JSONValue(val driver.Valuer) JSONField

+ func MustJSON(val interface{}) JSONField

+ func NewJSONField(name string, table Table) JSONField

+ func (f JSONField) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (f JSONField) As(alias string) JSONField

+ func (f JSONField) Asc() JSONField

+ func (f JSONField) Desc() JSONField

+ func (f JSONField) GetAlias() string

+ func (f JSONField) GetName() string

+ func (f JSONField) IsNotNull() Predicate

+ func (f JSONField) IsNull() Predicate

+ func (f JSONField) NullsFirst() JSONField

+ func (f JSONField) NullsLast() JSONField

+ func (f JSONField) Set(value interface{}) FieldAssignment

+ func (f JSONField) SetJSON(value interface{}) FieldAssignment

+ func (f JSONField) SetValue(value driver.Valuer) FieldAssignment

+ func (f JSONField) String() string

+ type JoinTable struct

+ JoinType JoinType

+ OnPredicates VariadicPredicate

+ Table Table

+ func CustomJoin(joinType JoinType, table Table, predicates ...Predicate) JoinTable

+ func FullJoin(table Table, predicates ...Predicate) JoinTable

+ func Join(table Table, predicates ...Predicate) JoinTable

+ func LeftJoin(table Table, predicates ...Predicate) JoinTable

+ func RightJoin(table Table, predicates ...Predicate) JoinTable

+ func (join JoinTable) AppendSQL(buf Buffer, args *[]interface{})

+ type JoinTables []JoinTable

+ func (joins JoinTables) AppendSQL(buf Buffer, args *[]interface{})

+ type JoinType string

+ const JoinTypeFull

+ const JoinTypeInner

+ const JoinTypeLeft

+ const JoinTypeRight

+ type LogFlag int

+ const Linterpolate

+ const Lparse

+ const Lresults

+ const Lstats

+ const Lverbose

+ type Logger interface

+ Output func(calldepth int, s string) error

+ type NumberField struct

+ func Avg(field interface{}) NumberField

+ func AvgOver(field interface{}, window Window) NumberField

+ func Count() NumberField

+ func CountOver(window Window) NumberField

+ func Float64(num float64) NumberField

+ func Int(num int) NumberField

+ func Int64(num int64) NumberField

+ func Max(field interface{}) NumberField

+ func MaxOver(field interface{}, window Window) NumberField

+ func Min(field interface{}) NumberField

+ func MinOver(field interface{}, window Window) NumberField

+ func NewNumberField(name string, table Table) NumberField

+ func NumberFieldf(format string, values ...interface{}) NumberField

+ func Sum(field interface{}) NumberField

+ func SumOver(field interface{}, window Window) NumberField

+ func (f NumberField) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (f NumberField) As(alias string) NumberField

+ func (f NumberField) Asc() NumberField

+ func (f NumberField) Desc() NumberField

+ func (f NumberField) Eq(field NumberField) Predicate

+ func (f NumberField) EqFloat64(num float64) Predicate

+ func (f NumberField) EqInt(num int) Predicate

+ func (f NumberField) Ge(field NumberField) Predicate

+ func (f NumberField) GeFloat64(num float64) Predicate

+ func (f NumberField) GeInt(num int) Predicate

+ func (f NumberField) GetAlias() string

+ func (f NumberField) GetName() string

+ func (f NumberField) Gt(field NumberField) Predicate

+ func (f NumberField) GtFloat64(num float64) Predicate

+ func (f NumberField) GtInt(num int) Predicate

+ func (f NumberField) In(v interface{}) Predicate

+ func (f NumberField) IsNotNull() Predicate

+ func (f NumberField) IsNull() Predicate

+ func (f NumberField) Le(field NumberField) Predicate

+ func (f NumberField) LeFloat64(num float64) Predicate

+ func (f NumberField) LeInt(num int) Predicate

+ func (f NumberField) Lt(field NumberField) Predicate

+ func (f NumberField) LtFloat64(num float64) Predicate

+ func (f NumberField) LtInt(num int) Predicate

+ func (f NumberField) Ne(field NumberField) Predicate

+ func (f NumberField) NeFloat64(num float64) Predicate

+ func (f NumberField) NeInt(num int) Predicate

+ func (f NumberField) NullsFirst() NumberField

+ func (f NumberField) NullsLast() NumberField

+ func (f NumberField) Set(val interface{}) FieldAssignment

+ func (f NumberField) SetFloat64(num float64) FieldAssignment

+ func (f NumberField) SetInt(num int) FieldAssignment

+ func (f NumberField) SetInt64(num int64) FieldAssignment

+ func (f NumberField) String() string

+ type Predicate interface

+ Not func() Predicate

+ func Not(predicate Predicate) Predicate

+ type PredicateCase struct

+ Condition Predicate

+ Result interface{}

+ type PredicateCases struct

+ Alias string

+ Cases []PredicateCase

+ Fallback interface{}

+ func CaseWhen(predicate Predicate, result interface{}) PredicateCases

+ func (f PredicateCases) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (f PredicateCases) As(alias string) PredicateCases

+ func (f PredicateCases) Else(fallback interface{}) PredicateCases

+ func (f PredicateCases) GetAlias() string

+ func (f PredicateCases) GetName() string

+ func (f PredicateCases) When(predicate Predicate, result interface{}) PredicateCases

+ type Query interface

+ NestThis func() Query

+ ToSQL func() (string, []interface{})

+ type Row struct

+ func (r *Row) Bool(predicate Predicate) bool

+ func (r *Row) BoolValid(predicate Predicate) bool

+ func (r *Row) Float64(field NumberField) float64

+ func (r *Row) Float64Valid(field NumberField) bool

+ func (r *Row) Int(field NumberField) int

+ func (r *Row) Int64(field NumberField) int64

+ func (r *Row) Int64Valid(field NumberField) bool

+ func (r *Row) IntValid(field NumberField) bool

+ func (r *Row) NullBool(predicate Predicate) sql.NullBool

+ func (r *Row) NullFloat64(field NumberField) sql.NullFloat64

+ func (r *Row) NullInt64(field NumberField) sql.NullInt64

+ func (r *Row) NullString(field StringField) sql.NullString

+ func (r *Row) NullTime(field TimeField) sql.NullTime

+ func (r *Row) ScanArray(slice interface{}, field Field)

+ func (r *Row) ScanInto(dest interface{}, field Field)

+ func (r *Row) String(field StringField) string

+ func (r *Row) StringValid(field StringField) bool

+ func (r *Row) Time(field TimeField) time.Time

+ func (r *Row) TimeValid(field TimeField) bool

+ type RowValue []interface

+ func (r RowValue) AppendSQL(buf Buffer, args *[]interface{})

+ func (r RowValue) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (r RowValue) In(v interface{}) CustomPredicate

+ func (r RowValue) Set(v interface{}) CustomAssignment

+ type RowValues []RowValue

+ func (rs RowValues) AppendSQL(buf Buffer, args *[]interface{})

+ type SelectQuery struct

+ Accumulator func()

+ Alias string

+ CTEs CTEs

+ DB DB

+ DistinctOn Fields

+ FromTable Table

+ GroupByFields Fields

+ HavingPredicate VariadicPredicate

+ JoinTables JoinTables

+ LimitValue *int64

+ Log Logger

+ LogFlag LogFlag

+ LogSkip int

+ Mapper func(*Row)

+ Nested bool

+ OffsetValue *int64

+ OrderByFields Fields

+ SelectFields Fields

+ SelectType SelectType

+ WherePredicate VariadicPredicate

+ Windows Windows

+ func From(table Table) SelectQuery

+ func Select(fields ...Field) SelectQuery

+ func SelectDistinct(fields ...Field) SelectQuery

+ func SelectOne() SelectQuery

+ func SelectRowx(mapper func(*Row)) SelectQuery

+ func Selectx(mapper func(*Row), accumulator func()) SelectQuery

+ func (q SelectQuery) AppendSQL(buf Buffer, args *[]interface{})

+ func (q SelectQuery) As(alias string) SelectQuery

+ func (q SelectQuery) CustomJoin(joinType JoinType, table Table, predicates ...Predicate) SelectQuery

+ func (q SelectQuery) Exec(db DB, flag ExecFlag) (rowsAffected int64, err error)

+ func (q SelectQuery) ExecContext(ctx context.Context, db DB, flag ExecFlag) (rowsAffected int64, err error)

+ func (q SelectQuery) Fetch(db DB) (err error)

+ func (q SelectQuery) FetchContext(ctx context.Context, db DB) (err error)

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

+ func (q SelectQuery) FullJoin(table Table, predicate Predicate, predicates ...Predicate) SelectQuery

+ func (q SelectQuery) Get(fieldName string) CustomField

+ func (q SelectQuery) GetAlias() string

+ func (q SelectQuery) GetName() string

+ func (q SelectQuery) GroupBy(fields ...Field) SelectQuery

+ func (q SelectQuery) Having(predicates ...Predicate) SelectQuery

+ func (q SelectQuery) Join(table Table, predicate Predicate, predicates ...Predicate) SelectQuery

+ func (q SelectQuery) LeftJoin(table Table, predicate Predicate, predicates ...Predicate) SelectQuery

+ func (q SelectQuery) Limit(limit int) SelectQuery

+ func (q SelectQuery) NestThis() Query

+ func (q SelectQuery) Offset(offset int) SelectQuery

+ func (q SelectQuery) OrderBy(fields ...Field) SelectQuery

+ func (q SelectQuery) RightJoin(table Table, predicate Predicate, predicates ...Predicate) SelectQuery

+ func (q SelectQuery) Select(fields ...Field) SelectQuery

+ func (q SelectQuery) SelectAll() SelectQuery

+ func (q SelectQuery) SelectCount() SelectQuery

+ func (q SelectQuery) SelectDistinct(fields ...Field) SelectQuery

+ func (q SelectQuery) SelectDistinctOn(distinctFields ...Field) func(...Field) SelectQuery

+ func (q SelectQuery) SelectOne() SelectQuery

+ func (q SelectQuery) SelectRowx(mapper func(*Row)) SelectQuery

+ func (q SelectQuery) Selectx(mapper func(*Row), accumulator func()) SelectQuery

+ func (q SelectQuery) ToSQL() (string, []interface{})

+ func (q SelectQuery) Where(predicates ...Predicate) SelectQuery

+ func (q SelectQuery) Window(windows ...Window) SelectQuery

+ func (q SelectQuery) With(ctes ...CTE) SelectQuery

+ type SelectType string

+ const SelectTypeDefault

+ const SelectTypeDistinct

+ const SelectTypeDistinctOn

+ type SimpleCase struct

+ Result interface{}

+ Value interface{}

+ type SimpleCases struct

+ Alias string

+ Cases []SimpleCase

+ Expression interface{}

+ Fallback interface{}

+ func Case(field Field) SimpleCases

+ func (f SimpleCases) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (f SimpleCases) As(alias string) SimpleCases

+ func (f SimpleCases) Else(field Field) SimpleCases

+ func (f SimpleCases) GetAlias() string

+ func (f SimpleCases) GetName() string

+ func (f SimpleCases) When(field Field, result Field) SimpleCases

+ type StringField struct

+ func NewStringField(name string, table Table) StringField

+ func String(s string) StringField

+ func (f StringField) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (f StringField) As(alias string) StringField

+ func (f StringField) Asc() StringField

+ func (f StringField) Desc() StringField

+ func (f StringField) Eq(field StringField) Predicate

+ func (f StringField) EqString(s string) Predicate

+ func (f StringField) Ge(field StringField) Predicate

+ func (f StringField) GeString(s string) Predicate

+ func (f StringField) GetAlias() string

+ func (f StringField) GetName() string

+ func (f StringField) Gt(field StringField) Predicate

+ func (f StringField) GtString(s string) Predicate

+ func (f StringField) ILikeString(s string) Predicate

+ func (f StringField) In(v interface{}) Predicate

+ func (f StringField) IsNotNull() Predicate

+ func (f StringField) IsNull() Predicate

+ func (f StringField) Le(field StringField) Predicate

+ func (f StringField) LeString(s string) Predicate

+ func (f StringField) LikeString(s string) Predicate

+ func (f StringField) Lt(field StringField) Predicate

+ func (f StringField) LtString(s string) Predicate

+ func (f StringField) Ne(field StringField) Predicate

+ func (f StringField) NeString(s string) Predicate

+ func (f StringField) NotILikeString(s string) Predicate

+ func (f StringField) NotLikeString(s string) Predicate

+ func (f StringField) NullsFirst() StringField

+ func (f StringField) NullsLast() StringField

+ func (f StringField) Set(value interface{}) FieldAssignment

+ func (f StringField) SetString(s string) FieldAssignment

+ func (f StringField) String() string

+ type Table interface

+ AppendSQL func(buf Buffer, args *[]interface{})

+ GetAlias func() string

+ GetName func() string

+ type TableInfo struct

+ Alias string

+ Name string

+ Schema string

+ func (tbl *TableInfo) AppendSQL(buf Buffer, args *[]interface{})

+ func (tbl *TableInfo) AssertBaseTable()

+ func (tbl *TableInfo) GetAlias() string

+ func (tbl *TableInfo) GetName() string

+ type TimeField struct

+ func NewTimeField(name string, table Table) TimeField

+ func Time(t time.Time) TimeField

+ func (f TimeField) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (f TimeField) As(alias string) TimeField

+ func (f TimeField) Asc() TimeField

+ func (f TimeField) Between(start, end TimeField) Predicate

+ func (f TimeField) BetweenSymmetricTime(start, end time.Time) Predicate

+ func (f TimeField) BetweenTime(start, end time.Time) Predicate

+ func (f TimeField) Desc() TimeField

+ func (f TimeField) Eq(field TimeField) Predicate

+ func (f TimeField) EqTime(t time.Time) Predicate

+ func (f TimeField) Ge(field TimeField) Predicate

+ func (f TimeField) GeTime(t time.Time) Predicate

+ func (f TimeField) GetAlias() string

+ func (f TimeField) GetName() string

+ func (f TimeField) Gt(field TimeField) Predicate

+ func (f TimeField) GtTime(t time.Time) Predicate

+ func (f TimeField) IsNotNull() Predicate

+ func (f TimeField) IsNull() Predicate

+ func (f TimeField) Le(field TimeField) Predicate

+ func (f TimeField) LeTime(t time.Time) Predicate

+ func (f TimeField) Lt(field TimeField) Predicate

+ func (f TimeField) LtTime(t time.Time) Predicate

+ func (f TimeField) Ne(field TimeField) Predicate

+ func (f TimeField) NeTime(t time.Time) Predicate

+ func (f TimeField) NotBetween(start, end TimeField) Predicate

+ func (f TimeField) NotBetweenSymmetricTime(start, end time.Time) Predicate

+ func (f TimeField) NotBetweenTime(start, end time.Time) Predicate

+ func (f TimeField) NullsFirst() TimeField

+ func (f TimeField) NullsLast() TimeField

+ func (f TimeField) Set(value interface{}) FieldAssignment

+ func (f TimeField) SetTime(value time.Time) FieldAssignment

+ func (f TimeField) String() string

+ type UpdateQuery struct

+ Accumulator func()

+ Alias string

+ Assignments Assignments

+ CTEs CTEs

+ DB DB

+ FromTable Table

+ JoinTables JoinTables

+ Log Logger

+ LogFlag LogFlag

+ LogSkip int

+ Mapper func(*Row)

+ Nested bool

+ ReturningFields Fields

+ UpdateTable BaseTable

+ WherePredicate VariadicPredicate

+ func Update(table BaseTable) UpdateQuery

+ func (q UpdateQuery) AppendSQL(buf Buffer, args *[]interface{})

+ func (q UpdateQuery) As(alias string) UpdateQuery

+ func (q UpdateQuery) CustomJoin(joinType JoinType, table Table, predicates ...Predicate) UpdateQuery

+ func (q UpdateQuery) Exec(db DB, flag ExecFlag) (rowsAffected int64, err error)

+ func (q UpdateQuery) ExecContext(ctx context.Context, db DB, flag ExecFlag) (rowsAffected int64, err error)

+ func (q UpdateQuery) Fetch(db DB) (err error)

+ func (q UpdateQuery) FetchContext(ctx context.Context, db DB) (err error)

+ func (q UpdateQuery) From(table Table) UpdateQuery

+ func (q UpdateQuery) FullJoin(table Table, predicate Predicate, predicates ...Predicate) UpdateQuery

+ func (q UpdateQuery) GetAlias() string

+ func (q UpdateQuery) GetName() string

+ func (q UpdateQuery) Join(table Table, predicate Predicate, predicates ...Predicate) UpdateQuery

+ func (q UpdateQuery) LeftJoin(table Table, predicate Predicate, predicates ...Predicate) UpdateQuery

+ func (q UpdateQuery) NestThis() Query

+ func (q UpdateQuery) Returning(fields ...Field) UpdateQuery

+ func (q UpdateQuery) ReturningOne() UpdateQuery

+ func (q UpdateQuery) ReturningRowx(mapper func(*Row)) UpdateQuery

+ func (q UpdateQuery) Returningx(mapper func(*Row), accumulator func()) UpdateQuery

+ func (q UpdateQuery) RightJoin(table Table, predicate Predicate, predicates ...Predicate) UpdateQuery

+ func (q UpdateQuery) Set(assignments ...Assignment) UpdateQuery

+ func (q UpdateQuery) ToSQL() (string, []interface{})

+ func (q UpdateQuery) Update(table BaseTable) UpdateQuery

+ func (q UpdateQuery) Where(predicates ...Predicate) UpdateQuery

+ func (q UpdateQuery) With(ctes ...CTE) UpdateQuery

+ type VariadicPredicate struct

+ Alias string

+ Negative bool

+ Operator VariadicPredicateOperator

+ Predicates []Predicate

+ Toplevel bool

+ func And(predicates ...Predicate) VariadicPredicate

+ func Or(predicates ...Predicate) VariadicPredicate

+ func (p VariadicPredicate) AppendSQLExclude(buf Buffer, args *[]interface{}, excludedTableQualifiers []string)

+ func (p VariadicPredicate) GetAlias() string

+ func (p VariadicPredicate) GetName() string

+ func (p VariadicPredicate) Not() Predicate

+ type VariadicPredicateOperator string

+ const PredicateAnd

+ const PredicateOr

+ type VariadicQuery struct

+ Alias string

+ Nested bool

+ Operator VariadicQueryOperator

+ Queries []Query

+ func Except(queries ...Query) VariadicQuery

+ func ExceptAll(queries ...Query) VariadicQuery

+ func Intersect(queries ...Query) VariadicQuery

+ func IntersectAll(queries ...Query) VariadicQuery

+ func Union(queries ...Query) VariadicQuery

+ func UnionAll(queries ...Query) VariadicQuery

+ func (q VariadicQuery) AppendSQL(buf Buffer, args *[]interface{})

+ func (q VariadicQuery) As(alias string) VariadicQuery

+ func (q VariadicQuery) Get(fieldName string) CustomField

+ func (q VariadicQuery) GetAlias() string

+ func (q VariadicQuery) GetName() string

+ func (q VariadicQuery) NestThis() Query

+ func (q VariadicQuery) ToSQL() (string, []interface{})

+ type VariadicQueryOperator string

+ const QueryExcept

+ const QueryExceptAll

+ const QueryIntersect

+ const QueryIntersectAll

+ const QueryUnion

+ const QueryUnionAll

+ type Window struct

+ FrameDefinition string

+ OrderByFields Fields

+ PartitionByFields Fields

+ RenderName bool

+ WindowName string

+ func OrderBy(fields ...Field) Window

+ func PartitionBy(fields ...Field) Window

+ func (w Window) AppendSQL(buf Buffer, args *[]interface{})

+ func (w Window) As(name string) Window

+ func (w Window) Frame(frameDefinition string) Window

+ func (w Window) Name() Window

+ func (w Window) OrderBy(fields ...Field) Window

+ func (w Window) PartitionBy(fields ...Field) Window

+ type Windows []Window

+ func (ws Windows) AppendSQL(buf Buffer, args *[]interface{})

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL