SQLAlchemy dialect for Greenplum Database
Project description
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.
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for sqlalchemy_greenplum-0.2.1.tar.gz
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 66b55ef3ab3df179c0bd7c5713120fc154c53919a7fab9c714a2bfdb1411b5f9 |
|
| MD5 | 8fad1c7f2fb5bf8a870e59676a39f5df |
|
| BLAKE2b-256 | 2a68237defa85072d8249974aa44f6b56f43022ed2a0ed816b206125acb4c0ca |
Hashes for sqlalchemy_greenplum-0.2.1-py3-none-any.whl
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | b52bb319e1429c2944578968608e3d6eae10e4c19044628a18643c9987606963 |
|
| MD5 | 15b1685a8e18ff784572ab80e70ae769 |
|
| BLAKE2b-256 | e13676b3f60c60fa3b152d5d2af14c55c280493fb023a2b392d2d7ee9be9f3e4 |
