Vertica dialect for sqlalchemy
Project description
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
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
File details
Details for the file vertica-sqlalchemy-0.13.tar.gz
.
File metadata
- Download URL: vertica-sqlalchemy-0.13.tar.gz
- Upload date:
- Size: 3.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | a94280e3914cd1058211b801990a53fe6e41edcdcea672b4dcd021816cb5363a |
|
MD5 | 4da8b52fea858dd5cca756375b1eddc4 |
|
BLAKE2b-256 | 45be10b23333c6cfa04f439c5b1d1cb9dde21a9a0480d5c6748fcef729766149 |