Vertica dialect for sqlalchemy
Project description
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
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distribution
File details
Details for the file sqlalchemy_vertica-0.0.5-py3-none-any.whl
.
File metadata
- Download URL: sqlalchemy_vertica-0.0.5-py3-none-any.whl
- Upload date:
- Size: 7.8 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.1.1 pkginfo/1.5.0.1 requests/2.22.0 setuptools/39.0.1 requests-toolbelt/0.9.1 tqdm/4.42.0 CPython/3.6.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5ae456e2bb918db01fec63527ef3b93c6e56b86671337b289f225012cd1ed8f4 |
|
MD5 | 51553e9fca7de0ac167f793958b11ece |
|
BLAKE2b-256 | ea2c23b77693eda9b687f49bc89ed733f4b63630fbdf7d8fa56fa8e6189baf07 |