Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

query

package module

Go to main page

Versions in this module

v0

v0.1.4

Dec 7, 2023

v0.1.3

Dec 7, 2023

Changes in this version

+ var Error = errors.New("query")

+ type BaseBuilder struct

+ func (b BaseBuilder) Operation() Operation

+ type BaseCondition struct

+ func (condition BaseCondition) IsNegate() bool

+ func (condition BaseCondition) Join(newJoinType JoinType) BaseCondition

+ func (condition BaseCondition) JoinType() JoinType

+ func (condition BaseCondition) Negate(newNegateIndicator bool) BaseCondition

+ func (condition BaseCondition) RenderJoin(isFirst bool) (result string)

+ func (condition BaseCondition) RenderNegate() string

+ type BaseSelectBuilder struct

+ func SelectFrom[T TableNameParameter](tableNameProvider T) BaseSelectBuilder

+ func (query BaseSelectBuilder) BuildQueryAndParams() (sql string, params []interface{}, err error)

+ func (query BaseSelectBuilder) Count() CountBuilder

+ func (query BaseSelectBuilder) Delete() DeleteBuilder

+ func (query BaseSelectBuilder) FieldDefinitions() (res []FieldDefinition)

+ func (query BaseSelectBuilder) Fields(fieldSpecs ...FieldDefinition) (updated BaseSelectBuilder)

+ func (query BaseSelectBuilder) FullJoin(rightTable TableIdent) IncompleteSelectJoin

+ func (query BaseSelectBuilder) InnerJoin(rightTable TableIdent) IncompleteSelectJoin

+ func (query BaseSelectBuilder) InsertInto(insertValues ...FieldValue) InsertBuilder

+ func (query BaseSelectBuilder) Join(rightTable TableIdent, joinType TableJoinType) IncompleteSelectJoin

+ func (query BaseSelectBuilder) LeftJoin(rightTable TableIdent) IncompleteSelectJoin

+ func (query BaseSelectBuilder) Limit(limit int) SelectManyBuilder

+ func (query BaseSelectBuilder) Many() SelectManyBuilder

+ func (query BaseSelectBuilder) Offset(offset uint) SelectManyBuilder

+ func (query BaseSelectBuilder) OrderBy(orderByFields ...FieldSorting) SelectManyBuilder

+ func (query BaseSelectBuilder) Render(parametersCount int) (sql string)

+ func (query BaseSelectBuilder) RenderFrom() (fromClause string)

+ func (query BaseSelectBuilder) RenderSQL() (sql string)

+ func (query BaseSelectBuilder) RightJoin(rightTable TableIdent) IncompleteSelectJoin

+ func (query BaseSelectBuilder) Single() SelectSingleBuilder

+ func (query BaseSelectBuilder) String() string

+ func (query BaseSelectBuilder) TableName() TableName

+ func (query BaseSelectBuilder) Update(values ...FieldValue) UpdateBuilder

+ func (query BaseSelectBuilder) Values() (params []any)

+ func (query BaseSelectBuilder) Where(fieldConditions ...Condition) (updated BaseSelectBuilder)

+ type ClauseFromRenderer interface

+ RenderFrom func() string

+ type Condition interface

+ And func(conditions ...Condition) Condition

+ ApplyFieldSpec func(spec FieldDefinition) Condition

+ ApplyFieldTable func(table TableName) Condition

+ FieldName func() FieldName

+ IsNegate func() bool

+ Join func(newJoinType JoinType) Condition

+ JoinType func() JoinType

+ Negate func(newNegate bool) Condition

+ Or func(conditions ...Condition) Condition

+ RenderJoin func(isFirst bool) (result string)

+ RenderNegate func() string

+ func And(condition Condition, additionalConditions ...Condition) Condition

+ func Contains(fieldName FieldName, value string) Condition

+ func EqualTo(fieldName FieldName, value interface{}) Condition

+ func GreaterOrEqual(fieldName FieldName, value interface{}) Condition

+ func GreaterThan(fieldName FieldName, value interface{}) Condition

+ func IContains(fieldName FieldName, value string) Condition

+ func In(fieldName FieldName, value interface{}) Condition

+ func IsNull(fieldName FieldName) Condition

+ func Less(fieldName FieldName, value interface{}) Condition

+ func LessOrEqual(fieldName FieldName, value interface{}) Condition

+ func Not(condition Condition) Condition

+ func Or(condition Condition, additionalConditions ...Condition) Condition

+ type CountBuilder struct

+ func Count(query BaseSelectBuilder, fieldToCount ...FieldName) (countBuilder CountBuilder)

+ func (query CountBuilder) BuildQueryAndParams() (sql string, params []interface{}, err error)

+ func (query CountBuilder) RenderFrom() string

+ type Counter interface

+ CountCtx func(ctx context.Context, helper CountBuilder) (rowsCount int, err error)

+ type CountingClauseRenderer interface

+ Render func(parametersCount int) (sql string)

+ type DeleteBuilder struct

+ func Delete[T TableNameParameter](tableNameProvider T) DeleteBuilder

+ func (updater DeleteBuilder) BuildQueryAndParams() (sql string, params []interface{}, err error)

+ func (updater DeleteBuilder) RenderFrom() string

+ func (updater DeleteBuilder) TableName() TableName

+ func (updater DeleteBuilder) Where(fieldConditions ...Condition) DeleteBuilder

+ type Deleter interface

+ DeleteManyCtx func(ctx context.Context, updateParams DeleteBuilder) (affectedRows int, err error)

+ type FetchCounter interface

+ FetchCountCtx func(ctx context.Context, queryParams SelectManyBuilder, target interface{}) (totalRows int, err error)

+ type Fetcher interface

+ FetchCtx func(ctx context.Context, queryParams SelectManyBuilder, target interface{}) (err error)

+ type FetcherCounter interface

+ type FieldDefinition struct

+ func FieldOrError[T FieldNameParameter](fieldName T) (field *FieldDefinition, err error)

+ func Field[T FieldNameParameter](spec T) (field FieldDefinition)

+ func (fieldIdent FieldDefinition) Alias() FieldName

+ func (fieldIdent FieldDefinition) As(alias FieldName) FieldDefinition

+ func (fieldIdent FieldDefinition) FieldName() FieldName

+ func (fieldIdent FieldDefinition) Of(tableName TableName) FieldDefinition

+ func (fieldIdent FieldDefinition) RenderField() string

+ func (fieldIdent FieldDefinition) RenderSpec() string

+ func (fieldIdent FieldDefinition) RenderTableSpec() string

+ func (fieldIdent FieldDefinition) TableFieldName() FieldName

+ func (fieldIdent FieldDefinition) TableName() TableName

+ func (fieldIdent FieldDefinition) Value(value any) FieldValue

+ type FieldName string

+ func UniqFieldNames(a []FieldName) []FieldName

+ func (fn FieldName) Contains(value string) Condition

+ func (fn FieldName) EqualTo(value interface{}) Condition

+ func (fn FieldName) Field() FieldDefinition

+ func (fn FieldName) IContains(value string) Condition

+ func (fn FieldName) In(value interface{}) Condition

+ func (fn FieldName) IsNull() Condition

+ func (fn FieldName) String() string

+ func (fn FieldName) Validate() error

+ func (fn FieldName) Value(value interface{}) FieldValue

+ type FieldNameParameter interface

+ type FieldSorting struct

+ func ASC(fieldName FieldName) FieldSorting

+ func DESC(fieldName FieldName) FieldSorting

+ func OrderBy(fieldName FieldName, direction ...SortDirection) FieldSorting

+ func (o FieldSorting) ApplyFieldSpec(spec FieldDefinition) FieldSorting

+ func (o FieldSorting) Direction() SortDirection

+ func (o FieldSorting) Render() string

+ type FieldValue struct

+ func NewFieldValue(fieldName FieldName, fieldValue interface{}) *FieldValue

+ func (fieldValue FieldValue) ApplyFieldSpec(spec FieldDefinition) FieldValue

+ func (fieldValue FieldValue) ApplyFieldTable(table TableName) FieldValue

+ func (fieldValue FieldValue) Values() (result []interface{})

+ type Fields struct

+ func NewFields(args ...any) Fields

+ func (query Fields) FieldDefinitions() (res []FieldDefinition)

+ func (query Fields) FieldList() string

+ func (query Fields) Fields(fieldSpecs ...FieldDefinition) (updated Fields)

+ func (query Fields) Len() int

+ func (query Fields) String() string

+ type Getter interface

+ GetCtx func(ctx context.Context, queryParams SelectSingleBuilder, target interface{}) (err error)

+ type Group struct

+ func NewGroup(joinType JoinType, conditions ...Condition) Group

+ func (conditionsGroup Group) And(conditions ...Condition) Condition

+ func (conditionsGroup Group) ApplyFieldSpec(spec FieldDefinition) Condition

+ func (conditionsGroup Group) ApplyFieldTable(table TableName) Condition

+ func (conditionsGroup Group) FieldName() FieldName

+ func (conditionsGroup Group) GroupAND(conditions ...Condition) Group

+ func (conditionsGroup Group) GroupOR(conditions ...Condition) Group

+ func (conditionsGroup Group) Join(newJoinType JoinType) Condition

+ func (conditionsGroup Group) Negate(newNegateIndicator bool) Condition

+ func (conditionsGroup Group) Or(conditions ...Condition) Condition

+ func (conditionsGroup Group) Render(parametersCount int) (sql string)

+ func (conditionsGroup Group) RenderSQL() (sql string)

+ func (conditionsGroup Group) Values() (values []interface{})

+ func (conditionsGroup Group) WithBrackets() Group

+ type IncompleteSelectJoin interface

+ On func(leftField FieldDefinition, rightField FieldDefinition) (updated BaseSelectBuilder)

+ type IncompleteSelectManyJoiner interface

+ On func(leftField FieldDefinition, rightField FieldDefinition) (updated SelectManyBuilder)

+ type IncompleteSelectSingleJoiner interface

+ On func(leftField FieldDefinition, rightField FieldDefinition) (updated SelectSingleBuilder)

+ type InsertBuilder struct

+ func InsertInto[T TableNameParameter](tableNameProvider T) InsertBuilder

+ func (inserter InsertBuilder) BuildQueryAndParams() (sql string, params []interface{}, err error)

+ func (inserter InsertBuilder) RenderFrom() string

+ func (inserter InsertBuilder) SetValues() []FieldValue

+ func (inserter InsertBuilder) TableName() TableName

+ func (inserter InsertBuilder) Values(values ...FieldValue) InsertBuilder

+ type Inserter interface

+ InsertOneCtx func(ctx context.Context, updateParams InsertBuilder) (err error)

+ type JoinCondition struct

+ func JoinFields(fromField FieldDefinition, toField FieldDefinition) JoinCondition

+ func (joinCondition JoinCondition) FullJoin() TableJoiner

+ func (joinCondition JoinCondition) InnerJoin() TableJoiner

+ func (joinCondition JoinCondition) LeftJoin() TableJoiner

+ func (joinCondition JoinCondition) Render() string

+ func (joinCondition JoinCondition) RightJoin() TableJoiner

+ func (joinCondition JoinCondition) Using(joinType TableJoinType) TableJoiner

+ type JoinType string

+ const LogicalAND

+ const LogicalOR

+ func (joinType JoinType) Join(conditions ...Condition) (result Condition)

+ func (joinType JoinType) SetToAll(conditions ...Condition) (result []Condition)

+ func (joinType JoinType) String() string

+ type Limiter struct

+ func (query Limiter) Limit(limit uint) Limiter

+ func (query Limiter) Offset(offset uint) Limiter

+ func (query Limiter) Render(paramNum int) (sql string)

+ func (query Limiter) RenderSQL() (sql string)

+ func (query Limiter) Values() (params []any)

+ type Operation int

+ const DoDelete

+ const DoInsert

+ const DoSelect

+ const DoUpdate

+ func (op Operation) New() BaseBuilder

+ func (op Operation) String() string

+ type RawClauseRenderer interface

+ RenderSQL func() (sql string)

+ type SQLKeyWord string

+ func (kw SQLKeyWord) String() string

+ type SelectManyBuilder struct

+ func SelectManyFromBase(builder BaseSelectBuilder) SelectManyBuilder

+ func SelectManyFrom[T TableNameParameter](tableNameProvider T) SelectManyBuilder

+ func (query SelectManyBuilder) BuildQueryAndParams() (sql string, params []interface{}, err error)

+ func (query SelectManyBuilder) Count() CountBuilder

+ func (query SelectManyBuilder) Delete() DeleteBuilder

+ func (query SelectManyBuilder) FieldDefinitions() (res []FieldDefinition)

+ func (query SelectManyBuilder) FieldList() string

+ func (query SelectManyBuilder) Fields(fieldSpecs ...FieldDefinition) (updated SelectManyBuilder)

+ func (query SelectManyBuilder) FullJoin(rightTable TableName) IncompleteSelectManyJoiner

+ func (query SelectManyBuilder) InnerJoin(rightTable TableName) IncompleteSelectManyJoiner

+ func (query SelectManyBuilder) Join(rightTable TableName, joinType TableJoinType) IncompleteSelectManyJoiner

+ func (query SelectManyBuilder) LeftJoin(rightTable TableName) IncompleteSelectManyJoiner

+ func (query SelectManyBuilder) Limit(limit int) SelectManyBuilder

+ func (query SelectManyBuilder) Offset(offset uint) SelectManyBuilder

+ func (query SelectManyBuilder) OrderBy(orderByFields ...FieldSorting) SelectManyBuilder

+ func (query SelectManyBuilder) RenderFrom() string

+ func (query SelectManyBuilder) RightJoin(rightTable TableName) IncompleteSelectManyJoiner

+ func (query SelectManyBuilder) Update(values ...FieldValue) UpdateBuilder

+ func (query SelectManyBuilder) Where(fieldConditions ...Condition) SelectManyBuilder

+ type SelectSingleBuilder struct

+ func SelectSingleFromBase(builder BaseSelectBuilder) SelectSingleBuilder

+ func SelectSingleFrom[T TableNameParameter](tableNameProvider T) SelectSingleBuilder

+ func (query SelectSingleBuilder) BuildQueryAndParams() (sql string, params []interface{}, err error)

+ func (query SelectSingleBuilder) FieldDefinitions() (res []FieldDefinition)

+ func (query SelectSingleBuilder) FieldList() string

+ func (query SelectSingleBuilder) Fields(fieldSpecs ...FieldDefinition) (updated SelectSingleBuilder)

+ func (query SelectSingleBuilder) FullJoin(rightTable TableName) IncompleteSelectSingleJoiner

+ func (query SelectSingleBuilder) InnerJoin(rightTable TableName) IncompleteSelectSingleJoiner

+ func (query SelectSingleBuilder) Join(rightTable TableName, joinType TableJoinType) IncompleteSelectSingleJoiner

+ func (query SelectSingleBuilder) LeftJoin(rightTable TableName) IncompleteSelectSingleJoiner

+ func (query SelectSingleBuilder) RenderFrom() string

+ func (query SelectSingleBuilder) RightJoin(rightTable TableName) IncompleteSelectSingleJoiner

+ func (query SelectSingleBuilder) Update(values ...FieldValue) UpdateBuilder

+ func (query SelectSingleBuilder) Where(fieldConditions ...Condition) SelectSingleBuilder

+ type SortDirection string

+ const Ascending

+ const Descending

+ func (direction SortDirection) String() string

+ type TableIdent struct

+ func TableOrError[T TableNameParameter](name T) (*TableIdent, error)

+ func Table[T TableNameParameter](name T) TableIdent

+ func (tableIdent TableIdent) Alias() TableName

+ func (tableIdent TableIdent) As(alias TableName) (updated TableIdent)

+ func (tableIdent TableIdent) Count(filterConditions ...Condition) CountBuilder

+ func (tableIdent TableIdent) Delete(filterConditions ...Condition) DeleteBuilder

+ func (tableIdent TableIdent) Field(name FieldName) FieldDefinition

+ func (tableIdent TableIdent) FullJoin(rightTable TableIdent) IncompleteSelectJoin

+ func (tableIdent TableIdent) InnerJoin(rightTable TableIdent) IncompleteSelectJoin

+ func (tableIdent TableIdent) InsertInto(insertValues ...FieldValue) InsertBuilder

+ func (tableIdent TableIdent) Join(rightTable TableIdent, joinType TableJoinType) IncompleteSelectJoin

+ func (tableIdent TableIdent) LeftJoin(rightTable TableIdent) IncompleteSelectJoin

+ func (tableIdent TableIdent) RenderFrom() string

+ func (tableIdent TableIdent) RightJoin(rightTable TableIdent) IncompleteSelectJoin

+ func (tableIdent TableIdent) Select(filterConditions ...Condition) BaseSelectBuilder

+ func (tableIdent TableIdent) SelectMany(filterConditions ...Condition) SelectManyBuilder

+ func (tableIdent TableIdent) SelectOne(filterConditions ...Condition) SelectSingleBuilder

+ func (tableIdent TableIdent) TableName() TableName

+ func (tableIdent TableIdent) Update(updateValues ...FieldValue) UpdateBuilder

+ type TableJoinType int

+ const FullJoin

+ const InnerJoin

+ const LeftJoin

+ const RightJoin

+ func (join TableJoinType) By(leftField FieldDefinition, rightField FieldDefinition) TableJoiner

+ func (join TableJoinType) String() string

+ func (join TableJoinType) Tables(leftTable TableIdent, rightTable TableIdent) IncompleteSelectJoin

+ type TableJoiner struct

+ func NewTableJoiner(right TableIdent, joinType TableJoinType, on JoinCondition) TableJoiner

+ func (tableJoiner TableJoiner) By(leftTableField FieldDefinition, rightTableField FieldDefinition) TableJoiner

+ func (tableJoiner TableJoiner) JoinCondition() JoinCondition

+ func (tableJoiner TableJoiner) JoinType() TableJoinType

+ func (tableJoiner TableJoiner) RenderFrom() string

+ type TableName string

+ func (tableName TableName) Delete(filterConditions ...Condition) DeleteBuilder

+ func (tableName TableName) Field(fieldName FieldName) FieldDefinition

+ func (tableName TableName) FullJoin(rightTable TableIdent) IncompleteSelectJoin

+ func (tableName TableName) Ident() TableIdent

+ func (tableName TableName) InnerJoin(rightTable TableIdent) IncompleteSelectJoin

+ func (tableName TableName) InsertInto(insertValues ...FieldValue) InsertBuilder

+ func (tableName TableName) Join(rightTable TableIdent, joinType TableJoinType) IncompleteSelectJoin

+ func (tableName TableName) LeftJoin(rightTable TableIdent) IncompleteSelectJoin

+ func (tableName TableName) RenderFrom() string

+ func (tableName TableName) RightJoin(rightTable TableIdent) IncompleteSelectJoin

+ func (tableName TableName) Select(filterConditions ...Condition) BaseSelectBuilder

+ func (tableName TableName) SelectMany(filterConditions ...Condition) SelectManyBuilder

+ func (tableName TableName) SelectOne(filterConditions ...Condition) SelectSingleBuilder

+ func (tableName TableName) String() string

+ func (tableName TableName) Update(updateValues ...FieldValue) UpdateBuilder

+ type TableNameParameter interface

+ type TableNameProvider interface

+ TableName func() TableName

+ type UpdateBuilder struct

+ func Update[T TableNameParameter](tableNameProvider T) UpdateBuilder

+ func (updater UpdateBuilder) BuildQueryAndParams() (sql string, params []interface{}, err error)

+ func (updater UpdateBuilder) RenderFrom() string

+ func (updater UpdateBuilder) Set(values ...FieldValue) UpdateBuilder

+ func (updater UpdateBuilder) SetValues() []FieldValue

+ func (updater UpdateBuilder) TableName() TableName

+ func (updater UpdateBuilder) Where(fieldConditions ...Condition) UpdateBuilder

+ type Updater interface

+ UpdateOneCtx func(ctx context.Context, updateParams UpdateBuilder) (err error)

+ type ValueProvider interface

+ DatabaseValue func() interface{}

+ type ValuesMap map[string]any

+ func (valuesMap ValuesMap) FieldValues() ([]FieldValue, error)

+ type ValuesProvider interface

+ Values func() []any

+ type WhereClause struct

+ func NewWhere() WhereClause

+ func (query WhereClause) ApplyFieldSpec(spec FieldDefinition) (updated WhereClause)

+ func (query WhereClause) Conditions() (conditions []Condition)

+ func (query WhereClause) GroupAND(conditions ...Condition) (updated WhereClause)

+ func (query WhereClause) GroupOR(conditions ...Condition) (updated WhereClause)

+ func (query WhereClause) Render(parametersCount int) (sql string)

+ func (query WhereClause) RenderSQL() (sql string)

+ func (query WhereClause) String() string

+ func (query WhereClause) Values() (values []interface{})

v0.1.2

Dec 7, 2023

v0.1.1

Jan 15, 2023

v0.1.0

Jan 15, 2023