sqlalchemy-vertica-dialec 0.1.3

SQLAlchemy的Vertica方言。

从sqlalchemy-vertica存储库 https://github.com/startappdev/sqlalchemy-vertica 分支而来。不幸的是，sqlalchemy-vertica已被从pypi中移除。

import sqlalchemy as sa import urllib

# for pyodbc connection sa.create_engine(‘vertica+pyodbc:///?odbc_connect=%s’ % (urllib.quote(‘DSN=dsn’),))

# for turbodbc connection sa.create_engine(‘vertica+turbodbc:///?DSN=dsn’)

# for vertica-python connection sa.create_engine(‘vertica+vertica_python://user:pwd@host:port/database’) 从PyPI安装

pip install sqlalchemy-vertica-dialect[pyodbc,turbodbc,vertica-python] # 选择相关引擎 From git

git clone https://github.com/vertica/sqlalchemy-vertica cd sqlalchemy-vertica pip install pyodbc turbodbc vertica-python # 选择相关引擎 python setup.py install