Skip to main content

SQLAlchemy dialect for MonetDB

Project description

https://travis-ci.org/gijzelaerr/sqlalchemy-monetdb.png?branch=master https://badges.gitter.im/JoinChat.svg

This is the MonetDB dialect driver for SQLAlchemy. It used pymonetdb.

installation

To install this dialect run:

$ pip install sqlalchemy_monetdb

or from source:

$ pip install -r ./requirements.txt
$ python ./setup.py install

usage

To start using this dialect:

from sqlalchemy import create_engine
engine = create_engine('monetdb:///demo:', echo=True)

If you don’t want to install this library (for example during development) add this folder to your PYTHONPATH and register this dialect with SQLAlchemy:

from sqlalchemy.dialects import registry
registry.register("monetdb", "sqlalchemy_monetdb.dialect", "MonetDialect")

testing

you need to have nose and mock installed:

$ pip install nose mock

create a database test:

$ monetdb create test && monetdb release test

Create a test schema:

$ echo "create schema test_schema;" | mclient test
$ echo "create schema test_schema2;" | mclient test
$ echo "alter user monetdb set schema test_schema2;" | mclient test

Run the test suite:

$ ./run_tests.py

more info

Authors

  • Matt Harrison

  • Pete Hollobon

  • Gijs Molenaar

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

sqlalchemy_monetdb-0.9.1.tar.gz (10.8 kB view details)

Uploaded Source

Built Distribution

sqlalchemy_monetdb-0.9.1-py2-none-any.whl (11.4 kB view details)

Uploaded Python 2

File details

Details for the file sqlalchemy_monetdb-0.9.1.tar.gz.

File metadata

File hashes

Hashes for sqlalchemy_monetdb-0.9.1.tar.gz
Algorithm Hash digest
SHA256 4081e9d82258436b916c62653a1a87b71db722b3bb6e7df9a2709926cc38b874
MD5 cbef0ef62b05e1b7283be65348e42a20
BLAKE2b-256 944ab683a1dbe49b03a74d46e4fbefbb613278563e5a25138034d02c67a27be3

See more details on using hashes here.

File details

Details for the file sqlalchemy_monetdb-0.9.1-py2-none-any.whl.

File metadata

File hashes

Hashes for sqlalchemy_monetdb-0.9.1-py2-none-any.whl
Algorithm Hash digest
SHA256 3b7a18f67baa3487766dd3abddf0f42419d2fa24866e1d78447bdb9d421e6736
MD5 145e9839ecebbb8e36fa92a23c0ce571
BLAKE2b-256 58798d722ae9261c315c877f4561711d3b1d6dd299257f4408f8ce7c8fb2aac5

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page