Vertica dialect for sqlalchemy using vertica_python
Project description
Vertica dialect for sqlalchemy. Forked from the Vertica ODBC dialect, written by James Casbon.
This module implements a Vertica dialect for SQLAlchemy using the pure-Python DB-API driver vertica-python, as adapted by Luke Emery-Fertitta.
It is currently maintained by BlueLabs - PRs are welcome!
Engine creation:
import sqlalchemy as sa
sa.create_engine('vertica+vertica_python://user:pwd@host:port/database')
Installation
From PyPI:
pip install sqlalchemy-vertica-python
From git:
git clone https://github.com/bluelabsio/vertica-sqlalchemy-python cd vertica-sqlalchemy-python python setup.py install
Usage
ID/Primary Key Declaration
Do not use this. The INSERT will fail as it will try to insert the ID
id = Column(Integer, primary_key=True)
Do the following instead
id = Column(Integer, Sequence(‘user_id_seq’), primary_key=True)
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
Built Distribution
Close
Hashes for sqlalchemy-vertica-python-0.5.9.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 486176a88c733029143ffcbcc1e2683f87e1539ea92b8a2198d257b3db990866 |
|
MD5 | 804d54dd57618a90b01bdb590baa269c |
|
BLAKE2b-256 | 888c2af19275ca88d576b5e2ddf4e624f45b77506a360aaf91f63e4a09233722 |
Close
Hashes for sqlalchemy_vertica_python-0.5.9-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9e182e5e6f4381e523f8a97ca8d7fba177a2ae7b840dc70bdd747bfe02bcd57c |
|
MD5 | 2db873d1cbcd60af05a3896231cea08e |
|
BLAKE2b-256 | f4dbef9e1ebbcf88b04925ab90c6b2fe93a8fc1b0143b8ec74ff9c833eaaa576 |