query

README

Query

Query is an adaptor of http query to expressions. Check adapters to convert it to sql or other expressions.

go get github.com/worldline-go/query

Usage

Parse url and extract query parameters with RAW, give to query.Parse to convert it to expression.
Use an adapter to convert it to sql or other expressions.

urlStr := "http://example.com?name=foo,bar|nick=bar&age[lt]=1&sort=-age&limit=10&offset=5&fields=id,name"
parsedURL, err := url.Parse(urlStr)
// ...
query, err := query.Parse(parsedURL.RawQuery)
// ...
sql, params, err := adaptergoqu.Select(query, goqu.From("test")).ToSQL()
// ...

// SQL: SELECT "id", "name" FROM "test" WHERE ((("name" IN ('foo', 'bar')) OR ("nick" = 'bar')) AND ("age" < '1')) ORDER BY "age" DESC LIMIT 10 OFFSET 5
// Params: []

If some value separated by , it will be converted to IN operator.
There are a list of [ ] operators that can be used in the query string:
eq, ne, gt, lt, gte, lte, like, ilike, nlike, nilike, in, nin, is, not

Validation

validator := query.NewValidator(
    WithValue("member", WithRequired()),
)

// after that use it to validate
err := validator.Validate(query)
if err != nil {
    // handle error
}

Documentation

Index

• func WithIn(values ...string) optionValidateFunc
• func WithMax(max json.Number) optionValidateFunc
• func WithMin(min json.Number) optionValidateFunc
• func WithNotEmpty() optionValidateFunc
• func WithNotIn(values ...string) optionValidateFunc
• func WithRequired() optionValidateFunc
• type Expression
• type ExpressionCmp
  • func (e ExpressionCmp) Expression() Expression
• type ExpressionLogic
  • func (e ExpressionLogic) Expression() Expression
• type ExpressionOrder
• type OperatorCmpType
• type OperatorLogicType
• type OptionValidate
• type OptionValidateSet
  • func WithField(key string, opts ...optionValidateFunc) OptionValidateSet
  • func WithValue(key string, opts ...optionValidateFunc) OptionValidateSet
• type Query
  • func Parse(query string) (*Query, error)
  • func (q *Query) Validate(v *Validator) error
  • func (q *Query) Walk(fn func(Token) error) error
• type Token
• type Validator
  • func NewValidator(opts ...OptionValidateSet) (*Validator, error)
• type WalkType

Functions

func WithIn

func WithIn(values ...string) optionValidateFunc

func WithMax

func WithMax(max json.Number) optionValidateFunc

func WithMin

func WithMin(min json.Number) optionValidateFunc

func WithNotEmpty

func WithNotEmpty() optionValidateFunc

func WithNotIn

func WithNotIn(values ...string) optionValidateFunc

func WithRequired

func WithRequired() optionValidateFunc

Types

type Expression

type Expression interface {
	Expression() Expression
}

type ExpressionCmp

type ExpressionCmp struct {
	Operator OperatorCmpType
	Field    string
	Value    any
}

func (ExpressionCmp) Expression

func (e ExpressionCmp) Expression() Expression

type ExpressionLogic

type ExpressionLogic struct {
	Operator OperatorLogicType
	List     []Expression
}

func (ExpressionLogic) Expression

func (e ExpressionLogic) Expression() Expression

type ExpressionOrder

type ExpressionOrder struct {
	// Field is the field name to order by.
	Field string
	// Desc indicates whether the order is descending.
	Desc bool
}

type OperatorCmpType

type OperatorCmpType string

const (
	// OperatorEq is the equality operator.
	OperatorEq OperatorCmpType = "eq"
	// OperatorNe is the not equal operator.
	OperatorNe OperatorCmpType = "ne"
	// OperatorGt is the greater than operator.
	OperatorGt OperatorCmpType = "gt"
	// OperatorLt is the less than operator.
	OperatorLt OperatorCmpType = "lt"
	// OperatorGte is the greater than or equal operator.
	OperatorGte OperatorCmpType = "gte"
	// OperatorLte is the less than or equal operator.
	OperatorLte OperatorCmpType = "lte"
	// OperatorLike is the like operator.
	OperatorLike OperatorCmpType = "like"
	// OperatorILike is the case insensitive like operator.
	OperatorILike OperatorCmpType = "ilike"
	// OperatorNLike is the not like operator.
	OperatorNLike OperatorCmpType = "nlike"
	// OperatorNILike is the case insensitive not like operator.
	OperatorNILike OperatorCmpType = "nilike"
	// OperatorIn is the in operator.
	OperatorIn OperatorCmpType = "in"
	// OperatorNIn is the not in operator.
	OperatorNIn OperatorCmpType = "nin"
	// OperatorIs is the is null operator.
	OperatorIs OperatorCmpType = "is"
	// OperatorIsNot is the is not null operator.
	OperatorIsNot OperatorCmpType = "not"
)

type OperatorLogicType

type OperatorLogicType string

const (
	// OperatorAnd is the AND operator.
	OperatorAnd OperatorLogicType = "and"
	// OperatorOr is the OR operator.
	OperatorOr OperatorLogicType = "or"
)

type OptionValidate

type OptionValidate func(string, ...optionValidateFunc)

type OptionValidateSet

type OptionValidateSet func(v *Validator) error

func WithField

func WithField(key string, opts ...optionValidateFunc) OptionValidateSet

func WithValue

func WithValue(key string, opts ...optionValidateFunc) OptionValidateSet

type Query

type Query struct {
	Values map[string][]ExpressionCmp

	Select []any
	Where  []Expression
	Order  []ExpressionOrder
	Offset *uint64
	Limit  *uint64
}

func Parse

func Parse(query string) (*Query, error)

Parse parses a query string into a Query struct.

func (*Query) Validate

func (q *Query) Validate(v *Validator) error

func (*Query) Walk

func (q *Query) Walk(fn func(Token) error) error

Walk traverses the query tree and calls the provided function for each expression.

type Token

type Token struct {
	Expression Expression
	Type       WalkType
}

type Validator

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

func NewValidator

func NewValidator(opts ...OptionValidateSet) (*Validator, error)

type WalkType

type WalkType int

const (
	WalkCurrent WalkType = iota
	WalkStart
	WalkEnd
)