{ "info": { "author": "Jeff Klukas", "author_email": "jeff@klukas.net", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Environment :: Console", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Natural Language :: English", "Operating System :: OS Independent", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: Implementation :: PyPy", "Programming Language :: SQL", "Topic :: Database", "Topic :: Database :: Database Engines/Servers", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "View Manipulation for SQLAlchemy\n================================\n\nAdds `CreateView` and `DropView` constructs to SQLAlchemy.\n\nStatus\n------\n\nCurrent version is 0.2.3; releases are infrequent as the code here is small and based on stable pieces of the SQLAlchemy API, so there has been no maintenance required so far to keep compatibility with new SQLAlchemy or python versions.\n\nAs of early 2019, this package is still working with latest Python and SQLAlchemy.\n\nUsage\n-----\n\nExamples:\n\n >>> from sqlalchemy import Table, MetaData\n >>> from sqlalchemy.sql import text\n >>> from sqlalchemy_views import CreateView, DropView\n\n >>> view = Table('my_view', MetaData())\n >>> definition = text(\"SELECT * FROM my_table\")\n >>> create_view = CreateView(view, definition)\n >>> print(str(create_view.compile()).strip())\n CREATE VIEW my_view AS SELECT * FROM my_table\n\n >>> create_view = CreateView(view, definition, or_replace=True)\n >>> print(str(create_view.compile()).strip())\n CREATE OR REPLACE VIEW my_view AS SELECT * FROM my_table\n\n >>> drop_view = DropView(view)\n >>> print(str(drop_view.compile()).strip())\n DROP VIEW my_view\n\n >>> drop_view = DropView(view, if_exists=True, cascade=True)\n >>> print(str(drop_view.compile()).strip())\n DROP VIEW IF EXISTS my_view CASCADE\n\nNote that the SQLAlchemy ``Table`` object is used to represent\nboth tables and views. To introspect a view, create a ``Table``\nwith ``autoload=True``, and then use SQLAlchemy's\n``get_view_definition`` method to generate the second\nargument to ``CreateView``.\n\n\nInstallation\n------------\n\n``sqlalchemy-views`` is available on PyPI and can be installed via ``pip`` ::\n\n pip install sqlalchemy-views\n\n\nLimitations\n-----------\n\nVarious SQL dialects have developed custom\n`CREATE VIEW` and `DROP VIEW` syntax.\nThis project aims to provide the core set of functionality\nshared by most database engines.\n\n\nAcknowledgements\n----------------\n\nSome design ideas taken from the\n`SQLAlchemy Usage Recipe for views `_.\n\nPackage structure is based on\n`python-project-template `_.\n\n\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/jklukas/sqlalchemy-views", "keywords": "", "license": "", "maintainer": "Jeff Klukas", "maintainer_email": "jeff@klukas.net", "name": "sqlalchemy-views", "package_url": "https://pypi.org/project/sqlalchemy-views/", "platform": "", "project_url": "https://pypi.org/project/sqlalchemy-views/", "project_urls": { "Homepage": "https://github.com/jklukas/sqlalchemy-views" }, "release_url": "https://pypi.org/project/sqlalchemy-views/0.2.3/", "requires_dist": [ "sqlalchemy (>=1.0.0)" ], "requires_python": "", "summary": "Adds CreateView and DropView constructs to SQLAlchemy", "version": "0.2.3" }, "last_serial": 5203007, "releases": { "0.2": [], "0.2.1": [ { "comment_text": "", "digests": { "md5": "8a4254a21e51f9fdecdc6f90f2353f54", "sha256": "91b4760abd1f4693c15dcf8dd51bd16c3fa3dbed364613af1458a4eaa37817e5" }, "downloads": -1, "filename": "sqlalchemy_views-0.2.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "8a4254a21e51f9fdecdc6f90f2353f54", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9298, "upload_time": "2015-09-16T14:46:48", "url": "https://files.pythonhosted.org/packages/84/da/cf4513d0e5fcb4f9b9515d3ce941e77cd611b5765720311e98cfcb807a0b/sqlalchemy_views-0.2.1-py2.py3-none-any.whl" } ], "0.2.2": [ { "comment_text": "", "digests": { "md5": "a88cd5fd9d93233684edd25e302d05cc", "sha256": "82e6df12a71c9db30247bdb88c190170adde4acd1ccf2d997656a52e7da94c5a" }, "downloads": -1, "filename": "sqlalchemy_views-0.2.2-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "a88cd5fd9d93233684edd25e302d05cc", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 4318, "upload_time": "2018-11-13T16:08:46", "url": "https://files.pythonhosted.org/packages/de/bb/2bdd883ac43f78ccbbb7a23df0bbbfe435f8fd8ef179cffdde6785af61d8/sqlalchemy_views-0.2.2-py2.py3-none-any.whl" } ], "0.2.3": [ { "comment_text": "", "digests": { "md5": "94df039b44842de56ed2bbc2a208f4c3", "sha256": "d6a96b2a1db3ccd85d33659fa05d6ac1ad8541abd93037a5c74ec4f96d26a7b4" }, "downloads": -1, "filename": "sqlalchemy_views-0.2.3-py3-none-any.whl", "has_sig": false, "md5_digest": "94df039b44842de56ed2bbc2a208f4c3", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5142, "upload_time": "2019-04-29T12:51:17", "url": "https://files.pythonhosted.org/packages/4e/95/67439d4c297e1d0b89cc9a250898e316d621b07b602beed48a81c1606e96/sqlalchemy_views-0.2.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d41ef1a34ce1ba7f1693908a83fb055e", "sha256": "08fe3f850f3ee2f89e1b909ae1f1a56c847cd55488241981f1f8532b282e6e3e" }, "downloads": -1, "filename": "sqlalchemy-views-0.2.3.tar.gz", "has_sig": false, "md5_digest": "d41ef1a34ce1ba7f1693908a83fb055e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17524, "upload_time": "2019-04-29T12:51:22", "url": "https://files.pythonhosted.org/packages/a5/ed/44a5e96cbfcdd35dcfff73cc5ca0ced7cd87fff0f5bdccf4ad061851e4a2/sqlalchemy-views-0.2.3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "94df039b44842de56ed2bbc2a208f4c3", "sha256": "d6a96b2a1db3ccd85d33659fa05d6ac1ad8541abd93037a5c74ec4f96d26a7b4" }, "downloads": -1, "filename": "sqlalchemy_views-0.2.3-py3-none-any.whl", "has_sig": false, "md5_digest": "94df039b44842de56ed2bbc2a208f4c3", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5142, "upload_time": "2019-04-29T12:51:17", "url": "https://files.pythonhosted.org/packages/4e/95/67439d4c297e1d0b89cc9a250898e316d621b07b602beed48a81c1606e96/sqlalchemy_views-0.2.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d41ef1a34ce1ba7f1693908a83fb055e", "sha256": "08fe3f850f3ee2f89e1b909ae1f1a56c847cd55488241981f1f8532b282e6e3e" }, "downloads": -1, "filename": "sqlalchemy-views-0.2.3.tar.gz", "has_sig": false, "md5_digest": "d41ef1a34ce1ba7f1693908a83fb055e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17524, "upload_time": "2019-04-29T12:51:22", "url": "https://files.pythonhosted.org/packages/a5/ed/44a5e96cbfcdd35dcfff73cc5ca0ced7cd87fff0f5bdccf4ad061851e4a2/sqlalchemy-views-0.2.3.tar.gz" } ] }