{"id":1000,"date":"2026-07-10T00:20:57","date_gmt":"2026-07-10T00:20:57","guid":{"rendered":"https:\/\/hyc.eshachem.com\/program\/?p=1000"},"modified":"2026-07-10T00:22:16","modified_gmt":"2026-07-10T00:22:16","slug":"python-script","status":"publish","type":"post","link":"https:\/\/hyc.eshachem.com\/program\/python-script\/","title":{"rendered":"Python &#8211; Script"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u5728\u5beb\u5168\u7aef\u7684\u5c08\u6848\u7684\u6642\u5019\u6709\u9047\u5230\u4e00\u500b\u554f\u984c\u5c31\u662fNext.js\u6c92\u8fa6\u6cd5\u8dd1DB2! ( IBM \u516c\u53f8\u958b\u767c\u7684\u4e00\u6b3e<strong>\u4f01\u696d\u7d1a\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71RDBMS<\/strong>\uff0c\u4ee5\u6975\u9ad8\u7684\u6548\u80fd\u8457\u7a31\uff09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u56e0\u6b64\u6211\u7684\u89e3\u6cd5\u662f\u900f\u904e python \u5beb\u4e00\u500bScript\uff0c\u6709\u9700\u8981\u53bbDB2\u67e5\u8a62\u6642\u5c31\u53ea\u7528\u6307\u4ee4\u57f7\u884c\u6b64 python\uff0cpython\u8173\u672c\u56de\u50b3JSON\u5373\u53ef~<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u88e1\u63d0\u4f9b\u7bc4\u4f8b\uff1a<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-meta\">#!\/usr\/bin\/env python3<\/span>\n# -*- coding: utf<span class=\"hljs-number\">-8<\/span> -*-\n<span class=\"hljs-keyword\">from<\/span> __future__ <span class=\"hljs-keyword\">import<\/span> annotations\n\n<span class=\"hljs-keyword\">import<\/span> sys\n<span class=\"hljs-keyword\">import<\/span> io\n<span class=\"hljs-keyword\">import<\/span> json\n<span class=\"hljs-keyword\">import<\/span> os\n# --- DB2 \u74b0\u5883\u914d\u7f6e ---\n<span class=\"hljs-keyword\">if<\/span> os.name == <span class=\"hljs-string\">'nt'<\/span>:\n    clidriver_path = r<span class=\"hljs-string\">'C:\\temp\\clidriver\\bin'<\/span>\n    <span class=\"hljs-keyword\">if<\/span> os.path.exists(clidriver_path):\n        os.add_dll_directory(clidriver_path)\n    # \u5f37\u5236 UTF<span class=\"hljs-number\">-8<\/span> \u8f38\u51fa\uff0c\u907f\u514d Windows \u8f49\u78bc\u932f\u8aa4\n\n    sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding=<span class=\"hljs-string\">'utf-8'<\/span>)\n    sys.stderr = io.TextIOWrapper(sys.stderr.buffer, encoding=<span class=\"hljs-string\">'utf-8'<\/span>)\n\ndef _build_conn_string() -&gt; str:\n    host = os.environ.get(<span class=\"hljs-string\">\"DB2_HOST\"<\/span>, <span class=\"hljs-string\">\"XXX.vghtpe.gov.tw\"<\/span>).strip()\n    port = os.environ.get(<span class=\"hljs-string\">\"DB2_PORT\"<\/span>, <span class=\"hljs-string\">\"3306\"<\/span>).strip()\n    database = os.environ.get(<span class=\"hljs-string\">\"DB2_DATABASE\"<\/span>, <span class=\"hljs-string\">\"DBHIS\"<\/span>).strip()\n    user = os.environ.get(<span class=\"hljs-string\">\"DB2_USER\"<\/span>, os.environ.get(<span class=\"hljs-string\">\"DB2_UID\"<\/span>, <span class=\"hljs-string\">\"TEST\"<\/span>)).strip()\n    password = os.environ.get(<span class=\"hljs-string\">\"DB2_PASSWORD\"<\/span>, os.environ.get(<span class=\"hljs-string\">\"DB2_PWD\"<\/span>, <span class=\"hljs-string\">\"TEST\"<\/span>)).strip()\n\n    <span class=\"hljs-keyword\">return<\/span> f<span class=\"hljs-string\">\"DATABASE={database};HOSTNAME={host};PORT={port};PROTOCOL=TCPIP;UID={user};PWD={password};\"<\/span>\n\n# \u7528\u6cd5: db2_vitals.py &lt;histno&gt; <span class=\"xml\"><span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">caseno<\/span>&gt;<\/span>\ndef main():\n\n    histno = sys.argv[1].strip()\n    caseno = sys.argv[2].strip()\n\n\n    try:\n        import ibm_db\n        conn = ibm_db.connect(_build_conn_string(), \"\", \"\")\n        sql = \"\"\"\n            SELECT \n                ERTTBP1, \n                ERTTBP2, \n                ERTTPR, \n                ERTTRR, \n                ERTTBT, \n                ERTTKG,\n                ERTTS12\n            FROM VGHLNXVG.ERTTAS5\n            WHERE ERTTHIST = ?\n            AND RIGHT(TRIM(ERTTBKEY), 8) = ? \n            WITH UR\n        \"\"\"\n        \n        stmt = ibm_db.prepare(conn, sql)\n        ibm_db.bind_param(stmt, 1, histno)\n        ibm_db.bind_param(stmt, 2, caseno)\n        ibm_db.execute(stmt)\n        \n        row = ibm_db.fetch_assoc(stmt)\n\n        if row:\n            final_data = {\n                \"bp_s\": str(row.get(\"ERTTBP1\") or \"\").strip(),\n                \"bp_d\": str(row.get(\"ERTTBP2\") or \"\").strip(),\n                \"pr\":   str(row.get(\"ERTTPR\") or \"\").strip(),\n                \"rr\":   str(row.get(\"ERTTRR\") or \"\").strip(),\n                \"bt\":   str(row.get(\"ERTTBT\") or \"\").strip(),\n                \"bw\":   str(row.get(\"ERTTKG\") or \"\").strip(),\n                \"\u75bc\u75db\u8a55\u4f30\": str(row.get(\"ERTTS12\") or \"\").strip(),\n            }\n            print(json.dumps({\"success\": True, \"data\": final_data}))\n        else:\n            print(json.dumps({\"success\": False, \"error\": 123}))\n        ibm_db.close(conn)\n        \n    except Exception as e:\n        # \u767c\u751f\u932f\u8aa4\u6642\u8f38\u51fa\u8a73\u7d30\u8cc7\u8a0a\u5230 stderr \u4e26\u56de\u50b3\u5931\u6557 JSON\n        import traceback\n        print(traceback.format_exc(), file=sys.stderr)\n        print(json.dumps({\"success\": False, \"error\": str(e)}))\n        sys.exit(1)\n\nif __name__ == \"__main__\":\n    main()<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p class=\"wp-block-paragraph\">\u9019\u88e1\u89e3\u91cb\u4e00\u4e9b\u6bd4\u8f03\u7279\u6b8a\u7684\u5beb\u6cd5\u4ee5\u53ca\u70ba\u4ec0\u9ebc\u8981\u9019\u6a23\u5beb\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8a3b\uff1a\u4e4b\u5f8c\u6709\u53ef\u80fd\u6703\u8981\u4e0aDocker\u56e0\u6b64\u6709\u4e9bLinux\u7684\u6307\u4ee4\u6703\u5148\u7559\u8457<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"%e6%a8%99%e9%a0%ad\">\u6a19\u982d<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>#!\/usr\/bin\/env python3<\/code>\uff1a\u6307\u5b9a\u4f7f\u7528 Python 3 \u89e3\u91cb\u5668\u57f7\u884c\u3002\u5728linux\u4e0b\u6703\u88ab\u57f7\u884c\u3002<\/li>\n\n\n\n<li><code># -*- coding: utf-8 -*-<\/code>\uff1a\u5ba3\u544a\u6a94\u6848\u7de8\u78bc\u70ba UTF-8\uff0c\u78ba\u4fdd\u4e2d\u6587\u5b57\u5143\u986f\u793a\u6b63\u78ba\u3002<\/li>\n\n\n\n<li><code>from __future__ import annotations<\/code>\uff1a\u555f\u7528Type Hints\uff08\u578b\u5225\u63d0\u793a\uff09\uff1a<code>-&gt; str:<\/code>\n<ul class=\"wp-block-list\">\n<li>\u5982\u679c\u51fd\u6578\u5b9a\u7fa9\u56de\u50b3 <code>str<\/code>\uff0c\u7d50\u679c\u56de\u50b3\u6578\u5b57\uff0cIDE \u6703\u8ddf\u64da\u6b64\u5075\u6e2c\u932f\u8aa4\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>import sys, io, json, os<\/code>\uff1a\u532f\u5165\u6a19\u6e96\u51fd\u5f0f\u5eab\uff0c\u8655\u7406\u7cfb\u7d71\u53c3\u6578\u3001\u8f38\u51fa\u6d41\u3001JSON \u683c\u5f0f\u8207\u4f5c\u696d\u7cfb\u7d71\u529f\u80fd\u3002<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"db2-%e7%92%b0%e5%a2%83%e9%85%8d%e7%bd%ae\">DB2 \u74b0\u5883\u914d\u7f6e<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>if os.name == 'nt':<\/code>\uff1a\u5224\u65b7\u662f\u5426\u5728 Windows \u74b0\u5883\u4e0b\u3002\n<ul class=\"wp-block-list\">\n<li><code>os.add_dll_directory(...)<\/code>\uff1a\u544a\u8a34 Windows \u54ea\u88e1\u53ef\u4ee5\u627e\u5230 DB2 \u7684\u9023\u63a5\u9a45\u52d5\u7a0b\u5f0f\uff08<code>clidriver<\/code>\uff09\u3002<\/li>\n\n\n\n<li><code>sys.stdout<\/code> \u5f37\u5236\u5c07\u6a19\u6e96\u8f38\u51fa (<code>stdout<\/code>) \u8207\u932f\u8aa4\u8f38\u51fa (<code>stderr<\/code>) \u8a2d\u5b9a\u70ba UTF-8 \u7de8\u78bc\uff0c\u9632\u6b62\u5728 Windows CMD \u4e2d\u51fa\u73fe\u4e82\u78bc\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"main\"><code>main<\/code><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u9023\u63a5\u8cc7\u6599\u5eab<\/strong>\uff1a\n<ul class=\"wp-block-list\">\n<li><code>import ibm_db<\/code>\uff1a\u5728\u6b64\u968e\u6bb5\u624d\u532f\u5165 DB2 \u9a45\u52d5\uff0c\u78ba\u4fdd\u74b0\u5883\u8a2d\u5b9a\u5df2\u5b8c\u6210\u3002<\/li>\n\n\n\n<li><code>ibm_db.connect(...)<\/code>\uff1a\u5efa\u7acb\u9023\u7dda\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u57f7\u884c SQL<\/strong>\uff1a\n<ul class=\"wp-block-list\">\n<li>\u4f7f\u7528 <code>?<\/code> \u4f54\u4f4d\u7b26\uff08Parameterized Query\uff09\uff0c\u9019\u80fd\u6709\u6548\u9632\u6b62 <strong>SQL Injection\uff08\u8cc7\u6599\u96b1\u78bc\u653b\u64ca\uff09<\/strong>\u3002<\/li>\n\n\n\n<li><code>WITH UR<\/code>\uff1a\u610f\u6307 Uncommitted Read\uff0c\u5728\u67e5\u8a62 DB2 \u6642\u5141\u8a31\u8b80\u53d6\u5c1a\u672a\u63d0\u4ea4\u7684\u8cc7\u6599\uff0c\u53ef\u63d0\u5347\u67e5\u8a62\u6548\u80fd\u4e14\u6e1b\u5c11\u9396\u5b9a\u885d\u7a81\u3002\u70baDB2\u7279\u6709\u5beb\u6cd5\u3002<\/li>\n\n\n\n<li>\u4f7f\u7528<code> bind_param<\/code> \u5beb\u5165\u8cc7\u6599\uff0c\u8cc7\u6599\u5eab\u6703\u5c07 <code>user_input<\/code> \u8996\u70ba<strong>\u7d14\u7cb9\u7684\u300c\u8cc7\u6599\uff08Data\uff09\u300d<\/strong>\uff0c\u800c\u4e0d\u662f\u300cSQL \u6307\u4ee4\u300d\uff0c\u9632\u6b62SQL\u6ce8\u5165\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u8cc7\u6599\u8655\u7406<\/strong>\uff1a\n<ul class=\"wp-block-list\">\n<li><code>ibm_db.fetch_assoc(stmt)<\/code>\uff1a\u5c07\u67e5\u8a62\u5230\u7684\u7d50\u679c\u8f49\u70ba\u95dc\u806f\u5f0f\u9663\u5217\uff08\u5b57\u5178\uff09\u3002<\/li>\n\n\n\n<li>\u82e5\u6709\u7d50\u679c\uff0c\u5c07\u6b04\u4f4d\u540d\u7a31\uff08\u5982 <code>ERTTBP1<\/code>\uff09\u5c0d\u61c9\u5230\u66f4\u53cb\u5584\u7684 JSON Key\uff08\u5982 <code>bp_s<\/code> \u4ee3\u8868\u8840\u58d3\u6536\u7e2e\u58d3\uff09\u3002<\/li>\n\n\n\n<li><code>json.dumps(...)<\/code>\uff1a\u5c07\u7d50\u679c\u8f49\u70ba JSON \u5b57\u4e32\u8f38\u51fa\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u4f8b\u5916\u8655\u7406 (<code>except<\/code>)<\/strong>\uff1a\n<ul class=\"wp-block-list\">\n<li>\u82e5\u67e5\u8a62\u5931\u6557\uff0c\u8f38\u51fa\u932f\u8aa4\u5806\u758a\u8cc7\u8a0a\uff08<code>traceback<\/code>\uff09\u5230\u932f\u8aa4\u6d41\uff0c\u4e26\u8f38\u51fa JSON \u683c\u5f0f\u7684\u932f\u8aa4\u8a0a\u606f\uff0c\u65b9\u4fbf\u547c\u53eb\u7aef\u6355\u6349\u5931\u6557\u72c0\u614b\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u5beb\u5168\u7aef\u7684\u5c08\u6848\u7684\u6642\u5019\u6709\u9047\u5230\u4e00\u500b\u554f\u984c\u5c31\u662fNext.js\u6c92\u8fa6\u6cd5\u8dd1DB2! ( IBM \u516c\u53f8\u958b\u767c\u7684\u4e00\u6b3e\u4f01\u696d\u7d1a\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71RDBMS\uff0c\u4ee5\u6975\u9ad8\u7684\u6548\u80fd\u8457\u7a31\uff09 \u56e0\u6b64\u6211\u7684\u89e3\u6cd5\u662f\u900f\u904e python \u5beb\u4e00\u500bScript\uff0c\u6709\u9700\u8981\u53bbDB2\u67e5\u8a62\u6642\u5c31\u53ea\u7528\u6307\u4ee4\u57f7\u884c\u6b64 python\uff0cpython\u8173\u672c\u56de\u50b3JSON\u5373\u53ef~ \u9019\u88e1\u63d0\u4f9b\u7bc4\u4f8b\uff1a \u9019\u88e1\u89e3\u91cb\u4e00\u4e9b\u6bd4\u8f03\u7279\u6b8a\u7684\u5beb\u6cd5\u4ee5\u53ca\u70ba\u4ec0\u9ebc\u8981\u9019\u6a23\u5beb\uff1a \u8a3b\uff1a\u4e4b\u5f8c\u6709\u53ef\u80fd\u6703\u8981\u4e0aDocker\u56e0\u6b64\u6709\u4e9bLinux\u7684\u6307\u4ee4\u6703\u5148\u7559\u8457 \u6a19\u982d DB2 \u74b0\u5883\u914d\u7f6e main<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[39],"tags":[],"class_list":["post-1000","post","type-post","status-publish","format-standard","hentry","category-back-end"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u5728\u5beb\u5168\u7aef\u7684\u5c08\u6848\u7684\u6642\u5019\u6709\u9047\u5230\u4e00\u500b\u554f\u984c\u5c31\u662fNext.js\u6c92\u8fa6\u6cd5\u8dd1DB2! ( IBM \u516c\u53f8\u958b\u767c\u7684\u4e00\u6b3e\u4f01\u696d\u7d1a\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71RDBMS\uff0c\u4ee5\u6975\u9ad8\u7684\u6548\u80fd\u8457\u7a31\uff09 \u56e0\u6b64\u6211\u7684\u89e3\u6cd5\u662f\u900f\u904e python \u5beb\u4e00\u500bScript\uff0c\u6709\u9700\u8981\u53bbDB2\u67e5\u8a62\u6642\u5c31\u53ea\u7528\u6307\u4ee4\u57f7\u884c\u6b64 python\uff0cpython\u8173\u672c\u56de\u50b3JSON\u5373\u53ef~ \u9019\u88e1\u63d0\u4f9b\u7bc4\u4f8b\uff1a #!\/usr\/bin\/env python3 # -*- coding: utf-8 -*- from __future__ import annotations import sys import io import json import os # --- DB2 \u74b0\u5883\u914d\u7f6e --- if os.name == &#039;nt&#039;: clidriver_path = r&#039;C:\\temp\\clidriver\\bin&#039; if os.path.exists(clidriver_path): os.add_dll_directory(clidriver_path) # \u5f37\u5236 UTF-8 \u8f38\u51fa\uff0c\u907f\u514d Windows \u8f49\u78bc\u932f\u8aa4 sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding=&#039;utf-8&#039;) sys.stderr =\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"H.Y. Chen\"\/>\n\t<meta name=\"google-site-verification\" content=\"-324YR5tomynX5FeTW2lTMHIX0KmPBvpxjXpOhXwi1Q\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/hyc.eshachem.com\/program\/python-script\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"HyC Wiki - Technical articles\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Python \u2013 Script - HyC Wiki\" \/>\n\t\t<meta property=\"og:description\" content=\"\u5728\u5beb\u5168\u7aef\u7684\u5c08\u6848\u7684\u6642\u5019\u6709\u9047\u5230\u4e00\u500b\u554f\u984c\u5c31\u662fNext.js\u6c92\u8fa6\u6cd5\u8dd1DB2! ( IBM \u516c\u53f8\u958b\u767c\u7684\u4e00\u6b3e\u4f01\u696d\u7d1a\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71RDBMS\uff0c\u4ee5\u6975\u9ad8\u7684\u6548\u80fd\u8457\u7a31\uff09 \u56e0\u6b64\u6211\u7684\u89e3\u6cd5\u662f\u900f\u904e python \u5beb\u4e00\u500bScript\uff0c\u6709\u9700\u8981\u53bbDB2\u67e5\u8a62\u6642\u5c31\u53ea\u7528\u6307\u4ee4\u57f7\u884c\u6b64 python\uff0cpython\u8173\u672c\u56de\u50b3JSON\u5373\u53ef~ \u9019\u88e1\u63d0\u4f9b\u7bc4\u4f8b\uff1a #!\/usr\/bin\/env python3 # -*- coding: utf-8 -*- from __future__ import annotations import sys import io import json import os # --- DB2 \u74b0\u5883\u914d\u7f6e --- if os.name == &#039;nt&#039;: clidriver_path = r&#039;C:\\temp\\clidriver\\bin&#039; if os.path.exists(clidriver_path): os.add_dll_directory(clidriver_path) # \u5f37\u5236 UTF-8 \u8f38\u51fa\uff0c\u907f\u514d Windows \u8f49\u78bc\u932f\u8aa4 sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding=&#039;utf-8&#039;) sys.stderr =\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/hyc.eshachem.com\/program\/python-script\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/06\/cropped-cropped-\u672a\u547d\u540d\u8a2d\u8a08-4.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/06\/cropped-cropped-\u672a\u547d\u540d\u8a2d\u8a08-4.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"64\" \/>\n\t\t<meta property=\"og:image:height\" content=\"64\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-07-10T00:20:57+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-07-10T00:22:16+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Python \u2013 Script - HyC Wiki\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u5728\u5beb\u5168\u7aef\u7684\u5c08\u6848\u7684\u6642\u5019\u6709\u9047\u5230\u4e00\u500b\u554f\u984c\u5c31\u662fNext.js\u6c92\u8fa6\u6cd5\u8dd1DB2! ( IBM \u516c\u53f8\u958b\u767c\u7684\u4e00\u6b3e\u4f01\u696d\u7d1a\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71RDBMS\uff0c\u4ee5\u6975\u9ad8\u7684\u6548\u80fd\u8457\u7a31\uff09 \u56e0\u6b64\u6211\u7684\u89e3\u6cd5\u662f\u900f\u904e python \u5beb\u4e00\u500bScript\uff0c\u6709\u9700\u8981\u53bbDB2\u67e5\u8a62\u6642\u5c31\u53ea\u7528\u6307\u4ee4\u57f7\u884c\u6b64 python\uff0cpython\u8173\u672c\u56de\u50b3JSON\u5373\u53ef~ \u9019\u88e1\u63d0\u4f9b\u7bc4\u4f8b\uff1a #!\/usr\/bin\/env python3 # -*- coding: utf-8 -*- from __future__ import annotations import sys import io import json import os # --- DB2 \u74b0\u5883\u914d\u7f6e --- if os.name == &#039;nt&#039;: clidriver_path = r&#039;C:\\temp\\clidriver\\bin&#039; if os.path.exists(clidriver_path): os.add_dll_directory(clidriver_path) # \u5f37\u5236 UTF-8 \u8f38\u51fa\uff0c\u907f\u514d Windows \u8f49\u78bc\u932f\u8aa4 sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding=&#039;utf-8&#039;) sys.stderr =\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/06\/cropped-cropped-\u672a\u547d\u540d\u8a2d\u8a08-4.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/python-script\\\/#blogposting\",\"name\":\"Python \\u2013 Script - HyC Wiki\",\"headline\":\"Python &#8211; Script\",\"author\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/author\\\/hychen\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/python-script\\\/#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc6e05e080c9ea570267ee9ed68c8b1841d745cee07c0331c5440646e0646603?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"H.Y. Chen\"},\"datePublished\":\"2026-07-10T00:20:57+00:00\",\"dateModified\":\"2026-07-10T00:22:16+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/python-script\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/python-script\\\/#webpage\"},\"articleSection\":\"Back-End\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/python-script\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/category\\\/back-end\\\/#listItem\",\"name\":\"Back-End\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/category\\\/back-end\\\/#listItem\",\"position\":2,\"name\":\"Back-End\",\"item\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/category\\\/back-end\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/python-script\\\/#listItem\",\"name\":\"Python &#8211; Script\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/python-script\\\/#listItem\",\"position\":3,\"name\":\"Python &#8211; Script\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/category\\\/back-end\\\/#listItem\",\"name\":\"Back-End\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/#person\",\"name\":\"H.Y. Chen\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/python-script\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc6e05e080c9ea570267ee9ed68c8b1841d745cee07c0331c5440646e0646603?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"H.Y. Chen\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/author\\\/hychen\\\/#author\",\"url\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/author\\\/hychen\\\/\",\"name\":\"H.Y. Chen\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/python-script\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc6e05e080c9ea570267ee9ed68c8b1841d745cee07c0331c5440646e0646603?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"H.Y. Chen\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/python-script\\\/#webpage\",\"url\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/python-script\\\/\",\"name\":\"Python \\u2013 Script - HyC Wiki\",\"description\":\"\\u5728\\u5beb\\u5168\\u7aef\\u7684\\u5c08\\u6848\\u7684\\u6642\\u5019\\u6709\\u9047\\u5230\\u4e00\\u500b\\u554f\\u984c\\u5c31\\u662fNext.js\\u6c92\\u8fa6\\u6cd5\\u8dd1DB2! ( IBM \\u516c\\u53f8\\u958b\\u767c\\u7684\\u4e00\\u6b3e\\u4f01\\u696d\\u7d1a\\u95dc\\u806f\\u5f0f\\u8cc7\\u6599\\u5eab\\u7ba1\\u7406\\u7cfb\\u7d71RDBMS\\uff0c\\u4ee5\\u6975\\u9ad8\\u7684\\u6548\\u80fd\\u8457\\u7a31\\uff09 \\u56e0\\u6b64\\u6211\\u7684\\u89e3\\u6cd5\\u662f\\u900f\\u904e python \\u5beb\\u4e00\\u500bScript\\uff0c\\u6709\\u9700\\u8981\\u53bbDB2\\u67e5\\u8a62\\u6642\\u5c31\\u53ea\\u7528\\u6307\\u4ee4\\u57f7\\u884c\\u6b64 python\\uff0cpython\\u8173\\u672c\\u56de\\u50b3JSON\\u5373\\u53ef~ \\u9019\\u88e1\\u63d0\\u4f9b\\u7bc4\\u4f8b\\uff1a #!\\\/usr\\\/bin\\\/env python3 # -*- coding: utf-8 -*- from __future__ import annotations import sys import io import json import os # --- DB2 \\u74b0\\u5883\\u914d\\u7f6e --- if os.name == 'nt': clidriver_path = r'C:\\\\temp\\\\clidriver\\\\bin' if os.path.exists(clidriver_path): os.add_dll_directory(clidriver_path) # \\u5f37\\u5236 UTF-8 \\u8f38\\u51fa\\uff0c\\u907f\\u514d Windows \\u8f49\\u78bc\\u932f\\u8aa4 sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8') sys.stderr =\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/python-script\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/author\\\/hychen\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/author\\\/hychen\\\/#author\"},\"datePublished\":\"2026-07-10T00:20:57+00:00\",\"dateModified\":\"2026-07-10T00:22:16+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/#website\",\"url\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/\",\"name\":\"HyC Wiki\",\"description\":\"Technical articles\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/hyc.eshachem.com\\\/program\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Python \u2013 Script - HyC Wiki","description":"\u5728\u5beb\u5168\u7aef\u7684\u5c08\u6848\u7684\u6642\u5019\u6709\u9047\u5230\u4e00\u500b\u554f\u984c\u5c31\u662fNext.js\u6c92\u8fa6\u6cd5\u8dd1DB2! ( IBM \u516c\u53f8\u958b\u767c\u7684\u4e00\u6b3e\u4f01\u696d\u7d1a\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71RDBMS\uff0c\u4ee5\u6975\u9ad8\u7684\u6548\u80fd\u8457\u7a31\uff09 \u56e0\u6b64\u6211\u7684\u89e3\u6cd5\u662f\u900f\u904e python \u5beb\u4e00\u500bScript\uff0c\u6709\u9700\u8981\u53bbDB2\u67e5\u8a62\u6642\u5c31\u53ea\u7528\u6307\u4ee4\u57f7\u884c\u6b64 python\uff0cpython\u8173\u672c\u56de\u50b3JSON\u5373\u53ef~ \u9019\u88e1\u63d0\u4f9b\u7bc4\u4f8b\uff1a #!\/usr\/bin\/env python3 # -*- coding: utf-8 -*- from __future__ import annotations import sys import io import json import os # --- DB2 \u74b0\u5883\u914d\u7f6e --- if os.name == 'nt': clidriver_path = r'C:\\temp\\clidriver\\bin' if os.path.exists(clidriver_path): os.add_dll_directory(clidriver_path) # \u5f37\u5236 UTF-8 \u8f38\u51fa\uff0c\u907f\u514d Windows \u8f49\u78bc\u932f\u8aa4 sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8') sys.stderr =","canonical_url":"https:\/\/hyc.eshachem.com\/program\/python-script\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"-324YR5tomynX5FeTW2lTMHIX0KmPBvpxjXpOhXwi1Q","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/hyc.eshachem.com\/program\/python-script\/#blogposting","name":"Python \u2013 Script - HyC Wiki","headline":"Python &#8211; Script","author":{"@id":"https:\/\/hyc.eshachem.com\/program\/author\/hychen\/#author"},"publisher":{"@id":"https:\/\/hyc.eshachem.com\/program\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/hyc.eshachem.com\/program\/python-script\/#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/fc6e05e080c9ea570267ee9ed68c8b1841d745cee07c0331c5440646e0646603?s=96&d=mm&r=g","width":96,"height":96,"caption":"H.Y. Chen"},"datePublished":"2026-07-10T00:20:57+00:00","dateModified":"2026-07-10T00:22:16+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/hyc.eshachem.com\/program\/python-script\/#webpage"},"isPartOf":{"@id":"https:\/\/hyc.eshachem.com\/program\/python-script\/#webpage"},"articleSection":"Back-End"},{"@type":"BreadcrumbList","@id":"https:\/\/hyc.eshachem.com\/program\/python-script\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program#listItem","position":1,"name":"Home","item":"https:\/\/hyc.eshachem.com\/program","nextItem":{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program\/category\/back-end\/#listItem","name":"Back-End"}},{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program\/category\/back-end\/#listItem","position":2,"name":"Back-End","item":"https:\/\/hyc.eshachem.com\/program\/category\/back-end\/","nextItem":{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program\/python-script\/#listItem","name":"Python &#8211; Script"},"previousItem":{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program\/python-script\/#listItem","position":3,"name":"Python &#8211; Script","previousItem":{"@type":"ListItem","@id":"https:\/\/hyc.eshachem.com\/program\/category\/back-end\/#listItem","name":"Back-End"}}]},{"@type":"Person","@id":"https:\/\/hyc.eshachem.com\/program\/#person","name":"H.Y. Chen","image":{"@type":"ImageObject","@id":"https:\/\/hyc.eshachem.com\/program\/python-script\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/fc6e05e080c9ea570267ee9ed68c8b1841d745cee07c0331c5440646e0646603?s=96&d=mm&r=g","width":96,"height":96,"caption":"H.Y. Chen"}},{"@type":"Person","@id":"https:\/\/hyc.eshachem.com\/program\/author\/hychen\/#author","url":"https:\/\/hyc.eshachem.com\/program\/author\/hychen\/","name":"H.Y. Chen","image":{"@type":"ImageObject","@id":"https:\/\/hyc.eshachem.com\/program\/python-script\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/fc6e05e080c9ea570267ee9ed68c8b1841d745cee07c0331c5440646e0646603?s=96&d=mm&r=g","width":96,"height":96,"caption":"H.Y. Chen"}},{"@type":"WebPage","@id":"https:\/\/hyc.eshachem.com\/program\/python-script\/#webpage","url":"https:\/\/hyc.eshachem.com\/program\/python-script\/","name":"Python \u2013 Script - HyC Wiki","description":"\u5728\u5beb\u5168\u7aef\u7684\u5c08\u6848\u7684\u6642\u5019\u6709\u9047\u5230\u4e00\u500b\u554f\u984c\u5c31\u662fNext.js\u6c92\u8fa6\u6cd5\u8dd1DB2! ( IBM \u516c\u53f8\u958b\u767c\u7684\u4e00\u6b3e\u4f01\u696d\u7d1a\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71RDBMS\uff0c\u4ee5\u6975\u9ad8\u7684\u6548\u80fd\u8457\u7a31\uff09 \u56e0\u6b64\u6211\u7684\u89e3\u6cd5\u662f\u900f\u904e python \u5beb\u4e00\u500bScript\uff0c\u6709\u9700\u8981\u53bbDB2\u67e5\u8a62\u6642\u5c31\u53ea\u7528\u6307\u4ee4\u57f7\u884c\u6b64 python\uff0cpython\u8173\u672c\u56de\u50b3JSON\u5373\u53ef~ \u9019\u88e1\u63d0\u4f9b\u7bc4\u4f8b\uff1a #!\/usr\/bin\/env python3 # -*- coding: utf-8 -*- from __future__ import annotations import sys import io import json import os # --- DB2 \u74b0\u5883\u914d\u7f6e --- if os.name == 'nt': clidriver_path = r'C:\\temp\\clidriver\\bin' if os.path.exists(clidriver_path): os.add_dll_directory(clidriver_path) # \u5f37\u5236 UTF-8 \u8f38\u51fa\uff0c\u907f\u514d Windows \u8f49\u78bc\u932f\u8aa4 sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8') sys.stderr =","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/hyc.eshachem.com\/program\/#website"},"breadcrumb":{"@id":"https:\/\/hyc.eshachem.com\/program\/python-script\/#breadcrumblist"},"author":{"@id":"https:\/\/hyc.eshachem.com\/program\/author\/hychen\/#author"},"creator":{"@id":"https:\/\/hyc.eshachem.com\/program\/author\/hychen\/#author"},"datePublished":"2026-07-10T00:20:57+00:00","dateModified":"2026-07-10T00:22:16+00:00"},{"@type":"WebSite","@id":"https:\/\/hyc.eshachem.com\/program\/#website","url":"https:\/\/hyc.eshachem.com\/program\/","name":"HyC Wiki","description":"Technical articles","inLanguage":"en-US","publisher":{"@id":"https:\/\/hyc.eshachem.com\/program\/#person"}}]},"og:locale":"en_US","og:site_name":"HyC Wiki - Technical articles","og:type":"article","og:title":"Python \u2013 Script - HyC Wiki","og:description":"\u5728\u5beb\u5168\u7aef\u7684\u5c08\u6848\u7684\u6642\u5019\u6709\u9047\u5230\u4e00\u500b\u554f\u984c\u5c31\u662fNext.js\u6c92\u8fa6\u6cd5\u8dd1DB2! ( IBM \u516c\u53f8\u958b\u767c\u7684\u4e00\u6b3e\u4f01\u696d\u7d1a\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71RDBMS\uff0c\u4ee5\u6975\u9ad8\u7684\u6548\u80fd\u8457\u7a31\uff09 \u56e0\u6b64\u6211\u7684\u89e3\u6cd5\u662f\u900f\u904e python \u5beb\u4e00\u500bScript\uff0c\u6709\u9700\u8981\u53bbDB2\u67e5\u8a62\u6642\u5c31\u53ea\u7528\u6307\u4ee4\u57f7\u884c\u6b64 python\uff0cpython\u8173\u672c\u56de\u50b3JSON\u5373\u53ef~ \u9019\u88e1\u63d0\u4f9b\u7bc4\u4f8b\uff1a #!\/usr\/bin\/env python3 # -*- coding: utf-8 -*- from __future__ import annotations import sys import io import json import os # --- DB2 \u74b0\u5883\u914d\u7f6e --- if os.name == 'nt': clidriver_path = r'C:\\temp\\clidriver\\bin' if os.path.exists(clidriver_path): os.add_dll_directory(clidriver_path) # \u5f37\u5236 UTF-8 \u8f38\u51fa\uff0c\u907f\u514d Windows \u8f49\u78bc\u932f\u8aa4 sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8') sys.stderr =","og:url":"https:\/\/hyc.eshachem.com\/program\/python-script\/","og:image":"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/06\/cropped-cropped-\u672a\u547d\u540d\u8a2d\u8a08-4.png","og:image:secure_url":"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/06\/cropped-cropped-\u672a\u547d\u540d\u8a2d\u8a08-4.png","og:image:width":64,"og:image:height":64,"article:published_time":"2026-07-10T00:20:57+00:00","article:modified_time":"2026-07-10T00:22:16+00:00","twitter:card":"summary_large_image","twitter:title":"Python \u2013 Script - HyC Wiki","twitter:description":"\u5728\u5beb\u5168\u7aef\u7684\u5c08\u6848\u7684\u6642\u5019\u6709\u9047\u5230\u4e00\u500b\u554f\u984c\u5c31\u662fNext.js\u6c92\u8fa6\u6cd5\u8dd1DB2! ( IBM \u516c\u53f8\u958b\u767c\u7684\u4e00\u6b3e\u4f01\u696d\u7d1a\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71RDBMS\uff0c\u4ee5\u6975\u9ad8\u7684\u6548\u80fd\u8457\u7a31\uff09 \u56e0\u6b64\u6211\u7684\u89e3\u6cd5\u662f\u900f\u904e python \u5beb\u4e00\u500bScript\uff0c\u6709\u9700\u8981\u53bbDB2\u67e5\u8a62\u6642\u5c31\u53ea\u7528\u6307\u4ee4\u57f7\u884c\u6b64 python\uff0cpython\u8173\u672c\u56de\u50b3JSON\u5373\u53ef~ \u9019\u88e1\u63d0\u4f9b\u7bc4\u4f8b\uff1a #!\/usr\/bin\/env python3 # -*- coding: utf-8 -*- from __future__ import annotations import sys import io import json import os # --- DB2 \u74b0\u5883\u914d\u7f6e --- if os.name == 'nt': clidriver_path = r'C:\\temp\\clidriver\\bin' if os.path.exists(clidriver_path): os.add_dll_directory(clidriver_path) # \u5f37\u5236 UTF-8 \u8f38\u51fa\uff0c\u907f\u514d Windows \u8f49\u78bc\u932f\u8aa4 sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8') sys.stderr =","twitter:image":"https:\/\/hyc.eshachem.com\/program\/wp-content\/uploads\/2026\/06\/cropped-cropped-\u672a\u547d\u540d\u8a2d\u8a08-4.png"},"aioseo_meta_data":{"post_id":"1000","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-07-28 14:33:05","updated":"2026-07-28 14:33:05"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/hyc.eshachem.com\/program\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/hyc.eshachem.com\/program\/category\/back-end\/\" title=\"Back-End\">Back-End<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tPython \u2013 Script\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/hyc.eshachem.com\/program"},{"label":"Back-End","link":"https:\/\/hyc.eshachem.com\/program\/category\/back-end\/"},{"label":"Python &#8211; Script","link":"https:\/\/hyc.eshachem.com\/program\/python-script\/"}],"views":19,"_links":{"self":[{"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/posts\/1000","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/comments?post=1000"}],"version-history":[{"count":4,"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/posts\/1000\/revisions"}],"predecessor-version":[{"id":1004,"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/posts\/1000\/revisions\/1004"}],"wp:attachment":[{"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/media?parent=1000"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/categories?post=1000"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hyc.eshachem.com\/program\/wp-json\/wp\/v2\/tags?post=1000"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}