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)
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
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file sqlalchemy-vertica-python-0.5.8.tar.gz.
File metadata
- Download URL: sqlalchemy-vertica-python-0.5.8.tar.gz
- Upload date:
- Size: 5.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.1.1 pkginfo/1.5.0.1 requests/2.23.0 setuptools/40.6.2 requests-toolbelt/0.9.1 tqdm/4.43.0 CPython/3.6.10
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
4307fd2db3a0dd2bba3245ad42ea3479189949c3790de19559e515ead893a417
|
|
| MD5 |
9859c7d3213cb5742bab408f8a04aad8
|
|
| BLAKE2b-256 |
3be05e96fabeab817395c38b642bb8b37efeab889c0cc70050720c9e89606fab
|
File details
Details for the file sqlalchemy_vertica_python-0.5.8-py3-none-any.whl.
File metadata
- Download URL: sqlalchemy_vertica_python-0.5.8-py3-none-any.whl
- Upload date:
- Size: 6.6 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.1.1 pkginfo/1.5.0.1 requests/2.23.0 setuptools/40.6.2 requests-toolbelt/0.9.1 tqdm/4.43.0 CPython/3.6.10
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
09af310baf58237bbd342d382d1484a804b3e160de91979871d8593fea7448a7
|
|
| MD5 |
d449b282a8bd6f6b716fcb8455711d51
|
|
| BLAKE2b-256 |
f4994800bca6ffaf31b0305e4e9ff4f72d9fbe3949ec455ea5ab5be056d5acd2
|
