{ "info": { "author": "Vaghul Aditya Balaji", "author_email": "vaghulb1992@gmail.com", "bugtrack_url": null, "classifiers": [], "description": "# xuebadb\n\n## Travis CI Status:\n\n[![Build Status](https://travis-ci.org/vaghulb1992/data533_lab4_vaghul_jiachen.svg?branch=master)](https://travis-ci.org/vaghulb1992/data533_lab4_vaghul_jiachen) \n\n---\n\n***xuebadb*** is a python package that allows users to conveniently connect to and query from various database systems using a unified API. Currently, it supports connecting to *MySQL* and *SQL Server* database systems. The queries return Pandas dataframes which can then be cleaned up and analysed using one of the modules in the package.\n\n---\n\n**Requirements:** \nIn order to be able to use the package, you would have to install the following:\n\nPython packages:\n* pyodbc\n* mysql-connector\n* pandas\n* numpy\n* missingno\n* matplotlib\n\n[ Microsoft ODBC Driver 17 ](https://docs.microsoft.com/en-us/sql/connect/python/python-driver-for-sql-server?view=sql-server-2017)\n\n---\n\n**Package structure:**\n\nxuebadb --> package \n  -- dbgeneric --> sub-package \n    -- db_interface --> module \n    -- mysql_interface -->module \n    -- odbc_interface --> module \n  -- dfanalysis --> sub-package \n    -- cleanup --> module \n    -- stats --> module", "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/vaghulb1992/xuebadb", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "xuebadb", "package_url": "https://pypi.org/project/xuebadb/", "platform": "", "project_url": "https://pypi.org/project/xuebadb/", "project_urls": { "Homepage": "https://github.com/vaghulb1992/xuebadb" }, "release_url": "https://pypi.org/project/xuebadb/1.3/", "requires_dist": null, "requires_python": ">=3", "summary": "xuebadb is a python package that allows users to conveniently connect to and query from various database systems using a unified API. Currently, it supports connecting to MySQL and SQL Server database systems. The queries return Pandas dataframes which can then be cleaned up and analysed using one of the modules in the package.", "version": "1.3" }, "last_serial": 4591383, "releases": { "1.0": [ { "comment_text": "", "digests": { "md5": "21f0e88c49d9af3c4a3860e328b675a8", "sha256": "dec4da0dfbea6f638e04dda6e8bdbbe545dc5459130501b375403f4051d43479" }, "downloads": -1, "filename": "xuebadb-1.0.tar.gz", "has_sig": false, "md5_digest": "21f0e88c49d9af3c4a3860e328b675a8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3106, "upload_time": "2018-12-12T18:30:16", "url": "https://files.pythonhosted.org/packages/c1/1c/06f620ea789304c0ca819880e9b864aa60a5a33b4bc84e25444254cbe684/xuebadb-1.0.tar.gz" } ], "1.1": [ { "comment_text": "", "digests": { "md5": "a5e09b62dfc55bb424007b6dafde5eaf", "sha256": "4ccc90896f11d42f6e25a79fcf9fe912fc4f5c099865f953ffcf4ba8dac2e840" }, "downloads": -1, "filename": "xuebadb-1.1.tar.gz", "has_sig": false, "md5_digest": "a5e09b62dfc55bb424007b6dafde5eaf", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3", "size": 3188, "upload_time": "2018-12-12T18:44:07", "url": "https://files.pythonhosted.org/packages/c0/eb/c77fd5b0f81d6db66717be42a4ff1c278b14dd4245b3a6995f6afd15b7a4/xuebadb-1.1.tar.gz" } ], "1.2": [ { "comment_text": "", "digests": { "md5": "82c1c3490a65aef1ea2ee60b4951d670", "sha256": "fbb862cbdc5d512f4d5315283fc39c25361d07f43266435224876651ca8e790c" }, "downloads": -1, "filename": "xuebadb-1.2.tar.gz", "has_sig": false, "md5_digest": "82c1c3490a65aef1ea2ee60b4951d670", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3", "size": 3320, "upload_time": "2018-12-12T18:50:37", "url": "https://files.pythonhosted.org/packages/a1/cd/8bcdb7968cff86b52f379273392b4cbba8cfe9ed987a1750bf5029d09442/xuebadb-1.2.tar.gz" } ], "1.3": [ { "comment_text": "", "digests": { "md5": "c5b3deb095ff6c3b4024b0b4d4fb7315", "sha256": "fe82ba7c7e692f41d134e61dd17d47dfe9357f4fa842aac64871078fadfa5e41" }, "downloads": -1, "filename": "xuebadb-1.3.tar.gz", "has_sig": false, "md5_digest": "c5b3deb095ff6c3b4024b0b4d4fb7315", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3", "size": 3265, "upload_time": "2018-12-12T19:17:29", "url": "https://files.pythonhosted.org/packages/a7/aa/ac71aa90dc32cd23e1590d0cc5c45557c706a5535b918df882ca24e23ddc/xuebadb-1.3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "c5b3deb095ff6c3b4024b0b4d4fb7315", "sha256": "fe82ba7c7e692f41d134e61dd17d47dfe9357f4fa842aac64871078fadfa5e41" }, "downloads": -1, "filename": "xuebadb-1.3.tar.gz", "has_sig": false, "md5_digest": "c5b3deb095ff6c3b4024b0b4d4fb7315", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3", "size": 3265, "upload_time": "2018-12-12T19:17:29", "url": "https://files.pythonhosted.org/packages/a7/aa/ac71aa90dc32cd23e1590d0cc5c45557c706a5535b918df882ca24e23ddc/xuebadb-1.3.tar.gz" } ] }