Vertica dialect for sqlalchemy using vertica_python
Project Links
Meta
Author: James Casbon, Luke Emery-Fertitta
Maintainer: Vince Broz
Classifiers
Development Status
- 3 - Alpha
License
- OSI Approved :: MIT License
Programming Language
- Python :: 3.5
- Python :: 3.6
- Python :: 3.7
- Python :: 3.8
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)
0.6.3
Jun 05, 2023
0.5.10
Sep 16, 2020
0.5.9
Jun 09, 2020
0.5.8
Mar 19, 2020
0.5.7
Feb 21, 2020
0.5.6
Feb 20, 2020
0.5.5
Feb 20, 2020
0.5.4
Feb 20, 2020
0.4.4
Jan 10, 2019
0.4.3
Jan 02, 2019
0.4.2
Dec 21, 2018
0.4.1
Oct 26, 2018
0.4.0
Oct 18, 2018
0.3.5
Oct 15, 2018
0.3.4
Sep 17, 2018
0.3.3
Sep 14, 2018
0.3.2
Jul 19, 2018
0.3.1
Jun 11, 2018
0.3.0
Mar 29, 2018
0.2.2
Mar 27, 2018
0.2.1
Jan 17, 2018
0.2.0
Jan 17, 2018
0.1.3
Oct 04, 2016
0.1.2
Dec 30, 2015
0.1.1
Dec 30, 2015
0.1.0
Jul 31, 2015
0.0.0
Jul 31, 2015
Wheel compatibility matrix
Files in release
Extras:
None
Dependencies:
vertica-python