test-query.txt

===[ Test #1 ]==============================================
Query:       select max(name), num, color where ((name=0 and color="Bright Blue") or num=5) orderby name asc, color desc, num

hasSelect:   true / ["max(name)","num","color"]
hasWhere:    true / ["((",["name","=","0"],"and",["color","=","\"Bright Blue\""],")","or",["num","=","5"],")"]
hasOrderBy:  true / [["name","asc"],["color","desc"],"num"]

Parsed query structure:
{
     "Select": [
          "max(name)",
          "num",
          "color"
     ],
     "Where": [
          "((",
          [
               "name",
               "=",
               "0"
          ],
          "and",
          [
               "color",
               "=",
               "\"Bright Blue\""
          ],
          ")",
          "or",
          [
               "num",
               "=",
               "5"
          ],
          ")"
     ],
     "OrderBy": [
          [
               "name",
               "asc"
          ],
          [
               "color",
               "desc"
          ],
          "num"
     ]
}
===[ Test #1 Results ]======================================
Parsing test, No results expected

===[ Test #2 ]==============================================
Query:       select name, color where (name=/frank/i and color=/green/i) orderby name, num

hasSelect:   true / ["name","color"]
hasWhere:    true / ["(",["name","=","/frank/i"],"and",["color","=","/green/i"],")"]
hasOrderBy:  true / ["name","num"]

Parsed query structure:
{
     "Select": [
          "name",
          "color"
     ],
     "Where": [
          "(",
          [
               "name",
               "=",
               "/frank/i"
          ],
          "and",
          [
               "color",
               "=",
               "/green/i"
          ],
          ")"
     ],
     "OrderBy": [
          "name",
          "num"
     ]
}
===[ Test #2 Results ]======================================
[ { name: 'Frank', color: 'green' } ]

===[ Test #3 ]==============================================
Query:       where (color=/green/i or num=20) orderby name, num

hasSelect:   false / []
hasWhere:    true / ["(",["color","=","/green/i"],"or",["num","=","20"],")"]
hasOrderBy:  true / ["name","num"]

Parsed query structure:
{
     "Select": [],
     "Where": [
          "(",
          [
               "color",
               "=",
               "/green/i"
          ],
          "or",
          [
               "num",
               "=",
               "20"
          ],
          ")"
     ],
     "OrderBy": [
          "name",
          "num"
     ]
}
===[ Test #3 Results ]======================================
[ { name: 'Sandy', color: 'green', num: 0 },
  { name: 'Molly', color: 'green', num: 50 },
  { name: 'frank', color: 'yellow', num: 20 },
  { name: 'Frank', color: 'green', num: 0.2 } ]

===[ Test #4 ]==============================================
Query:       where (num=null) orderby name, num

hasSelect:   false / []
hasWhere:    true / ["(",["num","=","null"],")"]
hasOrderBy:  true / ["name","num"]

Parsed query structure:
{
     "Select": [],
     "Where": [
          "(",
          [
               "num",
               "=",
               "null"
          ],
          ")"
     ],
     "OrderBy": [
          "name",
          "num"
     ]
}
===[ Test #4 Results ]======================================
[ { name: 'sisko', series: 'DS9' },
  { name: 'Quark', series: 'DS9' },
  { name: 'Q', series: 'TNG' },
  { name: 'Garak', series: 'DS9' },
  { name: 'Alice', color: 'blue' } ]

===[ Test #5 ]==============================================
Query:       where (color=/bright\sblue/i) orderby name, num

hasSelect:   false / []
hasWhere:    true / ["(",["color","=","/bright\\sblue/i"],")"]
hasOrderBy:  true / ["name","num"]

Parsed query structure:
{
     "Select": [],
     "Where": [
          "(",
          [
               "color",
               "=",
               "/bright\\sblue/i"
          ],
          ")"
     ],
     "OrderBy": [
          "name",
          "num"
     ]
}
===[ Test #5 Results ]======================================
[ { name: 'Frank', color: 'bright blue', num: 70 },
  { name: 'Angie', color: 'bright blue', num: 300 } ]

===[ Test #6 ]==============================================
Query:       where (color="bright blue") orderby name, num

hasSelect:   false / []
hasWhere:    true / ["(",["color","=","\"bright blue\""],")"]
hasOrderBy:  true / ["name","num"]

Parsed query structure:
{
     "Select": [],
     "Where": [
          "(",
          [
               "color",
               "=",
               "\"bright blue\""
          ],
          ")"
     ],
     "OrderBy": [
          "name",
          "num"
     ]
}
===[ Test #6 Results ]======================================
[ { name: 'Frank', color: 'bright blue', num: 70 },
  { name: 'Angie', color: 'bright blue', num: 300 } ]

===[ Test #7 ]==============================================
Query:       select name, num where (name=/^f/i) orderby name, num

hasSelect:   true / ["name","num"]
hasWhere:    true / ["(",["name","=","/^f/i"],")"]
hasOrderBy:  true / ["name","num"]

Parsed query structure:
{
     "Select": [
          "name",
          "num"
     ],
     "Where": [
          "(",
          [
               "name",
               "=",
               "/^f/i"
          ],
          ")"
     ],
     "OrderBy": [
          "name",
          "num"
     ]
}
===[ Test #7 Results ]======================================
[ { name: 'Frank', num: 70 },
  { name: 'frank', num: 20 },
  { name: 'fraNK', num: 8 },
  { name: 'Frank', num: 0.2 } ]

===[ Test #8 ]==============================================
Query:       where (name!=/^f/i) orderby name, num

hasSelect:   false / []
hasWhere:    true / ["(",["name","!=","/^f/i"],")"]
hasOrderBy:  true / ["name","num"]

Parsed query structure:
{
     "Select": [],
     "Where": [
          "(",
          [
               "name",
               "!=",
               "/^f/i"
          ],
          ")"
     ],
     "OrderBy": [
          "name",
          "num"
     ]
}
===[ Test #8 Results ]======================================
[ { name: 'steve', color: 'yellow', num: 0 },
  { name: 'sisko', series: 'DS9' },
  { name: 'Sandy', color: 'green', num: 0 },
  { name: 'Quark', series: 'DS9' },
  { name: 'Q', series: 'TNG' },
  { name: 'Molly', color: 'green', num: 50 },
  { name: 'Matthew', color: 'red', num: 90 },
  { name: 'Grace', color: 'blue', num: 300 },
  { name: 'Garak', series: 'DS9' },
  { name: 'Angie', color: 'bright blue', num: 300 },
  { name: 'Alice', color: 'blue' },
  { name: 'alex', color: 'blue', num: 0.1 } ]

===[ Test #9 ]==============================================
Query:       select name, series where (series="DS9" or series="TNG") orderby series

hasSelect:   true / ["name","series"]
hasWhere:    true / ["(",["series","=","\"DS9\""],"or",["series","=","\"TNG\""],")"]
hasOrderBy:  true / ["series"]

Parsed query structure:
{
     "Select": [
          "name",
          "series"
     ],
     "Where": [
          "(",
          [
               "series",
               "=",
               "\"DS9\""
          ],
          "or",
          [
               "series",
               "=",
               "\"TNG\""
          ],
          ")"
     ],
     "OrderBy": [
          "series"
     ]
}
===[ Test #9 Results ]======================================
[ { name: 'Q', series: 'TNG' },
  { name: 'Garak', series: 'DS9' },
  { name: 'Quark', series: 'DS9' },
  { name: 'sisko', series: 'DS9' } ]

===[ Test #10 ]==============================================
Query:       select name, color where (num=null or num=0) orderby name asc

hasSelect:   true / ["name","color"]
hasWhere:    true / ["(",["num","=","null"],"or",["num","=","0"],")"]
hasOrderBy:  true / [["name","asc"]]

Parsed query structure:
{
     "Select": [
          "name",
          "color"
     ],
     "Where": [
          "(",
          [
               "num",
               "=",
               "null"
          ],
          "or",
          [
               "num",
               "=",
               "0"
          ],
          ")"
     ],
     "OrderBy": [
          [
               "name",
               "asc"
          ]
     ]
}
===[ Test #10 Results ]======================================
[ { name: 'Alice', color: 'blue' },
  { name: 'Garak' },
  { name: 'Q' },
  { name: 'Quark' },
  { name: 'Sandy', color: 'green' },
  { name: 'sisko' },
  { name: 'steve', color: 'yellow' } ]