Skip to main content

Vertica dialect for sqlalchemy

This module implements a Vertica dialect for SQLAlchemy. You can use it:

>>> import sqlalchemy as sa
>>> sa.create_engine(sa.engine.url.URL(
    drivername='vertica+pyodbc',
    username='myusername',
    password='mypassword',
    host='hostname',
    database='dbname',
))

This work is mainly a package of code [posted](https://groups.google.com/d/msg/sqlalchemy/ttJzN-t9R74/9W1d9KfHK_0J) to the SQLAlchemy mailing list by ‘Bo’ (Google groups won’t let me see the original author).

I have tested this for table introspection, selects and joins. However, I do not have access to a Vertica database to test against. If you do, let me know.

The primary, foreign and index constraints return nothing. This is because I’m told these are ‘enforced on select’. Maybe a Vertica expert can tell me the correct way to handle this.

Installation

With pip

pip install vertica-sqlalchemy

From git:

git clone https://github.com/jamescasbon/vertica-sqlalchemy cd vertica-sqlalchemy python setup.py install

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

vertica-sqlalchemy-0.13.tar.gz (3.4 kB view details)

Uploaded Source

File details

Details for the file vertica-sqlalchemy-0.13.tar.gz.

File metadata

File hashes

Hashes for vertica-sqlalchemy-0.13.tar.gz
Algorithm Hash digest
SHA256 a94280e3914cd1058211b801990a53fe6e41edcdcea672b4dcd021816cb5363a
MD5 4da8b52fea858dd5cca756375b1eddc4
BLAKE2b-256 45be10b23333c6cfa04f439c5b1d1cb9dde21a9a0480d5c6748fcef729766149

See more details on using hashes here.

Release history Release notifications | RSS feed

This release

0.13 This release

1 file

0.1

1 file

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page