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.6.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 90faf1b0ac9b979a6994ab9b5a425159aefd71d6409910b28b3c362e9582ee2e |
|
MD5 | bf42e46bdee3c11eb2b834c865719a13 |
|
BLAKE2b-256 | bbfb3c24704b5f6b51e3e4cbcd9edf245372598a9866461a8c4211bdc752befd |
Close
Hashes for sqlalchemy_vertica_python-0.5.6-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 18fd4779f6ff386b19501e7deaee634ff549831af43647d615ff6aa88ba997af |
|
MD5 | c3041f87876ac84487bb1b54b9ad98c0 |
|
BLAKE2b-256 | 3894ad4c2fa0d5ac0e25ac4928c38563dacc97d57c2f47e67f3eb5180c68313c |