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.5.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 73ec02e1680062f4038d9b5a2622f84b2ae3c243427a00f686d64d25cd7c22ff |
|
MD5 | 6f59c15baee67a661375484f4c95f696 |
|
BLAKE2b-256 | 021ddc11c88301329d279188b72f8fce6736793522e78a9ab99c52ae654d0959 |
Close
Hashes for sqlalchemy_vertica_python-0.5.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c2846704dc435ff4180c57bd95ac3df0ae45475fbec37e6462cee98a798cf9fd |
|
MD5 | aa285bed5d593b54b672cec00523e1f7 |
|
BLAKE2b-256 | 4d3ca1ca7621ea56945c777385ff4233175e23efd675b2fd8856406c5350f4ec |