PyMysqlTools


NamePyMysqlTools JSON
Version 0.6.6 PyPI version JSON
download
home_pagehttps://gitee.com/uraurara/PyMysqlTools
SummaryA library that makes MySQL operation more convenient.
upload_time2023-12-11 07:32:25
maintainer
docs_urlNone
authorulala
requires_python>=3.8.10
licenseMIT
keywords mysql client mysqluitls pymysqltools
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            
# PyMysqlTools


PyMysqlTools 是一个使用封装好的函数替代SQL语句来操作mysql的工具库



**环境配置**

PyMysqlTools 目前支持 Python3.6+ 且 MySQL5.6+ 版本



### 快速开始

- 下载本项目

  ```bash
  pip install PyMysqlTools
  ```

- 导入本项目到您的代码

  ```python
  import PyMysqlTools
  ```

  

1. 建立连接

   ```python
   import PyMysqlTools
   
   # 可以使用下面的示例代码直接获得一个mysql数据库的连接
   mysql = PyMysqlTools.connect(
       database='db_test',
       username='root',
       password='123456'
   )
   print(mysql) # <PyMysqlTools.main.Connect object>
   ```

2. 简单使用

   - 添加数据

     ```python
     # 准备待添加的数据, key=字段名, value=字段值
     data = {
         'username': 'abc',
         'password': 'abc123'
     }
     
     # 添加数据到数据表
     mysql.insert_one('tb_test', data)
     ```

     

   - 删除数据

     ```python
     # 根据id删除数据
     mysql.delete_by_id('tb_test', 2)
     ```

     

   - 修改数据

     ```python
     # 准备待修改的数据, key=字段名, value=字段值
     data = {
         'username': 'abc',
         'password': 'abc123'
     }
     
     # 修改数据表中的数据
     mysql.update_by_id('tb_test', data, 3)
     ```

     

   - 查询数据

     ```python
     # 查询全表数据并遍历输出
     for row in mysql.find_all('tb_test'):
         print(row)
     ```




### 关于

如果您在使用时遇到了意料之外的结果,请[提交Issue](https://gitee.com/uraurara/PyMysqlTools/issues/new?issue%5Bassignee_id%5D=0&issue%5Bmilestone_id%5D=0)帮助我们改进此项目。



### Thanks

本项目在开发中使用了以下Python库
- [PyMySQL](https://gitee.com/src-openeuler/python-PyMySQL)
- [DBUtils](https://github.com/WebwareForPython/DBUtils)




            

Raw data

            {
    "_id": null,
    "home_page": "https://gitee.com/uraurara/PyMysqlTools",
    "name": "PyMysqlTools",
    "maintainer": "",
    "docs_url": null,
    "requires_python": ">=3.8.10",
    "maintainer_email": "",
    "keywords": "mysql,client,mysqluitls,PyMysqlTools",
    "author": "ulala",
    "author_email": "2713389652@qq.com",
    "download_url": "https://files.pythonhosted.org/packages/65/cb/062047e0ca7e1cdb8b4b407e550a9a779487280ac8badbfac99c63cae0ce/PyMysqlTools-0.6.6.tar.gz",
    "platform": null,
    "description": "\r\n# PyMysqlTools\r\n\r\n\r\nPyMysqlTools \u662f\u4e00\u4e2a\u4f7f\u7528\u5c01\u88c5\u597d\u7684\u51fd\u6570\u66ff\u4ee3SQL\u8bed\u53e5\u6765\u64cd\u4f5cmysql\u7684\u5de5\u5177\u5e93\r\n\r\n\r\n\r\n**\u73af\u5883\u914d\u7f6e**\r\n\r\nPyMysqlTools \u76ee\u524d\u652f\u6301 Python3.6+ \u4e14 MySQL5.6+ \u7248\u672c\r\n\r\n\r\n\r\n### \u5feb\u901f\u5f00\u59cb\r\n\r\n- \u4e0b\u8f7d\u672c\u9879\u76ee\r\n\r\n  ```bash\r\n  pip install PyMysqlTools\r\n  ```\r\n\r\n- \u5bfc\u5165\u672c\u9879\u76ee\u5230\u60a8\u7684\u4ee3\u7801\r\n\r\n  ```python\r\n  import PyMysqlTools\r\n  ```\r\n\r\n  \r\n\r\n1. \u5efa\u7acb\u8fde\u63a5\r\n\r\n   ```python\r\n   import PyMysqlTools\r\n   \r\n   # \u53ef\u4ee5\u4f7f\u7528\u4e0b\u9762\u7684\u793a\u4f8b\u4ee3\u7801\u76f4\u63a5\u83b7\u5f97\u4e00\u4e2amysql\u6570\u636e\u5e93\u7684\u8fde\u63a5\r\n   mysql = PyMysqlTools.connect(\r\n       database='db_test',\r\n       username='root',\r\n       password='123456'\r\n   )\r\n   print(mysql) # <PyMysqlTools.main.Connect object>\r\n   ```\r\n\r\n2. \u7b80\u5355\u4f7f\u7528\r\n\r\n   - \u6dfb\u52a0\u6570\u636e\r\n\r\n     ```python\r\n     # \u51c6\u5907\u5f85\u6dfb\u52a0\u7684\u6570\u636e, key=\u5b57\u6bb5\u540d, value=\u5b57\u6bb5\u503c\r\n     data = {\r\n         'username': 'abc',\r\n         'password': 'abc123'\r\n     }\r\n     \r\n     # \u6dfb\u52a0\u6570\u636e\u5230\u6570\u636e\u8868\r\n     mysql.insert_one('tb_test', data)\r\n     ```\r\n\r\n     \r\n\r\n   - \u5220\u9664\u6570\u636e\r\n\r\n     ```python\r\n     # \u6839\u636eid\u5220\u9664\u6570\u636e\r\n     mysql.delete_by_id('tb_test', 2)\r\n     ```\r\n\r\n     \r\n\r\n   - \u4fee\u6539\u6570\u636e\r\n\r\n     ```python\r\n     # \u51c6\u5907\u5f85\u4fee\u6539\u7684\u6570\u636e, key=\u5b57\u6bb5\u540d, value=\u5b57\u6bb5\u503c\r\n     data = {\r\n         'username': 'abc',\r\n         'password': 'abc123'\r\n     }\r\n     \r\n     # \u4fee\u6539\u6570\u636e\u8868\u4e2d\u7684\u6570\u636e\r\n     mysql.update_by_id('tb_test', data, 3)\r\n     ```\r\n\r\n     \r\n\r\n   - \u67e5\u8be2\u6570\u636e\r\n\r\n     ```python\r\n     # \u67e5\u8be2\u5168\u8868\u6570\u636e\u5e76\u904d\u5386\u8f93\u51fa\r\n     for row in mysql.find_all('tb_test'):\r\n         print(row)\r\n     ```\r\n\r\n\r\n\r\n\r\n### \u5173\u4e8e\r\n\r\n\u5982\u679c\u60a8\u5728\u4f7f\u7528\u65f6\u9047\u5230\u4e86\u610f\u6599\u4e4b\u5916\u7684\u7ed3\u679c\uff0c\u8bf7[\u63d0\u4ea4Issue](https://gitee.com/uraurara/PyMysqlTools/issues/new?issue%5Bassignee_id%5D=0&issue%5Bmilestone_id%5D=0)\u5e2e\u52a9\u6211\u4eec\u6539\u8fdb\u6b64\u9879\u76ee\u3002\r\n\r\n\r\n\r\n### Thanks\r\n\r\n\u672c\u9879\u76ee\u5728\u5f00\u53d1\u4e2d\u4f7f\u7528\u4e86\u4ee5\u4e0bPython\u5e93\r\n- [PyMySQL](https://gitee.com/src-openeuler/python-PyMySQL)\r\n- [DBUtils](https://github.com/WebwareForPython/DBUtils)\r\n\r\n\r\n\r\n",
    "bugtrack_url": null,
    "license": "MIT",
    "summary": "A library that makes MySQL operation more convenient.",
    "version": "0.6.6",
    "project_urls": {
        "Homepage": "https://gitee.com/uraurara/PyMysqlTools"
    },
    "split_keywords": [
        "mysql",
        "client",
        "mysqluitls",
        "pymysqltools"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "0f17f4ff0e380d212ea2107756b52c5efed786cd18f4f9b8551363e1e0461ede",
                "md5": "d2ad52b2af60aa77770026f509784a82",
                "sha256": "1678436f503a139b3eee156135abeef707c439cd49a5209c91ba1b3cf0787d35"
            },
            "downloads": -1,
            "filename": "PyMysqlTools-0.6.6-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "d2ad52b2af60aa77770026f509784a82",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.8.10",
            "size": 12111,
            "upload_time": "2023-12-11T07:32:23",
            "upload_time_iso_8601": "2023-12-11T07:32:23.809460Z",
            "url": "https://files.pythonhosted.org/packages/0f/17/f4ff0e380d212ea2107756b52c5efed786cd18f4f9b8551363e1e0461ede/PyMysqlTools-0.6.6-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "65cb062047e0ca7e1cdb8b4b407e550a9a779487280ac8badbfac99c63cae0ce",
                "md5": "8646daf749be2ae28933b0e4824f6f75",
                "sha256": "4652d236b158da9330797a6421b7f216f2d7fe9cbe9098350160886ceeb27452"
            },
            "downloads": -1,
            "filename": "PyMysqlTools-0.6.6.tar.gz",
            "has_sig": false,
            "md5_digest": "8646daf749be2ae28933b0e4824f6f75",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.8.10",
            "size": 11423,
            "upload_time": "2023-12-11T07:32:25",
            "upload_time_iso_8601": "2023-12-11T07:32:25.934177Z",
            "url": "https://files.pythonhosted.org/packages/65/cb/062047e0ca7e1cdb8b4b407e550a9a779487280ac8badbfac99c63cae0ce/PyMysqlTools-0.6.6.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2023-12-11 07:32:25",
    "github": false,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "lcname": "pymysqltools"
}
        
Elapsed time: 0.15356s