Metadata-Version: 1.1
Name: dictmysql
Version: 0.6.7
Summary: A MySQL class for more convenient database manipulations with Python dictionary.
Home-page: https://ligyxy.github.io/DictMySQL/
Author: Guangyang Li
Author-email: mail@guangyangli.com
License: MIT
Description: DictMySQL
        =========
        
        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 <https://github.com/PyMySQL/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:
        
        .. code:: bash
        
            pip install dictmysql
        
        Quick example:
        
        .. code:: python
        
            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:
        
        .. code:: python
        
            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'}]
        
        License
        -------
        
        DictMySQL uses the MIT license, see ``LICENSE`` file for the details.
        
Keywords: python mysql class
Platform: UNKNOWN
Classifier: Development Status :: 5 - Production/Stable
Classifier: Intended Audience :: Developers
Classifier: Topic :: Software Development :: Build Tools
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 2.6
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3.1
Classifier: Programming Language :: Python :: 3.2
Classifier: Programming Language :: Python :: 3.3
Classifier: Programming Language :: Python :: 3.4
Classifier: Programming Language :: Python :: 3.5
Classifier: Programming Language :: Python :: 3.6
