Vertica dialect for sqlalchemy
This module implements a Vertica dialect for SQLAlchemy. You can use it:
>>> import sqlalchemy as sa >>> sa.create_engine(sa.engine.url.URL( drivername='vertica+pyodbc', username='myusername', password='mypassword', host='hostname', database='dbname', ))
This work is mainly a package of code [posted](https://groups.google.com/d/msg/sqlalchemy/ttJzN-t9R74/9W1d9KfHK_0J) to the SQLAlchemy mailing list by ‘Bo’ (Google groups won’t let me see the original author).
I have tested this for table introspection, selects and joins. However, I do not have access to a Vertica database to test against. If you do, let me know.
The primary, foreign and index constraints return nothing. This is because I’m told these are ‘enforced on select’. Maybe a Vertica expert can tell me the correct way to handle this.
pip install vertica-sqlalchemy-0.2
git clone https://bitbucket.com/shivamshukla/vertica-sqlalchemy-0.2 cd vertica-sqlalchemy-0.2 python setup.py install
TODO: Figure out how to actually get changelog content.
Changelog content for this version goes here.