Metadata-Version: 2.0
Name: sqlalchemy-redshift
Version: 0.2.0
Summary: Amazon Redshift Dialect for sqlalchemy
Home-page: https://github.com/graingert/redshift_sqlalchemy
Author: Thomas Grainger
Author-email: sqlalchemy-redshift@graingert.co.uk
License: MIT
Platform: UNKNOWN
Classifier: Development Status :: 4 - Beta
Classifier: Environment :: Console
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python
Requires-Dist: psycopg2 (>=2.5)
Requires-Dist: SQLAlchemy (>=0.9.2)

redshift_sqlalchemy
===================

Amazon Redshift dialect for SQLAlchemy.

.. image:: https://travis-ci.org/graingert/redshift_sqlalchemy.png?branch=master

Installation
------------

The package is available on PyPI::

    pip install sqlalchemy-redshift

Usage
-----
The DSN format is similar to that of regular Postgres::

    >>> import sqlalchemy as sa
    >>> sa.create_engine('redshift+psycopg2://username@host.amazonaws.com:5439/database')
    Engine(redshift+psycopg2://username@host.amazonaws.com:5439/database)

See the docstring for `RedshiftDDLCompiler` in
`dialect.py <redshift_sqlalchemy/dialect.py>`_ for more detail.



0.2.0 (2015-09-04)
------------------

- Use SYSDATE instead of NOW().
  Thanks `bouk <https://github.com/bouk>`_.
  (`Issue #15 <https://github.com/graingert/redshift_sqlalchemy/pull/15>`_)
- Default to SSL with hardcoded AWS Redshift CA.
  (`Issue #20 <https://github.com/graingert/redshift_sqlalchemy/pull/20>`_)
- Refactor of CopyCommand including support for specifying format and
  compression type. (`Issue #21 <https://github.com/graingert/redshift_sqlalchemy/pull/21>`_)
- Explicitly require SQLAlchemy >= 0.9.2 for 'dialect_options'.
  (`Issue #13 <https://github.com/graingert/redshift_sqlalchemy/pull/13>`_)
- Refactor of UnloadFromSelect including support for specifying all documented
  redshift options.
  (`Issue #27 <https://github.com/graingert/redshift_sqlalchemy/pull/27>`_)
- Fix unicode issue with SORTKEY on python 2.
  (`Issue #34 <https://github.com/graingert/redshift_sqlalchemy/pull/34>`_)
- Add support for Redshift ``DELETE`` statements that refer other tables in the ``WHERE``
  clause. (`Issue #35 <https://github.com/graingert/redshift_sqlalchemy/issues/35>`_).
  Thanks `haleemur <https://github.com/haleemur> _`.
- Raise ``NoSuchTableError`` when trying to reflect a table that doesn't exist.
  (`Issue #38 <https://github.com/graingert/redshift_sqlalchemy/issues/38>`_).

0.1.2 (2015-08-11)
------------------

- Register postgresql.visit_rename_table for redshift's
  alembic RenameTable.
  Thanks `bouk <https://github.com/bouk>`_.
  (`Issue #7 <https://github.com/graingert/redshift_sqlalchemy/pull/7>`_)


0.1.1 (2015-05-20)
------------------

- Register RedshiftImpl as an alembic 3rd party dialect.


0.1.0 (2015-05-11)
------------------

- First version of sqlalchemy-redshift that can be installed from PyPI


