{ "info": { "author": "Rebecca Barnes", "author_email": "rebeccaebarnes@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Environment :: Console", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Topic :: Scientific/Engineering :: Information Analysis" ], "description": "The SQL Test module assists in testing of data between SQL database tables. This is the development version of the module.\n\nUse 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.\n\n## Main Features\n\n- **Class: SQLTest**\n 1. Creates and runs SQL database queries based on attributes provided with class instantiation or custom SQL query string.\n 2. Completes five built in tests based on field-type categorizations of `count`, `low_distinct`, `high_distinct`, `numeric`, `id_check`.\n 3. Flags fields above a specified difference threshold for \"priority review\".\n 4. Displays a summary of results.\n 5. Saves results and summary as specified.\n\n- **Function: compare_tables**\n 1. Auto-detects the type of test to be run.\n 2. Utilizes methods of SQLUnitTest to complete a full comparison of table values.\n\n- **Function: sql_query**\n 1. Conducts basic database queries\n\n\n## Functionality Overview\nThe 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](https://github.com/rebeccaebarnes/sql_analysis).\n\n### Basic Query\n\n

\n \n

\n\n### Run Test Battery\n\n**Setup Code**\n

\n \n

\n\nA 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.\n\n**Visual Summary**\n

\n \n

\n\n## Setup\n### First Installation\nThe files `sql_secrets.py` and `sql_config.py` provide examples of how the SQLAlchemy engines can be configured. These files should be customized for personal use. You can find these files in your Python/environment directory under Lib/site-packages/sql_test/.\n\nWhen updating these files, **do not** change the name or location of the files. Doing so will cause errors in the future if updating.\n\n## Dependencies\nAll dependencies are downloaded on installation if not already present. This module utilizes:\n- Python v 3.5+\n- [SQLAlchemy](https://www.sqlalchemy.org/)\n- [pandas](https://pandas.pydata.org/)\n- [NumPy](https://numpy.org/)\n- [Matplotlib](https://matplotlib.org/)\n- [Seaborn](https://seaborn.pydata.org/)\n- [cx_Oracle](https://oracle.github.io/python-cx_Oracle/)\n- [Psycopg](http://initd.org/psycopg/)\n\n## Acknowledgements\nTesting is completed using the [PostgreSQL DVD Rental](http://www.postgresqltutorial.com/postgresql-sample-database/) sample database.\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/rebeccaebarnes/sql_analysis", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "sql-test", "package_url": "https://pypi.org/project/sql-test/", "platform": "", "project_url": "https://pypi.org/project/sql-test/", "project_urls": { "Homepage": "https://github.com/rebeccaebarnes/sql_analysis" }, "release_url": "https://pypi.org/project/sql-test/0.1.5/", "requires_dist": [ "SQLAlchemy", "pandas", "seaborn", "psycopg2", "cx-Oracle" ], "requires_python": ">=3.5", "summary": "Conduct quality assurance testing on database tables", "version": "0.1.5" }, "last_serial": 5764898, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "ba3930ea3ac87821b0064d4ee3be5b15", "sha256": "7102fb334d6e7b061ff12db0d01411f329145bf603d7299259852447f64d58c0" }, "downloads": -1, "filename": "sql_test-0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "ba3930ea3ac87821b0064d4ee3be5b15", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 15776, "upload_time": "2019-08-25T04:45:36", "url": "https://files.pythonhosted.org/packages/06/68/1b8424c2464b4fadc5f84e3e743fc07517122f00814e961ad0801929f75e/sql_test-0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "402ed931265ff786314107430f3cdab3", "sha256": "6ebf58e6c3cfd5433cbc909f0bbbf7da39bfadfd881117ed28f674a495373bb1" }, "downloads": -1, "filename": "sql_test-0.1.tar.gz", "has_sig": false, "md5_digest": "402ed931265ff786314107430f3cdab3", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 15767, "upload_time": "2019-08-25T04:45:41", "url": "https://files.pythonhosted.org/packages/35/0f/6ead9a4a74de0f59889d5de8983bbe0a45ebacdfd7a94ecf17423d64095b/sql_test-0.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "39dba8effb6b9808dfde84b33230b315", "sha256": "d6b15b80d682cbc1d6782774810d2c3b813b621e65ae1e6d892edf2a3ca41ef3" }, "downloads": -1, "filename": "sql_test-0.1.2-py3-none-any.whl", "has_sig": false, "md5_digest": "39dba8effb6b9808dfde84b33230b315", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 15877, "upload_time": "2019-08-25T04:45:38", "url": "https://files.pythonhosted.org/packages/ff/2e/e0fee2c1563f2815a4d431c9bec34102168843e718f51e0b2ed19ef1a7d5/sql_test-0.1.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "13271914862f69731f5a96554aa63c2b", "sha256": "d2d595ddcf199c50d47579b8ac109ea05cb1bf77c2cc00231a94f43e8d5ff5d9" }, "downloads": -1, "filename": "sql_test-0.1.2.tar.gz", "has_sig": false, "md5_digest": "13271914862f69731f5a96554aa63c2b", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 16185, "upload_time": "2019-08-25T04:45:40", "url": "https://files.pythonhosted.org/packages/f3/f7/8cda409f687f9604f6b4c52e1830cd36e3b177dc484e5c98984e7aeb8e5f/sql_test-0.1.2.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "4b0ec0ac433b3c510d336da08b2def7c", "sha256": "60d973e039957ae1e45e372c3e5ccf291fea272dd0c6dc5d5d8d4a51f3616e18" }, "downloads": -1, "filename": "sql_test-0.1.3-py3-none-any.whl", "has_sig": false, "md5_digest": "4b0ec0ac433b3c510d336da08b2def7c", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 15895, "upload_time": "2019-08-25T05:40:19", "url": "https://files.pythonhosted.org/packages/dc/18/18b731987c553e2742d6ef5507485d97ba4b0ede40f59163b1d5372eb73d/sql_test-0.1.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "8c529c120b3170a705ebee63fc677ba1", "sha256": "fc4f15d1721ae35a04c94b7b9423c56c3eff16df82a0be762f4011a31fef7f62" }, "downloads": -1, "filename": "sql_test-0.1.3.tar.gz", "has_sig": false, "md5_digest": "8c529c120b3170a705ebee63fc677ba1", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 16196, "upload_time": "2019-08-25T05:40:21", "url": "https://files.pythonhosted.org/packages/f9/c7/de73fdf040610866195ee495a257f6d38f93c95a82a4625ff53cc8c903b9/sql_test-0.1.3.tar.gz" } ], "0.1.4": [ { "comment_text": "", "digests": { "md5": "160d4ae109b19c10bcc253fab05bf348", "sha256": "0998b9fa30e04e625a8d1554ea3749d5b618e14ef0e440ce8a57b513f9fb23a1" }, "downloads": -1, "filename": "sql_test-0.1.4-py3-none-any.whl", "has_sig": false, "md5_digest": "160d4ae109b19c10bcc253fab05bf348", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 15983, "upload_time": "2019-08-27T05:16:00", "url": "https://files.pythonhosted.org/packages/78/db/775dd30b18989aa1917ba4b108f1c8f1dd83016926a89046e0bd65fa0865/sql_test-0.1.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "e174a82daa6afbbca010638c5ad8562d", "sha256": "716463493fa5cc36cffb774f71c9c85da9b38434d193975944d6db897f3ead96" }, "downloads": -1, "filename": "sql_test-0.1.4.tar.gz", "has_sig": false, "md5_digest": "e174a82daa6afbbca010638c5ad8562d", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 15883, "upload_time": "2019-08-27T05:16:02", "url": "https://files.pythonhosted.org/packages/af/c3/e6e0c0d894f39b84fa018e18400f6929712b2bc15ae06bc81a9d27acae5b/sql_test-0.1.4.tar.gz" } ], "0.1.5": [ { "comment_text": "", "digests": { "md5": "133d8be7a33d462e5bd5d42b3cec4f84", "sha256": "3440f1316e032e0e129975fa11e99fe2d4bd0e42767fcb173c91225b296c40c4" }, "downloads": -1, "filename": "sql_test-0.1.5-py3-none-any.whl", "has_sig": false, "md5_digest": "133d8be7a33d462e5bd5d42b3cec4f84", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 15972, "upload_time": "2019-08-31T15:49:12", "url": "https://files.pythonhosted.org/packages/0a/3f/0d74ae7f47c92f8d483f30270daa30dfdb56431b2c32aa76e4dee287e128/sql_test-0.1.5-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "41534bb65458f8c0ab6e674d9336aef4", "sha256": "22947950d5596b4cafa131169861c4d1b56f6ced10d5a5e8dfb920db3c93a4e6" }, "downloads": -1, "filename": "sql_test-0.1.5.tar.gz", "has_sig": false, "md5_digest": "41534bb65458f8c0ab6e674d9336aef4", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 16136, "upload_time": "2019-08-31T15:49:15", "url": "https://files.pythonhosted.org/packages/5f/53/482b7deef8a694157064039a17b9ede788f4c7b610ed8bde6e6e0952a674/sql_test-0.1.5.tar.gz" } ], "0.1.5a0": [ { "comment_text": "", "digests": { "md5": "1df47e0a5494c64c64ffe8147821ba86", "sha256": "6692cf81ebf598b8a233a96c6665292bf7b0f3ba53c16041ecfe26415c005b45" }, "downloads": -1, "filename": "sql_test-0.1.5a0-py3-none-any.whl", "has_sig": false, "md5_digest": "1df47e0a5494c64c64ffe8147821ba86", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 15991, "upload_time": "2019-08-31T17:34:46", "url": "https://files.pythonhosted.org/packages/93/c9/8f641f33cf28acb2624bb8ab15aa22823419ab2cd19892a4c4fcc90554a8/sql_test-0.1.5a0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "1ce5ae1f7290afbe84b13b237eb610da", "sha256": "0b8b7ea89c2c4660490ff74d4f76b948910100c7d77cf3e7042e2797c0e1a165" }, "downloads": -1, "filename": "sql_test-0.1.5a0.tar.gz", "has_sig": false, "md5_digest": "1ce5ae1f7290afbe84b13b237eb610da", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 16406, "upload_time": "2019-08-31T17:34:50", "url": "https://files.pythonhosted.org/packages/5d/96/15d2aeacf76f14daa55bc9ee47ff402323b06f04aab77c03813d9668b9d6/sql_test-0.1.5a0.tar.gz" } ], "0.1.5b0": [ { "comment_text": "", "digests": { "md5": "847535cfd131f96f7899b5b10c61de0e", "sha256": "18ecd3b902b399cffdf46285e79e3e5cbee565d92d413dd3f08bba645b24f388" }, "downloads": -1, "filename": "sql_test-0.1.5b0-py3-none-any.whl", "has_sig": false, "md5_digest": "847535cfd131f96f7899b5b10c61de0e", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 15991, "upload_time": "2019-08-31T17:53:21", "url": "https://files.pythonhosted.org/packages/e1/5c/383e12c958ba928e4e1fe4b3f1108e04e0979453dacd8ce4b3ed61326dd0/sql_test-0.1.5b0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d51d73cce7fb9fabfec387117c846680", "sha256": "9a5de003c9d67a9d58e25ec1113c4820608083a8ad25dae899750b8d0ea7ceef" }, "downloads": -1, "filename": "sql_test-0.1.5b0.tar.gz", "has_sig": false, "md5_digest": "d51d73cce7fb9fabfec387117c846680", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 16425, "upload_time": "2019-08-31T17:53:25", "url": "https://files.pythonhosted.org/packages/e8/eb/f2f5fc597eb959fde54edc7cbd543adde0b8b6de8dff0c4dc6be41684783/sql_test-0.1.5b0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "133d8be7a33d462e5bd5d42b3cec4f84", "sha256": "3440f1316e032e0e129975fa11e99fe2d4bd0e42767fcb173c91225b296c40c4" }, "downloads": -1, "filename": "sql_test-0.1.5-py3-none-any.whl", "has_sig": false, "md5_digest": "133d8be7a33d462e5bd5d42b3cec4f84", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 15972, "upload_time": "2019-08-31T15:49:12", "url": "https://files.pythonhosted.org/packages/0a/3f/0d74ae7f47c92f8d483f30270daa30dfdb56431b2c32aa76e4dee287e128/sql_test-0.1.5-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "41534bb65458f8c0ab6e674d9336aef4", "sha256": "22947950d5596b4cafa131169861c4d1b56f6ced10d5a5e8dfb920db3c93a4e6" }, "downloads": -1, "filename": "sql_test-0.1.5.tar.gz", "has_sig": false, "md5_digest": "41534bb65458f8c0ab6e674d9336aef4", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 16136, "upload_time": "2019-08-31T15:49:15", "url": "https://files.pythonhosted.org/packages/5f/53/482b7deef8a694157064039a17b9ede788f4c7b610ed8bde6e6e0952a674/sql_test-0.1.5.tar.gz" } ] }