{ "info": { "author": "LyuGGang", "author_email": "me@lyuwonkyung.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Environment :: Console", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5" ], "description": "sqlalchemy-redshift\n===================\n\nAmazon Redshift dialect for SQLAlchemy.\n\n.. image:: https://travis-ci.org/sqlalchemy-redshift/sqlalchemy-redshift.svg?branch=master\n :target: https://travis-ci.org/sqlalchemy-redshift/sqlalchemy-redshift\n :alt: Travis CI build status\n\nInstallation\n------------\n\nThe package is available on PyPI::\n\n pip install sqlalchemy-redshift\n\nUsage\n-----\nThe DSN format is similar to that of regular Postgres::\n\n >>> import sqlalchemy as sa\n >>> sa.create_engine('redshift+psycopg2://username@host.amazonaws.com:5439/database')\n Engine(redshift+psycopg2://username@host.amazonaws.com:5439/database)\n\nSee the `RedshiftDDLCompiler documentation\n`_\nfor details on Redshift-specific features the dialect supports.\n\n\n0.5.1 (unreleased)\n------------------\n\n- Support role-based access control in COPY and UNLOAD commands\n (`Issue #88 `_)\n- Increase max_identifier_length to 127 characters\n (`Issue #96 `_)\n- Fix a bug where table names containing a period caused an error on reflection\n (`Issue #97 `_)\n- Performance improvement for reflection by caching table constraint info\n (`Issue #101 `_)\n\n\n0.5.0 (2016-04-21)\n------------------\n\n- Support reflecting tables with foriegn keys to tables in non-public schemas\n (`Issue #70 `_)\n- Fix a bug where DISTKEY and SORTKEY could not be used on column names containing\n spaces or commas. This is a breaking behavioral change for a command like\n `__table_args__ = {'redshift_sortkey': ('foo, bar')}`. Previously, this would sort\n on the columns named `foo` and `bar`. Now, it sorts on the column named `foo, bar`.\n (`Issue #74 `_)\n\n\n0.4.0 (2015-11-17)\n------------------\n\n- Change the name of the package to `sqlalchemy_redshift` to match the naming\n convention for other dialects; the `redshift_sqlalchemy` package now emits\n a `DeprecationWarning` and references `sqlalchemy_redshift`.\n The `redshift_sqlalchemy` compatibility package will be removed\n in a future release.\n (`Issue #58 `_)\n- Fix a bug where reflected tables could have incorrect column order for some\n `CREATE TABLE` statements, particularly for columns with an `IDENTITY`\n constraint.\n (`Issue #60 `_)\n- Fix a bug where reflecting a table could raise a ``NoSuchTableError``\n in cases where its schema is not on the current ``search_path``\n (`Issue #64 `_)\n- Add python 3.5 to the list of versions for integration tests.\n (`Issue #61 `_)\n\n\n0.3.1 (2015-10-08)\n------------------\n\n- Fix breakages to CopyCommand introduced in 0.3.0:\n Thanks `solackerman `_.\n (`Issue #53 `_)\n\n - When `format` is omitted, no `FORMAT AS ...` is appended to the query. This\n makes the default the same as a normal redshift query.\n - fix STATUPDATE as a COPY parameter\n\n\n0.3.0 (2015-09-29)\n------------------\n\n- Fix view support to be more in line with SQLAlchemy standards.\n `get_view_definition` output no longer includes a trailing semicolon and\n views no longer raise an exception when reflected as `Table` objects.\n (`Issue #46 `_)\n- Rename RedShiftDDLCompiler to RedshiftDDLCompiler.\n (`Issue #43 `_)\n- Update commands\n (`Issue #52 `_)\n\n - Expose optional TRUNCATECOLUMNS in CopyCommand.\n - Add all other COPY parameters to CopyCommand.\n - Move commands to their own module.\n - Support inserts into ordered columns in CopyCommand.\n\n\n0.2.0 (2015-09-04)\n------------------\n\n- Use SYSDATE instead of NOW().\n Thanks `bouk `_.\n (`Issue #15 `_)\n- Default to SSL with hardcoded AWS Redshift CA.\n (`Issue #20 `_)\n- Refactor of CopyCommand including support for specifying format and\n compression type. (`Issue #21 `_)\n- Explicitly require SQLAlchemy >= 0.9.2 for 'dialect_options'.\n (`Issue #13 `_)\n- Refactor of UnloadFromSelect including support for specifying all documented\n redshift options.\n (`Issue #27 `_)\n- Fix unicode issue with SORTKEY on python 2.\n (`Issue #34 `_)\n- Add support for Redshift ``DELETE`` statements that refer other tables in\n the ``WHERE`` clause.\n Thanks `haleemur `_.\n (`Issue #35 `_)\n- Raise ``NoSuchTableError`` when trying to reflect a table that doesn't exist.\n (`Issue #38 `_)\n\n0.1.2 (2015-08-11)\n------------------\n\n- Register postgresql.visit_rename_table for redshift's\n alembic RenameTable.\n Thanks `bouk `_.\n (`Issue #7 `_)\n\n\n0.1.1 (2015-05-20)\n------------------\n\n- Register RedshiftImpl as an alembic 3rd party dialect.\n\n\n0.1.0 (2015-05-11)\n------------------\n\n- First version of sqlalchemy-redshift that can be installed from PyPI", "description_content_type": null, "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/LyuGGang/sqlalchemy-redshift", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "sqlalchemy-redshift-psycopg2cffi", "package_url": "https://pypi.org/project/sqlalchemy-redshift-psycopg2cffi/", "platform": "", "project_url": "https://pypi.org/project/sqlalchemy-redshift-psycopg2cffi/", "project_urls": { "Homepage": "https://github.com/LyuGGang/sqlalchemy-redshift" }, "release_url": "https://pypi.org/project/sqlalchemy-redshift-psycopg2cffi/0.5.1.dev1/", "requires_dist": null, "requires_python": "", "summary": "Amazon Redshift Dialect for sqlalchemy", "version": "0.5.1.dev1" }, "last_serial": 2584412, "releases": { "0.5.1.dev1": [ { "comment_text": "", "digests": { "md5": "aae6f2287a027f921be77723b14aa917", "sha256": "dcb9ebef140aa99d61fbb548cb38f8764baf49606e271e9e1c111ca06d56f479" }, "downloads": -1, "filename": "sqlalchemy-redshift-psycopg2cffi-0.5.1.dev1.tar.gz", "has_sig": false, "md5_digest": "aae6f2287a027f921be77723b14aa917", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 20967, "upload_time": "2017-01-19T08:42:46", "url": "https://files.pythonhosted.org/packages/ad/55/36de13a6545296f5881b16b96b0e7470f5733ea1de7b9a3bd0620f4b1152/sqlalchemy-redshift-psycopg2cffi-0.5.1.dev1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "aae6f2287a027f921be77723b14aa917", "sha256": "dcb9ebef140aa99d61fbb548cb38f8764baf49606e271e9e1c111ca06d56f479" }, "downloads": -1, "filename": "sqlalchemy-redshift-psycopg2cffi-0.5.1.dev1.tar.gz", "has_sig": false, "md5_digest": "aae6f2287a027f921be77723b14aa917", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 20967, "upload_time": "2017-01-19T08:42:46", "url": "https://files.pythonhosted.org/packages/ad/55/36de13a6545296f5881b16b96b0e7470f5733ea1de7b9a3bd0620f4b1152/sqlalchemy-redshift-psycopg2cffi-0.5.1.dev1.tar.gz" } ] }