Vertica dialect for sqlalchemy using vertica_python
Project description
Vertica dialect for sqlalchemy. Forked from the Vertica ODBC dialect.
This module implements a Vertica dialect for SQLAlchemy using vertica-python. 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/LocusEnergy/vertica-sqlalchemy cd vertica-sqlalchemy 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.4.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | ba69c86f2df75623c469ccb4faba506388de839456aff157b7c939533e489a6e |
|
MD5 | 0053e588c9383cd8cf4470e109295713 |
|
BLAKE2b-256 | 2ddb824ae7be5d87848e7fba9271089d9381253d7cd2641a50f4d630d6076d6f |
Close
Hashes for sqlalchemy_vertica_python-0.5.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cdbef8d99b7ff87a3fe018901f07c1ed92a5596bb6349bf68e3cc76e169ab6f2 |
|
MD5 | 8af2e27aca05cd307b106e3bbada376f |
|
BLAKE2b-256 | 7ad349395e53a51ed1ffbd60472d86e5c1494f3da89f6aa8a12fecb3290bac03 |