skip to navigation
skip to content

dictmysql 0.6.5

A MySQL class for more convenient database manipulations with Python dictionary.

PyPI page: https://pypi.python.org/pypi/dictmysql

Documentation: https://git.io/dictmysql

Introduction

A mysql class on the top of PyMySQL, for more 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);

License

DictMySQL uses the MIT license, see LICENSE file for the details.

 
File Type Py Version Uploaded on Size
dictmysql-0.6.5.tar.gz (md5) Source 2017-03-24 8KB