# SQLAlchemy dialect for Pivotal Greenplum
This dialect allows you to use the Pivotal Greenplum database with SQLAlchemy, extending the features
of the PostgreSQL dialect and adding in some Greenplum specific options. The install will also integrate
with Alembic for generation of migration scripts.
## Prerequisites
Python 3.X
### Installation
```
git clone https://github.com/PlaidCloud/sqlalchemy-greenplum.git
cd sqlalchemy-greenplum
python setup.py install
```
### Tests
To run the tests, alter the db entry in setup.cfg and create that database and a schema within it named 'test_schema' on the server
Then run from the project root folder
```
python setup.py test
```
There is a random failure for ServerSideCursorsTest_greenplum+psycopg2_8_3_23.test_roundtrip because it seems
that Greenplum doesn't always return the records in the same order. Perhaps the test result needs to be ordered.
### Usage
```
from sqlalchemy import create_engine
engine = create_engine('greenplum://user:password@example.server.com')
engine = create_engine('greenplum://user:password@example.server.com/example_database')
```
### Contribute
If you find any bugs or have any suggestions, you are welcome to create a GitHub Issue.
Raw data
{
"_id": null,
"home_page": "https://github.com/PlaidCloud/sqlalchemy-greenplum",
"name": "sqlalchemy-greenplum",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": null,
"author": "Patrick Buxton",
"author_email": "patrick.buxton@tartansolutions.com",
"download_url": "https://files.pythonhosted.org/packages/2a/68/237defa85072d8249974aa44f6b56f43022ed2a0ed816b206125acb4c0ca/sqlalchemy_greenplum-0.2.1.tar.gz",
"platform": null,
"description": "# SQLAlchemy dialect for Pivotal Greenplum\n\nThis dialect allows you to use the Pivotal Greenplum database with SQLAlchemy, extending the features\nof the PostgreSQL dialect and adding in some Greenplum specific options. The install will also integrate\nwith Alembic for generation of migration scripts.\n\n## Prerequisites\n\nPython 3.X\n\n### Installation\n```\ngit clone https://github.com/PlaidCloud/sqlalchemy-greenplum.git\ncd sqlalchemy-greenplum\npython setup.py install\n```\n\n### Tests\n\nTo run the tests, alter the db entry in setup.cfg and create that database and a schema within it named 'test_schema' on the server\nThen run from the project root folder\n```\npython setup.py test\n```\n\nThere is a random failure for ServerSideCursorsTest_greenplum+psycopg2_8_3_23.test_roundtrip because it seems \nthat Greenplum doesn't always return the records in the same order. Perhaps the test result needs to be ordered.\n\n### Usage\n```\n from sqlalchemy import create_engine\n engine = create_engine('greenplum://user:password@example.server.com')\n engine = create_engine('greenplum://user:password@example.server.com/example_database')\n```\n\n### Contribute\n\nIf you find any bugs or have any suggestions, you are welcome to create a GitHub Issue.\n\n",
"bugtrack_url": null,
"license": "Apache License 2.0",
"summary": "SQLAlchemy dialect for Greenplum Database",
"version": "0.2.1",
"project_urls": {
"Homepage": "https://github.com/PlaidCloud/sqlalchemy-greenplum"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "e13676b3f60c60fa3b152d5d2af14c55c280493fb023a2b392d2d7ee9be9f3e4",
"md5": "15b1685a8e18ff784572ab80e70ae769",
"sha256": "b52bb319e1429c2944578968608e3d6eae10e4c19044628a18643c9987606963"
},
"downloads": -1,
"filename": "sqlalchemy_greenplum-0.2.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "15b1685a8e18ff784572ab80e70ae769",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 16112,
"upload_time": "2024-08-29T09:31:07",
"upload_time_iso_8601": "2024-08-29T09:31:07.003002Z",
"url": "https://files.pythonhosted.org/packages/e1/36/76b3f60c60fa3b152d5d2af14c55c280493fb023a2b392d2d7ee9be9f3e4/sqlalchemy_greenplum-0.2.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "2a68237defa85072d8249974aa44f6b56f43022ed2a0ed816b206125acb4c0ca",
"md5": "8fad1c7f2fb5bf8a870e59676a39f5df",
"sha256": "66b55ef3ab3df179c0bd7c5713120fc154c53919a7fab9c714a2bfdb1411b5f9"
},
"downloads": -1,
"filename": "sqlalchemy_greenplum-0.2.1.tar.gz",
"has_sig": false,
"md5_digest": "8fad1c7f2fb5bf8a870e59676a39f5df",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 16261,
"upload_time": "2024-08-29T09:31:08",
"upload_time_iso_8601": "2024-08-29T09:31:08.502843Z",
"url": "https://files.pythonhosted.org/packages/2a/68/237defa85072d8249974aa44f6b56f43022ed2a0ed816b206125acb4c0ca/sqlalchemy_greenplum-0.2.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-08-29 09:31:08",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "PlaidCloud",
"github_project": "sqlalchemy-greenplum",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "sqlalchemy-greenplum"
}
JSON
