{ "info": { "author": "Azat Ibrakov", "author_email": "azatibrakov@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "Environment :: Web Environment", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Operating System :: MacOS :: MacOS X", "Operating System :: Microsoft :: Windows", "Operating System :: POSIX", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: Implementation :: CPython", "Topic :: Database :: Database Engines/Servers" ], "description": ".. contents::\n\n\nIn what follows ``python3`` is an alias for ``python3.5``\nor any later version (``python3.6`` and so on).\n\nInstallation\n------------\nInstall the latest ``pip`` & ``setuptools`` packages versions\n\n.. code-block:: bash\n\n python3 -m pip install --upgrade pip setuptools\n\nRelease\n~~~~~~~\nDownload and install the latest stable version from ``PyPI`` repository\n\n.. code-block:: bash\n\n python3 -m pip install --upgrade hypothesis_sqlalchemy\n\nDeveloper\n~~~~~~~~~\nDownload and install the latest version from ``GitHub`` repository\n\n.. code-block:: bash\n\n git clone https://github.com/lycantropos/hypothesis_sqlalchemy.git\n cd hypothesis_sqlalchemy\n python3 setup.py install\n\nUsage\n-----\nAssuming that ``POSTGRES_URI`` environment variable is set\nand corresponds to the working database instance:\n\n>>> import os\n>>> from sqlalchemy.engine.url import make_url\n>>> postgres_uri = make_url(os.environ['POSTGRES_URI'])\n>>> from sqlalchemy_helpers.connectable import check_connection\n>>> check_connection(postgres_uri)\n>>> from sqlalchemy_helpers.connectable import create_engine\n>>> with create_engine(postgres_uri) as engine:\n... engine.scalar('SELECT 1')\n1\n>>> from sqlalchemy_helpers.connectable import open_connection\n>>> with create_engine(postgres_uri) as engine:\n... with open_connection(engine) as connection:\n... connection.scalar('SELECT 1')\n1\n\nRunning tests\n-------------\nPlain\n\n.. code-block:: bash\n\n export POSTGRES_URI=\"postgresql://$POSTGRES_USERNAME:$POSTGRES_PASSWORD@$POSTGRES_HOSTNAME:$POSTGRES_PORT/$POSTGRES_DATABASE\"\n export MYSQL_URI=\"mysql+pymysql://$MYSQL_USERNAME:$MYSQL_PASSWORD@$MYSQL_HOSTNAME:$MYSQL_PORT/$MYSQL_DATABASE\"\n python3 setup.py test\n\nwhere\n\n - ``$POSTGRES_USERNAME``: PostgreSQL database user name\n (e.g. ``postgres``),\n - ``$POSTGRES_PASSWORD``: PostgreSQL database user password\n (e.g. ``ilovepostgresql``),\n - ``$POSTGRES_HOSTNAME``: PostgreSQL database host\n (e.g. ``localhost``),\n - ``$POSTGRES_PORT``: PostgreSQL database port\n (e.g. ``5432``),\n - ``$POSTGRES_DATABASE``: target PostgreSQL database name\n (e.g. ``testdb``),\n - ``$MYSQL_USERNAME``: MySQL database user name\n (e.g. ``root``),\n - ``$MYSQL_PASSWORD``: MySQL database user password\n (e.g. ``ilovemysql``),\n - ``$MYSQL_HOSTNAME``: MySQL database host\n (e.g. ``localhost``),\n - ``$MYSQL_PORT``: MySQL database port\n (e.g. ``3306``),\n - ``$MYSQL_DATABASE``: target MySQL database name\n (e.g. ``testdb``).\n\n\nInside ``Docker`` container with remote debugger\n\n.. code-block:: bash\n\n ./set-dockerhost.sh docker-compose up\n", "description_content_type": null, "docs_url": null, "download_url": "https://github.com/lycantropos/sqlalchemy_helpers/archive/master.tar.gz", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/lycantropos/sqlalchemy_helpers/", "keywords": "SQLAlchemy", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "sqlalchemy_helpers", "package_url": "https://pypi.org/project/sqlalchemy_helpers/", "platform": "", "project_url": "https://pypi.org/project/sqlalchemy_helpers/", "project_urls": { "Download": "https://github.com/lycantropos/sqlalchemy_helpers/archive/master.tar.gz", "Homepage": "https://github.com/lycantropos/sqlalchemy_helpers/" }, "release_url": "https://pypi.org/project/sqlalchemy_helpers/0.1.0/", "requires_dist": null, "requires_python": "", "summary": "Helper functions for comfortable working with SQLAlchemy.", "version": "0.1.0" }, "last_serial": 3183304, "releases": { "0.0.0": [ { "comment_text": "", "digests": { "md5": "63b6254a13f0b3243b14986bdb55cbac", "sha256": "590f7329c80d8918447b874a992f0b27376af09e4a83faf975cccd1bc1cd5166" }, "downloads": -1, "filename": "sqlalchemy_helpers-0.0.0.tar.gz", "has_sig": false, "md5_digest": "63b6254a13f0b3243b14986bdb55cbac", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 770, "upload_time": "2017-05-01T19:01:15", "url": "https://files.pythonhosted.org/packages/86/94/36b3ad5f37a8ee570b86746bc2fd8ad17931dc54e02822f92aa144f30ab3/sqlalchemy_helpers-0.0.0.tar.gz" } ], "0.0.1": [ { "comment_text": "", "digests": { "md5": "424241958868c66acc3ccd6acdd8ce74", "sha256": "c0e17e256fa716361264c81a3bc3162ac006f67fadeb10b8c6f4282894f82375" }, "downloads": -1, "filename": "sqlalchemy_helpers-0.0.1.tar.gz", "has_sig": false, "md5_digest": "424241958868c66acc3ccd6acdd8ce74", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 825, "upload_time": "2017-05-02T07:21:44", "url": "https://files.pythonhosted.org/packages/56/94/3f635926ff6b4c4d96263485f8007592c9cae1612b059c6b81736cc031cc/sqlalchemy_helpers-0.0.1.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "bcc84b7f14c0002d5d54d0238e1e0779", "sha256": "e2f2ecbce55ebf03f8e998f95f3877adf2b9db69e4dc09925a7a2ec6c84efffd" }, "downloads": -1, "filename": "sqlalchemy_helpers-0.0.2.tar.gz", "has_sig": false, "md5_digest": "bcc84b7f14c0002d5d54d0238e1e0779", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1793, "upload_time": "2017-05-02T10:39:18", "url": "https://files.pythonhosted.org/packages/28/57/738e109bc25a888286059feff3f45035a0947907a72ef881208e76dbca51/sqlalchemy_helpers-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "e2d2d656a5b85391dfea1de65f6cd651", "sha256": "2ef03e285c9fb66d13614e377ac8262f3a911b8f7b5af8401e139cd26735804b" }, "downloads": -1, "filename": "sqlalchemy_helpers-0.0.3.tar.gz", "has_sig": false, "md5_digest": "e2d2d656a5b85391dfea1de65f6cd651", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1796, "upload_time": "2017-06-06T09:58:44", "url": "https://files.pythonhosted.org/packages/b9/4f/0c4d20a05bdb8550b3670b8d113e36191cd0cd38da57cac991bdd7f0b318/sqlalchemy_helpers-0.0.3.tar.gz" } ], "0.1.0": [ { "comment_text": "", "digests": { "md5": "b3346a0796fc721fb6b72757dedaa96f", "sha256": "3ccad71930e29d1155d60f8e9c3e7cd13b14eb959953f32732f63db7a906078f" }, "downloads": -1, "filename": "sqlalchemy_helpers-0.1.0.tar.gz", "has_sig": false, "md5_digest": "b3346a0796fc721fb6b72757dedaa96f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4884, "upload_time": "2017-09-18T19:58:06", "url": "https://files.pythonhosted.org/packages/91/6f/fb0f8403aee4a383f8eb16109eb8f76dc82f4748068b39bbf17abdd55a3d/sqlalchemy_helpers-0.1.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "b3346a0796fc721fb6b72757dedaa96f", "sha256": "3ccad71930e29d1155d60f8e9c3e7cd13b14eb959953f32732f63db7a906078f" }, "downloads": -1, "filename": "sqlalchemy_helpers-0.1.0.tar.gz", "has_sig": false, "md5_digest": "b3346a0796fc721fb6b72757dedaa96f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4884, "upload_time": "2017-09-18T19:58:06", "url": "https://files.pythonhosted.org/packages/91/6f/fb0f8403aee4a383f8eb16109eb8f76dc82f4748068b39bbf17abdd55a3d/sqlalchemy_helpers-0.1.0.tar.gz" } ] }