sqlalchemy-vertica-python

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)

Metadata

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)

Source distribution for sqlalchemy-vertica-python 0.6.3
File	Size	Uploaded	Provenance	Actions
sqlalchemy-vertica-python-0.6.3.tar.gz	7.2 kB	Jun 5, 2023	Without provenance	Details for sqlalchemy-vertica-python-0.6.3.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for sqlalchemy-vertica-python 0.6.3
File	Interpreter	ABI	Platform	Actions Reset
sqlalchemy_vertica_python-0.6.3-py3-none-any.whl 6.7 kB Jun 5, 2023 Without provenance	Python 3	none	any	Details for sqlalchemy_vertica_python-0.6.3-py3-none-any.whl

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	Jun 5, 2023
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	Jun 5, 2023
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/4.0.2 CPython/3.8.16`

Security for sqlalchemy-vertica-python 0.6.3

Report project as malware

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Release history Release notifications | RSS feed

This release

sqlalchemy-vertica-python 0.6.3