selects

May 21, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) Unordered() *Builder[T]

type SubBuilder

+ func (b *SubBuilder) Unordered() *SubBuilder

Apr 18, 2023

Changes in this version

type BelongsTo

+ func (r BelongsTo) ForeignKeys() []*ForeignKey

+ type ForeignKey struct

+ LocalKey string

+ RelatedKey string

+ RelatedTable string

+ func (f *ForeignKey) Equal(v *ForeignKey) bool

type HasMany

+ func (r HasMany) ForeignKeys() []*ForeignKey

type HasOne

+ func (r HasOne) ForeignKeys() []*ForeignKey

type Relationship

+ ForeignKeys func() []*ForeignKey

Apr 13, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) GetTable() string

type SubBuilder

+ func (b *SubBuilder) GetTable() string

Apr 13, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) CrossJoin(table, localColumn, operator, foreignColumn string) *Builder[T]

+ func (b *Builder[T]) CrossJoinOn(table string, cb func(q *Conditions)) *Builder[T]

+ func (b *Builder[T]) InnerJoin(table, localColumn, operator, foreignColumn string) *Builder[T]

+ func (b *Builder[T]) InnerJoinOn(table string, cb func(q *Conditions)) *Builder[T]

+ func (b *Builder[T]) JoinOn(table string, cb func(q *Conditions)) *Builder[T]

+ func (b *Builder[T]) LeftJoin(table, localColumn, operator, foreignColumn string) *Builder[T]

+ func (b *Builder[T]) LeftJoinOn(table string, cb func(q *Conditions)) *Builder[T]

+ func (b *Builder[T]) RightJoin(table, localColumn, operator, foreignColumn string) *Builder[T]

+ func (b *Builder[T]) RightJoinOn(table string, cb func(q *Conditions)) *Builder[T]

+ type Conditions struct

+ func (c *Conditions) And(cb func(q *Conditions)) *Conditions

+ func (c *Conditions) Clone() *Conditions

+ func (c *Conditions) Or(cb func(q *Conditions)) *Conditions

+ func (c *Conditions) OrWhere(column, operator string, value any) *Conditions

+ func (c *Conditions) OrWhereColumn(column, operator string, valueColumn string) *Conditions

+ func (c *Conditions) OrWhereExists(query QueryBuilder) *Conditions

+ func (c *Conditions) OrWhereHas(relation string, cb func(q *SubBuilder) *SubBuilder) *Conditions

+ func (c *Conditions) OrWhereIn(column string, values []any) *Conditions

+ func (c *Conditions) OrWhereRaw(rawSql string, bindings ...any) *Conditions

+ func (c *Conditions) OrWhereSubquery(subquery QueryBuilder, operator string, value any) *Conditions

+ func (c *Conditions) ToSQL(d dialects.Dialect) (string, []any, error)

+ func (c *Conditions) Where(column, operator string, value any) *Conditions

+ func (c *Conditions) WhereColumn(column, operator string, valueColumn string) *Conditions

+ func (c *Conditions) WhereExists(query QueryBuilder) *Conditions

+ func (c *Conditions) WhereHas(relation string, cb func(q *SubBuilder) *SubBuilder) *Conditions

+ func (c *Conditions) WhereIn(column string, values []any) *Conditions

+ func (c *Conditions) WhereRaw(rawSql string, bindings ...any) *Conditions

+ func (c *Conditions) WhereSubquery(subquery QueryBuilder, operator string, value any) *Conditions

type SubBuilder

+ func (b *SubBuilder) CrossJoin(table, localColumn, operator, foreignColumn string) *SubBuilder

+ func (b *SubBuilder) CrossJoinOn(table string, cb func(q *Conditions)) *SubBuilder

+ func (b *SubBuilder) InnerJoin(table, localColumn, operator, foreignColumn string) *SubBuilder

+ func (b *SubBuilder) InnerJoinOn(table string, cb func(q *Conditions)) *SubBuilder

+ func (b *SubBuilder) Join(table, localColumn, operator, foreignColumn string) *SubBuilder

+ func (b *SubBuilder) JoinOn(table string, cb func(q *Conditions)) *SubBuilder

+ func (b *SubBuilder) LeftJoin(table, localColumn, operator, foreignColumn string) *SubBuilder

+ func (b *SubBuilder) LeftJoinOn(table string, cb func(q *Conditions)) *SubBuilder

+ func (b *SubBuilder) RightJoin(table, localColumn, operator, foreignColumn string) *SubBuilder

+ func (b *SubBuilder) RightJoinOn(table string, cb func(q *Conditions)) *SubBuilder

Apr 11, 2023

Changes in this version

+ func LoadMissing(tx *sqlx.Tx, v any, relation string) error

+ func LoadMissingContext(ctx context.Context, tx *sqlx.Tx, v any, relation string) error

Apr 9, 2023

Changes in this version

+ var ErrMissingField = fmt.Errorf("missing related field")

Apr 6, 2023

Changes in this version

+ func LoadContext(ctx context.Context, tx *sqlx.Tx, v any, relation string) error

Apr 6, 2023

Changes in this version

+ var ErrMissingRelationship = fmt.Errorf("missing relationship")

Apr 3, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) Context() context.Context

+ func (b *Builder[T]) WithContext(ctx context.Context) *Builder[T]

type SubBuilder

+ func (b *SubBuilder) Context() context.Context

+ func (b *SubBuilder) WithContext(ctx context.Context) *SubBuilder

Apr 2, 2023

Changes in this version

type SubBuilder

+ func (b *SubBuilder) WithoutGlobalScope(scope *Scope) *SubBuilder

Apr 2, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) WithoutGlobalScope(scope *Scope) *Builder[T]

+ type Scoper interface

+ Scopes func() []*Scope

Apr 2, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) WithScope(scope *Scope) *Builder[T]

+ func (b *Builder[T]) WithoutScope(scope *Scope) *Builder[T]

+ type Scope struct

+ Apply ScopeFunc

+ Name string

+ type ScopeFunc func(b *SubBuilder) *SubBuilder

type SubBuilder

+ func (b *SubBuilder) WithScope(scope *Scope) *SubBuilder

+ func (b *SubBuilder) WithoutScope(scope *Scope) *SubBuilder

Apr 1, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) HavingRaw(rawSql string, bindings ...any) *Builder[T]

+ func (b *Builder[T]) OrHavingRaw(rawSql string, bindings ...any) *Builder[T]

+ func (b *Builder[T]) OrWhereRaw(rawSql string, bindings ...any) *Builder[T]

+ func (b *Builder[T]) WhereRaw(rawSql string, bindings ...any) *Builder[T]

type SubBuilder

+ func (b *SubBuilder) HavingRaw(rawSql string, bindings ...any) *SubBuilder

+ func (b *SubBuilder) OrHavingRaw(rawSql string, bindings ...any) *SubBuilder

+ func (b *SubBuilder) OrWhereRaw(rawSql string, bindings ...any) *SubBuilder

+ func (b *SubBuilder) WhereRaw(rawSql string, bindings ...any) *SubBuilder

type WhereList

+ func (w *WhereList) OrWhereRaw(rawSql string, bindings ...any) *WhereList

+ func (w *WhereList) WhereRaw(rawSql string, bindings ...any) *WhereList

Apr 1, 2023

Changes in this version

type BelongsTo

+ func (r BelongsTo) Subquery() *SubBuilder

type Builder

+ func (b *Builder[T]) HavingHas(relation string, cb func(q *SubBuilder) *SubBuilder) *Builder[T]

+ func (b *Builder[T]) OrHavingHas(relation string, cb func(q *SubBuilder) *SubBuilder) *Builder[T]

+ func (b *Builder[T]) OrWhereHas(relation string, cb func(q *SubBuilder) *SubBuilder) *Builder[T]

+ func (b *Builder[T]) WhereHas(relation string, cb func(q *SubBuilder) *SubBuilder) *Builder[T]

type HasMany

+ func (r HasMany) Subquery() *SubBuilder

type HasOne

+ func (r HasOne) Subquery() *SubBuilder

type Join

+ func (j *Join) Join() *Join

type Relationship

+ Subquery func() *SubBuilder

+ type SubBuilder struct

+ func NewSubBuilder() *SubBuilder

+ func (b *SubBuilder) AddGroupBy(columns ...string) *SubBuilder

+ func (b *SubBuilder) AddSelect(columns ...string) *SubBuilder

+ func (b *SubBuilder) AddSelectFunction(function, column string) *SubBuilder

+ func (b *SubBuilder) AddSelectSubquery(sb QueryBuilder) *SubBuilder

+ func (b *SubBuilder) And(wl *WhereList) *SubBuilder

+ func (b *SubBuilder) Clone() *SubBuilder

+ func (b *SubBuilder) Distinct() *SubBuilder

+ func (b *SubBuilder) Dump() *SubBuilder

+ func (b *SubBuilder) From(table string) *SubBuilder

+ func (b *SubBuilder) GroupBy(columns ...string) *SubBuilder

+ func (b *SubBuilder) Having(column, operator string, value any) *SubBuilder

+ func (b *SubBuilder) HavingAnd(wl *WhereList) *SubBuilder

+ func (b *SubBuilder) HavingColumn(column, operator string, valueColumn string) *SubBuilder

+ func (b *SubBuilder) HavingExists(query QueryBuilder) *SubBuilder

+ func (b *SubBuilder) HavingHas(relation string, cb func(q *SubBuilder) *SubBuilder) *SubBuilder

+ func (b *SubBuilder) HavingIn(column string, values []any) *SubBuilder

+ func (b *SubBuilder) HavingOr(wl *WhereList) *SubBuilder

+ func (b *SubBuilder) HavingSubquery(subquery QueryBuilder, operator string, value any) *SubBuilder

+ func (b *SubBuilder) Limit(limit int) *SubBuilder

+ func (b *SubBuilder) Offset(offset int) *SubBuilder

+ func (b *SubBuilder) Or(wl *WhereList) *SubBuilder

+ func (b *SubBuilder) OrHaving(column, operator string, value any) *SubBuilder

+ func (b *SubBuilder) OrHavingColumn(column, operator string, valueColumn string) *SubBuilder

+ func (b *SubBuilder) OrHavingExists(query QueryBuilder) *SubBuilder

+ func (b *SubBuilder) OrHavingHas(relation string, cb func(q *SubBuilder) *SubBuilder) *SubBuilder

+ func (b *SubBuilder) OrHavingIn(column string, values []any) *SubBuilder

+ func (b *SubBuilder) OrHavingSubquery(subquery QueryBuilder, operator string, value any) *SubBuilder

+ func (b *SubBuilder) OrWhere(column, operator string, value any) *SubBuilder

+ func (b *SubBuilder) OrWhereColumn(column, operator string, valueColumn string) *SubBuilder

+ func (b *SubBuilder) OrWhereExists(query QueryBuilder) *SubBuilder

+ func (b *SubBuilder) OrWhereHas(relation string, cb func(q *SubBuilder) *SubBuilder) *SubBuilder

+ func (b *SubBuilder) OrWhereIn(column string, values []any) *SubBuilder

+ func (b *SubBuilder) OrWhereSubquery(subquery QueryBuilder, operator string, value any) *SubBuilder

+ func (b *SubBuilder) OrderBy(column string) *SubBuilder

+ func (b *SubBuilder) OrderByDesc(column string) *SubBuilder

+ func (b *SubBuilder) Select(columns ...string) *SubBuilder

+ func (b *SubBuilder) SelectFunction(function, column string) *SubBuilder

+ func (b *SubBuilder) SelectSubquery(sb QueryBuilder) *SubBuilder

+ func (b *SubBuilder) ToSQL(d dialects.Dialect) (string, []any, error)

+ func (b *SubBuilder) Where(column, operator string, value any) *SubBuilder

+ func (b *SubBuilder) WhereColumn(column, operator string, valueColumn string) *SubBuilder

+ func (b *SubBuilder) WhereExists(query QueryBuilder) *SubBuilder

+ func (b *SubBuilder) WhereHas(relation string, cb func(q *SubBuilder) *SubBuilder) *SubBuilder

+ func (b *SubBuilder) WhereIn(column string, values []any) *SubBuilder

+ func (b *SubBuilder) WhereSubquery(subquery QueryBuilder, operator string, value any) *SubBuilder

type WhereList

+ func (w *WhereList) OrWhereHas(relation string, cb func(q *SubBuilder) *SubBuilder) *WhereList

+ func (w *WhereList) WhereHas(relation string, cb func(q *SubBuilder) *SubBuilder) *WhereList

Mar 30, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) HavingSubquery(subquery QueryBuilder, operator string, value any) *Builder[T]

+ func (b *Builder[T]) OrHavingSubquery(subquery QueryBuilder, operator string, value any) *Builder[T]

+ func (b *Builder[T]) OrWhereSubquery(subquery QueryBuilder, operator string, value any) *Builder[T]

+ func (b *Builder[T]) WhereSubquery(subquery QueryBuilder, operator string, value any) *Builder[T]

type WhereList

+ func (w *WhereList) OrWhereSubquery(subquery QueryBuilder, operator string, value any) *WhereList

+ func (w *WhereList) WhereSubquery(subquery QueryBuilder, operator string, value any) *WhereList

Mar 27, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) With(withs ...string) *Builder[T]

Mar 27, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) OrderByDesc(column string) *Builder[T]

Mar 27, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) AddSelectFunction(function, column string) *Builder[T]

+ type QueryBuilder interface

Mar 27, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) HavingColumn(column, operator string, valueColumn string) *Builder[T]

+ func (b *Builder[T]) HavingExists(query iBuilder) *Builder[T]

+ func (b *Builder[T]) HavingIn(column string, values []any) *Builder[T]

+ func (b *Builder[T]) OrHavingColumn(column, operator string, valueColumn string) *Builder[T]

+ func (b *Builder[T]) OrHavingExists(query iBuilder) *Builder[T]

+ func (b *Builder[T]) OrHavingIn(column string, values []any) *Builder[T]

+ func (b *Builder[T]) OrWhereExists(query iBuilder) *Builder[T]

+ func (b *Builder[T]) SelectFunction(function, column string) *Builder[T]

+ func (b *Builder[T]) WhereExists(query iBuilder) *Builder[T]

type WhereList

+ func (w *WhereList) OrWhereExists(query iBuilder) *WhereList

+ func (w *WhereList) WhereExists(query iBuilder) *WhereList

Mar 27, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) Load(tx *sqlx.Tx, v any) error

+ func (b *Builder[T]) LoadContext(ctx context.Context, tx *sqlx.Tx, v any) error

+ func (b *Builder[T]) LoadOne(tx *sqlx.Tx, v any) error

+ func (b *Builder[T]) LoadOneContext(ctx context.Context, tx *sqlx.Tx, v any) error

Mar 27, 2023

Changes in this version

type Builder

+ func (b *Builder[T]) Clone() *Builder[T]

type WhereList

+ func (w *WhereList) Clone() *WhereList

Mar 27, 2023

Changes in this version

+ func InitializeRelationships(v any) error

+ func Load(tx *sqlx.Tx, v any, relation string) error

+ func NewSelects() *selects

+ type AfterLoader interface

+ AfterLoad func(ctx context.Context, tx *sqlx.Tx) error

+ type AfterSaver interface

+ AfterSave func(ctx context.Context, tx *sqlx.Tx) error

+ type BeforeSaver interface

+ BeforeSave func(ctx context.Context, tx *sqlx.Tx) error

+ type BelongsTo struct

+ func (r *BelongsTo[T]) Initialize(parent any, field reflect.StructField) error

+ func (r *BelongsTo[T]) Load(tx *sqlx.Tx, relations []Relationship) error

+ func (r *BelongsTo[T]) Value(tx *sqlx.Tx) (T, error)

+ func (v *BelongsTo) Loaded() bool

+ func (v *BelongsTo) MarshalJSON() ([]byte, error)

+ type Builder struct

+ func From() *Builder[T]

+ func New() *Builder[T]

+ func NewEmpty() *Builder[T]

+ func (b *Builder[T]) AddGroupBy(columns ...string) *Builder[T]

+ func (b *Builder[T]) AddOrderBy(columns ...string) *Builder[T]

+ func (b *Builder[T]) AddSelect(columns ...string) *Builder[T]

+ func (b *Builder[T]) AddSelectSubquery(sb *Builder[T]) *Builder[T]

+ func (b *Builder[T]) And(cb func(b *WhereList)) *Builder[T]

+ func (b *Builder[T]) Distinct() *Builder[T]

+ func (b *Builder[T]) Dump() *Builder[T]

+ func (b *Builder[T]) Find(tx *sqlx.Tx, primaryKeyValues ...any) (T, error)

+ func (b *Builder[T]) FindContext(ctx context.Context, tx *sqlx.Tx, primaryKeyValues ...any) (T, error)

+ func (b *Builder[T]) First(tx *sqlx.Tx) (T, error)

+ func (b *Builder[T]) FirstContext(ctx context.Context, tx *sqlx.Tx) (T, error)

+ func (b *Builder[T]) From(table string) *Builder[T]

+ func (b *Builder[T]) Get(tx *sqlx.Tx) ([]T, error)

+ func (b *Builder[T]) GetContext(ctx context.Context, tx *sqlx.Tx) ([]T, error)

+ func (b *Builder[T]) GroupBy(columns ...string) *Builder[T]

+ func (b *Builder[T]) Having(column, operator string, value any) *Builder[T]

+ func (b *Builder[T]) HavingAnd(cb func(b *WhereList)) *Builder[T]

+ func (b *Builder[T]) HavingOr(cb func(b *WhereList)) *Builder[T]

+ func (b *Builder[T]) Join() *Builder[T]

+ func (b *Builder[T]) Limit(limit int) *Builder[T]

+ func (b *Builder[T]) Offset(offset int) *Builder[T]

+ func (b *Builder[T]) Or(cb func(b *WhereList)) *Builder[T]

+ func (b *Builder[T]) OrHaving(column, operator string, value any) *Builder[T]

+ func (b *Builder[T]) OrWhere(column, operator string, value any) *Builder[T]

+ func (b *Builder[T]) OrWhereColumn(column, operator string, valueColumn string) *Builder[T]

+ func (b *Builder[T]) OrWhereIn(column string, values []any) *Builder[T]

+ func (b *Builder[T]) OrderBy(columns ...string) *Builder[T]

+ func (b *Builder[T]) Select(columns ...string) *Builder[T]

+ func (b *Builder[T]) SelectSubquery(sb *Builder[T]) *Builder[T]

+ func (b *Builder[T]) ToSQL(d dialects.Dialect) (string, []any, error)

+ func (b *Builder[T]) Where(column, operator string, value any) *Builder[T]

+ func (b *Builder[T]) WhereColumn(column, operator string, valueColumn string) *Builder[T]

+ func (b *Builder[T]) WhereIn(column string, values []any) *Builder[T]

+ type HasMany struct

+ func (r *HasMany[T]) Initialize(parent any, field reflect.StructField) error

+ func (r *HasMany[T]) Load(tx *sqlx.Tx, relations []Relationship) error

+ func (r *HasMany[T]) Loaded() bool

+ func (r *HasMany[T]) Value(tx *sqlx.Tx) ([]T, error)

+ func (v *HasMany) MarshalJSON() ([]byte, error)

+ type HasOne struct

+ func (r *HasOne[T]) Initialize(parent any, field reflect.StructField) error

+ func (r *HasOne[T]) Load(tx *sqlx.Tx, relations []Relationship) error

+ func (r *HasOne[T]) Loaded() bool

+ func (r *HasOne[T]) Value(tx *sqlx.Tx) (T, error)

+ func (v *HasOne) MarshalJSON() ([]byte, error)

+ type Join struct

+ type Relationship interface

+ Initialize func(self any, field reflect.StructField) error

+ Load func(tx *sqlx.Tx, relations []Relationship) error

+ Loaded func() bool

+ type WhereList struct

+ func NewWhereList() *WhereList

+ func (w *WhereList) And(cb func(w *WhereList)) *WhereList

+ func (w *WhereList) Or(cb func(w *WhereList)) *WhereList

+ func (w *WhereList) OrWhere(column, operator string, value any) *WhereList

+ func (w *WhereList) OrWhereColumn(column, operator string, valueColumn string) *WhereList

+ func (w *WhereList) OrWhereIn(column string, values []any) *WhereList

+ func (w *WhereList) ToSQL(d dialects.Dialect) (string, []any, error)

+ func (w *WhereList) Where(column, operator string, value any) *WhereList

+ func (w *WhereList) WhereColumn(column, operator string, valueColumn string) *WhereList

+ func (w *WhereList) WhereIn(column string, values []any) *WhereList

+ type Wheres struct

+ func NewWheres() *Wheres

+ func (w *Wheres) ToSQL(d dialects.Dialect) (string, []any, error)