Skip to main content

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

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

sqlalchemy_vertica-0.0.5-py3-none-any.whl (7.8 kB view details)

Uploaded Python 3

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

Hashes for sqlalchemy_vertica-0.0.5-py3-none-any.whl
Algorithm Hash digest
SHA256 5ae456e2bb918db01fec63527ef3b93c6e56b86671337b289f225012cd1ed8f4
MD5 51553e9fca7de0ac167f793958b11ece
BLAKE2b-256 ea2c23b77693eda9b687f49bc89ed733f4b63630fbdf7d8fa56fa8e6189baf07

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page