sqlalchemy-rqlite
sqlalchemy-rqlite copied to clipboard
sqlalchemy dialect for rqlite, the lightweight, distributed database built on SQLite.
rqlite dialect for SQLAlchemy
.. image:: https://circleci.com/gh/rqlite/sqlalchemy-rqlite/tree/master.svg?style=svg :target: https://circleci.com/gh/rqlite/sqlalchemy-rqlite/?branch=master
This is the rqlite dialect driver for SQLAlchemy.
installation
To install this dialect run::
$ pip install sqlalchemy_rqlite
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('rqlite+pyrqlite://localhost:4001/', 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("rqlite.pyrqlite", "sqlalchemy_rqlite.pyrqlite", "dialect")
testing
you need to have pytest and pytest-cov installed::
$ pip install pytest pytest-cov
Run the test suite::
$ python setup.py test
more info
- http://www.sqlalchemy.org/
- https://github.com/rqlite/rqlite