go-simplequery-mongodb

Convert a condition query to MongoDB query syntax

Example

filter, _ := Parse(`foo < 5 AND (bar >= 10 OR baz = "example" OR qux = /[a-z]{3,5}/i)`)

generates a nested bson.M struct with the following nested structure:

{"$and":[{"foo":{"$lt":5}},{"$or":[{"$or":[{"bar":{"$gte":10}},{"baz":{"$eq":"example"}}]},{"qux":{"$eq":{"Key":"$regex","Value":{"Pattern":"[a-z]{3,5}","Options":"i"}}}}]}]}

that can be used in MongoDB's .Find(), .Aggregate(), Count(), ... functions.

Supported are the following operators:

Operator	Syntax
Parentheses	(<exp>)
Logical AND	<exp1> AND <exp2>
Logical OR	<exp1> OR <exp2>
Logical NOT	NOT <exp>
LT	<field> < <value>
LTE	<field> <= <value>
GT	<field> > <value>
GTE	<field> >= <value>
EQ (INT)	<field> = <int>
EQ (STR)	<field> = "<str>"
EQ (RGX)	<field> = /<rgx>/<opt>
NE (INT)	<field> != <int>
NE (STR)	<field> != "<str>"
NE (RGX)	<field> != /<rgx>/<opt>

more operators like EXISTS or IN are coming soon ...