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.2.tar.gz (10.2 kB view hashes)

Uploaded Source

Built Distribution

sqlalchemy_monetdb-0.9.2-py2.py3-none-any.whl (11.5 kB view hashes)

Uploaded Python 2 Python 3

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