queries

package

Go to main page

Versions in this module

v1

v1.1.0

May 27, 2025

Changes in this version

+ const LogicalOpEQ

+ const LogicalOpGT

+ const LogicalOpGTE

+ const LogicalOpLT

+ const LogicalOpLTE

+ const LogicalOpNE

+ const TypeJoinCross

+ const TypeJoinFull

+ const TypeJoinInner

+ const TypeJoinLeft

+ const TypeJoinRight

+ func RunInTransaction[T attrs.Definer](ctx context.Context, fn func(NewQuerySet NewQuerySetFunc[T]) error) error

type FieldInfo

+ Through *FieldInfo

type JoinDef

+ Operator LogicalOp

+ type JoinType string

+ type NewQuerySetFunc func(model T) *QuerySet[T]

type QueryCompiler

+ DatabaseName func() string

+ WithTransaction func(tx Transaction) (Transaction, error)

type QuerySet

+ func (qs *QuerySet[T]) BulkCreate(objects []T) ([]T, error)

+ func (qs *QuerySet[T]) BulkUpdate(objects []T, expressions ...expr.NamedExpression) (int64, error)

+ func (qs *QuerySet[T]) WithTransaction(tx Transaction) (Transaction, error)

+ type QuerySetChanger interface

+ ChangeQuerySet func(qs *QuerySet[attrs.Definer]) *QuerySet[attrs.Definer]

+ type RelM2M []RelO2O[T1, T2]

+ func (rl *RelM2M[T1, T2]) Len() int

+ func (rl *RelM2M[T1, T2]) SetValues(rel []Relation)

+ type RelO2O struct

+ Object ModelType

+ ThroughObject ThroughModelType

+ func (rl *RelO2O[T1, T2]) Model() attrs.Definer

+ func (rl *RelO2O[T1, T2]) SetValue(instance attrs.Definer, through attrs.Definer)

+ func (rl *RelO2O[T1, T2]) Through() attrs.Definer

+ type SettableMultiThroughRelation interface

+ SetValues func(instances []Relation)

+ type SettableThroughRelation interface

+ SetValue func(instance attrs.Definer, through attrs.Definer)

+ type UpdateInfo struct

+ Field FieldInfo

+ Joins []JoinDef

+ Values []any

+ Where []expr.LogicalExpression

v1.0.9

May 22, 2025

Changes in this version

+ var QUERYSET_USE_CACHE_DEFAULT = true

+ func ForSelectAll(f attrs.Field) bool

+ func Subquery(qs *GenericQuerySet) expr.Expression

+ func SubqueryCount(qs *GenericQuerySet) *subqueryExpr

+ func SubqueryExists(qs *GenericQuerySet) expr.Expression

+ func SubqueryIn(field any, qs *GenericQuerySet) expr.Expression

+ type AliasField interface

+ Alias func() string

+ type CompiledCountQuery CompiledQuery[int64]

+ type CompiledExistsQuery CompiledQuery[bool]

+ type CompiledQuery interface

+ Exec func() (T1, error)

+ type CompiledValuesListQuery CompiledQuery[[][]any]

+ type DataModel interface

+ ModelDataStore func() ModelDataStore

type FieldInfo

+ RelType attrs.RelationType

+ func (f *FieldInfo) WriteField(sb *strings.Builder, inf *expr.ExpressionInfo, field attrs.Field, ...) (args []any, isSQL, written bool)

+ func (f *FieldInfo) WriteUpdateFields(sb *strings.Builder, inf *expr.ExpressionInfo) []any

+ type ForUseInQueries interface

+ ForUseInQueries func() bool

+ type ForUseInQueriesField interface

+ ForSelectAll func() bool

+ type GenericQuerySet = QuerySet[attrs.Definer]

+ type ModelDataStore interface

+ DeleteValue func(key string) error

+ GetValue func(key string) (any, bool)

+ HasValue func(key string) bool

+ SetValue func(key string, value any) error

type OrderBy

+ Alias string

+ type QueryInfo interface

+ Args func() []any

+ Compiler func() QueryCompiler

+ Model func() attrs.Definer

+ SQL func() string

type QuerySet

+ AliasGen *alias.Generator

+ func ChangeObjectsType[OldT, NewT attrs.Definer](qs *QuerySet[OldT]) *QuerySet[NewT]

+ func GetQuerySet[T attrs.Definer](model attrs.Definer) *QuerySet[T]

+ func (qs *QuerySet[T]) Aggregate(annotations map[string]expr.Expression) (map[string]any, error)

+ func (qs *QuerySet[T]) Annotate(aliasOrAliasMap interface{}, exprs ...expr.Expression) *QuerySet[T]

+ func (qs *QuerySet[T]) LatestQuery() QueryInfo

+ func (qs *QuerySet[T]) Prefix(prefix string) *QuerySet[T]

+ func (qs *QuerySet[T]) StartTransaction(ctx context.Context) (Transaction, error)

+ type QuerySetDatabaseDefiner interface

+ QuerySetDatabase func() string

+ type QuerySetDefiner interface

+ GetQuerySet func() *QuerySet[attrs.Definer]

+ type QuerySetInternals struct

+ Annotations map[string]*queryField[any]

+ Distinct bool

+ Fields []FieldInfo

+ ForUpdate bool

+ GroupBy []FieldInfo

+ Having []expr.LogicalExpression

+ Joins []JoinDef

+ Limit int

+ Offset int

+ OrderBy []OrderBy

+ Where []expr.LogicalExpression

+ type RelatedField interface

+ GetTargetField func() attrs.Field

+ RelatedName func() string

+ type Relation interface

+ Model func() attrs.Definer

+ Through func() attrs.Through

+ type Row struct

+ Annotations map[string]any

+ Object T

+ QuerySet *QuerySet[T]

type SupportsReturning

+ func DBSupportsReturning(db *sql.DB) SupportsReturning

+ type Table struct

+ Alias string

+ Name string

+ type VirtualField interface

+ SQL func(inf *expr.ExpressionInfo) (string, []any)

v1.0.8

Apr 30, 2025

Changes in this version

+ const ErrNoResults

+ var LogQueries = true

+ var SignalPostModelDelete = signals_deleting.Get("queries.model.post_delete")

+ var SignalPostModelSave = signals_saving.Get("queries.model.post_save")

+ var SignalPreModelDelete = signals_deleting.Get("queries.model.pre_delete")

+ var SignalPreModelSave = signals_saving.Get("queries.model.pre_save")

type ErrorQuery

+ Compile QueryCompiler

+ func (e *ErrorQuery[T]) Compiler() QueryCompiler

type Query

+ Compiler func() QueryCompiler

type QueryObject

+ func (q *QueryObject[T1]) Compiler() QueryCompiler

type QuerySet

+ func (qs *QuerySet) ExplicitSave() *QuerySet

+ func (qs *QuerySet) GoString() string

+ func (w *QuerySet) String() string

+ type SignalSave struct

+ Instance attrs.Definer

+ Using QueryCompiler

v1.0.7

Apr 29, 2025

Changes in this version

+ const ErrFailedStartTransaction

+ const ErrMultipleRows

+ const ErrNoRows

+ const ErrNoTransaction

+ const ErrNoWhereClause

+ const ErrTransactionStarted

+ const ErrUnsupportedLookup

+ const MAX_GET_RESULTS

+ func DefinerListToList[T attrs.Definer](list []attrs.Definer) []T

+ func RegisterCompiler(driver driver.Driver, compiler func(model attrs.Definer) QueryCompiler)

+ func RegisterLookup(lookup string, ...)

+ type DB interface

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

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

+ QueryRowContext func(ctx context.Context, query string, args ...any) *sql.Row

+ type ErrorQuery struct

+ Err error

+ Obj attrs.Definer

+ func (e *ErrorQuery[T]) Args() []any

+ func (e *ErrorQuery[T]) Exec() (T, error)

+ func (e *ErrorQuery[T]) Model() attrs.Definer

+ func (e *ErrorQuery[T]) SQL() string

type FieldInfo

+ func (f *FieldInfo) WriteFields(sb *strings.Builder, quote string)

+ type GenericQueryBuilder struct

+ func (g *GenericQueryBuilder) BuildCountQuery(ctx context.Context, qs *QuerySet, where []Expression, joins []JoinDef, ...) CountQuery

+ func (g *GenericQueryBuilder) BuildCreateQuery(ctx context.Context, qs *QuerySet, fields FieldInfo, primary attrs.Field, ...) Query[[]interface{}]

+ func (g *GenericQueryBuilder) BuildDeleteQuery(ctx context.Context, qs *QuerySet, where []Expression, joins []JoinDef, ...) CountQuery

+ func (g *GenericQueryBuilder) BuildSelectQuery(ctx context.Context, qs *QuerySet, fields []FieldInfo, where []Expression, ...) Query[[][]interface{}]

+ func (g *GenericQueryBuilder) BuildUpdateQuery(ctx context.Context, qs *QuerySet, fields FieldInfo, where []Expression, ...) CountQuery

+ func (g *GenericQueryBuilder) CommitTransaction() error

+ func (g *GenericQueryBuilder) DB() DB

+ func (g *GenericQueryBuilder) InTransaction() bool

+ func (g *GenericQueryBuilder) Quote() (string, string)

+ func (g *GenericQueryBuilder) RollbackTransaction() error

+ func (g *GenericQueryBuilder) StartTransaction(ctx context.Context) (Transaction, error)

+ func (g *GenericQueryBuilder) SupportsReturning() SupportsReturning

+ type QueryCompiler interface

+ BuildCountQuery func(ctx context.Context, qs *QuerySet, where []Expression, joins []JoinDef, ...) CountQuery

+ BuildCreateQuery func(ctx context.Context, qs *QuerySet, fields FieldInfo, primary attrs.Field, ...) Query[[]interface{}]

+ BuildDeleteQuery func(ctx context.Context, qs *QuerySet, where []Expression, joins []JoinDef, ...) CountQuery

+ BuildSelectQuery func(ctx context.Context, qs *QuerySet, fields []FieldInfo, where []Expression, ...) Query[[][]interface{}]

+ BuildUpdateQuery func(ctx context.Context, qs *QuerySet, fields FieldInfo, where []Expression, ...) CountQuery

+ CommitTransaction func() error

+ DB func() DB

+ InTransaction func() bool

+ Quote func() (front string, back string)

+ RollbackTransaction func() error

+ StartTransaction func(ctx context.Context) (Transaction, error)

+ SupportsReturning func() SupportsReturning

+ func Compiler(model attrs.Definer) QueryCompiler

+ func NewGenericQueryBuilder(model attrs.Definer) QueryCompiler

+ type QueryObject struct

+ func (q *QueryObject[T1]) Args() []any

+ func (q *QueryObject[T1]) Exec() (T1, error)

+ func (q *QueryObject[T1]) Model() attrs.Definer

+ func (q *QueryObject[T1]) SQL() string

type QuerySet

+ func (qs *QuerySet) Compiler() QueryCompiler

+ func (qs *QuerySet) Create(value attrs.Definer) Query[attrs.Definer]

+ func (qs *QuerySet) DB() DB

+ func (qs *QuerySet) Get() Query[attrs.Definer]

+ func (qs *QuerySet) GetOrCreate(value attrs.Definer) (attrs.Definer, error)

+ func (qs *QuerySet) Model() attrs.Definer

+ type SupportsReturning string

+ const SupportsReturningColumns

+ const SupportsReturningLastInsertId

+ const SupportsReturningNone

+ type Transaction interface

+ Commit func() error

+ Rollback func() error

v1.0.6

Apr 26, 2025

v1.0.5

Apr 26, 2025

v1.0.4

Apr 26, 2025

v1.0.3

Apr 26, 2025

Changes in this version

+ type CountQuery Query[int64, T]

+ type ExistsQuery Query[bool, T]

+ type FieldInfo struct

+ Chain []string

+ Fields []attrs.Field

+ Model attrs.Definer

+ SourceField attrs.Field

+ Table string

+ type IterQuery Query[iter.Seq[T], T]

+ type JoinDef struct

+ ConditionA string

+ ConditionB string

+ Logic string

+ Table string

+ TypeJoin string

+ type OrderBy struct

+ Desc bool

+ Field string

+ Table string

+ type Query interface

+ Args func() []any

+ Exec func() (T1, error)

+ Model func() T2

+ SQL func() string

type QuerySet

+ func (qs *QuerySet[T]) Delete() CountQuery[T]

+ func (qs *QuerySet[T]) Distinct() *QuerySet[T]

+ func (qs *QuerySet[T]) Exists() ExistsQuery[T]

+ func (qs *QuerySet[T]) Last() Query[T, T]

+ func (qs *QuerySet[T]) Reverse() *QuerySet[T]

+ func (qs *QuerySet[T]) Select(fields ...string) *QuerySet[T]

+ func (qs *QuerySet[T]) Update(value T) CountQuery[T]

+ func (qs *QuerySet[T]) ValuesList(fields ...string) ValuesListQuery[T]

+ type RawExpr struct

+ Fields []string

+ Params []any

+ Statement string

+ func (e *RawExpr) And(exprs ...Expression) Expression

+ func (e *RawExpr) Args() []any

+ func (e *RawExpr) Clone() Expression

+ func (e *RawExpr) IsNot() bool

+ func (e *RawExpr) Not(not bool) Expression

+ func (e *RawExpr) Or(exprs ...Expression) Expression

+ func (e *RawExpr) SQL(sb *strings.Builder)

+ func (e *RawExpr) With(m attrs.Definer, quote string) Expression

+ type ValuesListQuery Query[[][]any, T]

v1.0.2

Apr 22, 2025

Changes in this version

+ func RegisterDriver(driver driver.Driver, database string)

v1.0.1

Apr 22, 2025

Changes in this version

+ var Quote = "`"

v1.0.0

Apr 22, 2025

Changes in this version

+ const ErrFieldNull

+ const ErrLastInsertId

+ const ErrNoDatabase

+ const ErrNoTableName

+ const ErrUnknownDriver

+ func CT_GetObject[T attrs.Definer](identifier any) (interface{}, error)

+ func CT_ListObjectsByIDs[T attrs.Definer](i []interface{}) ([]interface{}, error)

+ func CT_ListObjects[T attrs.Definer](amount, offset uint) ([]interface{}, error)

+ func CountObjects[T attrs.Definer](obj T) (int64, error)

+ func CreateObject[T attrs.Definer](obj T) error

+ func DeleteObject[T attrs.Definer](obj T) error

+ func GetObject[T attrs.Definer](identifier any) (T, error)

+ func ListObjectsByIDs[T attrs.Definer, T2 any](offset, limit uint64, ids []T2) ([]T, error)

+ func ListObjects[T attrs.Definer](offset, limit uint64, ordering ...string) ([]T, error)

+ func SaveObject[T attrs.Definer](obj T) error

+ func UpdateObject[T attrs.Definer](obj T) error

+ type ExprGroup struct

+ func (g *ExprGroup) And(exprs ...Expression) Expression

+ func (g *ExprGroup) Args() []any

+ func (g *ExprGroup) Clone() Expression

+ func (g *ExprGroup) IsNot() bool

+ func (g *ExprGroup) Not(not bool) Expression

+ func (g *ExprGroup) Or(exprs ...Expression) Expression

+ func (g *ExprGroup) SQL(sb *strings.Builder)

+ func (g *ExprGroup) With(m attrs.Definer, quote string) Expression

+ type ExprNode struct

+ func Expr(field string, operation string, value ...any) *ExprNode

+ func Q(fieldLookup string, value ...any) *ExprNode

+ func (e *ExprNode) And(exprs ...Expression) Expression

+ func (e *ExprNode) Args() []any

+ func (e *ExprNode) Clone() Expression

+ func (e *ExprNode) IsNot() bool

+ func (e *ExprNode) Not(not bool) Expression

+ func (e *ExprNode) Or(exprs ...Expression) Expression

+ func (e *ExprNode) SQL(sb *strings.Builder)

+ func (e *ExprNode) With(m attrs.Definer, quote string) Expression

+ type Expression interface

+ And func(...Expression) Expression

+ Args func() []any

+ Clone func() Expression

+ IsNot func() bool

+ Not func(b bool) Expression

+ Or func(...Expression) Expression

+ SQL func(sb *strings.Builder)

+ With func(model attrs.Definer, quote string) Expression

+ func And(exprs ...Expression) Expression

+ func Or(exprs ...Expression) Expression

+ type FuncExpr struct

+ Fields []string

+ Params []any

+ Statement string

+ func (e *FuncExpr) And(exprs ...Expression) Expression

+ func (e *FuncExpr) Args() []any

+ func (e *FuncExpr) Clone() Expression

+ func (e *FuncExpr) IsNot() bool

+ func (e *FuncExpr) Not(not bool) Expression

+ func (e *FuncExpr) Or(exprs ...Expression) Expression

+ func (e *FuncExpr) SQL(sb *strings.Builder)

+ func (e *FuncExpr) With(m attrs.Definer, quote string) Expression

+ type LogicalOp string

+ const OpAnd

+ const OpOr

+ type QuerySet struct

+ func Objects[T attrs.Definer](model T) *QuerySet[T]

+ func (qs *QuerySet[T]) All() ([]T, error)

+ func (qs *QuerySet[T]) Clone() *QuerySet[T]

+ func (qs *QuerySet[T]) Count() (int, error)

+ func (qs *QuerySet[T]) CrossJoin(field, conditionA, logic, conditionB string) *QuerySet[T]

+ func (qs *QuerySet[T]) CrossJoinTable(table, conditionA, logic, conditionB string) *QuerySet[T]

+ func (qs *QuerySet[T]) Fields(fields ...string) *QuerySet[T]

+ func (qs *QuerySet[T]) Filter(key interface{}, vals ...interface{}) *QuerySet[T]

+ func (qs *QuerySet[T]) First() (T, error)

+ func (qs *QuerySet[T]) ForUpdate() *QuerySet[T]

+ func (qs *QuerySet[T]) GroupBy(fields ...string) *QuerySet[T]

+ func (qs *QuerySet[T]) Having(key interface{}, vals ...interface{}) *QuerySet[T]

+ func (qs *QuerySet[T]) InnerJoin(field, conditionA, logic, conditionB string) *QuerySet[T]

+ func (qs *QuerySet[T]) InnerJoinTable(table, conditionA, logic, conditionB string) *QuerySet[T]

+ func (qs *QuerySet[T]) Join(field, conditionA, logic, conditionB string) *QuerySet[T]

+ func (qs *QuerySet[T]) JoinTable(table, conditionA, logic, conditionB string) *QuerySet[T]

+ func (qs *QuerySet[T]) LeftJoin(field, conditionA, logic, conditionB string) *QuerySet[T]

+ func (qs *QuerySet[T]) LeftJoinTable(table, conditionA, logic, conditionB string) *QuerySet[T]

+ func (qs *QuerySet[T]) Limit(n int) *QuerySet[T]

+ func (qs *QuerySet[T]) Offset(n int) *QuerySet[T]

+ func (qs *QuerySet[T]) OrderBy(fields ...string) *QuerySet[T]

+ func (qs *QuerySet[T]) RightJoin(field, conditionA, logic, conditionB string) *QuerySet[T]

+ func (qs *QuerySet[T]) RightJoinTable(table, conditionA, logic, conditionB string) *QuerySet[T]

+ func (s *QuerySet[T]) Union(f func(*QuerySet[attrs.Definer])) *QuerySet[T]

+ type Union func(*QuerySet[attrs.Definer])

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