Vertica dialect for sqlalchemy
Project description
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.
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Hashes for sqlalchemy-vertica-dialect-0.0.6.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | d071e0578b47b3858ff9460b0ae2cbda3320e338c56413ad8a17a5ee2c3aeb5c |
|
MD5 | aad87e6e6e8395efd9c2f3b6a4900c90 |
|
BLAKE2b-256 | 2ba9064af4d09e9ff36a62ebfc600e2082f8b91aaeea5d0b4e1c505c210904f2 |