Home Original page

moz-sql-parser/tests at dev · mozilla/moz-sql-parser

This repository was archived by the owner on Jun 11, 2021. It is now read-only.

Latest commit

The test suite has over 400 tests.

Running Tests

For Linux:

git clone https://github.com/mozilla/moz-sql-parser.git
cd moz-sql-parser
pip install -r requirements.txt
set PYTHONPATH=.	
python -m unittest discover tests

For Windows:

git clone https://github.com/mozilla/moz-sql-parser.git
cd moz-sql-parser
pip install -r requirements.txt
set PYTHONPATH=.	
python.exe -m unittest discover tests

Debugging Suggestions

  • Once you have written a failing test, you can DEBUG=True in the sql_parser.py to print out a trace of matching attempts.
  • If you added more ParserElements, you may want to add .setDebugActions(*debug) to each, so they print out thier matching attempts too.
  • Even though you can use Python strings for literals, they will not be attempted in all cases; wrap as a Literal or Keyword. This problem is known to lurk while matching infixNotation.
  • Feel free to leave in rulers, if you use them

History

  • January 2018 - fixes for Python3
  • July 2017 - Add suite to start testing error messages, with hope of improving them
  • April 2017 - All tests pass
  • March 2017 - Added a number of test cases, most of which are missing the expected JSON parse tree, so they fail.