dbkit

package
v0.9.5 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Oct 11, 2020 License: MIT Imports: 5 Imported by: 0

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 OrderBy added in v0.8.19

type OrderBy int

OrderBy is type of order by

const (
	// Asc for ascending
	Asc OrderBy = iota

	// Desc for descending
	Desc
)

func (OrderBy) String added in v0.8.19

func (o OrderBy) String() string

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

Jump to

Keyboard shortcuts

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