utils

Documentation

Index

• Constants
• Variables
• func AddLimit1(builder *strings.Builder)
• func AddPrimaryTableToBuilder(builder *strings.Builder, tableName string)
• type DBPagination
• type DbResponseCode
• type Pagination
  • func NewPagination(queryPagination QueryPagination, count int) *Pagination
• type QueryBuilder
  • func NewQueryBuilder(logicPart string, pagination DBPagination) *QueryBuilder
  • func (q *QueryBuilder) UpdateLogicPart(logicPart string)
  • func (q *QueryBuilder) WithSelected(selected string, paginationRule ruleResponsePagination) string
• type QueryPagination
  • func (p *QueryPagination) CheckValues(maxSize int)
  • func (p *QueryPagination) DB() DBPagination
• type RequestWithPagination
  • func (r *RequestWithPagination) SelectIn(responseVar interface{}) (Pagination, error)

Constants

const (
	WITH_PAGINATION ruleResponsePagination = iota
	NO_PAGINATION
)

const SELECTED_COUNT = "COUNT(*)"

Variables

var (
	ErrAlreadyExists  = errors.New("similar record already exists")
	ErrDbNotConnected = errors.New("not connected to database")
)

Functions

func AddLimit1

func AddLimit1(builder *strings.Builder)

func AddPrimaryTableToBuilder

func AddPrimaryTableToBuilder(builder *strings.Builder, tableName string)

Types

type DBPagination

type DBPagination struct {
	Offset int
	Limit  int
}

type DbResponseCode

type DbResponseCode int

type Pagination

type Pagination struct {
	Page  int
	Pages int
	Limit int
}

func NewPagination

func NewPagination(queryPagination QueryPagination, count int) *Pagination

type QueryBuilder

type QueryBuilder struct {
	// contains filtered or unexported fields
}

func NewQueryBuilder

func NewQueryBuilder(logicPart string, pagination DBPagination) *QueryBuilder

func (*QueryBuilder) UpdateLogicPart

func (q *QueryBuilder) UpdateLogicPart(logicPart string)

func (*QueryBuilder) WithSelected

func (q *QueryBuilder) WithSelected(selected string, paginationRule ruleResponsePagination) string

type QueryPagination

type QueryPagination struct {
	Page int
	Size int
}

func (*QueryPagination) CheckValues

func (p *QueryPagination) CheckValues(maxSize int)

func (*QueryPagination) DB

func (p *QueryPagination) DB() DBPagination

type RequestWithPagination

type RequestWithPagination struct {
	Db         *sqlx.DB
	LogicPart  string
	Selected   string
	Pagination QueryPagination
}

func (*RequestWithPagination) SelectIn

func (r *RequestWithPagination) SelectIn(responseVar interface{}) (Pagination, error)