{"id":68,"date":"2025-06-04T00:15:22","date_gmt":"2025-06-03T16:15:22","guid":{"rendered":"http:\/\/www.mavisblog.top\/?p=68"},"modified":"2025-06-04T00:15:22","modified_gmt":"2025-06-03T16:15:22","slug":"test8","status":"publish","type":"post","link":"http:\/\/mavisblog.top\/index.php\/2025\/06\/04\/test8\/","title":{"rendered":"\u63a5\u53e3\u81ea\u52a8\u5316(1)"},"content":{"rendered":"\n<p>\u76ee\u524d\u8f6f\u4ef6\u6d4b\u8bd5\u7684\u81ea\u52a8\u5316\u4e3b\u8981\u662f\u63a5\u53e3\u7684\u81ea\u52a8\u5316\uff0c\u5982selnium\u7b49UI\u81ea\u52a8\u5316\u5de5\u5177\u4ec5\u4ec5\u5728\u56de\u5f52\u6d4b\u8bd5\u4e2d\u6709\u6240\u5e94\u7528\u2026\u2026<\/p>\n\n\n\n<p>\u63a5\u53e3API\u7684\u81ea\u52a8\u5316\u5206\u4e3a\u4e24\u79cd\uff0c\u4e00\u79cd\u662f\u4f7f\u7528\u5de5\u5177\uff0c\u53e6\u4e00\u79cd\u662f\u4f7f\u7528Python\u4ee3\u7801\u81ea\u52a8\u5316\u6d4b\u8bd5\uff1b<\/p>\n\n\n\n<p>\u63a5\u53e3\u4e3b\u6d41\u7684\u6d4b\u8bd5\u81ea\u52a8\u5316\u5de5\u5177\u4e3b\u8981\u6709\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Postman<\/li>\n\n\n\n<li>Jemeter<\/li>\n\n\n\n<li>Fiddler<\/li>\n<\/ul>\n\n\n\n<p>\u5176\u4ed6\u7684\u6d4b\u8bd5\u5de5\u5177\u5927\u591a\u4f7f\u75284\u8981\u7d20\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>url<\/li>\n\n\n\n<li>methord<\/li>\n\n\n\n<li>headers<\/li>\n\n\n\n<li>body<\/li>\n<\/ul>\n\n\n\n<p><em><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-4-color\">\u63a5\u53e3\u6587\u6863\u4e00\u822c\u662f\u5fc5\u6709\u7684\uff0c\u7531\u5f00\u53d1\u7ecf\u7406\u6216\u8005\u67b6\u6784\u5e08\u4ea7\u51fa\u3002<\/mark><\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">API\u81ea\u52a8\u5316\u5e38\u7528\u5e93<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Requests&#8212;&gt;\u7528\u4e8ePython\u53d1\u9001\u63a5\u53e3\u8bbf\u95ee\u7684\u8bf7\u6c42<\/li>\n\n\n\n<li>Pytest&#8212;&gt;\u9a71\u52a8\u6570\u636e\uff0c\u7ec4\u7ec7\u6d4b\u8bd5\u7528\u4f8b<\/li>\n\n\n\n<li>Logging&#8212;&gt;\u65e5\u5fd7\u5e93<\/li>\n\n\n\n<li>Pymysql&#8212;&gt;Python\u8bfb\u53d6\u6570\u636e\u5e93<\/li>\n<\/ul>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-4-color\"><strong>\u76ee\u524d\u5e38\u7528\u7684\u662f\u963f\u91cc\u7684oceanbase\u5e93<\/strong><\/mark><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"has-text-align-left\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-4-color\">Python\u4ee3\u7801\u6d4b\u8bd5\u662f\u5fc5\u8981\u7684\uff0cnginx\u53cd\u5411\u4ee3\u7406\u540e\u65e0\u6cd5\u4f7f\u7528\u6293\u5305\u5de5\u5177\u8fdb\u884c\u6293\u5305<\/mark><\/p>\n<\/blockquote>\n\n\n\n<p>\u5e93\u73af\u5883\u7684\u5e94\u7528\u7248\u672c\u9009\u62e9\u8981\u4e92\u4e0d\u51b2\u7a81\u3002<\/p>\n\n\n\n<p>\u5e93\u7684\u5b89\u88c5\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/sh\n# 1\u5347\u7ea7 python3.8 \u548c pip3 \napt install -y python3.8\nrm -rf \/usr\/bin\/python3\nln -s \/usr\/bin\/python3.8  \/usr\/bin\/python3\n# 2.\u5b89\u88c5\u8bfe\u7a0b\u9700\u8981\u7684\u5e93\npip3 install requests==2.18.4\n## \u5b98\u65b9bug\u4fee\u590dhttps:\/\/www.osgeo.cn\/pytest\/announce\/release-6.0.1.html\npip3 install pytest==6.0.1\npip3 install pytest-html==3.1.1\n#\u6ce8\u610f\u8fd9\u91cc\u662f\u5bf9\u6307\u5b9a\u7248\u672c\u4fee\u590d\u5347\u7ea7 \u4e0d\u80fd\u4e0b\u8f7d\u6700\u65b0\u7248\u672c \u5e93\u4e4b\u95f4\u4e0d\u517c\u5bb9\u7684~\uff01\npip3 install pytest==8.0.1\npip3 install attrs==19.1.0\npip3 install PyMySQL==1.0.2\npip3 install allure-pytest==2.9.45\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Request \u5e93<\/h3>\n\n\n\n<p>\u5b98\u65b9\u7f51\u7ad9\uff1a<a href=\"https:\/\/pypi.org\/\">https:\/\/pypi.org\/<\/a><\/p>\n\n\n\n<p>\u8fd1\u671fAPI\uff1a<a href=\"https:\/\/requests.readthedocs.io\/en\/latest\/api\/\">https:\/\/requests.readthedocs.io\/en\/latest\/api\/<\/a><\/p>\n\n\n\n<figure class=\"wp-block-table aligncenter\"><table class=\"has-fixed-layout\"><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">\u5e93-\u5bf9\u8c61\u540d<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5bf9\u8c61API\u529f\u80fd<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">requests<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u53d1\u8bf7\u6c42<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">1.1get \uff08url=&amp;\u62fc\u63a5\u53c2\u6570\u503c,headers\u8bf7\u6c42\u5934\uff09<br><br>1.2 post\u8bf7\u6c42 <br><br>1.2.1 \u53d1\u9001\u8bf7\u6c42\u4f53\u5f0f\u5b57\u7b26\u4e32 post(url\uff0cheaders\u8bf7\u6c42\u5934\uff0cdata=\u8bf7\u6c42\u4f53\u6570\u636e)<br><br> 1.2.2 \u53d1\u9001\u8bf7\u6c42\u4f53json| \u5b57\u5178<br>post(url\uff0cheaders\u8bf7\u6c42\u5934\uff0cjson=\u8bf7\u6c42\u4f53\u6570\u636e)&nbsp;&nbsp;&nbsp;<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">\u54cd\u5e94\u7ed3\u679c\uff1a<br>encoding=&#8217;utf-8&#8242;<br>2.1 \u72b6\u6001\u7801<br>status_code<br>2.2 \u54cd\u5e94\u5934<br>\u7ed3\u679c.headers<br>2.3 \u54cd\u5e94\u4f53<br>2.3.1 \u5b57\u7b26\u4e32\u54cd\u5e94\u4f53 text<br>2.3.2 json\u54cd\u5e94\u4f53 &nbsp;<br>json()<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u4e0a\u4e0b\u6e38\u63a5\u53e3\u8c03\u8bd5<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#1 \u63a5\u53e3\u6587\u6863\u8981\u7d20\nimport requests\n#           \u8fd0\u7ef4\u670d\u52a1\u5668            + \u63a5\u53e3\u5730\u5740\nlogin_url=\"http:\/\/localhost:6088\/api\/User\"\nlogin_headers={'Content-Type':'application\/json'}\nlogin_method='post'\nlogin_body={\n    \"username\": \"admin\" ,\n    \"password\": \"123\"}\n\n# = \u5de6\u8fb9API\u8868\n# = \u53f3\u8fb9\u5b9e\u9645\u53c2\u6570  \u6765\u81ea\u4e8e\u63a5\u53e3\u6587\u6863\n\nshiji=requests.post(url=login_url,headers=login_headers,json=login_body)\n\nprint(shiji.status_code)\nprint(shiji.headers)\nprint(shiji.json())\n\n# \u4e0b\u6e38\u4ee3\u7801---\u300b\u4e00\u4e2a\u503c  \u73af\u5883\u53d8\u91cf\uff5e \u6b63\u5219\u8868\u8fbe\u63d0\u53d6\u5668  \u5b58    {{}}  ${}\u5f15\u7528\nshouquanma=shiji.headers&#91;'Authorization']\nprint(shouquanma)\n\n\n\n# \u53d1\u51fa\u4e0b\u6e38\u63a5\u53e3\n\n#           \u8fd0\u7ef4\u670d\u52a1\u5668            + \u63a5\u53e3\u5730\u5740\nuser_url='http:\/\/localhost:6088\/api\/User?IsEnabled=true&amp;Page=1'\nurl_headers={'Authorization':shouquanma}\nuser_method='get'\n\n\n# = \u5de6\u8fb9API\u8868\n# = \u53f3\u8fb9\u5b9e\u9645\u53c2\u6570  \u6765\u81ea\u4e8e\u63a5\u53e3\u6587\u6863\n\nshiji=requests.get(url=user_url,headers=url_headers)\n\nprint(shiji.status_code)\nprint(shiji.headers)\nprint(shiji.json())<\/code><\/pre>\n\n\n\n<p>requests \u5e93\u63d0\u4f9b\u4e86API\uff08application program interface \uff09<\/p>\n\n\n\n<p>\u4e0a\u6e38\u4f20\u9012\u6388\u6743\u7801\u65f6\u53ef\u4ee5\u4f7f\u7528get+\u9ed8\u8ba4\u503c\u7684\u65b9\u5f0f\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u4e0b\u6e38\u4ee3\u7801---\u300b\u4e00\u4e2a\u503c  \u73af\u5883\u53d8\u91cf\uff5e \u6b63\u5219\u8868\u8fbe\u63d0\u53d6\u5668  \u5b58    {{}}  ${}\u5f15\u7528\nshouquanma=shiji.headers.get('Authorization','error')<\/code><\/pre>\n\n\n\n<p>\u4e5f\u53ef\u4ee5\u4f7f\u7528try\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>try:\n    # \u63d0\u53d6json\u54cd\u5e94\u4f53\n    body=shiji.json()\nexcept:  # try \u4e2d\u62a5\u9519\u6267\u884c\u672c\u5206\u652f+ \u65ad\u8a00 \u5931\u8d25 \u6267\u884c\u672c\u5206\u652f\uff5e\n    body=\"\u65e0\u7ed3\u679c\uff5e\"\n    print(\"\u83b7\u53d6\u7ed3\u679c\u5931\u8d25\u6709bug\uff5e\")\nelse: # try \u4e2d\u4e0d\u62a5\u9519\u6267\u884c\u672c\u5206\u652f   +\u65ad\u8a00\u6210\u529f \u6267\u884c\u672c\u5206\u652f \n \n    print(\"\u83b7\u53d6\u7ed3\u679c\u6210\u529f\u65e0bug\uff5e\")\nfinally: # \u4e0d\u7ba1try \u662f\u5426\u6709\u5f02\u5e38  \u90fd\u8981\u8fd0\u884c\uff5e\n    print(body)\n    print(\"\u83b7\u53d6\u7ed3\u679c\u7ed3\u675f\uff5e\")<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Pytest \u5e93<\/h3>\n\n\n\n<p>\u548cunitest\u4e00\u6837\u7684\u5355\u5143\u6d4b\u8bd5\u6846\u67b6\uff0c\u4f46\u662f\u66f4\u52a0\u65b9\u4fbf\uff0c\u81ea\u5e26\u62a5\u544a\uff0c\u66f4\u65b9\u4fbf\u7684<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-3-color\">ddt\uff08\u6570\u636e\u9a71\u52a8\uff09<\/mark><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u5bfc\u5165 pytest \u6d4b\u8bd5\u6846\u67b6\nimport pytest\n# \u5b9a\u4e49 TestOrdering \u7c7b\nclass Test11():\n    # \u5b9a\u4e49 test_login11() \u65b9\u6cd5\n    def test_login11(self):\n        print(\" \u6b63\u5728\u6267\u884c\u767b\u5f55\u7528\u4f8b\u7b2c\u4e00\u6761 \")\n    # \u5b9a\u4e49 test_add() \u65b9\u6cd5\n    def test_login22(self):\n        print(\" \u6b63\u5728\u6267\u884c\u767b\u5f55\u7528\u4f8b\u7b2c\u4e8c\u6761 \")\n    # \u5b9a\u4e49 test_del() \u65b9\u6cd5\n    def test_login33(self):\n        print(\" \u6b63\u5728\u6267\u884c\u767b\u5f55\u7528\u4f8b\u7b2c\u4e09\u6761 \")\nif __name__ == '__main__':\n    '''\n    \u8fd0\u884c\u65b9\u5f0f\uff0c\u76f4\u63a5\u5728\u6587\u4ef6\u5185\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\n    \u5176\u4e2d\uff0c -v \u53c2\u6570\u663e\u793a\u547d\u4ee4\u6267\u884c\u8fc7\u7a0b\uff0c -s \u53c2\u6570\u663e\u793a\u6253\u5370\u7684\u4fe1\u606f\n    \u5982\u4e0d\u52a0 -s \u53c2\u6570\uff0c\u5219 print() \u51fd\u6570\u6253\u5370\u7684\u4fe1\u606f\u4e0d\u4f1a\u663e\u793a\n    '''\n    pytest.main(&#91;'-v','-s','jw1.py'])<\/code><\/pre>\n\n\n\n<p>if\u5224\u65ad\u8bed\u53e5\u68c0\u6d4b\u7684\u662f\u811a\u672c\u662f\u5426\u662f\u76f4\u63a5\u8fd0\u884c\u7684\uff0c\u8fd8\u662f\u88ab\u5bfc\u5165\u7684\uff0c\u53ea\u6709\u76f4\u63a5\u8fd0\u884c\u65f6\u624d\u4f1a\u6267\u884c\u4e0b\u9762\u7684\u6d4b\u8bd5\u7528\u4f8b\u6267\u884c\u5668\u3002<\/p>\n\n\n\n<p>\u6d4b\u8bd5\u56fa\u4ef6\uff1a\uff08\u8001\u7248\u672c\u53ea\u7528setup\uff0cteardown\uff09<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u5bfc\u5165 pytest \u6d4b\u8bd5\u6846\u67b6\nimport pytest\n# \u5b9a\u4e49 TestOrdering\n\nclass Test11():\n    def setup_class(self):\n        print('all the test case preparation')\n    def teardown_class(self):\n        print('all the test case closure')\n    def setup_method(self):\n        print('test case preparation')\n    def teardown_method(self):\n        print('test case closure')\n    # \u5b9a\u4e49 test_login11() \u65b9\u6cd5\n    def test_login11(self):\n        print(\" \u6b63\u5728\u6267\u884c\u767b\u5f55\u7528\u4f8b\u7b2c\u4e00\u6761 \")\n    # \u5b9a\u4e49 test_add() \u65b9\u6cd5\n    def test_login22(self):\n        print(\" \u6b63\u5728\u6267\u884c\u767b\u5f55\u7528\u4f8b\u7b2c\u4e8c\u6761 \")\n    # \u5b9a\u4e49 test_del() \u65b9\u6cd5\n    def test_login33(self):\n        print(\" \u6b63\u5728\u6267\u884c\u767b\u5f55\u7528\u4f8b\u7b2c\u4e09\u6761 \")\nif __name__ == '__main__':\n    '''\n    \u8fd0\u884c\u65b9\u5f0f\uff0c\u76f4\u63a5\u5728\u6587\u4ef6\u5185\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\n    \u5176\u4e2d\uff0c -v \u53c2\u6570\u663e\u793a\u547d\u4ee4\u6267\u884c\u8fc7\u7a0b\uff0c -s \u53c2\u6570\u663e\u793a\u6253\u5370\u7684\u4fe1\u606f\n    \u5982\u4e0d\u52a0 -s \u53c2\u6570\uff0c\u5219 print() \u51fd\u6570\u6253\u5370\u7684\u4fe1\u606f\u4e0d\u4f1a\u663e\u793a\n    '''\n    pytest.main(&#91;'-v','-s','test.py'])\n<\/code><\/pre>\n\n\n\n<p>\u5199\u7528\u4f8b\uff0c\u8c03\u7528\u5f00\u53d1\u4ee3\u7801\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import pytest\n\nfrom testdev import Count\n\nclass TestAdd():\n    def test_add(self):\n#     # design test case--&gt;expect result\n#         a = 1\n#         b = 2\n#         expect = 3\n#     # #invoke development code,test procedure----&gt;actual result\n#         c1 = Count(a, b)\n#         result = c1.add()\n#     # #result of assertion:\n#         assert result == expect\n# #symplify the above code to:\n        assert Count(50,50).add()\nif __name__ == '__main__':\n    pytest.main(&#91;'-v','-s','test2.py'])\n<\/code><\/pre>\n\n\n\n<p>\u7ec3\u4e60\uff0c\u8c03\u7528\u7d20\u6570\u68c0\u67e5\u6a21\u5757\u529f\u80fd\uff0c\u4f7f\u7528\u771f\u5047\u65ad\u8a00\uff0c\u975e\u65ad\u8a00\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import pytest\nfrom tsetdev1 import is_prime\nclass TestCord:\n    def test_1(self):\n        assert is_prime(19)\n    def test_2(self):\n        assert not is_prime(9)\nif __name__ == '__main__':\n    pytest.main(&#91;'-v', '-s', 'test3.py'])\n<\/code><\/pre>\n\n\n\n<p>pytest\u8fdb\u884c\u6570\u636e\u9a71\u52a8\uff1a<\/p>\n\n\n\n<p>\u6bcf\u6761\u7528\u4f8b\u7684\u53c2\u6570\u4e0d\u540c\u800c\u8fc7\u7a0b\u76f8\u540c\u65f6\uff0c\u53ef\u4ee5\u8fdb\u884c\u53c2\u6570\u5316\uff0c\u65b9\u4fbfddt\u3002<\/p>\n\n\n\n<p>\u8bed\u6cd5\uff1a<\/p>\n\n\n\n<p>@pytest.mark.parametrize\uff08\u2018\u53c2\u6570\u540d\u5b57\u2019\uff0c[\u6570\u636e]\uff09<\/p>\n\n\n\n<p>def test_xxx(self,\u53c2\u6570\u540d)\uff1a<em><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-4-color\">\uff08self\u662f\u7c7b\u7684\u7b2c\u4e00\u4e2a\u56fa\u5b9a\u53c2\u6570\uff0c\u5982\u679c\u53c2\u6570\u5316\u7684\u65b9\u6cd5\u5199\u5230\u4e86\u7c7b\u91cc\u9762\u5c31\u5fc5\u987b\u52a0\u4e0aself\uff09<\/mark><\/em><\/p>\n\n\n\n<p>      pass<\/p>\n\n\n\n<p>\u53c2\u6570\u7684\u6570\u636e\u7c7b\u578b\u6ca1\u6709\u8981\u6c42\u4f46\u662f\u8981\u4e00\u81f4\u3002<\/p>\n\n\n\n<p>\u5217\u8868\u4e2d\u7684\u6570\u636e\u4e2a\u6570\u51b3\u5b9a\u4e86\u6267\u884c\u6b21\u6570\u3002<\/p>\n\n\n\n<p>\u4f8b\u5b50\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import pytest\n\n\n@pytest.mark.parametrize('username', &#91;'lucy', 'natsu', 'gray'])\nclass TestCode:\n\n    def test_1(username):\n        print(f'the test case is {username}')\nif __name__ == '__main__':\n    pytest.main(&#91;'-s','-v','test4.py'])<\/code><\/pre>\n\n\n\n<p>\u6570\u636e\u4e3a\u5143\u7ec4\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import pytest\nfrom testdev import Count\n\nclass Test():\n    @pytest.mark.parametrize('Data',&#91;(1,2,3),(2,3,5),(3,6,9)])\n    def test_1(self,Data):\n        print(f\"current use case data :{Data}\")\n        assert Data&#91;2]==Count.add(Data&#91;0],Data&#91;1])\nif __name__ == '__main__':\n    pytest.main(&#91;'-v','-s','test5.py'])<\/code><\/pre>\n\n\n\n<p>\u4e00\u6761\u7528\u4f8b\u6709\u591a\u4e2a\u6570\u636e\u7684\uff0c\u6bd4\u5982\u6709\u7528\u6237\u540d\u5bc6\u7801\u548c\u9884\u671f\u7ed3\u679c\u7684\u65f6\u5019\uff1a<\/p>\n\n\n\n<p>1\u3001\u5355\u53c2\u6570\u52a0\u5b57\u5178\u5b9e\u73b0\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import pytest\nfrom testdev import Count\n\nclass Test():\n    @pytest.mark.parametrize('Data',&#91;(1,2,3),(2,3,5),(3,6,9)])\n    def test_1(self,Data):\n        print(f\"current use case data :{Data}\")\n        assert Data&#91;2]==Count.add(Data&#91;0],Data&#91;1])\nif __name__ == '__main__':\n    pytest.main(&#91;'-v','-s','test5.py'])<\/code><\/pre>\n\n\n\n<p>2\u3001\u591a\u53c2\u6570\u5b9e\u73b0\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import pytest\n\n@pytest.mark.parametrize('username',&#91;'natsu','gray','arsa'])\n@pytest.mark.parametrize('pwd',&#91;'123','456','789'])\n@pytest.mark.parametrize('expect',&#91;True,True,False])\ndef test_login(username,pwd,expect):\n    print(f'current use case username:{username},pwd:{pwd},expect:{expect}')\nif __name__ == '__main__':\n    pytest.main(&#91;'-sv','test7.py'])<\/code><\/pre>\n\n\n\n<p>\u591a\u53c2\u6570\u904d\u5386\u4e86\u6240\u6709\u7684\u53c2\u6570\uff0c\u5982\u4e0a\u9762\u8fd9\u4e2a\u4ee3\u7801\u904d\u5386\u4e8627\u6761\u7528\u4f8b\uff0c\u5b9e\u9645\u4e0a\u4e0d\u80fd\u5f88\u597d\u7684\u786e\u5b9a\u7528\u4f8b\u7684\u9884\u671f\u7ed3\u679c\u3002 \u9700\u8981\u4f7f\u7528pymysql\u4ee3\u7801\u3002<\/p>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0);color:#f1ee08\" class=\"has-inline-color\">\u6570\u636e\u9a71\u52a8\u4e3b\u8981\u4ee5\u5355\u9a71\u52a8\u4e3a\u4e3b\u3002<\/mark><\/p>\n\n\n\n<!--nextpage-->\n\n\n\n<h3 class=\"wp-block-heading\">\u9879\u76ee\u6846\u67b6\u548c\u81ea\u52a8\u5316\u62a5\u544a<\/h3>\n\n\n\n<p>pytest\u7684pytest.ini\u914d\u7f6e\u6587\u4ef6\u662f\u4e00\u4e2a\u56fa\u5b9a\u914d\u7f6e\u6587\u4ef6\uff0cpytest.ini\u7528\u4e8e\u8bfb\u53d6\u6574\u4e2a\u9879\u76ee\u7684\u914d\u7f6e\u4fe1\u606f\uff0cpytest\u6309\u7167\u6b64\u914d\u7f6e\u6587\u4ef6\u6307\u5b9a\u65b9\u5f0f\u8fd0\u884c\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u914d\u7f6e\u6587\u4ef6\u653e\u5728\u9879\u76ee\u7684\u6839\u76ee\u5f55\u4e0b<\/li>\n\n\n\n<li>\u6587\u4ef6\u540d\u56fa\u5b9a\u4e0d\u53ef\u4fee\u6539<\/li>\n\n\n\n<li>\u6587\u4ef6\u4e2d\u4e0d\u5f97\u51fa\u73b0\u4e2d\u6587\u4ee5\u53ca\u6ce8\u91ca<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6587\u4ef6\u8bf4\u660e\u5982\u4e0b:<\/li>\n\n\n\n<li>4.1 addopts \u58f0\u660e\u8fd0\u884c\u65b9\u5f0f\u4ee5\u53ca\u751f\u6210\u62a5\u544a\u5982\u4e0b<\/li>\n\n\n\n<li>4.2 testpaths \u6307\u5b9a\u7528\u4f8b\u6587\u4ef6\u540d\u5b57<\/li>\n\n\n\n<li>4.3 python_files \u6307\u5b9a\u7528\u4f8b\u6240\u5728\u6587\u4ef6<\/li>\n\n\n\n<li>4.4 python_classes \u6307\u5b9a\u7528\u4f8b\u7c7b\u6240\u5728\u4f4d\u7f6e<\/li>\n\n\n\n<li>4.5 python_functions \u6307\u5b9a\u7528\u4f8b\u6240\u5728\u7684\u4f4d\u7f6e<\/li>\n<\/ul>\n\n\n\n<p>\u4f8b\u5b50\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;pytest]\naddopts = -s -v --html=..\/report\/report.html\ntestpaths = testcase\npython_files = test_*.py\npython_classes = Test*\npython_functions = test*\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">logging \u5e93<\/h3>\n\n\n\n<p>Python\u81ea\u5e26\u7684\u65e5\u5fd7\u5e93\uff0c\u9700\u8981\u638c\u63e1\u57fa\u672c\u7684API\u3002<\/p>\n\n\n\n<p>\u5de5\u5177\u7c7b\uff1a\u5c01\u88c5API\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u4f1a\u6253\u5370WARNING\u7ea7\u522b\u7684\u65e5\u5fd7<\/li>\n\n\n\n<li>DEBUG\uff1a\u8be6\u7ec6\u4fe1\u606f\uff0c\u8c03\u8bd5\u4fe1\u606f\u3002<\/li>\n\n\n\n<li>INFO\uff1a\u786e\u8ba4\u4e00\u5207\u6309\u9884\u671f\u8fd0\u884c\u3002<\/li>\n\n\n\n<li>WARNING\uff1a\u8868\u660e\u53d1\u751f\u4e86\u4e00\u4e9b\u610f\u5916\uff0c\u6216\u8005\u4e0d\u4e45\u7684\u5c06\u6765\u4f1a\u53d1\u751f\u95ee\u9898\uff08\u5982\u2018\u78c1\u76d8\u6ee1\u4e86&#8217;\uff09\u3002\u8f6f\u4ef6\u8fd8\u662f\u5728\u6b63\u5e38\u5de5\u4f5c\u3002&#8212;-\u9ed8\u8ba4\u7ea7\u522b<\/li>\n\n\n\n<li>ERROR\uff1a\u7531\u4e8e\u66f4\u4e25\u91cd\u7684\u95ee\u9898\uff0c\u8f6f\u4ef6\u5df2\u4e0d\u80fd\u6267\u884c\u4e00\u4e9b\u529f\u80fd\u4e86\u3002<\/li>\n\n\n\n<li>CRITICAL\uff1a\u4e25\u91cd\u9519\u8bef\uff0c\u8868\u660e\u8f6f\u4ef6\u5df2\u4e0d\u80fd\u7ee7\u7eed\u8fd0\u884c\u4e86\u3002<\/li>\n\n\n\n<li>\u6ce8\u610f\uff1a<\/li>\n\n\n\n<li>\u65e5\u5fd7\u7b49\u7ea7 DEBUG\u8be6\u7ec6&lt;INFO&lt;WARNING&lt;ERROR&lt;CRITICAL\u7b80\u7565<\/li>\n\n\n\n<li>\u53ea\u6709\u7ea7\u522b\u9ad8\u4e8e\u6216\u8005\u7b49\u4e8e\u65e5\u5fd7\u7ea7\u522b\u7684\u65e5\u5fd7\u624d\u4f1a\u88ab\u8f93\u51fa\uff0c\u4f4e\u4e8e\u8be5\u7b49\u7ea7\u7684\u65e5\u5fd7\u5c06\u4f1a\u88ab\u4e22\u5f03<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>\u5bf9\u8c61\u540d\u79f0<\/td><td>\u5bf9\u8c61API<\/td><\/tr><tr><td>logging<\/td><td>1\u3001\u4e94\u4e2a\u8f93\u51fa\u65e5\u5fd7\u5c0f\u5199\uff0c\u8bbe\u7f6e\u7ea7\u522b\u5927\u5199\uff1abasicconfig(level=\u5927\u5199\uff0cformat=\u8bbe\u7f6e\u683c\u5f0f)<\/td><\/tr><tr><td><\/td><td>\u65e5\u5fd7\u7cfb\u7edf<br>1<br>bosslogger=getLogger(&#8220;name&#8221;)<br>setLevel(ERROR)<br>&#8212;set the lowest level<br>2<br>streamhandler\uff08\u5904\u7406\u6d41\uff09<br>2.1setLevel(debug)\u7ed3\u679c\u4e3aerror\u4ee5\u4e0a<br>&#8212;set the lowest level<br>2.2setFormat<br>3<br>fileHandler<br>r w\uff08\u8986\u5199\uff09 a(append\u8ffd\u52a0\u6a21\u5f0f)<br>3.1<br>fp1=FileHandler(&#8216;fileadress&#8217;,mode=&#8217;a&#8217;,encoding=&#8217;utf-8&#8242;)<br>3.2<br>setLevel()<br>3.3<br>setFormat()<br>4<br>\u5916\u90e8\u88ab\u8c03\u7528\u7684\u5bf9\u8c61\u662fboss\uff0c\u518d\u7528boss\u8c03\u7528\u5176\u4ed6<br>5<br>boss.addHandler()<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"has-text-align-center\">logging.debug(&#8220;\u6211\u662f\u4ee3\u7801\u8c03\u8bd5\u4fe1\u606f11\uff5e&#8221;)<br>logging.info(&#8220;\u6211\u662f\u7cfb\u7edf\u6b63\u5e38\u8f93\u51fa\u4fe1\u606f11&#8221;)<br>logging.warning(&#8220;&#8212;-\u6211\u662f\u8b66\u544a\u4fe1\u606f11\uff0c\u6bd4\u5982\u5185\u5b58\u4e0d\u591f\uff5e&#8212;&#8211;&#8220;)<br>logging.debug(&#8220;\u6211\u662f\u4ee3\u7801\u8c03\u8bd5\u4fe1\u606f22\uff5e&#8221;)<br>logging.error(&#8220;&#8212;&#8211;\u6211\u662f\u4e00\u4e2a\u5c0fbug11\uff01\uff01&#8212;&#8212;&#8220;)<br>logging.info(&#8220;\u6211\u662f\u7cfb\u7edf\u6b63\u5e38\u8f93\u51fa\u4fe1\u606f22&#8221;)<br>logging.warning(&#8220;&#8212;-\u6211\u662f\u8b66\u544a\u4fe1\u606f22\uff0c\u6bd4\u5982\u5185\u5b58\u4e0d\u591f\uff5e&#8212;&#8211;&#8220;)<br>logging.error(&#8220;&#8212;&#8211;\u6211\u662f\u4e00\u4e2a\u5c0fbug22\uff01\uff01&#8212;&#8212;&#8220;)<br>logging.warning(&#8220;&#8212;-\u6211\u662f\u8b66\u544a\u4fe1\u606f33\uff0c\u6bd4\u5982\u5185\u5b58\u4e0d\u591f\uff5e&#8212;&#8211;&#8220;)<br>logging.critical(&#8220;&#8212;-\u6211\u662fbug \u4e25\u91cd\u4e8b\u6545\uff5e\u5bfc\u81f4\u7cfb\u7edf\u5d29\u6e83&#8212;&#8211;&#8220;)<\/p>\n\n\n\n<p>\u65e5\u5fd7\u591a\u7ec8\u7aef\u5206\u53d1\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import logging\n\n\nclass logutil:\n    def __init__(self):#coustructing a class as an object\n        self.logger=logging.getLogger('ikun')#convert it an contribute variable\n        self.logger.setLevel(logging.INFO)\n        sh=logging.StreamHandler()\n        sh.setLevel(logging.ERROR)\n        sh.setFormatter(logging.Formatter('%(filename)s-%(asctime)s-&#91;hanghao:%(lineno)d] - %(levelname)s: %(message)s'))\n        fh=logging.FileHandler('1.log',mode='a',encoding='utf-8')\n        fh.setFormatter(logging.Formatter('%(filename)s-%(asctime)s-&#91;hanghao:%(lineno)d] - %(levelname)s: %(message)s'))\n        fh.setLevel(logging.WARNING)\n        self.logger.addHandler(sh)\n        self.logger.addHandler(fh)\n    def log(self):\n        return self.logger\nll = logutil().log()<\/code><\/pre>\n\n\n\n<p>logutil()\u521b\u5efa\u5bf9\u8c61\uff0c.log()\u8c03\u7528\u4e86\u65b9\u6cd5\uff0c\u8d4b\u503c\u7ed9\u4e86ll<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>from logutil import ll\n\nif __name__ == '__main__':\n    # \u81ea\u6d4b\n    # \u65e5\u5fd7\u7cfb\u7edf \u9ed8\u8ba4\u7684\u7ea7\u522b  \u662fWARNING \u7ea7\u522b\n    ll.warning(\"\u6211\u662f\u4ee3\u7801\u8c03\u8bd5\u4fe1\u606f11\uff5e\")\n<\/code><\/pre>\n\n\n\n<p>\u5c01\u88c5\u4e3a\u5de5\u5177\u7c7b\u4f7f\u7528\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import pytest\n\nfrom jwdev.jwdev1 import Count\nfrom utils.jw2 import logger\n\n\nclass TestAdd():\n    def test_11(self):\n        logger.info(\"\u4e3b\u4eba\uff0c\u6211\u662f\u7b2c\u4e00\u6761\u7528\u4f8b\uff5e\")\n        # 1\u8bbe\u8ba1\u7528\u4f8b\uff5e===\u300b\u9884\u671f\u7ed3\u679c\n\n        try:\n            a = 3\n            b = 5\n            yuqi = 81\n            # 2 \u8c03\u7528\u5f00\u53d1\u5199\u7684\u4ee3\u7801===\u300b\u5b9e\u9645\u7ed3\u679c\uff5e\n            c1 = Count(a, b)\n            shiji = c1.add()\n            assert yuqi == shiji\n        except: # \u65ad\u8a00\u5931\u8d25 \u4e5f\u4f1aexcept \u5206\u652f~\n            logger.error(\"\u4e3b\u4eba\uff0c\u6211\u662f\u7b2c\u4e00\u6761\u7528\u4f8b\u6709bug\uff5e\uff5e\")\n\n\n    def test_22(self):\n        logger.info(\"\u4e3b\u4eba\uff0c\u6211\u662f\u7b2c\u4e8c\u6761\u7528\u4f8b\uff5e\")\n\n        assert  200==Count(100,100).add()\n\n    def test_33(self):\n        logger.info(\"\u4e3b\u4eba\uff0c\u6211\u662f\u7b2c\u4e09\u6761\u7528\u4f8b\uff5e\")\n        assert  202==Count(101,101).add()\n\nif __name__ == '__main__':\n    pytest.main(&#91;'-v', '-s', 'jwtest1.py']) # \u4e0d\u8981\u5fd8\u4e86\u6539\u6210\u4f60\u7684\u6587\u4ef6\u540d~\n<\/code><\/pre>\n\n\n\n<p>logger\u5bf9\u8c61\u6539\u4e3all\u3002<\/p>\n\n\n\n<p>API\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>\u5bf9\u8c61\u540d\u5b57<\/td><td>\u5bf9\u8c61API<\/td><\/tr><tr><td>OS<\/td><td>__file__ \u9b54\u6cd5\u53d8\u91cf\uff0c\u5f97\u5230\u5f53\u524d\u6587\u4ef6\u540d\u5b57\u8def\u5f84<\/td><\/tr><tr><td><\/td><td>os.path.dirname(__file__)\u5f53\u524d\u76ee\u5f55\uff08\u6587\u4ef6\u7236\u76ee\u5f55\uff09\uff0c\u5957\u4e00\u5c42\u662f\u7956\u7236\u76ee\u5f55<br>os.sep\u8def\u5f84\u5206\u5272\u7b26\u53f7\uff0c\u4f1a\u81ea\u52a8\u7684\u83b7\u53d6\u5f53\u524d\u7684\u7cfb\u7edf\u4f7f\u7528\u7684\u5206\u9694\u7b26\u53f7<br>os.path.join(\u76ee\u5f55\uff0c\u6587\u4ef6\u540d\u5b57)<br>\u628a\u6587\u4ef6\u62fc\u63a5\u5230\u76ee\u5f55\u4e0a<\/td><\/tr><tr><td>time<\/td><td>sleep\u5f3a\u5236\u7b49\u5f85<br>localtime()\u6253\u5370\u5f53\u524d\u65f6\u95f4\uff08\u82f1\u6587\u4e60\u60ef\uff09<br>strftime(&#8220;%Y_%m_%d %H:%M:%S&#8221;,\u65f6\u95f4)<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-3-color\">\u65f6\u95f4\u6307time.localtime()\u65b9\u6cd5<\/mark><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u4f8b\u5b50\uff1a<strong>print(time.strftime(&#8220;%Y_%m_%d&#8221;,time.localtime()))<\/strong><\/p>\n\n\n\n<p>os\u65b9\u6cd5\u786e\u5b9a\u6587\u4ef6\u76ee\u5f55\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import logging\nimport os\n\n\nclass logutil:\n    def __init__(self):#coustructing a class as an object\n        self.logger=logging.getLogger('ikun')#convert it an contribute variable\n        self.logger.setLevel(logging.INFO)\n        sh=logging.StreamHandler()\n        sh.setLevel(logging.ERROR)\n        sh.setFormatter(logging.Formatter('%(filename)s-%(asctime)s-&#91;hanghao:%(lineno)d] - %(levelname)s: %(message)s'))\n        <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-3-color\">project_path=os.path.dirname(os.path.dirname(__file__))\n        log_path=project_path+os.sep+'log'\n        log_path_name=os.path.join(log_path,'jw2.log')<\/mark>\n        fh=logging.FileHandler(<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-3-color\">log_path_name<\/mark>,mode='a',encoding='utf-8')\n        fh.setFormatter(logging.Formatter('%(filename)s-%(asctime)s-&#91;hanghao:%(lineno)d] - %(levelname)s: %(message)s'))\n        fh.setLevel(logging.WARNING)\n        self.logger.addHandler(sh)\n        self.logger.addHandler(fh)\n    def log(self):\n        return self.logger\nll = logutil().log()<\/code><\/pre>\n\n\n\n<p>\u81ea\u52a8\u521b\u5efalog\u6587\u4ef6\u5939\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>if not os.path.exists(log_path):<br>os.makedirs(log_path) # \u81ea\u52a8\u521b\u5efa log \u6587\u4ef6\u5939<\/code><\/pre>\n\n\n\n<!--nextpage-->\n\n\n\n<h3 class=\"wp-block-heading\">pymysql \u5e93<\/h3>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-3-color\">\u5b57\u5178\u6e38\u6807\u521a\u597d\u5bf9\u5e94\u5355\u53c2\u6570\u7684pytest\u7684\u53c2\u6570\u5316\uff01<\/mark><\/strong><\/p>\n\n\n\n<p>pymysql\u901f\u5ea6\u76f8\u5bf9\u5feb\uff0c\u66f4\u5bb9\u6613\u8fdb\u884c\u81ea\u52a8\u5316<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>\u5bf9\u8c61\u540d<\/td><td>\u5bf9\u8c61API<\/td><\/tr><tr><td>pymysql<\/td><td>1 \u521b\u5efadb\u8fde\u63a5<br>connect<br>2 \u521b\u5efa\u6e38\u6807cursor<br>\u9ed8\u8ba4\u5143\u7ec4\u6e38\u6807\uff0c\u5b57\u5178\u6e38\u6807\u66f4\u597d\u7528<br>[{data1},{data2},{data3}]\u6e38\u6807\u91cc\u9762\u662f\u4e00\u4e2a\u4e2a\u7684\u5b57\u5178<br>pymysql.cursor.DictCursor<br>2.1 \u6267\u884csql\u8bed\u53e5<br>2.2 \u4fdd\u5b58select\u8bed\u53e5\u7ed3\u679c<br>3 \u4ece\u6e38\u6807\u4e0a\u63d0\u53d6select\u7ed3\u679c<br>3.1 fetchone() \u63d0\u53d6\u4e00\u884c<br>3.2 fetchmany(n)\u63d0\u53d6n\u884c<br>3.3 fetchall()\u63d0\u53d6\u6240\u6709\u6570\u636e<br>4\u66f4\u65b0\u7c7bsql\uff08\u589e\u5220\u6539\uff09<br>4.1 commit()\u63d0\u4ea4<br>4.2 rollback()\u56de\u6eda<br>5 close()<br>\u5148\u5173\u6e38\u6807\u518d\u5173\u6570\u636e\u5e93<\/td><\/tr><tr><td><\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u4f7f\u7528\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#\n# 1\u521b\u5efadb\u8fde\u63a5\n# connect\nimport pymysql\n#                   \u672c\u5730\u673a\u5668\njwdb=pymysql.connect(host=\"127.0.0.1\",port=3306,\n                user=\"root\",password=\"123456\",database=\"jwtest1\",\n                charset=\"utf8\")\n# 2 \u521b\u5efa\u6e38\u6807cursor() \uff1f\njwcursor=jwdb.cursor(pymysql.cursors.DictCursor) # \u5b57\u5178\u6e38\u6807\u65b9\u4fbf pytest\u7684 ddt \u5bf9\u63a5~\n# 2.1  \u6267\u884cSQL\u8bed\u53e5\nsql=\"select * from xsb;\"\njwcursor.execute(sql)\n# 2.2 \u4fdd\u5b58  select  \u8bed\u53e5\u7684\u7ed3\u679c\n# print(jwcursor.fetchone())\n# print(jwcursor.fetchmany(2))\n# print(jwcursor.fetchone())\n# print(jwcursor.fetchall())\n# print(jwcursor.fetchone())\n\nall_data=jwcursor.fetchall() #\u5143\u7ec4\u6570\u636e\uff5e\n# \u53d6\u51fa\u73ed\u7ea7\uff1f--->\n# \u5143\u7ec4\u6e38\u6807\u7f3a\u70b9   1  \u6570\u6570\u9ebb\u70e6  2  \u8bb0\u5f55\u957f\u5ea6\u53d8\u5316\u7684 3 \u53ef\u8bfb\u6027\u5dee\nprint(all_data)\nprint(all_data&#91;2]&#91;'bj'])\nprint(all_data&#91;2])\n# print(all_data&#91;0])\n\n\n\n# 3 \u4ece\u6e38\u6807 \u63d0\u53d6select \u7ed3\u679c\n# 3.1   fetchone()    \u63d0\u53d6\u4e00\u884c\u6570\u636e\n# 3.2  fetchmany(n) \u63d0\u53d6 n\u884c\u6570\u636e\n# 3.3  fetchall()  \u63d0\u53d6\u6240\u6709\u6570\u636e\n# 5 close()\n# \u5148\u5173\u95ed\u6e38\u6807 \u518d\u5173\u6570\u636e\u5e93\njwcursor.close()\njwdb.close()\n\n<\/code><\/pre>\n\n\n\n<p>\u66f4\u65b0\u7c7bsql\u7684\u4f7f\u7528<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u601d\u8def\uff1a\n            1fetchXXXAPI \u4e0d\u9700\u8981\n            2 commit()  \u4fdd\u5b58API\n     #\n# 1\u521b\u5efadb\u8fde\u63a5\n# connect\nimport pymysql\n#                   \u672c\u5730\u673a\u5668\njwdb=pymysql.connect(host=\"127.0.0.1\",port=3306,\n                user=\"root\",password=\"123456\",database=\"jwtest1\",\n                charset=\"utf8\")\n# 2 \u521b\u5efa\u6e38\u6807cursor() \uff1f\njwcursor=jwdb.cursor(pymysql.cursors.DictCursor) # \u5b57\u5178\u6e38\u6807\n# 2.1  \u6267\u884cSQL\u8bed\u53e5\nsql=\"insert into xsb  set xh='012',xm='\u5965\u7279\u66fc',xb='\u7537';\"\njwcursor.execute(sql)# \u6e38\u6807\u6267\u884csql\n\njwdb.commit() # \u6570\u636e\u5e93\u4fdd\u5b58\n\n\njwcursor.close()\njwdb.close()\n\n<\/code><\/pre>\n\n\n\n<p>try\u8bed\u53e5\u7ba1\u7406MySQL\u7684\u4e8b\u52a1<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#\n# 1\u521b\u5efadb\u8fde\u63a5\n# connect\nimport pymysql\n#                   \u672c\u5730\u673a\u5668\njwdb=pymysql.connect(host=\"127.0.0.1\",port=3306,\n                user=\"root\",password=\"123456\",database=\"jwtest1\",\n                charset=\"utf8\")\n# 2 \u521b\u5efa\u6e38\u6807cursor() \uff1f\njwcursor=jwdb.cursor(pymysql.cursors.DictCursor) # \u5b57\u5178\u6e38\u6807\n# 2.1  \u6267\u884cSQL\u8bed\u53e5\ntry:\n    sql1=\"insert into xsb  set xh='102',xm='\u6768\u8fc7',xb='\u7537';\"\n    jwcursor.execute(sql1)# \u6e38\u6807\u6267\u884csql\n\n    sql2=\"insert into xsb  set xh='103',xm='\u5c0f\u9f99\u5973',xb='\u5973';\"\n    jwcursor.execute(sql2)# \u6e38\u6807\u6267\u884csql\n\n    jwdb.commit() # \u6570\u636e\u5e93\u4fdd\u5b58\nexcept:\n    print(\"\u6709sql\u5931\u8d25\uff0c\u5f00\u59cb\u56de\u6eda\u3002\u3002\")\n    jwdb.rollback()\nelse:\n    print(\"\u5168\u90e8sql\u6267\u884c\u6210\u529f\")\nfinally:\n    print(\"\u4e8b\u52a1\u7ed3\u675f\uff5e\")\n\n\njwcursor.close()\njwdb.close()\n\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u5b57\u7b26\u4e32\u7684\u5207\u5272\u3001\u67e5\u8be2\u3001\u7c7b\u578b\u66ff\u6362\u3001\u7c7b\u578b\u8f6c\u6362<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># 1\u5b57\u7b26\u4e32\u5207\u5272---\u300b\u5217\u8868\uff5e\nimport re\nfrom string import Template\n\njwstr=\"zhangsan=lisi=wangwu\"\njwlist=jwstr.split(\"=\")\nprint(jwlist)\nprint(jwlist&#91;1])\n\n\n# 2 \u5b57\u7b26\u4e32\u67e5\u8be2\u67e5\u627e  \u63d0\u53d6\u76ee\u6807\u6570\u636e\uff5e\njwstr2=\"\u4e0a\u6e38\u63a5\u53e3\u6388\u6743${aaaaaaa},\u6211\u7231${\u5927s}\uff0c\u6211\u7231${\u5fd7\u73b2}\uff0c\u6211\u7231${\u4e00\u535a} \uff0c\u6211\u7231${\u793e\u4f1a\u4e3b\u4e49}\"\n# \u6b63\u5219\u8868\u8fbe\u5f0f  (.*?)    0~\u591a\u4e2a\u5b57\u7b26\n#  \u6839\u636e\u76ee\u6807\u6570\u636e\u7684\u5de6\u53f3\u8fb9\u754c\u7b56\u7565  \u63d0\u53d6\u6570\u636e\u5440\uff5e\n# \u5de6\u8fb9\u754c ${   \u53f3\u8fb9\u754c}\nzhengze=\"\\\\${(.*?)}\" #python  \\\\ \u4ee3\u8868\u6b63\u5219\u8868\u8fbe\u5f0f\uff5e\n# Python re\u5e93  findall api  \u4e13\u95e8\u662f\u6839\u636e\u6b63\u5219\u4ece\u6570\u636e\u4e2d\u5b8c\u6210\u67e5\u627e \u5b58\u653e\u5230\u5217\u8868\uff5e\nlist=re.findall(zhengze,jwstr2)\nprint(list)\n\n\n\n# 3\u5b57\u7b26\u4e32\u7c7b\u578b\u66ff\u6362\n# \u88ab\u66ff\u6362\u6570\u636e  \u8981\u6c42\u5fc5\u987b\u5b57\u7b26\u4e32  \u5305\u542b ${}\n#  \u66ff\u6362\u6570\u636e   \u8981\u6c42 \u5fc5\u987b\u662f\u5b57\u5178   ${} \u548c\u5b57\u5178\u952e\u5fc5\u987b\u4e00\u81f4\uff5e\njwstr3=\"\u6211\u662f\u4e0b\u6e38\u63a5\u53e3\u7528\u4f8b \u9700\u8981\u6388\u6743\u7801${jwtoken}\"\n# \u8fd0\u884c\u4e86\u63a5\u53e3\nshangyou_jieguo={\"jwtoken\":\"aaaaaaaaaa\"}\n#\u9700\u8981\u5c06 \u6388\u6743\u7801aaaa \u66ff\u6362\u5230  \u5b57\u7b26\u4e32\u4e2d\u4e0b\u6e38\u63a5\u53e3\u624d\u53ef\u4ee5\u8fd0\u884c\uff5e\n\n# Python  \u6a21\u677f\u5b57\u7b26\u4e32 Template(\u5b57\u7b26\u4e32)==\u300b\u652f\u6301\u66ff\u6362\n#                  safe_substitute ==>\u53d1\u751f\u66ff\u6362\ngenghuan=Template(jwstr3)\nnew_shiji=genghuan.safe_substitute(shangyou_jieguo)\nprint(new_shiji)\n# 4 \u5b57\u7b26\u4e32\u7c7b\u578b\u8f6c\u6362\n#API\n# \u5b57\u7b26\u4e32   --json.loads()   eval()---\u300b\u5b57\u5178\ndata=\"{'username':'admin','password':'123'}\"\nprint(type(data)) # \u4e3a\u4ec0\u4e48\u8f6c\u5b57\u5178\uff1f  \u7b54\uff1a\u952e\u503c\u5bf9\u53d6\u503c +\u624d\u80fd\u4ea4\u7ed9requests\u53d1\u9001\nprint(data)\ndata2=eval(data)\nprint(data2)\nprint(type(data2),data2&#91;'username'])\n#  \u5b57\u5178    --json.dumps()  str()--\u300b\u5b57\u7b26\u4e32\n<\/code><\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u76ee\u524d\u8f6f\u4ef6\u6d4b\u8bd5\u7684\u81ea\u52a8\u5316\u4e3b\u8981\u662f\u63a5\u53e3\u7684\u81ea\u52a8\u5316\uff0c\u5982selnium\u7b49UI\u81ea\u52a8\u5316\u5de5\u5177\u4ec5\u4ec5\u5728\u56de\u5f52\u6d4b\u8bd5\u4e2d\u6709\u6240\u5e94\u7528\u2026\u2026 \u63a5\u53e3AP [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-68","post","type-post","status-publish","format-standard","hentry","category-api-testing"],"_links":{"self":[{"href":"http:\/\/mavisblog.top\/index.php\/wp-json\/wp\/v2\/posts\/68","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/mavisblog.top\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/mavisblog.top\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/mavisblog.top\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/mavisblog.top\/index.php\/wp-json\/wp\/v2\/comments?post=68"}],"version-history":[{"count":0,"href":"http:\/\/mavisblog.top\/index.php\/wp-json\/wp\/v2\/posts\/68\/revisions"}],"wp:attachment":[{"href":"http:\/\/mavisblog.top\/index.php\/wp-json\/wp\/v2\/media?parent=68"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/mavisblog.top\/index.php\/wp-json\/wp\/v2\/categories?post=68"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/mavisblog.top\/index.php\/wp-json\/wp\/v2\/tags?post=68"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}