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)
2 maintainers
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file sqlalchemy-vertica-python-0.4.4.tar.gz.
File metadata
- Download URL: sqlalchemy-vertica-python-0.4.4.tar.gz
- Upload date:
- Size: 4.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/1.11.0 pkginfo/1.4.2 requests/2.19.1 setuptools/39.0.1 requests-toolbelt/0.8.0 tqdm/4.26.0 CPython/3.7.0
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
53b51e735509468893f8707c0935675c9ed21757b853144beb2b9dd6cf7c3e8c
|
|
| MD5 |
f979d7b2f0e0c053bec2661a091a02bd
|
|
| BLAKE2b-256 |
97585e875039e24051dc86f7da1de6bb3df6d6ab956f0794bdc53749ac39860b
|
