A MySQL class for more convenient database manipulations with Python dictionary.
Project description
PyPI page: https://pypi.python.org/pypi/dictmysql
Documentation: https://git.io/dictmysql
Introduction
DictMySQL is a MySQL query builder on the top of PyMySQL. It allows convenient database manipulation with Python dictionary.
DictMySQL simplifies and unifies the input/output of MySQL queries, by allowing passing values and conditions in dictionary into database. With DictCursor, you can even have a dict-in, dict-out mysql connector.
To install:
pip install dictmysql
Quick example:
from dictmysql import DictMySQL db = DictMySQL(db='occupation', host='127.0.0.1', user='root', passwd='') db.select(table='jobs', columns=['id','value'], where={'$OR': [{'value': {'$LIKE': 'Artist%'}}, {'id': 10}]}) # SELECT `id`, `value` FROM `jobs` WHERE (`value` LIKE "Artist%") OR (`id` = 10);
With DictCursor:
from dictmysql import DictMySQL, cursors db = DictMySQL(db='occupation', host='127.0.0.1', user='root', passwd='', cursorclass=cursors.DictCursor) db.select(table='jobs', columns=['id','value'], limit=2) # returns [{u'id': 1, u'value': u'Artist'}, {u'id': 2, u'value': u'Engineer'}]
Future Works
- Full support of CRUD
- Better documents
License
DictMySQL uses the MIT license, see LICENSE file for the details.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Filename, size | File type | Python version | Upload date | Hashes |
---|---|---|---|---|
Filename, size dictmysql-0.6.8.tar.gz (7.8 kB) | File type Source | Python version None | Upload date | Hashes View |