searcher

searcher

ORM search wrapper.

Installation

go get -u github.com/coolstina/searcher

Feature

Statement

• Expression: Build condition statement.
• Pagination: SQL paging query substatement.

Operator

• LogicalOperator: Logical Operator.
• RelationalOperator: Relational Operator.

Example

simple conditional expression

The following example will construct a conditional expression, name = 'helloshaohua':

where := &Expression{Query: "name = ?", Args: []interface{}{"helloshaohua"}}

complex conditional expressions

Example1

	condition := searcher.StringCondition{
		Field:    "name",
		Operator: searcher.OperatorEqual,
		Value:    "helloshaohua"}
	name := searcher.NewSingleStringCondition().
		StringCondition(condition)

	condition = searcher.StringCondition{
		Field:    "age",
		Operator: searcher.OperatorGreater,
		Value:    18,
	}
	age := searcher.NewSingleStringCondition().
		StringCondition(condition).
		PreviousLogical(searcher.LogicalOperatorAND)

	condition = searcher.StringCondition{
		Field:    "sex",
		Operator: searcher.OperatorEqual,
		Value:    "male",
	}
	sex := searcher.NewSingleStringCondition().
		StringCondition(condition).
		PreviousLogical(searcher.LogicalOperatorOR).
		LogicalWrapStart(true)

	condition = searcher.StringCondition{
		Field:    "email",
		Operator: searcher.OperatorLIKE,
		Value:    "@foxmail.com",
	}
	email := searcher.NewSingleStringCondition().
		StringCondition(condition).
		PreviousLogical(searcher.LogicalOperatorAND).
		LogicalWrapFinish(true)

	expression := searcher.NewMultiStringCondition().
		AddCondition(name).
		AddCondition(age).
		AddCondition(sex).
		AddCondition(email).
		Expression()

Build the following conditional expression:

{
    "query":"name = ? AND age > ? OR ( sex = ? AND email LIKE ? )",
    "args":[
        "helloshaohua",
        18,
        "male",
        "%@foxmail.com%"
    ]
}

Example2

	condition := searcher.StringCondition{
		Field:    "name",
		Operator: searcher.OperatorEqual,
		Value:    "helloshaohua",
	}
	name := searcher.NewSingleStringCondition().
		StringCondition(condition).
		LogicalWrapStart(true)

	condition = searcher.StringCondition{
		Field:    "age",
		Operator: searcher.OperatorGreater,
		Value:    18,
	}
	age := searcher.NewSingleStringCondition().
		StringCondition(condition).
		LogicalWrapFinish(true).
		PreviousLogical(searcher.LogicalOperatorAND)

	condition = searcher.StringCondition{
		Field:    "sex",
		Operator: searcher.OperatorEqual,
		Value:    "male",
	}
	sex := searcher.NewSingleStringCondition().
		StringCondition(condition).
		PreviousLogical(searcher.LogicalOperatorOR).
		LogicalWrapStart(true)

	condition = searcher.StringCondition{
		Field:    "email",
		Operator: searcher.OperatorLIKE,
		Value:    "@foxmail.com",
	}
	email := searcher.NewSingleStringCondition().
		StringCondition(condition).
		PreviousLogical(searcher.LogicalOperatorAND).
		LogicalWrapFinish(true)

	expression := searcher.NewMultiStringCondition().
		AddCondition(name).
		AddCondition(age).
		AddCondition(sex).
		AddCondition(email).
		Expression()

Build the following conditional expression:

{
    "query":"( name = ? AND age > ? ) OR ( sex = ? AND email LIKE ? )",
    "args":[
        "helloshaohua",
        18,
        "male",
        "%@foxmail.com%"
    ]
}

Example3

	condition := searcher.StringCondition{
		Field:    "name",
		Operator: searcher.OperatorEqual,
		Value:    "helloshaohua",
	}
	name := searcher.NewSingleStringCondition().
		StringCondition(condition)

	expression := searcher.NewMultiStringCondition().
		AddCondition(name).
		Expression()

Build the following conditional expression:

{
    "query":"name = ?",
    "args":[
        "helloshaohua"
    ]
}

Example4

	condition := searcher.StringCondition{
		Field:    "name",
		Operator: searcher.OperatorEqual,
		Value:    "helloshaohua",
	}
	name := searcher.NewSingleStringCondition().
		StringCondition(condition)

	condition = searcher.StringCondition{
		Field:    "age",
		Operator: searcher.OperatorGreater,
		Value:    18,
	}
	age := searcher.NewSingleStringCondition().
		StringCondition(condition).
		PreviousLogical(searcher.LogicalOperatorAND)

	expression := searcher.NewMultiStringCondition().
		AddCondition(name).
		AddCondition(age).
		Expression()

Build the following conditional expression:

{
    "query":"name = ? AND age > ?",
    "args":[
        "helloshaohua",
        18
    ]
}

Example5

	condition := searcher.StringCondition{
		Field:    "name",
		Operator: searcher.OperatorEqual,
		Value:    "helloshaohua",
	}
	name := searcher.NewSingleStringCondition().
		StringCondition(condition)

	condition = searcher.StringCondition{
		Field:    "age",
		Operator: searcher.OperatorGreater,
		Value:    18,
	}
	age := searcher.NewSingleStringCondition().
		StringCondition(condition).
		PreviousLogical(searcher.LogicalOperatorOR)

	expression := searcher.NewMultiStringCondition().AddCondition(name).AddCondition(age).Expression()

Build the following conditional expression:

{
  "query":"name = ? OR age > ?",
  "args":[
    "helloshaohua",
    18
  ]
}

Example6

	condition := searcher.StringCondition{
		Field: "name", 
		Operator: searcher.OperatorEqual, 
		Value: "helloshaohua",
	}
	name := searcher.NewSingleStringCondition().
		StringCondition(condition)

	condition = searcher.StringCondition{
		Field: "age", 
		Operator: searcher.OperatorGreater,
		Value: 18,
	}
	age := searcher.NewSingleStringCondition().
		StringCondition(condition).
		PreviousLogical(searcher.LogicalOperatorAND)

	condition = searcher.StringCondition{
		Field: "email",
		Operator: searcher.OperatorLIKE,
		Value: "@foxmail.com",
	}
	email := searcher.NewSingleStringCondition().
		StringCondition(condition).
		PreviousLogical(searcher.LogicalOperatorOR).
		LogicalWrapStart(true).
		LogicalWrapFinish(true)

	// Build the following conditional expression {"query":"name = ? AND age > ? OR ( email LIKE ? )","args":["helloshaohua",18,"%@foxmail.com%"]}
	expression := searcher.NewMultiStringCondition().
		AddCondition(name).
		AddCondition(age).
		AddCondition(email).
		Expression()

Build the following conditional expression:

{
    "query":"name = ? AND age > ? OR ( email LIKE ? )",
    "args":[
        "helloshaohua",
        18,
        "%@foxmail.com%"
    ]
}

How to use?

It's very simple to use, just out of the box, and you can view the documentation through GoDoc.