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
Metadata
Release files for vertica-sqlalchemy 0.13
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| vertica-sqlalchemy-0.13.tar.gz | 3.4 kB | Details |
Release files / vertica-sqlalchemy-0.13.tar.gz
| Download URL | vertica-sqlalchemy-0.13.tar.gz |
|---|---|
| Size | 3.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
a94280e3914cd1058211b801990a53fe6e41edcdcea672b4dcd021816cb5363a
|
|
BLAKE2b-256 checksum How to use checksums |
45be10b23333c6cfa04f439c5b1d1cb9dde21a9a0480d5c6748fcef729766149
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |