dj-test-queries 0.1.1

Extension of assertNumQueries that can record queries that were executed and show the differences in future runs.[

Extension of assertNumQueries that can record queries that were executed and show the differences in future runs.

Documentation

The full documentation is at https://dj-test-queries.readthedocs.io.

Quickstart

Install django-debug-toolbar dependency to your project:

pip install django-debug-toolbar

Apply NumQueriesMixin to your test and use assertNumQueries as you would normally do:

from test_queries import NumQueriesMixin

class XYZTests(NumQueriesMixin, TestCase):
    def test_xyz(self):
        with self.assertNumQueries(3):
            xyz()

Run the tests with TEST_QUERIES_REWRITE_SQLLOGS environment variable to generate sqllog files:

TEST_QUERIES_REWRITE_SQLLOGS="true" manage.py test

Files like test_views.XYZTests.test_xyz.sqllog will appear in sqllog directory next to your test_views.py file.

If you will run the test next time and the queries will differ from previous, the test will print out output detailing the change with stacktrace from where the query was executed. You can also enlist the *.sqllog files to your repository to see the changes.

Running Tests

Does the code actually work?

source <YOURVIRTUALENV>/bin/activate
(myenv) $ pip install tox
(myenv) $ tox

Development commands

pip install -r requirements_dev.txt
invoke -l

Credits

Tools used in rendering this package:

• Cookiecutter

• cookiecutter-djangopackage

History

0.1.0 (2023-04-21)

• First release on PyPI.