{ "info": { "author": "Tim Savage", "author_email": "tim@savage.company", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Intended Audience :: Developers", "License :: OSI Approved :: BSD License", "Operating System :: OS Independent", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Programming Language :: Python :: Implementation :: CPython", "Programming Language :: Python :: Implementation :: PyPy", "Topic :: Software Development :: Libraries :: Application Frameworks", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "##################\npyApp - SQLAlchemy\n##################\n\n*Let us handle the boring stuff!*\n\n.. image:: https://img.shields.io/badge/code%20style-black-000000.svg\n :target: https://github.com/ambv/black\n :alt: Once you go Black...\n\n.. image:: https://api.codeclimate.com/v1/badges/0a86755f39f0416fbd1e/maintainability\n :target: https://codeclimate.com/github/pyapp-org/pae.sqlalchemy/maintainability\n :alt: Maintainability\n\nThis extension provides a `Connection` and `Session` factory for SQLAlchemy to\nallow database connections to be configured via pyApp settings. \n\n`Engine` instances are created from a singleton factory to ensure that \nconnection pooling is utilised.\n\nThe extension also provides checks to confirm the settings are correct and\nthat the application is able to connect to the database host.\n\n\nInstallation\n============\n\nInstall using *pip*::\n\n pip install pyapp-sqlalchemy\n\nInstall using *pipenv*::\n\n pipenv install pyapp-sqlalchemy\n\n\nAdd `pyapp_ext.sqlalchemy` into the `EXT` list in your applications\n`default_settings.py`.\n\nAdd the `DATABASE_ENGINES` block into your runtime settings file::\n\n DATABASE_ENGINES = {\n \"default\": {\n \"url\": \"postgres://user:pass@host:port/database\",\n },\n }\n\n\n.. note::\n\n The URI is a defined by SQLAlchemy see the\n `documentation `_. In addition to\n the url any argument that can be provided to `sqlalchemy.engines.create_engine` can be\n provided.\n\n\nUsage\n=====\n\nThe following example creates both `Connection` and `Session` instances::\n\n from pyapp_ext.sqlalchemy import get_connection, get_session\n\n # Get connection from default connection pool\n cnn = get_connection()\n\n # Get connection from an alternate pool\n session = get_session(\"Alternate\")\n\n\nAPI\n===\n\n`pyapp_ext.sqlalchemy.get_engine(default: str = None) -> Engine`\n\n Get named `Engine` instance (singleton)\n\n\n`pyapp_ext.sqlalchemy.get_connection(default: str = None) -> Connection`\n\n Get named `Connection` instance.\n\n\n`pyapp_ext.sqlalchemy.get_raw_connection(default: str = None)`\n\n Get named *raw* connection, this is the underlying Python DBAPI object.\n\n\n`pyapp_ext.sqlalchemy.get_session(default: str = None) -> Session`\n\n Get named `Session` instance.\n\n\n", "description_content_type": "text/x-rst", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/pyapp-org/pyapp.sqlalchemy", "keywords": "application,framework", "license": "BSD-3-Clause", "maintainer": "", "maintainer_email": "", "name": "pyApp-SQLAlchemy", "package_url": "https://pypi.org/project/pyApp-SQLAlchemy/", "platform": "any", "project_url": "https://pypi.org/project/pyApp-SQLAlchemy/", "project_urls": { "Homepage": "https://github.com/pyapp-org/pyapp.sqlalchemy" }, "release_url": "https://pypi.org/project/pyApp-SQLAlchemy/1.0.1/", "requires_dist": [ "pyapp (>=4.0)", "sqlalchemy", "docutils ; extra == 'dev'", "black ; extra == 'dev'" ], "requires_python": ">=3.6", "summary": "SQLAlchemy Extension for PyApp", "version": "1.0.1" }, "last_serial": 5629535, "releases": { "1.0": [ { "comment_text": "", "digests": { "md5": "81145b494e0e55023a8d4885f6fcdfb8", "sha256": "c46f542e86e8723e34a1a8cdfa62355c3d272d1e4f872a6e3e6b4486484ca403" }, "downloads": -1, "filename": "pyApp_SQLAlchemy-1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "81145b494e0e55023a8d4885f6fcdfb8", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 7022, "upload_time": "2019-06-29T15:45:31", "url": "https://files.pythonhosted.org/packages/36/f4/961da67fd848dc34f876d7c2cce05bde042933f0032e333c203e8080d1fb/pyApp_SQLAlchemy-1.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "16f482ce5c1e96b8da3a3153455e3233", "sha256": "94aed538bb98ed88c95e35b2fe00c542b6cd955fd6a4ae168a697e78ba97681d" }, "downloads": -1, "filename": "pyApp-SQLAlchemy-1.0.tar.gz", "has_sig": false, "md5_digest": "16f482ce5c1e96b8da3a3153455e3233", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 3967, "upload_time": "2019-06-29T15:45:33", "url": "https://files.pythonhosted.org/packages/f8/a2/4c24318af349083128d3740c182ebe7ac2e944baf8099a23d24dd79b50a7/pyApp-SQLAlchemy-1.0.tar.gz" } ], "1.0.1": [ { "comment_text": "", "digests": { "md5": "ac97458c3fca2ac5ef1743e0fe45b257", "sha256": "fa42a92c735286321005b46af3594a9d7662197fe303d3835a8f6fd701a2d14e" }, "downloads": -1, "filename": "pyApp_SQLAlchemy-1.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "ac97458c3fca2ac5ef1743e0fe45b257", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 8601, "upload_time": "2019-07-01T01:38:06", "url": "https://files.pythonhosted.org/packages/fe/bf/af42fd4524d71a83138a0edf1148596fefb97c61ae70a0f397f0cffb32fc/pyApp_SQLAlchemy-1.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "809878c28afd86ee75353dd45578c82f", "sha256": "f97df5094ec8a4d8c67b09ad5fa5bf0950552ddaee467a1ed1ceb4ded4c5612e" }, "downloads": -1, "filename": "pyApp-SQLAlchemy-1.0.1.tar.gz", "has_sig": false, "md5_digest": "809878c28afd86ee75353dd45578c82f", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 4005, "upload_time": "2019-07-01T01:38:08", "url": "https://files.pythonhosted.org/packages/24/89/77cbc08b32301b62fc28a94cd8b9347e206cfa785fe06e8ea0ad270d74ce/pyApp-SQLAlchemy-1.0.1.tar.gz" } ], "1.0b1": [ { "comment_text": "", "digests": { "md5": "0246d3c29e836de1be9778016230a2ab", "sha256": "52fe6c55d56510c6bc1168c55614f874c4b1047facf130acd0b89d2fb1126aaf" }, "downloads": -1, "filename": "pyApp_SQLAlchemy-1.0b1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "0246d3c29e836de1be9778016230a2ab", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=3.6", "size": 4929, "upload_time": "2019-05-29T14:12:38", "url": "https://files.pythonhosted.org/packages/1c/3a/9c6b5c747ff27de5dd4c4f2b331cb6ab8d06467e817a453b9a0a8002bfb0/pyApp_SQLAlchemy-1.0b1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "707e402129bb86af21f800cf29f3fc95", "sha256": "cc58201a83ee32e54f7a979eb6ba4685c86036a6960fd4d421ea78c62e5dad3c" }, "downloads": -1, "filename": "pyApp-SQLAlchemy-1.0b1.tar.gz", "has_sig": false, "md5_digest": "707e402129bb86af21f800cf29f3fc95", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 3873, "upload_time": "2019-05-29T14:12:40", "url": "https://files.pythonhosted.org/packages/17/70/041e079179390304943d3e04581d2b0dd77052b7dd45fedff4be6c939edf/pyApp-SQLAlchemy-1.0b1.tar.gz" } ], "1.0b2": [ { "comment_text": "", "digests": { "md5": "a1d1599b24cf22c0d4ae820013e440c5", "sha256": "24a71f71034d210461daef6cb578304747051f79a01d0aeb9eefae74553b3612" }, "downloads": -1, "filename": "pyApp_SQLAlchemy-1.0b2-py3-none-any.whl", "has_sig": false, "md5_digest": "a1d1599b24cf22c0d4ae820013e440c5", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 7046, "upload_time": "2019-06-21T14:33:25", "url": "https://files.pythonhosted.org/packages/f9/68/faa0f19bf67d9109ab9cb9908fade610c531a25d16b0ad74dc3d429a99d8/pyApp_SQLAlchemy-1.0b2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "f8564aa3e6b92a52557a13cafa1e70e5", "sha256": "819ce91831b69991cf6cc3baf5546f3bbfea9c5a3da765bf2934bbfe47f4eb06" }, "downloads": -1, "filename": "pyApp-SQLAlchemy-1.0b2.tar.gz", "has_sig": false, "md5_digest": "f8564aa3e6b92a52557a13cafa1e70e5", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 3967, "upload_time": "2019-06-21T14:33:27", "url": "https://files.pythonhosted.org/packages/d9/fc/ee2358a077b7e0fc7379cfc3556eb86d3679bccc53e193b9966516d79206/pyApp-SQLAlchemy-1.0b2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "ac97458c3fca2ac5ef1743e0fe45b257", "sha256": "fa42a92c735286321005b46af3594a9d7662197fe303d3835a8f6fd701a2d14e" }, "downloads": -1, "filename": "pyApp_SQLAlchemy-1.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "ac97458c3fca2ac5ef1743e0fe45b257", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 8601, "upload_time": "2019-07-01T01:38:06", "url": "https://files.pythonhosted.org/packages/fe/bf/af42fd4524d71a83138a0edf1148596fefb97c61ae70a0f397f0cffb32fc/pyApp_SQLAlchemy-1.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "809878c28afd86ee75353dd45578c82f", "sha256": "f97df5094ec8a4d8c67b09ad5fa5bf0950552ddaee467a1ed1ceb4ded4c5612e" }, "downloads": -1, "filename": "pyApp-SQLAlchemy-1.0.1.tar.gz", "has_sig": false, "md5_digest": "809878c28afd86ee75353dd45578c82f", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 4005, "upload_time": "2019-07-01T01:38:08", "url": "https://files.pythonhosted.org/packages/24/89/77cbc08b32301b62fc28a94cd8b9347e206cfa785fe06e8ea0ad270d74ce/pyApp-SQLAlchemy-1.0.1.tar.gz" } ] }