sqlalchemy-vertica-python

Vertica dialect for sqlalchemy using vertica_python

MIT 27 个版本
James Casbon, Luke Emery-Fertitta
主页
Download
Homepage
安装
pip install sqlalchemy-vertica-python
poetry add sqlalchemy-vertica-python
pipenv install sqlalchemy-vertica-python
conda install sqlalchemy-vertica-python
描述

sqlalchemy-vertica-python

Vertica dialect for sqlalchemy. Forked from the Vertica ODBC dialect <https://pypi.python.org/pypi/vertica-sqlalchemy>, written by James Casbon <https://github.com/jamescasbon>.

This module implements a Vertica dialect for SQLAlchemy using the pure-Python DB-API driver vertica-python <https://github.com/vertica/vertica-python>, as adapted by Luke Emery-Fertitta <https://github.com/lemeryfertitta>.

It is currently maintained by BlueLabs <https://bluelabs.com/>_ - PRs are welcome!

Engine creation:

.. code-block:: python

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)
分类
Development Status :: 3 - Alpha License :: OSI Approved :: MIT License Programming Language :: Python :: 3.5 Programming Language :: Python :: 3.6 Programming Language :: Python :: 3.7 Programming Language :: Python :: 3.8
版本列表
0.6.3 2023-06-05
0.5.10 2020-09-16
0.5.9 2020-06-09
0.5.8 2020-03-19
0.5.7 2020-02-21
0.5.6 2020-02-20
0.5.5 2020-02-20
0.5.4 2020-02-20
0.4.4 2019-01-10
0.4.3 2019-01-02
0.4.2 2018-12-21
0.4.1 2018-10-26
0.4.0 2018-10-18
0.3.5 2018-10-15
0.3.4 2018-09-17
0.3.3 2018-09-14
0.3.2 2018-07-19
0.3.1 2018-06-11
0.3.0 2018-03-29
0.2.2 2018-03-27
0.2.1 2018-01-17
0.2.0 2018-01-17
0.1.3 2016-10-04
0.1.2 2015-12-30
0.1.1 2015-12-30
0.1.0 2015-07-31
0.0.0 2015-07-31