sqlbuilder

Documentation

Index

• Variables
• func ConvertValueToSQLParameter(value interface{}) query.SQLParameter
• func GenPlaceholders(n int) string
• type OrderPolicy
• type SQLBuilder
  • func NewSQLBuilder() *SQLBuilder
  • func (sb *SQLBuilder) GetQueryParams() []query.SQLParameter
  • func (sb *SQLBuilder) GetQuerySQL() (string, error)
  • func (sb *SQLBuilder) GroupBy(fields ...string) *SQLBuilder
  • func (sb *SQLBuilder) Having(field string, condition string, value interface{}) *SQLBuilder
  • func (sb *SQLBuilder) HavingRaw(s string, values ...interface{}) *SQLBuilder
  • func (sb *SQLBuilder) JoinRaw(join string, values ...interface{}) *SQLBuilder
  • func (sb *SQLBuilder) Limit(offset, num int) *SQLBuilder
  • func (sb *SQLBuilder) OrHaving(field string, condition string, value interface{}) *SQLBuilder
  • func (sb *SQLBuilder) OrHavingRaw(s string, values ...interface{}) *SQLBuilder
  • func (sb *SQLBuilder) OrWhere(field string, condition string, value interface{}) *SQLBuilder
  • func (sb *SQLBuilder) OrWhereIn(field string, values ...interface{}) *SQLBuilder
  • func (sb *SQLBuilder) OrWhereMvContains(field string, values ...interface{}) *SQLBuilder
  • func (sb *SQLBuilder) OrWhereMvOverlap(field string, values ...interface{}) *SQLBuilder
  • func (sb *SQLBuilder) OrWhereNotIn(field string, values ...interface{}) *SQLBuilder
  • func (sb *SQLBuilder) OrWhereRaw(s string, values ...interface{}) *SQLBuilder
  • func (sb *SQLBuilder) OrderBy(orderPolicys ...OrderPolicy) *SQLBuilder
  • func (sb *SQLBuilder) Select(cols ...string) *SQLBuilder
  • func (sb *SQLBuilder) Table(table string) *SQLBuilder
  • func (sb *SQLBuilder) Where(field string, condition string, value interface{}) *SQLBuilder
  • func (sb *SQLBuilder) WhereIn(field string, values ...interface{}) *SQLBuilder
  • func (sb *SQLBuilder) WhereMvContains(field string, values ...interface{}) *SQLBuilder
  • func (sb *SQLBuilder) WhereMvOverlap(field string, values ...interface{}) *SQLBuilder
  • func (sb *SQLBuilder) WhereNotIn(field string, values ...interface{}) *SQLBuilder
  • func (sb *SQLBuilder) WhereRaw(s string, values ...interface{}) *SQLBuilder

Variables

var (
	// ErrTableEmpty table not set
	ErrTableEmpty = errors.New("table empty")
)

Functions

func ConvertValueToSQLParameter

func ConvertValueToSQLParameter(value interface{}) query.SQLParameter

func GenPlaceholders

func GenPlaceholders(n int) string

GenPlaceholders generate placeholders

Types

type OrderPolicy

type OrderPolicy struct {
	Field     string
	Direction string
}

type SQLBuilder

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

SQLBuilder sql builder

func NewSQLBuilder

func NewSQLBuilder() *SQLBuilder

NewSQLBuilder init sql builder

func (*SQLBuilder) GetQueryParams

func (sb *SQLBuilder) GetQueryParams() []query.SQLParameter

GetQueryParams get params

func (*SQLBuilder) GetQuerySQL

func (sb *SQLBuilder) GetQuerySQL() (string, error)

GetQuerySQL get sql

func (*SQLBuilder) GroupBy

func (sb *SQLBuilder) GroupBy(fields ...string) *SQLBuilder

GroupBy set group by fields

func (*SQLBuilder) Having

func (sb *SQLBuilder) Having(field string, condition string, value interface{}) *SQLBuilder

Having set having cond

func (*SQLBuilder) HavingRaw

func (sb *SQLBuilder) HavingRaw(s string, values ...interface{}) *SQLBuilder

HavingRaw set having raw string

func (*SQLBuilder) JoinRaw

func (sb *SQLBuilder) JoinRaw(join string, values ...interface{}) *SQLBuilder

JoinRaw join with raw sql

func (*SQLBuilder) Limit

func (sb *SQLBuilder) Limit(offset, num int) *SQLBuilder

Limit set limit

func (*SQLBuilder) OrHaving

func (sb *SQLBuilder) OrHaving(field string, condition string, value interface{}) *SQLBuilder

OrHaving set or having cond

func (*SQLBuilder) OrHavingRaw

func (sb *SQLBuilder) OrHavingRaw(s string, values ...interface{}) *SQLBuilder

OrHavingRaw set having raw string

func (*SQLBuilder) OrWhere

func (sb *SQLBuilder) OrWhere(field string, condition string, value interface{}) *SQLBuilder

OrWhere set or where cond

func (*SQLBuilder) OrWhereIn

func (sb *SQLBuilder) OrWhereIn(field string, values ...interface{}) *SQLBuilder

OrWhereIn set or where in cond

func (*SQLBuilder) OrWhereMvContains

func (sb *SQLBuilder) OrWhereMvContains(field string, values ...interface{}) *SQLBuilder

OrWhereMvContains set or where in cond

func (*SQLBuilder) OrWhereMvOverlap

func (sb *SQLBuilder) OrWhereMvOverlap(field string, values ...interface{}) *SQLBuilder

OrWhereMvOverlap set or where in cond

func (*SQLBuilder) OrWhereNotIn

func (sb *SQLBuilder) OrWhereNotIn(field string, values ...interface{}) *SQLBuilder

OrWhereNotIn set or where not in cond

func (*SQLBuilder) OrWhereRaw

func (sb *SQLBuilder) OrWhereRaw(s string, values ...interface{}) *SQLBuilder

OrWhereRaw set where raw string

func (*SQLBuilder) OrderBy

func (sb *SQLBuilder) OrderBy(orderPolicys ...OrderPolicy) *SQLBuilder

OrderBy set order by fields

func (*SQLBuilder) Select

func (sb *SQLBuilder) Select(cols ...string) *SQLBuilder

Select set select cols

func (*SQLBuilder) Table

func (sb *SQLBuilder) Table(table string) *SQLBuilder

Table set table

func (*SQLBuilder) Where

func (sb *SQLBuilder) Where(field string, condition string, value interface{}) *SQLBuilder

Where set where cond

func (*SQLBuilder) WhereIn

func (sb *SQLBuilder) WhereIn(field string, values ...interface{}) *SQLBuilder

WhereIn set where in cond

func (*SQLBuilder) WhereMvContains

func (sb *SQLBuilder) WhereMvContains(field string, values ...interface{}) *SQLBuilder

WhereMvContains set where in cond

func (*SQLBuilder) WhereMvOverlap

func (sb *SQLBuilder) WhereMvOverlap(field string, values ...interface{}) *SQLBuilder

WhereMvOverlap set where in cond

func (*SQLBuilder) WhereNotIn

func (sb *SQLBuilder) WhereNotIn(field string, values ...interface{}) *SQLBuilder

WhereNotIn set where not in cond

func (*SQLBuilder) WhereRaw

func (sb *SQLBuilder) WhereRaw(s string, values ...interface{}) *SQLBuilder

WhereRaw set where raw string