{
    "info": {
        "author": "Wang Dong",
        "author_email": "20004604@qq.com",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: MIT License",
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 3"
        ],
        "description": "# \u8bf4\u660e\n\n\u5b89\u88c5\uff1a\n\n```bash\npip install mysql-lingling\n```\n\n## 1\u3001\u4f5c\u7528\n\n``mysql`` \u6a21\u5757\u7684\u518d\u5305\u88c5\uff0c\u5e76\u652f\u6301 with\u8bed\u6cd5\u3002\n\n\u5c06\u4f7f\u7528\u7b80\u5316\u62bd\u8c61\u4e3a\uff1a\n\n1. \u8fde\u63a5\u6570\u636e\u5e93\uff1b\n2. \u6267\u884csql\u8bed\u53e5\u5e76\u83b7\u5f97\u8fd4\u56de\u7ed3\u679c\uff1b\n3. \u5173\u95ed\u6570\u636e\u5e93\uff08\u4f7f\u7528with\u7684\u65f6\u5019\u53ef\u4ee5\u7701\u7565\uff09\uff1b\n\n## 2\u3001\u793a\u4f8b\n\n\u793a\u4f8b1\uff08with\u8bed\u6cd5\uff09\n\n```\n# \u8fde\u63a5\u6570\u636e\u5e93\nwith MySQLTool(user=user, password=pw, database=database) as m2:\n    # \u6267\u884csql\u5e76\u83b7\u5f97\u8fd4\u56de\u7ed3\u679c\n    result2 = m2.run_sql([\n        ['insert person(name, age) values (\"\u674e\u56db\", 20), (\"\u738b\u4e94\", 30)'],\n        ['select * from person']\n    ])\n    # \u6253\u5370\u7ed3\u679c\n    print(result2)\n```\n\n\u793a\u4f8b2\uff08\u666e\u901a\u8bed\u6cd5\uff0c\u5efa\u8bae\u4f7f\u7528\u4e13\u6709\u8bed\u6cd5\uff0c\u8fd9\u91cc\u662f\u901a\u7528\u8bed\u6cd5\u793a\u4f8b\uff09\n\n```\nm = MySQLTool()\n# \u67e5\u770bmysql\u5bb9\u5668\u5185 ip\uff0c\u53c2\u8003\u8fd9\u4e2a\u94fe\u63a5\uff1ahttps://blog.csdn.net/CSDN_duomaomao/article/details/75638544\nm.connect(user=user,\n          password=pw,\n          # host=ip,\n          database=database)\nresult = m.run_sql([\n    ['insert person(name,age) values (%s, %s)', ['\u516d\u516d\u516d', 666]],\n    ['select * from person']\n])\nprint(result)\nm.close()\n```\n\n\u793a\u4f8b3\uff08\u540c\u65f6\u63d2\u5165\u591a\u884c\u6570\u636e\uff09\n\n```mysql\nwith MySQLTool(user=user, password=pw, database=database, host=host) as m2:\n\t# \u6267\u884csql\u5e76\u83b7\u5f97\u8fd4\u56de\u7ed3\u679c\n\tresult2 = m2.insert_more_rows(\n\t    'INSERT INTO key_value (k, val, creator_id, user_id, status) values (%s, %s, %s, %s, %s)',\n\t    [\n\t        ('c', 'AAA', 1, '1', 0),\n\t        ('d', 'BBB', 1, '1', 0)\n\t    ]\n\t)\n\tif result2 is not False:\n\t    print('success')\n\telse:\n\t    print('error!')\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/qq20004604/my-pip-package-list/tree/master/mysql_lingling/packaging_tutorial",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "mysql-lingling",
        "package_url": "https://pypi.org/project/mysql-lingling/",
        "platform": "",
        "project_url": "https://pypi.org/project/mysql-lingling/",
        "project_urls": {
            "Homepage": "https://github.com/qq20004604/my-pip-package-list/tree/master/mysql_lingling/packaging_tutorial"
        },
        "release_url": "https://pypi.org/project/mysql-lingling/0.0.8/",
        "requires_dist": [
            "mysql-connector (>=2.2.9)"
        ],
        "requires_python": "",
        "summary": "\u5bf9 mysql-connector \u7684\u4e8c\u6b21\u5c01\u88c5",
        "version": "0.0.8",
        "yanked": false,
        "yanked_reason": null
    },
    "last_serial": 6198077,
    "releases": {
        "0.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "733f36ec70064aafd452a034e66c5d9c",
                    "sha256": "a6356d9382cd4ab530bd62b4c0dbfe5b2d3c44b011cb7434ac27a92031b1b10d"
                },
                "downloads": -1,
                "filename": "mysql_lingling-0.0.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "733f36ec70064aafd452a034e66c5d9c",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5748,
                "upload_time": "2019-10-05T08:43:13",
                "upload_time_iso_8601": "2019-10-05T08:43:13.601060Z",
                "url": "https://files.pythonhosted.org/packages/36/d6/bbebea7d0ce4407a83e24264d6faa14dd7f809484715f8787aeb1603b2fb/mysql_lingling-0.0.1-py3-none-any.whl",
                "yanked": false,
                "yanked_reason": null
            }
        ],
        "0.0.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6bcc87c6ffe53f73404f2a2a688a992f",
                    "sha256": "35ed0b5e066dca737279eb493018152e9d69e5f1568980f9e4817c1785bd6bed"
                },
                "downloads": -1,
                "filename": "mysql_lingling-0.0.5-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "6bcc87c6ffe53f73404f2a2a688a992f",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5774,
                "upload_time": "2019-10-09T00:49:37",
                "upload_time_iso_8601": "2019-10-09T00:49:37.537519Z",
                "url": "https://files.pythonhosted.org/packages/9f/a5/6ca92eb9593c56df407eba5d8b3642c63da504bb02f60ee8bbfbd1c27af4/mysql_lingling-0.0.5-py3-none-any.whl",
                "yanked": false,
                "yanked_reason": null
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "b79e770b3cbce6a0c7bd66fddf16c5d5",
                    "sha256": "3b022963636d4da83db0bc3d7358fafe484f4e5e5c971c0a7dde88b337768030"
                },
                "downloads": -1,
                "filename": "mysql_lingling-0.0.5.tar.gz",
                "has_sig": false,
                "md5_digest": "b79e770b3cbce6a0c7bd66fddf16c5d5",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4336,
                "upload_time": "2019-10-09T00:49:39",
                "upload_time_iso_8601": "2019-10-09T00:49:39.122780Z",
                "url": "https://files.pythonhosted.org/packages/7b/64/08a862d57fda8fb2d41e4d4012f6af7e2162e638ed288e0a6576042ed2b1/mysql_lingling-0.0.5.tar.gz",
                "yanked": false,
                "yanked_reason": null
            }
        ],
        "0.0.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b8eb5d2e128737d1f00bc7a0cc42eecd",
                    "sha256": "b74b7529d1c08b67bc4e679999ac2868a14015dce9e370593991c5cd8af08142"
                },
                "downloads": -1,
                "filename": "mysql_lingling-0.0.6-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "b8eb5d2e128737d1f00bc7a0cc42eecd",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5784,
                "upload_time": "2019-10-24T03:13:32",
                "upload_time_iso_8601": "2019-10-24T03:13:32.242513Z",
                "url": "https://files.pythonhosted.org/packages/83/a4/cf9ec14e01303a1834b325e795706d43fba8f8936bcb7868f9b871b88405/mysql_lingling-0.0.6-py3-none-any.whl",
                "yanked": false,
                "yanked_reason": null
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "ffd520da1df20494e8fb3100d50bce18",
                    "sha256": "576e6261c37331089ac533f0b2ee10967af3668412ec952db87a5ac33c9be881"
                },
                "downloads": -1,
                "filename": "mysql_lingling-0.0.6.tar.gz",
                "has_sig": false,
                "md5_digest": "ffd520da1df20494e8fb3100d50bce18",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4349,
                "upload_time": "2019-10-24T03:13:33",
                "upload_time_iso_8601": "2019-10-24T03:13:33.938129Z",
                "url": "https://files.pythonhosted.org/packages/44/a9/fe0e2b7632b51b5f37dbc2bcfcbef20669d5ca0de81da50d25b5b500f84b/mysql_lingling-0.0.6.tar.gz",
                "yanked": false,
                "yanked_reason": null
            }
        ],
        "0.0.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "9affd29b0bc508ae3b2c90562b5450fc",
                    "sha256": "df7022dc78702f161b4a047d98ba938105bcb859c3f129ba4fa374e83c7298a3"
                },
                "downloads": -1,
                "filename": "mysql_lingling-0.0.7-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "9affd29b0bc508ae3b2c90562b5450fc",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5826,
                "upload_time": "2019-11-06T16:41:43",
                "upload_time_iso_8601": "2019-11-06T16:41:43.216276Z",
                "url": "https://files.pythonhosted.org/packages/88/32/40bfc9ae2966fb1ad9467f8145da72626851981a64cc411108a386d07593/mysql_lingling-0.0.7-py3-none-any.whl",
                "yanked": false,
                "yanked_reason": null
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "861d27cde69c8ba6a367d184aae3a114",
                    "sha256": "4d13181a08dfb5672f47d3476f3abe8132998c2552a9edde73cb732314ff6ee0"
                },
                "downloads": -1,
                "filename": "mysql_lingling-0.0.7.tar.gz",
                "has_sig": false,
                "md5_digest": "861d27cde69c8ba6a367d184aae3a114",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4374,
                "upload_time": "2019-11-06T16:41:46",
                "upload_time_iso_8601": "2019-11-06T16:41:46.003891Z",
                "url": "https://files.pythonhosted.org/packages/58/8a/a89181f9d5bf456ca6f459ecb0a09f9a46e0817514ee947e047d9fe7f016/mysql_lingling-0.0.7.tar.gz",
                "yanked": false,
                "yanked_reason": null
            }
        ],
        "0.0.8": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "40b244e8bbf71234e4a7a6641aac14cb",
                    "sha256": "c4eb28234815b41c7581e9d3650ac3d9d317a749214fff6ad59c53f53df1dc63"
                },
                "downloads": -1,
                "filename": "mysql_lingling-0.0.8-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "40b244e8bbf71234e4a7a6641aac14cb",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5897,
                "upload_time": "2019-11-26T01:49:46",
                "upload_time_iso_8601": "2019-11-26T01:49:46.059151Z",
                "url": "https://files.pythonhosted.org/packages/5e/8d/a89c466fac54f3d8ca07d0eac492ccb3016b4c4de5efe637a18c33595632/mysql_lingling-0.0.8-py3-none-any.whl",
                "yanked": false,
                "yanked_reason": null
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "6f3a4a847aaee6f1013c824c0af26b3e",
                    "sha256": "48d793e3dff1f13b82cac994ed0af98a8f36538522606c79522cc141bbf04b03"
                },
                "downloads": -1,
                "filename": "mysql_lingling-0.0.8.tar.gz",
                "has_sig": false,
                "md5_digest": "6f3a4a847aaee6f1013c824c0af26b3e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4458,
                "upload_time": "2019-11-26T01:49:47",
                "upload_time_iso_8601": "2019-11-26T01:49:47.656660Z",
                "url": "https://files.pythonhosted.org/packages/56/cf/18b0394459f4985a76fd31c52eae36dd8bca153c4ddd33665f7d66557d42/mysql_lingling-0.0.8.tar.gz",
                "yanked": false,
                "yanked_reason": null
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "40b244e8bbf71234e4a7a6641aac14cb",
                "sha256": "c4eb28234815b41c7581e9d3650ac3d9d317a749214fff6ad59c53f53df1dc63"
            },
            "downloads": -1,
            "filename": "mysql_lingling-0.0.8-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "40b244e8bbf71234e4a7a6641aac14cb",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 5897,
            "upload_time": "2019-11-26T01:49:46",
            "upload_time_iso_8601": "2019-11-26T01:49:46.059151Z",
            "url": "https://files.pythonhosted.org/packages/5e/8d/a89c466fac54f3d8ca07d0eac492ccb3016b4c4de5efe637a18c33595632/mysql_lingling-0.0.8-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "6f3a4a847aaee6f1013c824c0af26b3e",
                "sha256": "48d793e3dff1f13b82cac994ed0af98a8f36538522606c79522cc141bbf04b03"
            },
            "downloads": -1,
            "filename": "mysql_lingling-0.0.8.tar.gz",
            "has_sig": false,
            "md5_digest": "6f3a4a847aaee6f1013c824c0af26b3e",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 4458,
            "upload_time": "2019-11-26T01:49:47",
            "upload_time_iso_8601": "2019-11-26T01:49:47.656660Z",
            "url": "https://files.pythonhosted.org/packages/56/cf/18b0394459f4985a76fd31c52eae36dd8bca153c4ddd33665f7d66557d42/mysql_lingling-0.0.8.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "vulnerabilities": []
}