Skip to main content

Vertica dialect for sqlalchemy using vertica_python

Project description

Vertica dialect for sqlalchemy. Forked from the Vertica ODBC dialect.

This module implements a Vertica dialect for SQLAlchemy using vertica-python. 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/LocusEnergy/vertica-sqlalchemy
cd vertica-sqlalchemy
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)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for sqlalchemy-vertica-python, version 0.4.4
Filename, size File type Python version Upload date Hashes
Filename, size sqlalchemy-vertica-python-0.4.4.tar.gz (4.8 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page