{ "info": { "author": "Emmanuel Bavoux", "author_email": "emmanuel.bavoux@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "License :: OSI Approved :: Apache Software License", "Operating System :: OS Independent", "Programming Language :: Python :: 3" ], "description": "# SQL Alchemy Plus\n\nThis package provide additional package definition for SqlAlchemy\nthat are specific for PostgreSQL and other database.\n\nHere are the currently supported features (database supported):\n* View (PostgreSQL)\n* Materialized View (PostgreSQL)\n\n\n## Installation\n\nInstall SQL Alchemy Plus using pip\n\n```bash\npip install sqlalchemyplus\n```\n\n## Quick start\n\n**Define a View or a Materialized View programmatically**\n\n```\nfrom sqlalchemy import Table, select, Column, MetaData, Integer, String\nfrom sqlalchemyplus import View\n\nmetadata = MetaData()\ntable = Table('mytable',\n metadata,\n Column('key', Integer),\n Column('value', String))\n\nselect_table = table.select()\nview = View(\n 'myview',\n metadata,\n select_table\n)\n\n```\n\n**Create and drop a view**\n\n```\nfrom sqlalchemy import create_engine\nfrom sqlalchemyplus import CreateView, DropView\n\nengine = create_engine(\"postgresql://example:example@localhost:5432/mydatabase\")\n\nview = View(\n 'myview',\n metadata,\n select_table\n)\n\n# Execute 'CREATE VIEW myview AS (...)'\nengine.execute(CreateView(view))\n\n# Execute 'DROP VIEW myview'\nengine.execute(CreateView(view))\n```\n\n\n", "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/opus-42/sqlalchemy-plus", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "sqlalchemy-plus", "package_url": "https://pypi.org/project/sqlalchemy-plus/", "platform": "", "project_url": "https://pypi.org/project/sqlalchemy-plus/", "project_urls": { "Homepage": "https://github.com/opus-42/sqlalchemy-plus" }, "release_url": "https://pypi.org/project/sqlalchemy-plus/0.2.0/", "requires_dist": [ "sqlalchemy (>=1.3.0)" ], "requires_python": "", "summary": "Create Views and Materialized Views with SqlAlchemy", "version": "0.2.0" }, "last_serial": 5427373, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "6a51caf797b3d854144e0668a0dab23b", "sha256": "d16f6e877e14a02eb654f751f7dccdcfc5ec61947e6e8ad6b0726fde13bc419a" }, "downloads": -1, "filename": "sqlalchemy_plus-0.1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "6a51caf797b3d854144e0668a0dab23b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 9875, "upload_time": "2019-05-21T12:11:45", "url": "https://files.pythonhosted.org/packages/b6/49/979109a6643df5727fec2d9734245852dd35d9244712982968cfa0ce5ab7/sqlalchemy_plus-0.1.0-py3-none-any.whl" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "92c2995b5730d58b4eee902b09a54d74", "sha256": "b2620d2ea572371dafc118f733accbc5660a605bf7acdc4d9b16bb6c89780561" }, "downloads": -1, "filename": "sqlalchemy_plus-0.1.1-py3-none-any.whl", "has_sig": false, "md5_digest": "92c2995b5730d58b4eee902b09a54d74", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 10013, "upload_time": "2019-05-22T12:04:41", "url": "https://files.pythonhosted.org/packages/9a/45/a7243d7787bbd5d016b9c80d1bf25e4cc80e6a941b6f89227b4177ff98b1/sqlalchemy_plus-0.1.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "5d08b306455f45096c5e7f17bd538622", "sha256": "455545ed7eb89f8024a7252715219533567273d1cff5c18ce57551c6ff9e450a" }, "downloads": -1, "filename": "sqlalchemy-plus-0.1.1.tar.gz", "has_sig": false, "md5_digest": "5d08b306455f45096c5e7f17bd538622", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4611, "upload_time": "2019-05-22T12:04:43", "url": "https://files.pythonhosted.org/packages/b3/30/efd9dcf936148e138e748495949846bf729742d0e4ce4fe4a046842f1372/sqlalchemy-plus-0.1.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "2602a8e8433846c56a6e11172407a7f9", "sha256": "e4df9e5837d879184866a1159000ca915b6f25f365498b7a8a2808f2a7e1d2f7" }, "downloads": -1, "filename": "sqlalchemy_plus-0.1.2-py3-none-any.whl", "has_sig": false, "md5_digest": "2602a8e8433846c56a6e11172407a7f9", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 10020, "upload_time": "2019-05-22T12:09:40", "url": "https://files.pythonhosted.org/packages/cb/86/168130e05849d50ff3f58bc85a0e6b18d10235da1a930dc60d40241b8d2d/sqlalchemy_plus-0.1.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "61623169969415bc207b3ff02016187c", "sha256": "9eb1f5402bf16be598c0dc3d93974040de4f4706e25f346cd98cd291ae256c63" }, "downloads": -1, "filename": "sqlalchemy-plus-0.1.2.tar.gz", "has_sig": false, "md5_digest": "61623169969415bc207b3ff02016187c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4615, "upload_time": "2019-05-22T12:09:42", "url": "https://files.pythonhosted.org/packages/7b/a7/f33662b336641cabd18ea9011e0a498bcb651fdc8ae59fe02983444cf506/sqlalchemy-plus-0.1.2.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "e7bfee21142e8b119ab2bb71bf0b981b", "sha256": "6f8d876c766e728e01c500fd6f2161226aec9c8d88fa2ce422f2fff39d29cc25" }, "downloads": -1, "filename": "sqlalchemy_plus-0.2.0-py3-none-any.whl", "has_sig": false, "md5_digest": "e7bfee21142e8b119ab2bb71bf0b981b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 10129, "upload_time": "2019-06-20T19:34:08", "url": "https://files.pythonhosted.org/packages/51/3a/d96cfa08e2cb6640bd51a62d1d659967c735ee73b8e5aecb500d52cd0d43/sqlalchemy_plus-0.2.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d7850d882a94ed766fc42572604bb152", "sha256": "9ddc0ebcc81bc6363fe402e7e4626ad0f112ad0cf46c520cbf9253bd1ca44d3b" }, "downloads": -1, "filename": "sqlalchemy-plus-0.2.0.tar.gz", "has_sig": false, "md5_digest": "d7850d882a94ed766fc42572604bb152", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4724, "upload_time": "2019-06-20T19:34:12", "url": "https://files.pythonhosted.org/packages/2f/11/2d3b7c0b5f1ea40bca25e2c3f3eaa926fd2d3bf3ea8e5d576101fbc23d38/sqlalchemy-plus-0.2.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "e7bfee21142e8b119ab2bb71bf0b981b", "sha256": "6f8d876c766e728e01c500fd6f2161226aec9c8d88fa2ce422f2fff39d29cc25" }, "downloads": -1, "filename": "sqlalchemy_plus-0.2.0-py3-none-any.whl", "has_sig": false, "md5_digest": "e7bfee21142e8b119ab2bb71bf0b981b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 10129, "upload_time": "2019-06-20T19:34:08", "url": "https://files.pythonhosted.org/packages/51/3a/d96cfa08e2cb6640bd51a62d1d659967c735ee73b8e5aecb500d52cd0d43/sqlalchemy_plus-0.2.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d7850d882a94ed766fc42572604bb152", "sha256": "9ddc0ebcc81bc6363fe402e7e4626ad0f112ad0cf46c520cbf9253bd1ca44d3b" }, "downloads": -1, "filename": "sqlalchemy-plus-0.2.0.tar.gz", "has_sig": false, "md5_digest": "d7850d882a94ed766fc42572604bb152", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4724, "upload_time": "2019-06-20T19:34:12", "url": "https://files.pythonhosted.org/packages/2f/11/2d3b7c0b5f1ea40bca25e2c3f3eaa926fd2d3bf3ea8e5d576101fbc23d38/sqlalchemy-plus-0.2.0.tar.gz" } ] }