A SQLAlchemy dialect for MonetDB
Python Shell
#12 Compare This branch is 55 commits ahead, 2 commits behind fkarb:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
sqlalchemy_monetdb
test
.gitignore
.travis.yml
CHANGES
LICENSE
MANIFEST.in
README.rst
TODO
requirements_dev.txt
run_tests.py
setup.cfg
setup.py
tox.ini

README.rst

MonetDB dialect for SQLAlchemy

https://travis-ci.org/gijzelaerr/sqlalchemy-monetdb.png?branch=master

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