Documentation ¶
Index ¶
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type BetweenOption ¶ added in v0.9.5
type BetweenOption struct {
// contains filtered or unexported fields
}
BetweenOption is a placeholder for value used in a BETWEEN clause
func Between ¶ added in v0.9.5
func Between(column string, minValue, maxValue interface{}) *BetweenOption
Between creates a new BetweenOption condition
func (*BetweenOption) CompileDelete ¶ added in v0.9.5
func (f *BetweenOption) CompileDelete(base sq.DeleteBuilder) (sq.DeleteBuilder, error)
CompileDelete compile delete query for filtering
func (*BetweenOption) CompileSelect ¶ added in v0.9.5
func (f *BetweenOption) CompileSelect(base sq.SelectBuilder) (sq.SelectBuilder, error)
CompileSelect compile select query for filtering
func (*BetweenOption) CompileUpdate ¶ added in v0.9.5
func (f *BetweenOption) CompileUpdate(base sq.UpdateBuilder) (sq.UpdateBuilder, error)
CompileUpdate compile update query for filtering
type CompileDeleteFn ¶ added in v0.8.32
type CompileDeleteFn func(sq.DeleteBuilder) (sq.DeleteBuilder, error)
CompileDeleteFn function
type CompileSelectFn ¶ added in v0.8.32
type CompileSelectFn func(sq.SelectBuilder) (sq.SelectBuilder, error)
CompileSelectFn function
type CompileUpdateFn ¶ added in v0.8.32
type CompileUpdateFn func(sq.UpdateBuilder) (sq.UpdateBuilder, error)
CompileUpdateFn function
type DeleteOption ¶ added in v0.8.31
type DeleteOption interface {
CompileDelete(sq.DeleteBuilder) (sq.DeleteBuilder, error)
}
DeleteOption to compile delete query
func NewDeleteOption ¶ added in v0.8.32
func NewDeleteOption(fn CompileDeleteFn) DeleteOption
NewDeleteOption return new instance of DeleteOption
type DeleteTestCase ¶ added in v0.8.32
type DeleteTestCase struct { TestName string DeleteOption Builder sq.DeleteBuilder ExpectedErr string Expected string ExpectedArgs []interface{} }
DeleteTestCase for testing purpose
func (*DeleteTestCase) Execute ¶ added in v0.8.32
func (tt *DeleteTestCase) Execute(t *testing.T)
Execute test
type EqualOption ¶ added in v0.8.31
type EqualOption struct {
// contains filtered or unexported fields
}
EqualOption for where condition
func Equal ¶ added in v0.8.19
func Equal(column string, expectation interface{}) *EqualOption
Equal where condition
func (*EqualOption) CompileDelete ¶ added in v0.8.31
func (f *EqualOption) CompileDelete(base sq.DeleteBuilder) (sq.DeleteBuilder, error)
CompileDelete to compile delete query for filtering
func (*EqualOption) CompileSelect ¶ added in v0.8.31
func (f *EqualOption) CompileSelect(base sq.SelectBuilder) (sq.SelectBuilder, error)
CompileSelect to compile select query for filtering
func (*EqualOption) CompileUpdate ¶ added in v0.8.31
func (f *EqualOption) CompileUpdate(base sq.UpdateBuilder) (sq.UpdateBuilder, error)
CompileUpdate to compile update query for filtering
type LikeOption ¶ added in v0.8.31
type LikeOption struct {
// contains filtered or unexported fields
}
LikeOption for where condition
func Like ¶ added in v0.8.19
func Like(column string, expectation interface{}) *LikeOption
Like where condition
func (*LikeOption) CompileSelect ¶ added in v0.8.31
func (l *LikeOption) CompileSelect(base sq.SelectBuilder) (sq.SelectBuilder, error)
CompileSelect for like
type PaginationOption ¶ added in v0.8.31
type PaginationOption struct {
// contains filtered or unexported fields
}
PaginationOption param
func Pagination ¶ added in v0.8.19
func Pagination(offset, limit uint64) *PaginationOption
Pagination find option
func PaginationWithRange ¶ added in v0.8.19
func PaginationWithRange(start, end uint64) *PaginationOption
PaginationWithRange to setup pagination with start and end index
func (*PaginationOption) CompileSelect ¶ added in v0.8.31
func (p *PaginationOption) CompileSelect(base sq.SelectBuilder) (sq.SelectBuilder, error)
CompileSelect to compile select query for pagination
type SelectOption ¶ added in v0.8.31
type SelectOption interface {
CompileSelect(sq.SelectBuilder) (sq.SelectBuilder, error)
}
SelectOption to compile select query
func NewSelectOption ¶ added in v0.8.32
func NewSelectOption(fn CompileSelectFn) SelectOption
NewSelectOption return new instance of SelectOption
type SelectTestCase ¶ added in v0.8.32
type SelectTestCase struct { TestName string SelectOption Builder sq.SelectBuilder ExpectedErr string Expected string ExpectedArgs []interface{} }
SelectTestCase for testing puspose
func (*SelectTestCase) Execute ¶ added in v0.8.32
func (tt *SelectTestCase) Execute(t *testing.T)
Execute test
type SortOption ¶ added in v0.8.31
type SortOption struct {
// contains filtered or unexported fields
}
SortOption for select
func Sort ¶ added in v0.8.19
func Sort(column string, orderBy OrderBy) *SortOption
Sort is find option to sort by column and order
func (*SortOption) CompileSelect ¶ added in v0.8.31
func (s *SortOption) CompileSelect(base sq.SelectBuilder) (sq.SelectBuilder, error)
CompileSelect to compile select query for sorting
type UpdateOption ¶ added in v0.8.31
type UpdateOption interface {
CompileUpdate(sq.UpdateBuilder) (sq.UpdateBuilder, error)
}
UpdateOption to compile update query
func NewUpdateOption ¶ added in v0.8.32
func NewUpdateOption(fn CompileUpdateFn) UpdateOption
NewUpdateOption return new instance of UpdateOption
type UpdateTestCase ¶ added in v0.8.32
type UpdateTestCase struct { TestName string UpdateOption Builder sq.UpdateBuilder ExpectedErr string Expected string ExpectedArgs []interface{} }
UpdateTestCase to test the update
func (*UpdateTestCase) Execute ¶ added in v0.8.32
func (tt *UpdateTestCase) Execute(t *testing.T)
Execute test