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)
Raw data
{
"_id": null,
"home_page": "https://github.com/bluelabsio/sqlalchemy-vertica-python",
"name": "sqlalchemy-vertica-python",
"maintainer": "Vince Broz",
"docs_url": null,
"requires_python": "",
"maintainer_email": "opensource@bluelabs.com",
"keywords": "sqlalchemy,vertica,python",
"author": "James Casbon, Luke Emery-Fertitta",
"author_email": "",
"download_url": "https://files.pythonhosted.org/packages/e0/fc/e52cac0df3d55a2b4d0b07d449ddf9600adcc35c5715b289e17114ad86c2/sqlalchemy-vertica-python-0.6.3.tar.gz",
"platform": null,
"description": "sqlalchemy-vertica-python\n=========================\n\nVertica dialect for sqlalchemy. Forked from the `Vertica ODBC dialect <https://pypi.python.org/pypi/vertica-sqlalchemy>`_, written by `James Casbon <https://github.com/jamescasbon>`_.\n\nThis 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>`_.\n\nIt is currently maintained by `BlueLabs <https://bluelabs.com/>`_ - PRs are welcome!\n\nEngine creation:\n\n.. code-block:: python\n\n import sqlalchemy as sa\n sa.create_engine('vertica+vertica_python://user:pwd@host:port/database')\n\nInstallation\n------------\n\nFrom PyPI: ::\n\n pip install sqlalchemy-vertica-python\n\nFrom git: ::\n\n git clone https://github.com/bluelabsio/vertica-sqlalchemy-python\n cd vertica-sqlalchemy-python\n python setup.py install\n\n\nUsage\n------------\n\n**ID/Primary Key Declaration**\n\nDo not use this. The INSERT will fail as it will try to insert the ID\n\n id = Column(Integer, primary_key=True)\n\nDo the following instead\n\n id = Column(Integer, Sequence('user_id_seq'), primary_key=True)\n\n\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Vertica dialect for sqlalchemy using vertica_python",
"version": "0.6.3",
"project_urls": {
"Download": "https://github.com/bluelabsio/sqlalchemy-vertica-python/tarball/0.6.3",
"Homepage": "https://github.com/bluelabsio/sqlalchemy-vertica-python"
},
"split_keywords": [
"sqlalchemy",
"vertica",
"python"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "1b7fbc56d6d5dd40ead585529289505547f83322e1ba2cd4990bde534d2445c9",
"md5": "3199410dc592bb9c08a1b587221ea818",
"sha256": "9f41c8d51f81bb00d9064cfe8facfda698667c105200f5d570d574696bcca4c9"
},
"downloads": -1,
"filename": "sqlalchemy_vertica_python-0.6.3-py3-none-any.whl",
"has_sig": false,
"md5_digest": "3199410dc592bb9c08a1b587221ea818",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 6747,
"upload_time": "2023-06-05T20:29:04",
"upload_time_iso_8601": "2023-06-05T20:29:04.550174Z",
"url": "https://files.pythonhosted.org/packages/1b/7f/bc56d6d5dd40ead585529289505547f83322e1ba2cd4990bde534d2445c9/sqlalchemy_vertica_python-0.6.3-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "e0fce52cac0df3d55a2b4d0b07d449ddf9600adcc35c5715b289e17114ad86c2",
"md5": "17015d17ca93ba0929ce8e95eafdcb66",
"sha256": "5cbebb9875e59366b9e3b4791ef7c2a8e45dbe460fd27687f3dc742dc058a024"
},
"downloads": -1,
"filename": "sqlalchemy-vertica-python-0.6.3.tar.gz",
"has_sig": false,
"md5_digest": "17015d17ca93ba0929ce8e95eafdcb66",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 7237,
"upload_time": "2023-06-05T20:29:06",
"upload_time_iso_8601": "2023-06-05T20:29:06.031630Z",
"url": "https://files.pythonhosted.org/packages/e0/fc/e52cac0df3d55a2b4d0b07d449ddf9600adcc35c5715b289e17114ad86c2/sqlalchemy-vertica-python-0.6.3.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-06-05 20:29:06",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "bluelabsio",
"github_project": "sqlalchemy-vertica-python",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"circle": true,
"requirements": [],
"lcname": "sqlalchemy-vertica-python"
}
JSON
