{
    "info": {
        "author": "",
        "author_email": "",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 3 - Alpha",
            "Intended Audience :: Developers",
            "Programming Language :: Python :: 3.6"
        ],
        "description": "# py-db-wrapper\nShallow wrapper for convenience tools for db management\n\n\n## TODO:\n*  Utils - HiveUtils.get_table_columns(). This should probabkly be generic not in Hive utils.\n*  Statements - standardise the use of database (or schema) and table (or tablename)\n\n## Examples\n\n## Connections\nThe connection class is a simple wrapper to simplify connecting to know database types.Currently supports MSSQL, MYSQL and HIVE.\n### Making a sql alchemy engine\n\n```py\nazure_sre_connection = AzureConnection(\n    host=env('AZURE_HOST'), \n    port=env('AZURE_PORT'), \n    database=env('AZURE_DB'), \n    user=env('AZURE_USER'), \n    password=env('AZURE_PASSWORD')\n)\n\n\nazure_sre_engine = azure_sre_connection.connect()\n```\n\n## Statements\nStatement classes are designed to help make various sql statements for different dialect.\n\n```py\ncolumns = HiveUtils.get_table_columns(hive_engine=engine, database='foo', tablename='bar')\n\nstmt = CreateTableStatement(dialect=dialect.Mssql, columns=columns)\nsql = stmt.get_sql(schema='doo',table='dar')\nprint(sql)\n```\n\n## Developer notes\n\nPackage deployment etc\n\n```sh\npython setup.py test\n```\n\n```sh\npython setup.py sdist bdist_egg\n```\n```sh\ntwine upload --repository-url https://test.pypi.org/legacy/ dist/*\ntwine upload dist/*\n```",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "py-db-wrapper",
        "package_url": "https://pypi.org/project/py-db-wrapper/",
        "platform": "",
        "project_url": "https://pypi.org/project/py-db-wrapper/",
        "project_urls": null,
        "release_url": "https://pypi.org/project/py-db-wrapper/1.0.8/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "",
        "version": "1.0.8"
    },
    "last_serial": 5155522,
    "releases": {
        "1.0.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "fd7cf1e1360c85396ce0f4d8fdd04a22",
                    "sha256": "a2a62f482a1fd143d16852db3bd8b9d31db1b08484c4417c3ef17ad5716b9d1c"
                },
                "downloads": -1,
                "filename": "py_db_wrapper-1.0.5-py3.6.egg",
                "has_sig": false,
                "md5_digest": "fd7cf1e1360c85396ce0f4d8fdd04a22",
                "packagetype": "bdist_egg",
                "python_version": "3.6",
                "requires_python": null,
                "size": 13975,
                "upload_time": "2019-04-15T20:30:06",
                "url": "https://files.pythonhosted.org/packages/a3/40/43548e982a01bc14c15218eb285c9b20ee8ad950c1401d34b23debc87a66/py_db_wrapper-1.0.5-py3.6.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "a5078a88275aeb881554599255030643",
                    "sha256": "bdb466bde2c02c9122920e7d04577b514a3e856266877241eaf89eaed8cbae84"
                },
                "downloads": -1,
                "filename": "py-db-wrapper-1.0.5.tar.gz",
                "has_sig": false,
                "md5_digest": "a5078a88275aeb881554599255030643",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6766,
                "upload_time": "2019-04-15T20:30:08",
                "url": "https://files.pythonhosted.org/packages/56/b7/05a97f5b118e5df8da3c168cde9d2a9c90b88a7b13d0657209a5c89dcd29/py-db-wrapper-1.0.5.tar.gz"
            }
        ],
        "1.0.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "3c0e54ad07358b6ad4f8499436b290bb",
                    "sha256": "dfc2e2fb154844970c57f58c947abc9b8e762c798b9a5357d958df58e7712a63"
                },
                "downloads": -1,
                "filename": "py_db_wrapper-1.0.6-py3.6.egg",
                "has_sig": false,
                "md5_digest": "3c0e54ad07358b6ad4f8499436b290bb",
                "packagetype": "bdist_egg",
                "python_version": "3.6",
                "requires_python": null,
                "size": 20883,
                "upload_time": "2019-04-15T20:30:09",
                "url": "https://files.pythonhosted.org/packages/e7/6e/600a920b2ccfd539567b6a04140972773a3ea6496b7f6f312a1c80391b44/py_db_wrapper-1.0.6-py3.6.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "be252889b1dfa0accb64bdcdfe38b847",
                    "sha256": "f54abc0520b312989d02ed510313e6d97fad58f7c775de09d168246c12f2b25b"
                },
                "downloads": -1,
                "filename": "py-db-wrapper-1.0.6.tar.gz",
                "has_sig": false,
                "md5_digest": "be252889b1dfa0accb64bdcdfe38b847",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8275,
                "upload_time": "2019-04-15T20:30:10",
                "url": "https://files.pythonhosted.org/packages/49/12/fa55be516b6a694ba9587ca0eda41d4ddaa897f3c4d347a2071e7d37d4a8/py-db-wrapper-1.0.6.tar.gz"
            }
        ],
        "1.0.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8c857dcdb10652e4eaedde5e7f7df251",
                    "sha256": "8379bd73df57bea40870877eac660f183dbc579e4bd2713f33e65ab3bbb6a4ca"
                },
                "downloads": -1,
                "filename": "py_db_wrapper-1.0.7-py3.6.egg",
                "has_sig": false,
                "md5_digest": "8c857dcdb10652e4eaedde5e7f7df251",
                "packagetype": "bdist_egg",
                "python_version": "3.6",
                "requires_python": null,
                "size": 23302,
                "upload_time": "2019-04-15T21:38:22",
                "url": "https://files.pythonhosted.org/packages/12/0e/0cf167af576018461feb30fcfe03438cb1f4e580c605b4576979e1c8c299/py_db_wrapper-1.0.7-py3.6.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "6c2984a03a9ba716dbb815e6c7bdf5d1",
                    "sha256": "6228a6f22d74db4ffbea08644e34077eee5d80a6b572e1417ef110c263d9230d"
                },
                "downloads": -1,
                "filename": "py-db-wrapper-1.0.7.tar.gz",
                "has_sig": false,
                "md5_digest": "6c2984a03a9ba716dbb815e6c7bdf5d1",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8375,
                "upload_time": "2019-04-15T21:38:23",
                "url": "https://files.pythonhosted.org/packages/19/04/527ef894649e20aca11619a22dd786ef41ee3f65ec10428ad85acdb40a34/py-db-wrapper-1.0.7.tar.gz"
            }
        ],
        "1.0.8": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "0c22c83f71cbffcda059f0634658116b",
                    "sha256": "1c5d5881b4ac8fed47d846c5a7df014c1eeb0d4b808a8246b8c9f51678922abd"
                },
                "downloads": -1,
                "filename": "py_db_wrapper-1.0.8-py3.6.egg",
                "has_sig": false,
                "md5_digest": "0c22c83f71cbffcda059f0634658116b",
                "packagetype": "bdist_egg",
                "python_version": "3.6",
                "requires_python": null,
                "size": 24139,
                "upload_time": "2019-04-17T14:49:52",
                "url": "https://files.pythonhosted.org/packages/1e/81/baab506da5b8bc4243d9384a3eb2a561e61f13f45fe6943d0aa6012a1209/py_db_wrapper-1.0.8-py3.6.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "d3565099906061d9739b4ad480231b0e",
                    "sha256": "7e90751e76aea1ec61e8d7043edce0d1a3e3693b31c2688a2d408c7b398be0cc"
                },
                "downloads": -1,
                "filename": "py-db-wrapper-1.0.8.tar.gz",
                "has_sig": false,
                "md5_digest": "d3565099906061d9739b4ad480231b0e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8634,
                "upload_time": "2019-04-17T14:49:53",
                "url": "https://files.pythonhosted.org/packages/79/9a/6b88a3cffd89613a1be8371c5722a6b2b539987378c04151953d3a4c8914/py-db-wrapper-1.0.8.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "0c22c83f71cbffcda059f0634658116b",
                "sha256": "1c5d5881b4ac8fed47d846c5a7df014c1eeb0d4b808a8246b8c9f51678922abd"
            },
            "downloads": -1,
            "filename": "py_db_wrapper-1.0.8-py3.6.egg",
            "has_sig": false,
            "md5_digest": "0c22c83f71cbffcda059f0634658116b",
            "packagetype": "bdist_egg",
            "python_version": "3.6",
            "requires_python": null,
            "size": 24139,
            "upload_time": "2019-04-17T14:49:52",
            "url": "https://files.pythonhosted.org/packages/1e/81/baab506da5b8bc4243d9384a3eb2a561e61f13f45fe6943d0aa6012a1209/py_db_wrapper-1.0.8-py3.6.egg"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "d3565099906061d9739b4ad480231b0e",
                "sha256": "7e90751e76aea1ec61e8d7043edce0d1a3e3693b31c2688a2d408c7b398be0cc"
            },
            "downloads": -1,
            "filename": "py-db-wrapper-1.0.8.tar.gz",
            "has_sig": false,
            "md5_digest": "d3565099906061d9739b4ad480231b0e",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 8634,
            "upload_time": "2019-04-17T14:49:53",
            "url": "https://files.pythonhosted.org/packages/79/9a/6b88a3cffd89613a1be8371c5722a6b2b539987378c04151953d3a4c8914/py-db-wrapper-1.0.8.tar.gz"
        }
    ]
}