Metadata-Version: 2.1
Name: sqlalchemy-vertica
Version: 0.0.4
Summary: Vertica dialect for sqlalchemy
Home-page: https://github.com/lv10/sqlalchemy-vertica
Author: Luis Villamarin
Author-email: luis@lv10.me
License: MIT
Download-URL: https://github.com/lv10/sqlalchemy-vertica/tarball/0.0.4
Platform: UNKNOWN
Requires-Dist: six (>=1.10.0)
Requires-Dist: sqlalchemy (>=1.1.11)
Provides-Extra: pyodbc
Requires-Dist: pyodbc (>=4.0.16) ; extra == 'pyodbc'
Provides-Extra: vertica-python
Requires-Dist: vertica-python (>=0.7.3) ; extra == 'vertica-python'

sqlalchemy-vertica
==================

Vertica dialect for sqlalchemy.

Forked from the `sqlalchemy-vertica repository <https://github.com/startappdev/sqlalchemy-vertica>`.
Unfortunately, sqlalchemy-vertica was removed from pypi. As of Sept 28, 2018 this version supports
querying views. This is version is not a state of the art, nor does it follow the principles
outlinedb by SQLAlchemy at:https://github.com/zzzeek/sqlalchemy/blob/master/README.dialects.rst.
However, I will slowly start upgrading the code base to meet standards and submit so that it
becomes an external dialect in SQLAlchemy. Anyone interested in helping is welcome to contribute
and/or submit issues/ideas.


.. code-block:: python

    import sqlalchemy as sa
    import urllib
    # for pyodbc connection
    sa.create_engine('vertica+pyodbc:///?odbc_connect=%s' % (urllib.quote('DSN=dsn'),))

    # for turbodbc connection
    sa.create_engine('vertica+turbodbc:///?DSN=dsn')

    # for vertica-python connection
    sa.create_engine('vertica+vertica_python://user:pwd@host:port/database')

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

From PyPI: ::

     pip install sqlalchemy-vertica[pyodbc,turbodbc,vertica-python]  # choose the relevant engines

From git: ::

     git clone https://github.com/startappdev/sqlalchemy-vertica
     cd sqlalchemy-vertica
     pip install pyodbc turbodbc vertica-python  # choose the relevant engines
     python setup.py install



