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.
Filename, size | File type | Python version | Upload date | Hashes |
---|---|---|---|---|
Filename, size sqlalchemy_vertica_python-0.5.10-py3-none-any.whl (6.7 kB) | File type Wheel | Python version py3 | Upload date | Hashes View |
Filename, size sqlalchemy-vertica-python-0.5.10.tar.gz (6.0 kB) | File type Source | Python version None | Upload date | Hashes View |
Close
Hashes for sqlalchemy_vertica_python-0.5.10-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9a72e8f88cc96cdb2eff10c37fc4192d036db7909b3ad934f829c7509f012d73 |
|
MD5 | 494cb39344f441eeeb8b242a9f58f0b0 |
|
BLAKE2-256 | 0f0e463ecfcc60408eab26327709078fccd5eac41fe9238c4e3a05b0ea30c2b3 |
Close
Hashes for sqlalchemy-vertica-python-0.5.10.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 993c5fa3ed7ac0c8475de73ddb751271ba1515a402ede523cc58ee12ea47cf83 |
|
MD5 | 97541e2c5ea6c4d63ecfbb59ff9b50e5 |
|
BLAKE2-256 | a29343c5ec9fe7f9a86790a4be61fa673d0b5b655798b2ee6e659938c6ca8b61 |