selects

Documentation

Index

• func InitializeRelationships(v any) error
• func Load(tx *sqlx.Tx, v any, relation string) error
• func NewSelects() *selects
• type AfterLoader
• type AfterSaver
• type BeforeSaver
• type BelongsTo
  • func (r *BelongsTo[T]) Initialize(parent any, field reflect.StructField) error
  • func (r *BelongsTo[T]) Load(tx *sqlx.Tx, relations []Relationship) error
  • func (v *BelongsTo) Loaded() bool
  • func (v *BelongsTo) MarshalJSON() ([]byte, error)
  • func (r *BelongsTo[T]) Value(tx *sqlx.Tx) (T, error)
• type Builder
  • func From[T models.Model]() *Builder[T]
  • func New[T models.Model]() *Builder[T]
  • func NewEmpty[T models.Model]() *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
  • 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 (v *HasMany) MarshalJSON() ([]byte, error)
  • func (r *HasMany[T]) Value(tx *sqlx.Tx) ([]T, error)
• type HasOne
  • 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 (v *HasOne) MarshalJSON() ([]byte, error)
  • func (r *HasOne[T]) Value(tx *sqlx.Tx) (T, error)
• type Join
• type Relationship
• type WhereList
  • 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
  • func NewWheres() *Wheres
  • func (w *Wheres) ToSQL(d dialects.Dialect) (string, []any, error)

Functions

func InitializeRelationships

func InitializeRelationships(v any) error

func Load

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

func NewSelects

func NewSelects() *selects

Types

type AfterLoader

type AfterLoader interface {
	AfterLoad(ctx context.Context, tx *sqlx.Tx) error
}

type AfterSaver

type AfterSaver interface {
	AfterSave(ctx context.Context, tx *sqlx.Tx) error
}

type BeforeSaver

type BeforeSaver interface {
	BeforeSave(ctx context.Context, tx *sqlx.Tx) error
}

type BelongsTo

type BelongsTo[T models.Model] struct {
	// contains filtered or unexported fields
}

func (*BelongsTo[T]) Initialize

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

func (*BelongsTo[T]) Load

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

func (*BelongsTo) Loaded

func (v *BelongsTo) Loaded() bool

func (*BelongsTo) MarshalJSON

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

func (*BelongsTo[T]) Value

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

type Builder

type Builder[T models.Model] struct {
	// contains filtered or unexported fields
}

func From

func From[T models.Model]() *Builder[T]

func New

func New[T models.Model]() *Builder[T]

func NewEmpty

func NewEmpty[T models.Model]() *Builder[T]

func (*Builder[T]) AddGroupBy

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

func (*Builder[T]) AddOrderBy

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

func (*Builder[T]) AddSelect

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

func (*Builder[T]) AddSelectSubquery

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

func (*Builder[T]) And

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

func (*Builder[T]) Distinct

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

func (*Builder[T]) Dump

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

func (*Builder[T]) Find

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

func (*Builder[T]) FindContext

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

func (*Builder[T]) First

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

func (*Builder[T]) FirstContext

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

func (*Builder[T]) From

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

func (*Builder[T]) Get

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

func (*Builder[T]) GetContext

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

func (*Builder[T]) GroupBy

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

func (*Builder[T]) Having

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

func (*Builder[T]) HavingAnd

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

func (*Builder[T]) HavingOr

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

func (*Builder[T]) Join

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

func (*Builder[T]) Limit

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

func (*Builder[T]) Offset

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

func (*Builder[T]) Or

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

func (*Builder[T]) OrHaving

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

func (*Builder[T]) OrWhere

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

func (*Builder[T]) OrWhereColumn

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

func (*Builder[T]) OrWhereIn

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

func (*Builder[T]) OrderBy

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

func (*Builder[T]) Select

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

func (*Builder[T]) SelectSubquery

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

func (*Builder[T]) ToSQL

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

func (*Builder[T]) Where

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

func (*Builder[T]) WhereColumn

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

func (*Builder[T]) WhereIn

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

type HasMany

type HasMany[T models.Model] struct {
	// contains filtered or unexported fields
}

func (*HasMany[T]) Initialize

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

func (*HasMany[T]) Load

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

func (*HasMany[T]) Loaded

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

func (*HasMany) MarshalJSON

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

func (*HasMany[T]) Value

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

type HasOne

type HasOne[T models.Model] struct {
	// contains filtered or unexported fields
}

func (*HasOne[T]) Initialize

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

func (*HasOne[T]) Load

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

func (*HasOne[T]) Loaded

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

func (r *HasOne[T]) Query() *selects.Builder {
	var related T
	local, ok := builder.GetValue(r.parent, r.localKey)
	if !ok {
		panic(fmt.Errorf("no local key %s", r.localKey))
	}
	return selects.New().
		Select("*").
		From(builder.GetTable(related)).
		Where(r.foreignKey, "=", local).
		Limit(1)
}

func (*HasOne) MarshalJSON

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

func (*HasOne[T]) Value

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

type Join

type Join struct{}

type Relationship

type Relationship interface {
	// Query() *selects.Builder
	Initialize(self any, field reflect.StructField) error
	Load(tx *sqlx.Tx, relations []Relationship) error
	Loaded() bool
}

type WhereList

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

func NewWhereList

func NewWhereList() *WhereList

func (*WhereList) And

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

func (*WhereList) Or

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

func (*WhereList) OrWhere

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

func (*WhereList) OrWhereColumn

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

func (*WhereList) OrWhereIn

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

func (*WhereList) ToSQL

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

func (*WhereList) Where

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

func (*WhereList) WhereColumn

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

func (*WhereList) WhereIn

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

type Wheres

type Wheres struct {
	*WhereList
}

func NewWheres

func NewWheres() *Wheres

func (*Wheres) ToSQL

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