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 details)

Uploaded Source

Built Distribution

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

Uploaded Python 2 Python 3

File details

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

File metadata

File hashes

Hashes for sqlalchemy_monetdb-0.9.2.tar.gz
Algorithm Hash digest
SHA256 f9ef9c871b6921b85f4a6f2078d9561099de42f8666b4e1757a7ac478f235506
MD5 8c12c1533f85c539c9280450bc6c2b9a
BLAKE2b-256 9ba7e3ab9d8577738f6abc9d5338cf9de2c3cc69f33dbb6e1a6d7623586da274

See more details on using hashes here.

File details

Details for the file sqlalchemy_monetdb-0.9.2-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for sqlalchemy_monetdb-0.9.2-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 337682b540f7c2a0abeccefafddc284c0f97ab16a157dccf99c23c92f648ab94
MD5 ea1101d5c466b6fb1e11d389dcefeadf
BLAKE2b-256 d816a86f1a7a10b32ce762a44db47779c6cbca334dce3dcc5359a6d5837bd099

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