Conduct quality assurance testing on database tables
The SQL Test module assists in testing of data between SQL database tables. This is the development version of the module.
Use examples include comparing data in a view to those in a table derived from a star schema, or comparing results from a table derived from an external source to a table built via ETL.
- Creates and runs SQL database queries based on attributes provided with class instantiation or custom SQL query string.
- Completes five built in tests based on field-type categorizations of
- Flags fields above a specified difference threshold for "priority review".
- Displays a summary of results.
- Saves results and summary as specified.
- Auto-detects the type of test to be run.
- Utilizes methods of SQLUnitTest to complete a full comparison of table values.
- Conducts basic database queries
The concept behind the testing is that database information can often be segmented by a field, such as dates. Testing can be done by comparing field values across these groupings. For a more detailed description of the available functionality, check out the development page.
Run Test Battery
A summarized version of results (as a DataFrame or image), indicating the percentage difference between table fields (and the test type used), is available via the test battery.
sql_config.py provide examples of how the SQLAlchemy engines can be configured. These files should be customized for personal use.
Updating SQL Test
Unfortunately, updating via pip will likely overwrite your customized configuration files. (As soon as I can work out a way to avoid this I'll be updating this section!) Before updating, make sure to store your custom configuration files in a new directory or rename them. You can find these files in your Anaconda directory under Lib/site-packages/sql_test/. You can then replace the "updated" versions with your original ones.
All dependencies are downloaded on installation if not already present. This module utilizes:
Testing is completed using the PostgreSQL DVD Rental sample database.
Release history Release notifications
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size sql_test-0.1.4-py3-none-any.whl (16.0 kB)||File type Wheel||Python version py3||Upload date||Hashes View hashes|
|Filename, size sql_test-0.1.4.tar.gz (15.9 kB)||File type Source||Python version None||Upload date||Hashes View hashes|