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
Release files for sqlalchemy-vertica-python 0.6.3
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| sqlalchemy-vertica-python-0.6.3.tar.gz | 7.2 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| sqlalchemy_vertica_python-0.6.3-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 14.0 kB
Release files / sqlalchemy-vertica-python-0.6.3.tar.gz
| Download URL | sqlalchemy-vertica-python-0.6.3.tar.gz |
|---|---|
| Size | 7.2 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
5cbebb9875e59366b9e3b4791ef7c2a8e45dbe460fd27687f3dc742dc058a024
|
|
BLAKE2b-256 checksum How to use checksums |
e0fce52cac0df3d55a2b4d0b07d449ddf9600adcc35c5715b289e17114ad86c2
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.8.16
|
Release files / sqlalchemy_vertica_python-0.6.3-py3-none-any.whl
| Download URL | sqlalchemy_vertica_python-0.6.3-py3-none-any.whl |
|---|---|
| Size | 6.7 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
9f41c8d51f81bb00d9064cfe8facfda698667c105200f5d570d574696bcca4c9
|
|
BLAKE2b-256 checksum How to use checksums |
1b7fbc56d6d5dd40ead585529289505547f83322e1ba2cd4990bde534d2445c9
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.8.16
|
