{
    "info": {
        "author": "Guangyang Li",
        "author_email": "mail@guangyangli.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 2.6",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3.1",
            "Programming Language :: Python :: 3.2",
            "Programming Language :: Python :: 3.3",
            "Programming Language :: Python :: 3.4",
            "Programming Language :: Python :: 3.5",
            "Programming Language :: Python :: 3.6",
            "Topic :: Software Development :: Build Tools"
        ],
        "description": "DictMySQL\n=========\n\nPyPI page: https://pypi.python.org/pypi/dictmysql\n\nDocumentation: https://git.io/dictmysql\n\nIntroduction\n------------\n\nDictMySQL is a MySQL query builder on the top of\n`PyMySQL <https://github.com/PyMySQL/PyMySQL>`__. It allows 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\nWith DictCursor:\n\n.. code:: python\n\n    from dictmysql import DictMySQL, cursors\n    db = DictMySQL(db='occupation', host='127.0.0.1', user='root', passwd='', \n                   cursorclass=cursors.DictCursor)\n\n    db.select(table='jobs',\n              columns=['id','value'],\n              limit=2)\n    # returns [{u'id': 1, u'value': u'Artist'}, {u'id': 2, u'value': u'Engineer'}]\n\nFuture Works\n------------\n\n1. Full support of CRUD\n2. Better documents\n\n\nLicense\n-------\n\nDictMySQL uses the MIT license, see ``LICENSE`` file for the details.\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://ligyxy.github.io/DictMySQL/",
        "keywords": "python mysql class",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "dictmysql",
        "package_url": "https://pypi.org/project/dictmysql/",
        "platform": "",
        "project_url": "https://pypi.org/project/dictmysql/",
        "project_urls": {
            "Homepage": "https://ligyxy.github.io/DictMySQL/"
        },
        "release_url": "https://pypi.org/project/dictmysql/0.6.8/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "A MySQL class for more convenient database manipulations with Python dictionary.",
        "version": "0.6.8"
    },
    "last_serial": 5963335,
    "releases": {
        "0.4.10": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "2a86370480c92782282156f1c7707a0b",
                    "sha256": "7848591bcacf829fcc1a70e99fed4eee7664c8f2529eff5a195a8a1c81f1d5a9"
                },
                "downloads": -1,
                "filename": "dictmysql-0.4.10.tar.gz",
                "has_sig": false,
                "md5_digest": "2a86370480c92782282156f1c7707a0b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5636,
                "upload_time": "2016-04-26T21:23:27",
                "url": "https://files.pythonhosted.org/packages/6a/2c/39592c7bdc76869c6ad66f15296e8dce289e6842430c1bba43149d134685/dictmysql-0.4.10.tar.gz"
            }
        ],
        "0.4.11": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "45bad2b87ec46d7bb5cc18cf6be3a80d",
                    "sha256": "0976b23259b5ba27c0d6f5542893f7e60cab7b0571665a52fe6af099a062fb10"
                },
                "downloads": -1,
                "filename": "dictmysql-0.4.11.tar.gz",
                "has_sig": false,
                "md5_digest": "45bad2b87ec46d7bb5cc18cf6be3a80d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5593,
                "upload_time": "2017-01-17T20:50:57",
                "url": "https://files.pythonhosted.org/packages/f6/5e/ab587556c2102fc9a7004f73440e1b4a69c1d737b542cc68c029a57e0185/dictmysql-0.4.11.tar.gz"
            }
        ],
        "0.4.12": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "cdc6a658be397f08012f160a6b3ca638",
                    "sha256": "6080c37af1acee9ad0d9e9bcbd3a34e3ad6e9995d893a9c8b7000dc3e68c9528"
                },
                "downloads": -1,
                "filename": "dictmysql-0.4.12.tar.gz",
                "has_sig": false,
                "md5_digest": "cdc6a658be397f08012f160a6b3ca638",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5706,
                "upload_time": "2017-01-23T22:22:08",
                "url": "https://files.pythonhosted.org/packages/29/d9/6ca37b136f7fd432a27bfd808c6e3c9f9935e32aca6314674c738c7503dc/dictmysql-0.4.12.tar.gz"
            }
        ],
        "0.4.13": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "1fb6502e72c5a0d185cdf86f2b8f89b3",
                    "sha256": "000fb3d62effa26a1edf7126b35ab7d4e200605e26519e7fe0046c72a6d77699"
                },
                "downloads": -1,
                "filename": "dictmysql-0.4.13.tar.gz",
                "has_sig": false,
                "md5_digest": "1fb6502e72c5a0d185cdf86f2b8f89b3",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5749,
                "upload_time": "2017-02-01T23:26:32",
                "url": "https://files.pythonhosted.org/packages/d7/bf/b07d85c07f336f349bbe1502ee2dc6dd080f3c61039110977bb3c14738e2/dictmysql-0.4.13.tar.gz"
            }
        ],
        "0.4.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ee6d3823e206cc140e06028b1aa2687a",
                    "sha256": "bf2c2993b6ab7422ce248616a15d4a6e7b6fcdbf5f52107c89d09e7d5638c501"
                },
                "downloads": -1,
                "filename": "dictmysql-0.4.5.tar.gz",
                "has_sig": false,
                "md5_digest": "ee6d3823e206cc140e06028b1aa2687a",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5548,
                "upload_time": "2016-01-15T22:21:33",
                "url": "https://files.pythonhosted.org/packages/76/d9/0c27c513c773105a76ff29e96ad8536eae6517fbc6b8815754a4f5a04a25/dictmysql-0.4.5.tar.gz"
            }
        ],
        "0.4.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "3d3ddb44862f51d359c709eebf5c7676",
                    "sha256": "aa61a5fb07796bcf37c652e56e2cbdf3c7574be158dcbe4e26c608cf819cfff7"
                },
                "downloads": -1,
                "filename": "dictmysql-0.4.6.tar.gz",
                "has_sig": false,
                "md5_digest": "3d3ddb44862f51d359c709eebf5c7676",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5557,
                "upload_time": "2016-01-19T21:13:07",
                "url": "https://files.pythonhosted.org/packages/bf/1e/4967a1ee3987b610de73c5d6e35b7e4ef0117276c98afad26bd1913554c5/dictmysql-0.4.6.tar.gz"
            }
        ],
        "0.4.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "e2ffba5326150ff001aea82a57be42d7",
                    "sha256": "fbca6a5ed6f17b9ec5fe0c9603f1ed9fc4cd34d0994a5a023d25084c3a786afa"
                },
                "downloads": -1,
                "filename": "dictmysql-0.4.7.tar.gz",
                "has_sig": false,
                "md5_digest": "e2ffba5326150ff001aea82a57be42d7",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5646,
                "upload_time": "2016-02-10T19:01:47",
                "url": "https://files.pythonhosted.org/packages/14/67/bb8d1aebfae44de66c5b4590dcbf8b5cd1930c1b2851b8fb908f4a1166ec/dictmysql-0.4.7.tar.gz"
            }
        ],
        "0.4.8": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "2ac81fc5f7c3ab8b25b9896cbd54036c",
                    "sha256": "cb1287815275f1b778f832d7ba5c4527ad9b42fdce7df246e351c88d9dfdcc7d"
                },
                "downloads": -1,
                "filename": "dictmysql-0.4.8.tar.gz",
                "has_sig": false,
                "md5_digest": "2ac81fc5f7c3ab8b25b9896cbd54036c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5615,
                "upload_time": "2016-02-18T19:22:34",
                "url": "https://files.pythonhosted.org/packages/8f/70/bdab359d51d776569fc1d8332a7b1abcef6d17318ac7b96cc4888c9dc326/dictmysql-0.4.8.tar.gz"
            }
        ],
        "0.4.9": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f2a89d575a4a9240816bb198313f71d8",
                    "sha256": "c570c238a5cd6270d1c156dbb142680e2e6aa19819b9f10b8ee8811b2073bbe2"
                },
                "downloads": -1,
                "filename": "dictmysql-0.4.9.tar.gz",
                "has_sig": false,
                "md5_digest": "f2a89d575a4a9240816bb198313f71d8",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5688,
                "upload_time": "2016-04-10T05:51:49",
                "url": "https://files.pythonhosted.org/packages/3f/be/f70049b3e3b593a21900d4afec1a97c6c2a2dd75389c30995f9babf1cd42/dictmysql-0.4.9.tar.gz"
            }
        ],
        "0.5.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c7d678daf0e5a3fc1dbe5e56d8aeda4c",
                    "sha256": "8aafada997731f90188b6475079bac380d4bd3151a1a0f37c985a003b552e839"
                },
                "downloads": -1,
                "filename": "dictmysql-0.5.0.tar.gz",
                "has_sig": false,
                "md5_digest": "c7d678daf0e5a3fc1dbe5e56d8aeda4c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5963,
                "upload_time": "2017-02-17T04:30:34",
                "url": "https://files.pythonhosted.org/packages/03/aa/7a7b063def369ec534f80e55b6cfc5ecc27d0e33fb09ff8d0ad40e0c7652/dictmysql-0.5.0.tar.gz"
            }
        ],
        "0.5.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6c0e0eaac3d5bc8d5d933eda783e64cd",
                    "sha256": "a6ac77f61e5d40b9e003a62ab397308972c6c742f87d68c4838e3b03bb40a581"
                },
                "downloads": -1,
                "filename": "dictmysql-0.5.1.tar.gz",
                "has_sig": false,
                "md5_digest": "6c0e0eaac3d5bc8d5d933eda783e64cd",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6584,
                "upload_time": "2017-02-17T18:34:26",
                "url": "https://files.pythonhosted.org/packages/f1/ca/01cb9afe7ed2a40388db41044cbedaf398ba8f5346576432e235881dd501/dictmysql-0.5.1.tar.gz"
            }
        ],
        "0.5.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "fd8e1db7c6200a0c8e8402587263790d",
                    "sha256": "0c143bc4305d0e7fe49b327070a4057e8dc740097a719aca2d8456be847b81d5"
                },
                "downloads": -1,
                "filename": "dictmysql-0.5.5.tar.gz",
                "has_sig": false,
                "md5_digest": "fd8e1db7c6200a0c8e8402587263790d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6583,
                "upload_time": "2017-02-17T20:23:11",
                "url": "https://files.pythonhosted.org/packages/09/45/2bf0ecba5d236e2ec1d6623f913553a3e93e78c96b000d9e2eaf3d458bda/dictmysql-0.5.5.tar.gz"
            }
        ],
        "0.5.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "583c068a2ed4ee1788e76b9973f18f86",
                    "sha256": "3a783df3ec3f312ef298c58083bc0211bc788e47ebc0e3223d73b97ce6458592"
                },
                "downloads": -1,
                "filename": "dictmysql-0.5.6.tar.gz",
                "has_sig": false,
                "md5_digest": "583c068a2ed4ee1788e76b9973f18f86",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8591,
                "upload_time": "2017-03-06T17:05:31",
                "url": "https://files.pythonhosted.org/packages/5a/0f/36114d70104e644bbac1b58ee91a7bf46e6990c8f1216eba4cbd317ef906/dictmysql-0.5.6.tar.gz"
            }
        ],
        "0.5.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ee039301cb55e3c115417166fd8a3616",
                    "sha256": "b5aadde058f64a8228e56ca812a123a1db981135e448348c2639754b48d5e74a"
                },
                "downloads": -1,
                "filename": "dictmysql-0.5.7.tar.gz",
                "has_sig": false,
                "md5_digest": "ee039301cb55e3c115417166fd8a3616",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8700,
                "upload_time": "2017-03-08T21:01:50",
                "url": "https://files.pythonhosted.org/packages/d5/ae/0fa468265d8450ec92903bc5698abffce9f567fe4f827edf11d17d4765e5/dictmysql-0.5.7.tar.gz"
            }
        ],
        "0.6.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "94807b69bb86c080b35753775a3cd1af",
                    "sha256": "366209d59aec4c1bf06fbff0c19958a88f3020b04afeda003af92dd7af9e88e4"
                },
                "downloads": -1,
                "filename": "dictmysql-0.6.0.tar.gz",
                "has_sig": false,
                "md5_digest": "94807b69bb86c080b35753775a3cd1af",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8749,
                "upload_time": "2017-03-09T17:17:19",
                "url": "https://files.pythonhosted.org/packages/bb/12/0008e8f270f6c681e4cf4a53cf6f2eecd077651748945e849801b056b1f3/dictmysql-0.6.0.tar.gz"
            }
        ],
        "0.6.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "013f4575474a3b061965f048e0a72e59",
                    "sha256": "c236568288e9a05ca9b088691bd637fe3357692b65a207cdc20c16061a78d52a"
                },
                "downloads": -1,
                "filename": "dictmysql-0.6.1.tar.gz",
                "has_sig": false,
                "md5_digest": "013f4575474a3b061965f048e0a72e59",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8768,
                "upload_time": "2017-03-09T20:06:05",
                "url": "https://files.pythonhosted.org/packages/4d/db/c424a2998ce9caf448afd55b8870312ae78db26f885f170544700006b96c/dictmysql-0.6.1.tar.gz"
            }
        ],
        "0.6.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b97df96dc62d5e09f173aad8d299381c",
                    "sha256": "3bcc3ca5d1422160a64cc1bbd573c756cd2bec7421ad87ef1b9dfb93a23a357f"
                },
                "downloads": -1,
                "filename": "dictmysql-0.6.2.tar.gz",
                "has_sig": false,
                "md5_digest": "b97df96dc62d5e09f173aad8d299381c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8880,
                "upload_time": "2017-03-10T03:07:25",
                "url": "https://files.pythonhosted.org/packages/50/d7/ab6dc44bfeec5bd8031c23c6980536c8c9ac64a6f75029a6096f749bacc1/dictmysql-0.6.2.tar.gz"
            }
        ],
        "0.6.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "adc28f6ce67c4788c37e859d6b9db57b",
                    "sha256": "69bf4bbc2a45f4a783b52a455df1812879bfce64e32d1967202eb3357b11b922"
                },
                "downloads": -1,
                "filename": "dictmysql-0.6.3.tar.gz",
                "has_sig": false,
                "md5_digest": "adc28f6ce67c4788c37e859d6b9db57b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8857,
                "upload_time": "2017-03-10T03:13:03",
                "url": "https://files.pythonhosted.org/packages/0c/9b/3d693e623c78843fc224773c65ee2f08a3d0d20f7a9ab04b4b39510febbe/dictmysql-0.6.3.tar.gz"
            }
        ],
        "0.6.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c1a64691a2ac7c413667671b01aad632",
                    "sha256": "34fbbce1bce59e79ce8b9318bdb3e0c553a395f5635b8a0aa6a40fd28e84bbc7"
                },
                "downloads": -1,
                "filename": "dictmysql-0.6.4.tar.gz",
                "has_sig": false,
                "md5_digest": "c1a64691a2ac7c413667671b01aad632",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8996,
                "upload_time": "2017-03-12T06:32:41",
                "url": "https://files.pythonhosted.org/packages/d6/2a/43a3c3519787f5d5207e8d33ffb8ef59f795704a9509c04b71fbcc9e3422/dictmysql-0.6.4.tar.gz"
            }
        ],
        "0.6.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "7641f4b5189c73518f870e98744d687e",
                    "sha256": "315072a2469e104753e2166826694d1ab0549df173efa4b30c306ee7737e88e3"
                },
                "downloads": -1,
                "filename": "dictmysql-0.6.5.tar.gz",
                "has_sig": false,
                "md5_digest": "7641f4b5189c73518f870e98744d687e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8952,
                "upload_time": "2017-03-24T17:44:15",
                "url": "https://files.pythonhosted.org/packages/7c/26/5f4250c5035a760982dca2151fefed9a2370d7ebc56284f8ee74320c8a94/dictmysql-0.6.5.tar.gz"
            }
        ],
        "0.6.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "9636011f4aa6da088981a30d00488689",
                    "sha256": "cbc97a2c2f429904365708cbfd80346c183d4c1980ce430a96eb855a0b0857eb"
                },
                "downloads": -1,
                "filename": "dictmysql-0.6.6.tar.gz",
                "has_sig": false,
                "md5_digest": "9636011f4aa6da088981a30d00488689",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 7482,
                "upload_time": "2018-05-21T03:59:24",
                "url": "https://files.pythonhosted.org/packages/ea/87/0bda203ce2fe81e3db65524b90deb9d6a2f93c71f6970b43de537e7622c9/dictmysql-0.6.6.tar.gz"
            }
        ],
        "0.6.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "32cb84fd0e609f4c50b468a50a494060",
                    "sha256": "b9fd6e393cf50c31fd5ddfce455c64a18d0cb19a42cb62159af322f4c121d459"
                },
                "downloads": -1,
                "filename": "dictmysql-0.6.7.tar.gz",
                "has_sig": false,
                "md5_digest": "32cb84fd0e609f4c50b468a50a494060",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 7692,
                "upload_time": "2018-05-30T21:39:06",
                "url": "https://files.pythonhosted.org/packages/dc/1d/f0e75637e95392eb76f8247810152e4bc58c0367dc4d35593a2dcf30eb89/dictmysql-0.6.7.tar.gz"
            }
        ],
        "0.6.8": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "3414c5f7bfd6ca484ad5d0b0f3957b5e",
                    "sha256": "2c27e39c26f633f9edd4c3326932ac26fed1de952216798806671be362d513d0"
                },
                "downloads": -1,
                "filename": "dictmysql-0.6.8.tar.gz",
                "has_sig": false,
                "md5_digest": "3414c5f7bfd6ca484ad5d0b0f3957b5e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 7780,
                "upload_time": "2018-07-16T21:20:21",
                "url": "https://files.pythonhosted.org/packages/f9/f5/5e04b91b4424603340051e0d02f4cff770457faae490d4952ba2ccd2bbcd/dictmysql-0.6.8.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "3414c5f7bfd6ca484ad5d0b0f3957b5e",
                "sha256": "2c27e39c26f633f9edd4c3326932ac26fed1de952216798806671be362d513d0"
            },
            "downloads": -1,
            "filename": "dictmysql-0.6.8.tar.gz",
            "has_sig": false,
            "md5_digest": "3414c5f7bfd6ca484ad5d0b0f3957b5e",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 7780,
            "upload_time": "2018-07-16T21:20:21",
            "url": "https://files.pythonhosted.org/packages/f9/f5/5e04b91b4424603340051e0d02f4cff770457faae490d4952ba2ccd2bbcd/dictmysql-0.6.8.tar.gz"
        }
    ]
}