querybuilder

package module

Go to main page

Versions in this module

v0

v0.5.6

Oct 22, 2025

v0.5.5

Oct 22, 2025

v0.5.4

Oct 23, 2024

v0.5.3

Oct 9, 2024

v0.5.2

Oct 7, 2024

Changes in this version

type Builder

+ Withs []contracts.RelationType

+ func (builder *Builder[T]) GetTableName() string

+ func (builder *Builder[T]) GetWith() []contracts.RelationType

+ func (builder *Builder[T]) OrWhereExistsRaw(raw string) contracts.QueryBuilder[T]

+ func (builder *Builder[T]) OrWhereRaw(raw string) contracts.QueryBuilder[T]

+ func (builder *Builder[T]) WhereExistsRaw(raw string, where ...contracts.WhereJoinType) contracts.QueryBuilder[T]

+ func (builder *Builder[T]) WhereRaw(raw string, whereTypes ...contracts.WhereJoinType) contracts.QueryBuilder[T]

+ func (builder *Builder[T]) With(relations ...contracts.RelationType) contracts.QueryBuilder[T]

v0.5.1

Oct 2, 2024

v0.5.0

Oct 2, 2024

v0.4.1

May 24, 2024

v0.4.0

May 24, 2024

v0.3.1

May 10, 2024

v0.3.0

May 10, 2024

v0.2.5

May 8, 2024

Changes in this version

type Builder

+ Selects []string

v0.2.4

Feb 16, 2024

v0.2.3

Feb 13, 2024

v0.2.2

Jan 18, 2024

v0.2.1

Jan 17, 2024

v0.2.0

Apr 13, 2023

Changes in this version

+ func FromQuery(subQuery contracts.QueryBuilder[T], as string) contracts.Query[T]

+ func New(table string) contracts.Query[T]

type Builder

+ func NewBuilder(table string) *Builder[T]

v0.1.19

Jan 29, 2023

v0.1.18

Jan 29, 2023

Changes in this version

type ParamException

+ Arg interface{}

+ Condition string

+ Err error

+ func (p ParamException) GetPrevious() *contracts.Exception

v0.1.17

Mar 18, 2022

v0.1.16

Mar 18, 2022

v0.1.15

Mar 17, 2022

v0.1.14

Mar 16, 2022

Changes in this version

+ type Expression string

v0.1.13

Feb 11, 2022

Changes in this version

type Builder

+ func (this *Builder) SelectForUpdate() contracts.Collection

+ func (this *Builder) SelectForUpdateSql() (string, []interface{})

v0.1.12

Jan 28, 2022

v0.1.11

Jan 27, 2022

Changes in this version

+ const RandOrder

+ const RandomOrder

type Builder

+ func (this *Builder) InRandomOrder() contracts.QueryBuilder

v0.1.10

Jan 25, 2022

v0.1.9

Jan 24, 2022

v0.1.8

Jan 24, 2022

Changes in this version

type Builder

+ func (this *Builder) SetExecutor(executor contracts.SqlExecutor) contracts.QueryBuilder

v0.1.7

Jan 21, 2022

v0.1.6

Jan 21, 2022

v0.1.5

Jan 21, 2022

Changes in this version

type Builder

+ func (this *Builder) Bind(builder *Builder) contracts.QueryBuilder

v0.1.4

Jan 21, 2022

Changes in this version

type Builder

+ func (this *Builder) WhereFields(fields contracts.Fields) contracts.QueryBuilder

v0.1.3

Jan 21, 2022

v0.1.2

Jan 21, 2022

Changes in this version

type Builder

+ func (this *Builder) FirstOr(provider contracts.InstanceProvider) interface{}

+ func (this *Builder) FirstOrCreate(values ...contracts.Fields) interface{}

+ func (this *Builder) FirstOrFail(provider contracts.InstanceProvider) interface{}

+ func (this *Builder) FirstWhere(column string, args ...interface{}) interface{}

+ func (this *Builder) InsertGetId(values ...contracts.Fields) int64

+ func (this *Builder) InsertOrIgnore(values ...contracts.Fields) int64

+ func (this *Builder) InsertOrReplace(values ...contracts.Fields) int64

+ func (this *Builder) UpdateOrCreate(attributes contracts.Fields, values ...contracts.Fields) interface{}

+ func (this *Builder) UpdateOrInsert(attributes contracts.Fields, values ...contracts.Fields) bool

+ func (this *Builder) WithAvg(field string, as ...string) contracts.QueryBuilder

+ func (this *Builder) WithCount(fields ...string) contracts.QueryBuilder

+ func (this *Builder) WithMax(field string, as ...string) contracts.QueryBuilder

+ func (this *Builder) WithMin(field string, as ...string) contracts.QueryBuilder

+ func (this *Builder) WithSum(field string, as ...string) contracts.QueryBuilder

v0.1.1

Jan 21, 2022

Changes in this version

+ func FromSub(callback contracts.QueryProvider, as string) contracts.QueryBuilder

+ func JoinStringerArray(arr []fmt.Stringer, sep string) (result string)

+ func JoinSubStringerArray(arr []fmt.Stringer, sep string) (result string)

+ func NewQuery(table string) contracts.QueryBuilder

+ type Builder struct

+ func (this *Builder) AddSelect(fields ...string) contracts.QueryBuilder

+ func (this *Builder) AddSelectSub(provider contracts.QueryProvider, as string) contracts.QueryBuilder

+ func (this *Builder) Avg(field string, as ...string) contracts.QueryBuilder

+ func (this *Builder) Count(fields ...string) contracts.QueryBuilder

+ func (this *Builder) Create(fields contracts.Fields) interface{}

+ func (this *Builder) CreateSql(value contracts.Fields, insertType2 ...contracts.InsertType) (sql string, bindings []interface{})

+ func (this *Builder) Delete() int64

+ func (this *Builder) DeleteSql() (sql string, bindings []interface{})

+ func (this *Builder) Distinct() contracts.QueryBuilder

+ func (this *Builder) Find(key interface{}) interface{}

+ func (this *Builder) First() interface{}

+ func (this *Builder) From(table string, as ...string) contracts.QueryBuilder

+ func (this *Builder) FromMany(tables ...string) contracts.QueryBuilder

+ func (this *Builder) FromSub(provider contracts.QueryProvider, as string) contracts.QueryBuilder

+ func (this *Builder) FullJoin(table string, first, condition, second string) contracts.QueryBuilder

+ func (this *Builder) FullOutJoin(table string, first, condition, second string) contracts.QueryBuilder

+ func (this *Builder) Get() interface{}

+ func (this *Builder) GetBindings() (results []interface{})

+ func (this *Builder) GroupBy(columns ...string) contracts.QueryBuilder

+ func (this *Builder) Having(field string, args ...interface{}) contracts.QueryBuilder

+ func (this *Builder) Insert(values ...contracts.Fields) interface{}

+ func (this *Builder) InsertIgnoreSql(values []contracts.Fields) (sql string, bindings []interface{})

+ func (this *Builder) InsertReplaceSql(values []contracts.Fields) (sql string, bindings []interface{})

+ func (this *Builder) InsertSql(values []contracts.Fields, insertType2 ...contracts.InsertType) (sql string, bindings []interface{})

+ func (this *Builder) Join(table string, first, condition, second string, joins ...contracts.JoinType) contracts.QueryBuilder

+ func (this *Builder) JoinSub(provider contracts.QueryProvider, as, first, condition, second string, ...) contracts.QueryBuilder

+ func (this *Builder) LeftJoin(table string, first, condition, second string) contracts.QueryBuilder

+ func (this *Builder) Limit(num int64) contracts.QueryBuilder

+ func (this *Builder) Max(field string, as ...string) contracts.QueryBuilder

+ func (this *Builder) Min(field string, as ...string) contracts.QueryBuilder

+ func (this *Builder) Offset(offset int64) contracts.QueryBuilder

+ func (this *Builder) OrHaving(field string, args ...interface{}) contracts.QueryBuilder

+ func (this *Builder) OrWhere(field string, args ...interface{}) contracts.QueryBuilder

+ func (this *Builder) OrWhereBetween(field string, args interface{}) contracts.QueryBuilder

+ func (this *Builder) OrWhereExists(provider contracts.QueryProvider) contracts.QueryBuilder

+ func (this *Builder) OrWhereFunc(callback contracts.QueryFunc) contracts.QueryBuilder

+ func (this *Builder) OrWhereIn(field string, args interface{}) contracts.QueryBuilder

+ func (this *Builder) OrWhereIsNull(field string) contracts.QueryBuilder

+ func (this *Builder) OrWhereNotBetween(field string, args interface{}) contracts.QueryBuilder

+ func (this *Builder) OrWhereNotExists(provider contracts.QueryProvider) contracts.QueryBuilder

+ func (this *Builder) OrWhereNotIn(field string, args interface{}) contracts.QueryBuilder

+ func (this *Builder) OrWhereNotNull(field string) contracts.QueryBuilder

+ func (this *Builder) OrderBy(field string, columnOrderType ...contracts.OrderType) contracts.QueryBuilder

+ func (this *Builder) OrderByDesc(field string) contracts.QueryBuilder

+ func (this *Builder) Paginate(perPage int64, current ...int64) (interface{}, int64)

+ func (this *Builder) RightJoin(table string, first, condition, second string) contracts.QueryBuilder

+ func (this *Builder) Select(field string, fields ...string) contracts.QueryBuilder

+ func (this *Builder) SelectSql() (string, []interface{})

+ func (this *Builder) SelectSub(provider contracts.QueryProvider, as string) contracts.QueryBuilder

+ func (this *Builder) SetTX(tx interface{}) contracts.QueryBuilder

+ func (this *Builder) SimplePaginate(perPage int64, current ...int64) interface{}

+ func (this *Builder) Skip(offset int64) contracts.QueryBuilder

+ func (this *Builder) Sum(field string, as ...string) contracts.QueryBuilder

+ func (this *Builder) Take(num int64) contracts.QueryBuilder

+ func (this *Builder) ToSql() string

+ func (this *Builder) Union(builder contracts.QueryBuilder, unionType ...contracts.UnionJoinType) contracts.QueryBuilder

+ func (this *Builder) UnionAll(builder contracts.QueryBuilder) contracts.QueryBuilder

+ func (this *Builder) UnionAllByProvider(builder contracts.QueryProvider) contracts.QueryBuilder

+ func (this *Builder) UnionByProvider(builder contracts.QueryProvider, unionType ...contracts.UnionJoinType) contracts.QueryBuilder

+ func (this *Builder) Update(fields contracts.Fields) int64

+ func (this *Builder) UpdateSql(value contracts.Fields) (sql string, bindings []interface{})

+ func (this *Builder) When(condition bool, callback contracts.QueryCallback, ...) contracts.QueryBuilder

+ func (this *Builder) Where(field string, args ...interface{}) contracts.QueryBuilder

+ func (this *Builder) WhereBetween(field string, args interface{}, whereType ...contracts.WhereJoinType) contracts.QueryBuilder

+ func (this *Builder) WhereExists(provider contracts.QueryProvider, where ...contracts.WhereJoinType) contracts.QueryBuilder

+ func (this *Builder) WhereFunc(callback contracts.QueryFunc, whereType ...contracts.WhereJoinType) contracts.QueryBuilder

+ func (this *Builder) WhereIn(field string, args interface{}, joinType ...contracts.WhereJoinType) contracts.QueryBuilder

+ func (this *Builder) WhereIsNull(field string, whereType ...contracts.WhereJoinType) contracts.QueryBuilder

+ func (this *Builder) WhereNotBetween(field string, args interface{}, whereType ...contracts.WhereJoinType) contracts.QueryBuilder

+ func (this *Builder) WhereNotExists(provider contracts.QueryProvider, where ...contracts.WhereJoinType) contracts.QueryBuilder

+ func (this *Builder) WhereNotIn(field string, args interface{}, joinType ...contracts.WhereJoinType) contracts.QueryBuilder

+ func (this *Builder) WhereNotNull(field string, whereType ...contracts.WhereJoinType) contracts.QueryBuilder

+ func (this *Builder) WithPagination(perPage int64, current ...int64) contracts.QueryBuilder

+ type GroupBy []string

+ func (this GroupBy) IsEmpty() bool

+ func (this GroupBy) String() string

+ type Join struct

+ func (this Join) String() (result string)

+ type Joins []Join

+ func (this Joins) IsEmpty() bool

+ func (this Joins) String() (result string)

+ type OrderBy struct

+ type OrderByFields []OrderBy

+ func (this OrderByFields) IsEmpty() bool

+ func (this OrderByFields) String() string

+ type ParamException struct

+ func (p ParamException) Error() string

+ func (p ParamException) Fields() contracts.Fields

+ type Unions map[contracts.UnionJoinType][]contracts.QueryBuilder

+ func (this Unions) IsEmpty() bool

+ func (this Unions) String() (result string)

+ type Where struct

+ func (this *Where) String() string

+ type Wheres struct

+ func (this *Wheres) IsEmpty() bool

+ func (this *Wheres) String() (result string)

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