{
    "info": {
        "author": "zlyuan",
        "author_email": "1277260932@qq.com",
        "bugtrack_url": null,
        "classifiers": [
            "Environment :: Web Environment",
            "Intended Audience :: Developers",
            "Operating System :: OS Independent",
            "Programming Language :: Python",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.5",
            "Programming Language :: Python :: 3.6"
        ],
        "description": "\u7b80\u5355\u7684mysql\u5c01\u88c5\u5e93\n\n\u4f7f\u7528\u975e\u5e38\u7b80\u5355, \u76f4\u63a5\u8c03\u7528\u65b9\u6cd5\u64cd\u4f5c, \u4e0d\u9700\u8981\u518d\u53bb\u60f3sql\u4ee3\u7801\u4e86\n\n\u6d4b\u8bd5\u4ee3\u7801:\nif __name__ == '__main__':\n    # \u521b\u5efa\u64cd\u4f5c\u6570\u636e\u5e93\u7684\u5b9e\u4f8b\n    sql = zsql()\n    # \u521b\u5efa\u4e00\u4e2a\u5e93\n    sql.create_db('db_name')\n    # \u4f7f\u7528\u5e93\n    sql.use_db('db_name')\n    # \u521b\u5efa\u4e00\u4e2a\u8868\n    sql.create_table_ex('table_name', ID='int', name='char(16)', pwd='char(32)')\n    # \u4fdd\u5b58\u6570\u636e\n    sql.save_values('table_name', (0, '\u7528\u62370', '\u5bc6\u78010'), (1, '\u7528\u62371', '\u5bc6\u78011'))\n    # \u66f4\u65b0\u6570\u636e\n    sql.update('table_name', new_item=dict(name='\u65b0\u7528\u6237\u540d', pwd='\u65b0\u5bc6\u7801'), where=dict(name='\u7528\u62371', pwd='\u5bc6\u78011'))\n    # \u67e5\u8be2\u6570\u636e\n    data = sql.select_all('table_name')\n    # \u5220\u9664\u8868\n    sql.drop_table('table_name')\n    # \u5220\u9664\u5e93\n    sql.drop_db('db_name')\n    # \u663e\u793a\u6570\u636e\n    for v in data:\n        print(v)\n    # \u5173\u95ed\n    sql.close()\n\n    '''\n    \u6253\u5370\u51fa\u4ee5\u4e0b\u7ed3\u679c\n    CREATE DATABASE IF NOT EXISTS db_name DEFAULT CHARSET=utf8;\n    USE db_name;\n    USE db_name;\n    CREATE TABLE table_name (ID int, name char(16), pwd char(32)) DEFAULT CHARSET=utf8;\n    INSERT INTO table_name VALUES (0,'\u7528\u62370','\u5bc6\u78010'), (1,'\u7528\u62371','\u5bc6\u78011');\n    UPDATE table_name SET name = '\u65b0\u7528\u6237\u540d', pwd = '\u65b0\u5bc6\u7801' WHERE name='\u7528\u62371' AND pwd='\u5bc6\u78011';\n    SELECT * FROM table_name;\n    DROP TABLE IF EXISTS table_name;\n    DROP DATABASE IF EXISTS db_name;\n    (0, '\u7528\u62370', '\u5bc6\u78010')\n    (1, '\u65b0\u7528\u6237\u540d', '\u65b0\u5bc6\u7801')\n    '''\n\n\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://pypi.org/",
        "keywords": "",
        "license": "GNU GENERAL PUBLIC LICENSE",
        "maintainer": "",
        "maintainer_email": "",
        "name": "zsql",
        "package_url": "https://pypi.org/project/zsql/",
        "platform": "all",
        "project_url": "https://pypi.org/project/zsql/",
        "project_urls": {
            "Homepage": "https://pypi.org/"
        },
        "release_url": "https://pypi.org/project/zsql/1.0.2/",
        "requires_dist": [
            "pymysql"
        ],
        "requires_python": "",
        "summary": "\u7b80\u5355\u7684mysql\u5c01\u88c5\u5e93, \u4f7f\u7528\u975e\u5e38\u7b80\u5355, \u76f4\u63a5\u8c03\u7528\u65b9\u6cd5\u64cd\u4f5c, \u4e0d\u9700\u8981\u518d\u53bb\u60f3sql\u4ee3\u7801\u4e86",
        "version": "1.0.2"
    },
    "last_serial": 4376445,
    "releases": {
        "1.0.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "83eeaf5c2f176a86d4d24a3beb799894",
                    "sha256": "b00fa30aa127138d27073bf6d66a78744e18dbf9e72e885a52c51c924665db76"
                },
                "downloads": -1,
                "filename": "zsql-1.0.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "83eeaf5c2f176a86d4d24a3beb799894",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5364,
                "upload_time": "2018-10-11T03:48:30",
                "url": "https://files.pythonhosted.org/packages/af/23/f1aff5d206f0c7a1a97aa76223b1e0f2b60320b5910cc03d698479b78be9/zsql-1.0.0-py3-none-any.whl"
            }
        ],
        "1.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "47b71b5e8b09f20df8e1597927d4572d",
                    "sha256": "8fa4bf9f2cd3aad53375521a3879dc94e9ef2dde7f2c36a9d3cec6040fce8072"
                },
                "downloads": -1,
                "filename": "zsql-1.0.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "47b71b5e8b09f20df8e1597927d4572d",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5392,
                "upload_time": "2018-10-11T07:20:31",
                "url": "https://files.pythonhosted.org/packages/0d/48/1208ca8b4b311edc6270fe7efd95708dea20133432c8b04074acca978f66/zsql-1.0.1-py3-none-any.whl"
            }
        ],
        "1.0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "23e316ccaaf9f04c29d1208247a484eb",
                    "sha256": "0b5519b02bdcb3bc3497f62d5b6e1bcaf2c10e71349b671093f77b64594cc694"
                },
                "downloads": -1,
                "filename": "zsql-1.0.2-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "23e316ccaaf9f04c29d1208247a484eb",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5507,
                "upload_time": "2018-10-12T02:32:56",
                "url": "https://files.pythonhosted.org/packages/67/ac/52f6b0d4379701ff8fd94d8f5a71724432fbf950f6f8bb0ae315aebd6e54/zsql-1.0.2-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "989855caf2fd0d5c2187819fb31f8051",
                    "sha256": "afcbdafadb087b1d4412ba0a730a1b0977565ad05eca389d9a5b1ef87219aa4f"
                },
                "downloads": -1,
                "filename": "zsql-1.0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "989855caf2fd0d5c2187819fb31f8051",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5136,
                "upload_time": "2018-10-15T06:46:30",
                "url": "https://files.pythonhosted.org/packages/37/46/c56518cd60ca74333438eccf392f8007630e4d776e68c07b322cd1e82b05/zsql-1.0.2.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "23e316ccaaf9f04c29d1208247a484eb",
                "sha256": "0b5519b02bdcb3bc3497f62d5b6e1bcaf2c10e71349b671093f77b64594cc694"
            },
            "downloads": -1,
            "filename": "zsql-1.0.2-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "23e316ccaaf9f04c29d1208247a484eb",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 5507,
            "upload_time": "2018-10-12T02:32:56",
            "url": "https://files.pythonhosted.org/packages/67/ac/52f6b0d4379701ff8fd94d8f5a71724432fbf950f6f8bb0ae315aebd6e54/zsql-1.0.2-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "989855caf2fd0d5c2187819fb31f8051",
                "sha256": "afcbdafadb087b1d4412ba0a730a1b0977565ad05eca389d9a5b1ef87219aa4f"
            },
            "downloads": -1,
            "filename": "zsql-1.0.2.tar.gz",
            "has_sig": false,
            "md5_digest": "989855caf2fd0d5c2187819fb31f8051",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 5136,
            "upload_time": "2018-10-15T06:46:30",
            "url": "https://files.pythonhosted.org/packages/37/46/c56518cd60ca74333438eccf392f8007630e4d776e68c07b322cd1e82b05/zsql-1.0.2.tar.gz"
        }
    ]
}