{
    "info": {
        "author": "Peng Shiyu",
        "author_email": "pengshiyuyx@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.6"
        ],
        "description": "# PureMySQL\n![PyPI](https://img.shields.io/pypi/v/PureMySQL.svg)\n\n\u4e00\u4e2aMySQL\u7b80\u5355\u64cd\u4f5c\u65b9\u5f0f\n\n```\npip install PureMySQL\n```\n\n- https://github.com/mouday/PureMySQL\n- https://pypi.org/project/PureMySQL/\n\n\u4ee3\u7801\u793a\u4f8b\n```python\n# -*- coding: utf-8 -*-\n\nfrom puremysql import PureMysql\n\ndb_config = {\n    \"database\": \"mydata\",\n    \"user\": \"root\",\n    \"password\": \"123456\",\n    \"host\": \"127.0.0.1\",\n    \"port\": 3306,\n}\n\npure_mysql = PureMysql(**db_config)\n\n# \u6216\u8005\n# url = \"mysql://root:123456@127.0.0.1:3306/mydata\"\n# pure_mysql = PureMysql(db_url=url)\n\nstudent = pure_mysql.table(\"student\")\n\n\n# \u63d2\u5165\u6570\u636e\ndef test_insert():\n    data = {\n        \"name\": \"Tom\",\n        \"age\": 25\n    }\n\n    count = student.insert(data)\n    print(count)  # 1\n\n    data = [\n        {\n            \"name\": \"Tom\",\n            \"age\": 26,\n\n        },\n        {\n            \"name\": \"Jack\",\n            \"age\": 27,\n\n        }\n    ]\n    count = student.insert(data)\n    print(count)  # 2\n\n\n# \u5220\u9664\u6570\u636e\ndef test_delete():\n    ret = student.delete(\"id=13\")\n    print(ret)  # 1\n\n    ret = student.delete_by_id(12)\n    print(ret)  # 1\n\n\n# \u66f4\u65b0\u6570\u636e\ndef test_update():\n    data = {\n        \"name\": \"Tom\"\n    }\n    ret = student.update(data, \"name='Tom'\")\n    print(ret)  # 1\n\n    ret = student.update_by_id(data, 1)\n    print(ret)  # 1\n\n\n# \u67e5\u8be2\u6570\u636e\ndef test_select():\n    ret = student.select([\"name\", \"age\"], \"id=1\")\n    print(ret)\n    # [{\"name\": \"Tom\", \"age\": 25}]\n\n    ret = student.select(\"name, age\", \"id=1\")\n    print(ret)\n    # [{\"name\": \"Tom\", \"age\": 25}]\n\n    ret = student.select_one([\"name\", \"age\"], \"id=1\")\n    print(ret)\n    # {\"name\": \"Tom\", \"age\": 25}\n\n    ret = student.select_by_id(\"name, age\", 2007)\n    print(ret)\n    # {\"name\": \"Tom\", \"age\": 25}\n\n```\n\n",
        "description_content_type": "text/markdown",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/mouday/PureMySQL",
        "keywords": "pure mysql",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "PureMySQL",
        "package_url": "https://pypi.org/project/PureMySQL/",
        "platform": "",
        "project_url": "https://pypi.org/project/PureMySQL/",
        "project_urls": {
            "Homepage": "https://github.com/mouday/PureMySQL"
        },
        "release_url": "https://pypi.org/project/PureMySQL/0.0.9/",
        "requires_dist": [
            "mysql-connector-python (>=8.0.16)",
            "six (>=1.12.0)"
        ],
        "requires_python": "",
        "summary": "\u4e00\u4e2aMySQL\u7b80\u5355\u64cd\u4f5c\u65b9\u5f0f",
        "version": "0.0.9"
    },
    "last_serial": 5707165,
    "releases": {
        "0.0.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "91afbe7d4d7e13d1e0328336a1e6ac38",
                    "sha256": "0a23ff5bf3ece3a65a1ea8c3fbcbf37e1fceff5e2a43617fc2e8b2343d12b52f"
                },
                "downloads": -1,
                "filename": "PureMySQL-0.0.5-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "91afbe7d4d7e13d1e0328336a1e6ac38",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 7266,
                "upload_time": "2019-06-28T07:19:35",
                "url": "https://files.pythonhosted.org/packages/e2/4e/ad342fe7d2064318056c32019a57eccf59092f89e9b4f9011124f12399c4/PureMySQL-0.0.5-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "4260e4c07c2922d45f731079c780eefc",
                    "sha256": "776b0578fd882324d49e8b6f3424eea8a8d0c60a85bbe78658111c5737be1aa7"
                },
                "downloads": -1,
                "filename": "PureMySQL-0.0.5.tar.gz",
                "has_sig": false,
                "md5_digest": "4260e4c07c2922d45f731079c780eefc",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5310,
                "upload_time": "2019-06-28T07:19:38",
                "url": "https://files.pythonhosted.org/packages/cd/d9/2e160dc43a96c40dfa9ad30e36ea3ee7c38a6138d7cea203120f65cf8a51/PureMySQL-0.0.5.tar.gz"
            }
        ],
        "0.0.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b3dc739e6a44e5697c6451239dbd3275",
                    "sha256": "10cb98b4d4ac7e0d557757f6a76930bf3b81336c136f42818dbb308f2c49580d"
                },
                "downloads": -1,
                "filename": "PureMySQL-0.0.6-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "b3dc739e6a44e5697c6451239dbd3275",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 7512,
                "upload_time": "2019-07-09T09:24:12",
                "url": "https://files.pythonhosted.org/packages/d5/29/2e190c1ae6ed42dd734cd590a8acf4547b2f7729b9a6d5bd6b5de65a48ca/PureMySQL-0.0.6-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "ceba783facb5483bd477f7238ba57fa5",
                    "sha256": "27b8a2113129274d9abdac1f8ee31b679f381b5d556ac8462b49645cd0beeb6f"
                },
                "downloads": -1,
                "filename": "PureMySQL-0.0.6.tar.gz",
                "has_sig": false,
                "md5_digest": "ceba783facb5483bd477f7238ba57fa5",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6288,
                "upload_time": "2019-07-09T09:24:14",
                "url": "https://files.pythonhosted.org/packages/68/b9/121a6701f6da6cd9f2e2ed55e7193a0833c40398d0516ffff7cde167f915/PureMySQL-0.0.6.tar.gz"
            }
        ],
        "0.0.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "88d7bfb48a15fff5e097af5e4e1d871c",
                    "sha256": "f9496865aedc2b38a3b1d8fbfc7804eff49def5a5ebfee2faad021c4939da5a9"
                },
                "downloads": -1,
                "filename": "PureMySQL-0.0.7-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "88d7bfb48a15fff5e097af5e4e1d871c",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 7593,
                "upload_time": "2019-07-09T09:41:37",
                "url": "https://files.pythonhosted.org/packages/da/2e/f7c6872dda5dfca6dc41e4c767913e5a842cec0c1fdcc0a46fe9c9795e11/PureMySQL-0.0.7-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "0b3e70828e8d45f7ee2402b10a115871",
                    "sha256": "2661dc100a4b5488f881b37768f081a37eb0dc682f51a54c611b64d7aaca0b60"
                },
                "downloads": -1,
                "filename": "PureMySQL-0.0.7.tar.gz",
                "has_sig": false,
                "md5_digest": "0b3e70828e8d45f7ee2402b10a115871",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6342,
                "upload_time": "2019-07-09T09:41:39",
                "url": "https://files.pythonhosted.org/packages/23/93/cf50780b69c135cd90febb31576bb67b2fdec873397b55a2c5fcc8eacf5b/PureMySQL-0.0.7.tar.gz"
            }
        ],
        "0.0.8": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "65bc22c4a20f4350735d148f15da2674",
                    "sha256": "0759326cd7c5907ce9f0e902883707278cd2966221930abcf481685bbf06f9fd"
                },
                "downloads": -1,
                "filename": "PureMySQL-0.0.8-py3.7.egg",
                "has_sig": false,
                "md5_digest": "65bc22c4a20f4350735d148f15da2674",
                "packagetype": "bdist_egg",
                "python_version": "3.7",
                "requires_python": null,
                "size": 15421,
                "upload_time": "2019-08-21T06:01:12",
                "url": "https://files.pythonhosted.org/packages/14/b5/a78b3e7a3e38a6e6a6881154bfd6c111db8083131e5b6e0de50ab54b601f/PureMySQL-0.0.8-py3.7.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "2568d23c7be8ddca04fbaced7d1f7ea3",
                    "sha256": "291cdc4606dc987430c007178f1a4412bb8bf60c0b94a73c90045c5c32f09041"
                },
                "downloads": -1,
                "filename": "PureMySQL-0.0.8-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "2568d23c7be8ddca04fbaced7d1f7ea3",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 7599,
                "upload_time": "2019-07-13T14:45:31",
                "url": "https://files.pythonhosted.org/packages/3f/62/87aaf79e8fa46c4194106a8f75534a6b2f3d038a72653bbeff6b146930d0/PureMySQL-0.0.8-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "ae934aa184910e91cb5cc8c4f6131eb7",
                    "sha256": "9751777c25a8905951e0d39c3c23fb374e60e0a7881681c0415cc3e1aed6ea08"
                },
                "downloads": -1,
                "filename": "PureMySQL-0.0.8.tar.gz",
                "has_sig": false,
                "md5_digest": "ae934aa184910e91cb5cc8c4f6131eb7",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6344,
                "upload_time": "2019-07-13T14:45:33",
                "url": "https://files.pythonhosted.org/packages/87/ad/6f6e06138a08842dc8340f5d2b27363c3840e72e8d8393d68ebb99c6b316/PureMySQL-0.0.8.tar.gz"
            }
        ],
        "0.0.9": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "716ea3ed970e99962d9a7deaeb4a0e79",
                    "sha256": "bb1466934ff921f7880d968b6442045f2c0a882f2e6c4c209551bcb6d378a611"
                },
                "downloads": -1,
                "filename": "PureMySQL-0.0.9-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "716ea3ed970e99962d9a7deaeb4a0e79",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 7598,
                "upload_time": "2019-08-21T06:01:10",
                "url": "https://files.pythonhosted.org/packages/a7/2a/ad2ebf62306f4797fe7bfb9331377721382351c051b7c376045233327257/PureMySQL-0.0.9-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "63610224eb05796508527d372301d1d8",
                    "sha256": "f4495358579fd83ce435a5d0205078e3c227dbbb2824ffbc6ed035db2c0666ed"
                },
                "downloads": -1,
                "filename": "PureMySQL-0.0.9.tar.gz",
                "has_sig": false,
                "md5_digest": "63610224eb05796508527d372301d1d8",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6309,
                "upload_time": "2019-08-21T06:01:14",
                "url": "https://files.pythonhosted.org/packages/70/a7/ad48749c3ff986b0903318eee4e4cdc93170ae4ed6b6fd4c6ae2f3c4f856/PureMySQL-0.0.9.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "716ea3ed970e99962d9a7deaeb4a0e79",
                "sha256": "bb1466934ff921f7880d968b6442045f2c0a882f2e6c4c209551bcb6d378a611"
            },
            "downloads": -1,
            "filename": "PureMySQL-0.0.9-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "716ea3ed970e99962d9a7deaeb4a0e79",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 7598,
            "upload_time": "2019-08-21T06:01:10",
            "url": "https://files.pythonhosted.org/packages/a7/2a/ad2ebf62306f4797fe7bfb9331377721382351c051b7c376045233327257/PureMySQL-0.0.9-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "63610224eb05796508527d372301d1d8",
                "sha256": "f4495358579fd83ce435a5d0205078e3c227dbbb2824ffbc6ed035db2c0666ed"
            },
            "downloads": -1,
            "filename": "PureMySQL-0.0.9.tar.gz",
            "has_sig": false,
            "md5_digest": "63610224eb05796508527d372301d1d8",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 6309,
            "upload_time": "2019-08-21T06:01:14",
            "url": "https://files.pythonhosted.org/packages/70/a7/ad48749c3ff986b0903318eee4e4cdc93170ae4ed6b6fd4c6ae2f3c4f856/PureMySQL-0.0.9.tar.gz"
        }
    ]
}