sql

Documentation

Index

• type BaseSearch
  • func (*BaseSearch) Limit(q string) string
  • func (b *BaseSearch) Order(q string, sort ...*SortTerm) string
  • func (*BaseSearch) Where(q string, sort ...*SortTerm) string
• type Search
• type SortTerm
  • func NewSortTerm(key, value string, order int, like bool) *SortTerm

Types

type BaseSearch

type BaseSearch struct{}

BaseSearch implements Where, Order and Limit, generically for searches

func (*BaseSearch) Limit

func (*BaseSearch) Limit(q string) string

Limit returns q + "LIMIT ?,?" for paging

func (*BaseSearch) Order

func (b *BaseSearch) Order(q string, sort ...*SortTerm) string

Order returns q + "ORDER BY" the sort key and and order based on the int value

of sort.order.

func (*BaseSearch) Where

func (*BaseSearch) Where(q string, sort ...*SortTerm) string

Where adds WHERE term=value OR ... to the q string for each sort term

in the sort slice. If SortTerm.like = true, it will use a `like` clause
instead of `=`

type Search

type Search interface {
	ToQuery() string
	Where(string, ...*SortTerm) string
	Order(string, ...*SortTerm) string
	Limit(string) string
}

Search defines an interface for structs that can be used in sql queries

type SortTerm

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

SortTerm is used to define search terms as well as the ordering for

queries using that search

func NewSortTerm

func NewSortTerm(key, value string, order int, like bool) *SortTerm

NewSortTerm returns a configured SortTerm where any order value other than 0 or 1 will not be used in any queries