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.
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
File details
Details for the file sqlalchemy_greenplum-0.2.1.tar.gz.
File metadata
- Download URL: sqlalchemy_greenplum-0.2.1.tar.gz
- Upload date:
- Size: 16.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.1.1 CPython/3.11.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 66b55ef3ab3df179c0bd7c5713120fc154c53919a7fab9c714a2bfdb1411b5f9 |
|
| MD5 | 8fad1c7f2fb5bf8a870e59676a39f5df |
|
| BLAKE2b-256 | 2a68237defa85072d8249974aa44f6b56f43022ed2a0ed816b206125acb4c0ca |
File details
Details for the file sqlalchemy_greenplum-0.2.1-py3-none-any.whl.
File metadata
- Download URL: sqlalchemy_greenplum-0.2.1-py3-none-any.whl
- Upload date:
- Size: 16.1 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.1.1 CPython/3.11.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | b52bb319e1429c2944578968608e3d6eae10e4c19044628a18643c9987606963 |
|
| MD5 | 15b1685a8e18ff784572ab80e70ae769 |
|
| BLAKE2b-256 | e13676b3f60c60fa3b152d5d2af14c55c280493fb023a2b392d2d7ee9be9f3e4 |
