{ "info": { "author": "Ken", "author_email": "kenjyco@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "Environment :: Console", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python", "Programming Language :: Python :: 3.5", "Topic :: Software Development :: Libraries" ], "description": "About\n-----\n\nThis is meant to be a simple way to explore a postgresql/mysql database\nand get data out (super light wrapper to SQLAlchemy).\n\nConnect with DB url in the following formats:\n\n- ``postgresql://someuser:somepassword@somehost/somedatabase``\n- ``mysql://someuser:somepassword@somehost/somedatabase``\n\n Note: This package uses ``pymysql`` driver for connecting to mysql.\n Urls that start with ``mysql://`` will automatically be changed to\n use ``mysql+pymysql://``.\n\nInstall\n-------\n\n::\n\n $ pip3 install sql-helper\n\nUsage\n-----\n\n::\n\n In [1]: from sql_helper import SQL\n\n In [2]: sql = SQL('postgresql://someuser:somepassword@somehost/somedatabase')\n\n In [3]: table_names = sql.get_tables()\n\n In [4]: results = sql.execute('SELECT ...')\n\nExtra\n-----\n\n`Redshift `__\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\n Ensure the ``pg_config`` executable is on the system\n\n::\n\n $ sudo apt-get install -y libpq-dev\n\n or\n\n $ brew install postgresql\n\nThen install ``sqlalchemy-redshift`` wherever you installed\n``sql-helper``\n\n::\n\n $ venv/bin/pip3 install sqlalchemy-redshift\n\nConnect with DB url in the following format:\n\n- ``redshift+psycopg2://someuser:somepassword@somehost/somedatabase``\n\n\n", "description_content_type": "", "docs_url": null, "download_url": "https://github.com/kenjyco/sql-helper/tarball/v0.0.6", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/kenjyco/sql-helper", "keywords": "sql,mysql,postgresql,helper", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "sql-helper", "package_url": "https://pypi.org/project/sql-helper/", "platform": "", "project_url": "https://pypi.org/project/sql-helper/", "project_urls": { "Download": "https://github.com/kenjyco/sql-helper/tarball/v0.0.6", "Homepage": "https://github.com/kenjyco/sql-helper" }, "release_url": "https://pypi.org/project/sql-helper/0.0.6/", "requires_dist": [ "SQLAlchemy (==1.3.2)", "psycopg2-binary (==2.8.1)", "PyMySQL (==0.9.3)", "settings-helper", "bg-helper" ], "requires_python": "", "summary": "Helper funcs and tools for working with SQL in mysql or postgresql", "version": "0.0.6" }, "last_serial": 5879167, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "5bd031ddd473853c2cba6efcdc15e68f", "sha256": "a7a361f441348c9b00568205d609b96301351cd9b03991f764d0cf0ecf3202bf" }, "downloads": -1, "filename": "sql_helper-0.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "5bd031ddd473853c2cba6efcdc15e68f", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 3462, "upload_time": "2019-04-01T12:17:45", "url": "https://files.pythonhosted.org/packages/0d/67/0c1be7ab6cde2bbf8fc6fa51cd88745d5fff0a747fcc6e679ae3e9f83d23/sql_helper-0.0.1-py3-none-any.whl" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "2abd0b9dcb72cc2fd174536330c5e212", "sha256": "d183eefe49c78e03effd3708cc91d6e7a26f9ddf7e79516c724561d79b5bd152" }, "downloads": -1, "filename": "sql_helper-0.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "2abd0b9dcb72cc2fd174536330c5e212", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 3491, "upload_time": "2019-04-10T11:05:39", "url": "https://files.pythonhosted.org/packages/32/91/b7d215b064c4f069e4bae21d5d7317c5b54be48ebeb2ddf21d49d0dbb920/sql_helper-0.0.2-py3-none-any.whl" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "04a58dabb3d158df1ba2c449982d932b", "sha256": "20329719de07165e607096e4a5bbcdc1d05c9ce03d2bc3da84768a79c42919aa" }, "downloads": -1, "filename": "sql_helper-0.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "04a58dabb3d158df1ba2c449982d932b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 3649, "upload_time": "2019-05-08T11:00:14", "url": "https://files.pythonhosted.org/packages/26/28/9d55ad2d3eee040fd0279352554fab302b53574f095c6f68a1ef4a73c6ef/sql_helper-0.0.3-py3-none-any.whl" } ], "0.0.4": [ { "comment_text": "", "digests": { "md5": "e7d4219fd4aa301100bfc2bb2ea40ccb", "sha256": "031dd94e0a6408d95a95a39451b97a2d8fac83c309f33f910bd4ce48d520c124" }, "downloads": -1, "filename": "sql_helper-0.0.4-py3-none-any.whl", "has_sig": false, "md5_digest": "e7d4219fd4aa301100bfc2bb2ea40ccb", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 3893, "upload_time": "2019-05-13T08:20:38", "url": "https://files.pythonhosted.org/packages/05/ec/1402a618cf8a89f2ecdbe768e9c3eab019c13034e3db7dc94d17151e503f/sql_helper-0.0.4-py3-none-any.whl" } ], "0.0.5": [ { "comment_text": "", "digests": { "md5": "8fd5e374b60cec3a27a701552eb3ad5f", "sha256": "a4ed8c723215783552556afc310d1845f99e2702494b22c992cff1fb8edd3272" }, "downloads": -1, "filename": "sql_helper-0.0.5-py3-none-any.whl", "has_sig": false, "md5_digest": "8fd5e374b60cec3a27a701552eb3ad5f", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 4428, "upload_time": "2019-05-15T03:45:58", "url": "https://files.pythonhosted.org/packages/0a/9a/cf1c53e7742b040328e633a79e586e685f2e3bfe9a181a8aba18ae6e4712/sql_helper-0.0.5-py3-none-any.whl" } ], "0.0.6": [ { "comment_text": "", "digests": { "md5": "da149cee93811ca68effa568fb69297f", "sha256": "1d4297c06a370c179d082ecad722ee59e6360f6157564a7ac93eb3238daad4ff" }, "downloads": -1, "filename": "sql_helper-0.0.6-py3-none-any.whl", "has_sig": false, "md5_digest": "da149cee93811ca68effa568fb69297f", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 4756, "upload_time": "2019-09-24T11:41:48", "url": "https://files.pythonhosted.org/packages/f7/f1/c64b72ee1680026dab2dd4b8b57288e45a085238fde3943bac922e75c3a2/sql_helper-0.0.6-py3-none-any.whl" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "da149cee93811ca68effa568fb69297f", "sha256": "1d4297c06a370c179d082ecad722ee59e6360f6157564a7ac93eb3238daad4ff" }, "downloads": -1, "filename": "sql_helper-0.0.6-py3-none-any.whl", "has_sig": false, "md5_digest": "da149cee93811ca68effa568fb69297f", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 4756, "upload_time": "2019-09-24T11:41:48", "url": "https://files.pythonhosted.org/packages/f7/f1/c64b72ee1680026dab2dd4b8b57288e45a085238fde3943bac922e75c3a2/sql_helper-0.0.6-py3-none-any.whl" } ] }