django-pyodbc-azure
django-pyodbc-azure copied to clipboard
michiya
Need a test suite
In building Django 1.8 compatibility - #25 - I realized that I didn't have a good way to easily test all of the changes I was making, which were not insignificant. It would be really nice to be able to run a full suite of tests against this package, and also to have a CI service such as Travis build it against multiple Django and Python versions.
FWIW, the Django team has been making an effort to let Django's test-suite be used for this. If you run Django's tests with this backend, and run into a test failure whose cause is that the Django tests are only built for the core backends, come talk about it on the django-developers mailing list or the #django-dev IRC channel.
Well, my thought for this test suite was more to validate the SQL being generated for these backends, and in so doing, being able to actually to test the output from this without having to have a live database. I don't have access to any SQL Server instances at the moment (I'm using this against Sybase ASE, with just a small modification) so I can't run the full test suite, that I'm aware of.
Or is all that considered excessive?
I think it could also be useful, in the case of this package, to have mocked responses in order to test the engine version specific functionality without having all versions readily available (SQL Server 2000 vs 2005, etc.)
What about using https://github.com/django/django-docker-box? SQL Server 2017 is available for Linux, even as container: https://hub.docker.com/_/microsoft-mssql-server
