dictmysql


Namedictmysql JSON
Version 0.6.5 PyPI version JSON
download
home_pagehttps://ligyxy.github.io/DictMySQL/
SummaryA MySQL class for more convenient database manipulations with Python dictionary.
upload_time2017-03-24 17:44:15
maintainer
docs_urlNone
authorGuangyang Li
requires_python
licenseMIT
keywords python mysql class
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            DictMySQL
=========

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

Documentation: https://git.io/dictmysql

Introduction
------------

A mysql class on the top of
`PyMySQL <https://github.com/PyMySQL/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:

.. 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);

License
-------

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

            

Raw data

            {
    "maintainer": "", 
    "docs_url": null, 
    "requires_python": "", 
    "maintainer_email": "", 
    "cheesecake_code_kwalitee_id": null, 
    "keywords": "python mysql class", 
    "upload_time": "2017-03-24 17:44:15", 
    "author": "Guangyang Li", 
    "home_page": "https://ligyxy.github.io/DictMySQL/", 
    "download_url": "https://pypi.python.org/packages/7c/26/5f4250c5035a760982dca2151fefed9a2370d7ebc56284f8ee74320c8a94/dictmysql-0.6.5.tar.gz", 
    "platform": "", 
    "version": "0.6.5", 
    "cheesecake_documentation_id": null, 
    "description": "DictMySQL\n=========\n\nPyPI page: https://pypi.python.org/pypi/dictmysql\n\nDocumentation: https://git.io/dictmysql\n\nIntroduction\n------------\n\nA mysql class on the top of\n`PyMySQL <https://github.com/PyMySQL/PyMySQL>`__, for more convenient\ndatabase manipulation with Python dictionary.\n\nDictMySQL simplifies and unifies the input/output of MySQL queries, by\nallowing passing values and conditions in dictionary into database. With\nDictCursor, you can even have a dict-in, dict-out mysql connector.\n\nTo install:\n\n.. code:: bash\n\n    pip install dictmysql\n\nQuick example:\n\n.. code:: python\n\n    from dictmysql import DictMySQL\n    db = DictMySQL(db='occupation', host='127.0.0.1', user='root', passwd='')\n\n    db.select(table='jobs',\n              columns=['id','value'],\n              where={'$OR': [{'value': {'$LIKE': 'Artist%'}}, {'id': 10}]})\n    # SELECT `id`, `value` FROM `jobs` WHERE (`value` LIKE \"Artist%\") OR (`id` = 10);\n\nLicense\n-------\n\nDictMySQL uses the MIT license, see ``LICENSE`` file for the details.\n", 
    "lcname": "dictmysql", 
    "bugtrack_url": null, 
    "github": false, 
    "name": "dictmysql", 
    "license": "MIT", 
    "summary": "A MySQL class for more convenient database manipulations with Python dictionary.", 
    "split_keywords": [
        "python", 
        "mysql", 
        "class"
    ], 
    "author_email": "mail@guangyangli.com", 
    "urls": [
        {
            "has_sig": false, 
            "upload_time": "2017-03-24T17:44:15", 
            "comment_text": "", 
            "python_version": "source", 
            "url": "https://pypi.python.org/packages/7c/26/5f4250c5035a760982dca2151fefed9a2370d7ebc56284f8ee74320c8a94/dictmysql-0.6.5.tar.gz", 
            "md5_digest": "7641f4b5189c73518f870e98744d687e", 
            "downloads": 0, 
            "filename": "dictmysql-0.6.5.tar.gz", 
            "packagetype": "sdist", 
            "path": "7c/26/5f4250c5035a760982dca2151fefed9a2370d7ebc56284f8ee74320c8a94/dictmysql-0.6.5.tar.gz", 
            "size": 8952
        }
    ], 
    "_id": null, 
    "cheesecake_installability_id": null
}