pgbuilder

package

Go to main page

Versions in this module

v1

v1.7.0

Apr 24, 2020

Changes in this version

+ type Collection struct

+ func (c *Collection) DoList(db sqlx.DBExecutor, pager *Pager, additions ...builder.Addition) error

+ func (c *Collection) Init(new func() interface{}, id func(v interface{}) interface{}, ...)

+ func (c *Collection) New() interface{}

+ func (c *Collection) Next(v interface{}) error

+ func (c *Collection) OnNext(id interface{}, receivers ...Receiver)

+ func (c *Collection) ToCondition(db sqlx.DBExecutor) builder.SqlCondition

+ type Receiver func(v interface{})

v1.6.2

Jan 13, 2020

v1.6.1

Jan 9, 2020

v1.6.0

Dec 21, 2019

Changes in this version

+ func FilterAdditions(additions builder.Additions, filter func(a builder.Addition) bool) builder.Additions

v1.5.0

Dec 19, 2019

Changes in this version

type ConditionBuilder

+ func AllOf(builders ...ConditionBuilder) ConditionBuilder

+ func ConditionBuilderBy(build func(db sqlx.DBExecutor) builder.SqlCondition) ConditionBuilder

+ func OneOf(builders ...ConditionBuilder) ConditionBuilder

+ func SubSelect(target *builder.Column, subConditionBuilder SubConditionBuilder) ConditionBuilder

+ type SubConditionBuilder interface

+ SelectFrom func(db sqlx.DBExecutor) *StmtSelect

v1.4.2

Dec 17, 2019

v1.4.1

Dec 17, 2019

v1.4.0

Dec 17, 2019

v1.3.1

Dec 11, 2019

v1.3.0

Dec 10, 2019

Changes in this version

type StmtUpdate

+ func (s StmtUpdate) From(from builder.Model) *StmtUpdate

v1.2.0

Dec 10, 2019

v1.1.0

Dec 10, 2019

Changes in this version

+ type ModalAndWithQuery interface

+ WithQuery func(db sqlx.DBExecutor) builder.SqlExpr

+ func AsWithQuery(model builder.Model, withQueryFn func(db sqlx.DBExecutor) builder.SqlExpr) ModalAndWithQuery

+ func AsWithRecursiveQuery(model builder.Model, withQueryFn func(db sqlx.DBExecutor) builder.SqlExpr) ModalAndWithQuery

type Stmt

+ func (s *Stmt) ExprBy(do func(ctx context.Context) *builder.Ex) builder.SqlExpr

+ type WithRecursive interface

v1.0.5

Dec 7, 2019

v1.0.4

Dec 5, 2019

v1.0.3

Dec 5, 2019

v1.0.2

Dec 5, 2019

Changes in this version

+ const PrimaryKey

+ func BatchDoList(db sqlx.DBExecutor, scanners ...DataList) (err error)

+ func ContextWithIgnoreDeletedAt(ctx context.Context) context.Context

+ func Excluded(f *builder.Column) builder.SqlExpr

+ func ExcludedFields(fields ...*builder.Column) builder.Assignments

+ func ToCondition(db sqlx.DBExecutor, b ConditionBuilder) builder.SqlCondition

+ type BuildSubExpr func(s *Stmt, model builder.Model) builder.SqlExpr

+ type ConditionBuilder interface

+ ToCondition func(db sqlx.DBExecutor) builder.SqlCondition

+ func ConditionBuilderFromCondition(c builder.SqlCondition) ConditionBuilder

+ type CouldScan interface

+ Scan func(v interface{}) error

+ type Counter interface

+ SetCount func(i int)

+ type DataList interface

+ DoList func(db sqlx.DBExecutor, conditionBuilder ConditionBuilder, pager *Pager, ...) error

+ type ModelWithCreatedAt interface

+ FieldCreatedAt func() *builder.Column

+ type ModelWithDeletedAt interface

+ FieldDeletedAt func() *builder.Column

+ type ModelWithPrimaryKey interface

+ PrimaryKey func() []string

+ type ModelWithUniqueIndexes interface

+ UniqueIndexes func() builder.Indexes

+ type ModelWithUpdatedAt interface

+ FieldUpdatedAt func() *builder.Column

+ type Pager struct

+ Offset int64

+ Size int64

+ type RecordCollection struct

+ Columns *builder.Columns

+ func RecordCollectionBy(collect func(rc *RecordCollection), columns ...*builder.Column) *RecordCollection

+ func RecordCollectionFrom(db sqlx.DBExecutor, model builder.Model, ...) *RecordCollection

+ func RecordCollectionWith(recordValues RecordValues, columns ...*builder.Column) *RecordCollection

+ func (vc *RecordCollection) AsAssignments() builder.Assignments

+ func (vc *RecordCollection) IsNil() bool

+ func (vc *RecordCollection) SetRecordValues(values ...interface{})

+ func (vc *RecordCollection) Values() []interface{}

+ func (vc RecordCollection) WithExtendCol(col *builder.Column, val interface{}) *RecordCollection

+ type RecordValues []interface

+ type Stmt struct

+ func Use(db sqlx.DBExecutor) *Stmt

+ func (s *Stmt) Delete(model builder.Model) *StmtDelete

+ func (s *Stmt) Insert() *StmtInsert

+ func (s *Stmt) ReturningOf(expr builder.SqlExpr, target builder.SqlExpr) CouldScan

+ func (s *Stmt) Select(target builder.SqlExpr) *StmtSelect

+ func (s *Stmt) T(model builder.Model) *builder.Table

+ func (s *Stmt) Update(model builder.Model, modifiers ...string) *StmtUpdate

+ func (s *Stmt) With(model builder.Model, build BuildSubExpr) *StmtWith

+ func (s *Stmt) WithRecursive(model builder.Model, build BuildSubExpr) *StmtWith

+ type StmtDelete struct

+ func (s *StmtDelete) Do() error

+ func (s *StmtDelete) Ex(ctx context.Context) *builder.Ex

+ func (s *StmtDelete) IsNil() bool

+ func (s *StmtDelete) Returning(target builder.SqlExpr) CouldScan

+ func (s StmtDelete) From(model builder.Model) *StmtDelete

+ func (s StmtDelete) Where(where builder.SqlCondition) *StmtDelete

+ type StmtInsert struct

+ func (s *StmtInsert) Do() error

+ func (s *StmtInsert) Ex(ctx context.Context) *builder.Ex

+ func (s *StmtInsert) IsNil() bool

+ func (s *StmtInsert) Returning(target builder.SqlExpr) CouldScan

+ func (s StmtInsert) Into(model builder.Model, additions ...builder.Addition) *StmtInsert

+ func (s StmtInsert) OnConflictDoNothing(indexKey string) *StmtInsert

+ func (s StmtInsert) OnConflictDoUpdateSet(indexKey string, excludedColumns ...*builder.Column) *StmtInsert

+ func (s StmtInsert) ValuesBy(collect func(vc *RecordCollection), columns ...*builder.Column) *StmtInsert

+ func (s StmtInsert) ValuesFrom(model builder.Model, columnsCouldBeZeroValue ...*builder.Column) *StmtInsert

+ func (s StmtInsert) ValuesWith(recordValues RecordValues, columns ...*builder.Column) *StmtInsert

+ type StmtSelect struct

+ func (s *StmtSelect) CrossJoin(target builder.Model) *StmtSelect

+ func (s *StmtSelect) Ex(ctx context.Context) *builder.Ex

+ func (s *StmtSelect) FullJoin(target builder.Model, joinCondition builder.SqlCondition) *StmtSelect

+ func (s *StmtSelect) IsNil() bool

+ func (s *StmtSelect) Join(target builder.Model, joinCondition builder.SqlCondition) *StmtSelect

+ func (s *StmtSelect) LeftJoin(target builder.Model, joinCondition builder.SqlCondition) *StmtSelect

+ func (s *StmtSelect) List(list sqlx.ScanIterator, pager *Pager) error

+ func (s *StmtSelect) RightJoin(target builder.Model, joinCondition builder.SqlCondition) *StmtSelect

+ func (s *StmtSelect) Scan(v interface{}) error

+ func (s StmtSelect) From(model builder.Model) *StmtSelect

+ func (s StmtSelect) Select(target builder.SqlExpr) *StmtSelect

+ func (s StmtSelect) Where(where builder.SqlCondition, additions ...builder.Addition) *StmtSelect

+ type StmtUpdate struct

+ func (s *StmtUpdate) Do() error

+ func (s *StmtUpdate) Ex(ctx context.Context) *builder.Ex

+ func (s *StmtUpdate) IsNil() bool

+ func (s *StmtUpdate) Returning(target builder.SqlExpr) CouldScan

+ func (s StmtUpdate) SetBy(collect func(vc *RecordCollection), columns ...*builder.Column) *StmtUpdate

+ func (s StmtUpdate) SetFrom(model builder.Model, columnsCouldBeZeroValue ...*builder.Column) *StmtUpdate

+ func (s StmtUpdate) SetWith(recordValues RecordValues, columns ...*builder.Column) *StmtUpdate

+ func (s StmtUpdate) Where(where builder.SqlCondition) *StmtUpdate

+ type StmtWith struct

+ func (s *StmtWith) Do() error

+ func (s *StmtWith) Ex(ctx context.Context) *builder.Ex

+ func (s *StmtWith) IsNil() bool

+ func (s *StmtWith) Scan(v interface{}) error

+ func (s StmtWith) Exec(statement func(stmt *Stmt, model ...builder.Model) builder.SqlExpr) *StmtWith

+ func (s StmtWith) With(model builder.Model, build BuildSubExpr) *StmtWith

+ type WithCountExpr interface

+ CountExpr func(db sqlx.DBExecutor) builder.SqlExpr

+ type WithTotal struct

+ Total int

+ func (c *WithTotal) SetCount(i int)

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