{"id":298,"date":"2026-01-25T02:19:18","date_gmt":"2026-01-24T18:19:18","guid":{"rendered":"https:\/\/skwp.zeabur.app\/2026\/01\/25\/%e3%80%90asyncpg-%e6%95%99%e5%ad%b8%e3%80%9101-%e8%aa%8d%e8%ad%98-asyncpg%ef%bc%9apython-%e9%9d%9e%e5%90%8c%e6%ad%a5-postgresql-%e7%9a%84%e9%a6%96%e9%81%b8\/"},"modified":"2026-01-25T02:19:18","modified_gmt":"2026-01-24T18:19:18","slug":"%e3%80%90asyncpg-%e6%95%99%e5%ad%b8%e3%80%9101-%e8%aa%8d%e8%ad%98-asyncpg%ef%bc%9apython-%e9%9d%9e%e5%90%8c%e6%ad%a5-postgresql-%e7%9a%84%e9%a6%96%e9%81%b8","status":"publish","type":"post","link":"https:\/\/blog.itsmygo.uk\/wordpress\/2026\/01\/25\/%e3%80%90asyncpg-%e6%95%99%e5%ad%b8%e3%80%9101-%e8%aa%8d%e8%ad%98-asyncpg%ef%bc%9apython-%e9%9d%9e%e5%90%8c%e6%ad%a5-postgresql-%e7%9a%84%e9%a6%96%e9%81%b8\/","title":{"rendered":"\u3010asyncpg \u6559\u5b78\u3011#01 \u8a8d\u8b58 asyncpg\uff1aPython \u975e\u540c\u6b65 PostgreSQL \u7684\u9996\u9078"},"content":{"rendered":"\n<div id=\"quiz-basic\">\n<style>\n#quiz-basic .question {\n        background: white;\n        border-radius: 8px;\n        padding: 20px;\n        margin: 20px 0;\n        box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);\n      }#quiz-basic .question h3 {\n        margin-top: 0;\n        color: #333;\n      }#quiz-basic .options {\n        list-style: none;\n        padding: 0;\n      }#quiz-basic .options li {\n        padding: 12px 15px;\n        margin: 8px 0;\n        border: 2px solid #ddd;\n        border-radius: 6px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-basic .options li:hover:not(.disabled) {\n        border-color: #4caf50;\n        background: #f0fff0;\n      }#quiz-basic .options li.correct {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-basic .options li.wrong {\n        border-color: #f44336;\n        background: #ffebee;\n      }#quiz-basic .options li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-basic .options li.show-answer {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-basic .feedback {\n        margin-top: 15px;\n        padding: 12px;\n        border-radius: 6px;\n        display: none;\n      }#quiz-basic .feedback.correct {\n        background: #e8f5e9;\n        color: #2e7d32;\n        display: block;\n      }#quiz-basic .feedback.wrong {\n        background: #ffebee;\n        color: #c62828;\n        display: block;\n      }#quiz-basic .score {\n        text-align: center;\n        font-size: 1.5em;\n        padding: 20px;\n        background: white;\n        border-radius: 8px;\n        margin-top: 20px;\n      }#quiz-basic .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Monaco\", \"Consolas\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }\n<\/style>\n<h1>\u6e2c\u9a57\uff1a\u8a8d\u8b58 asyncpg &#8211; Python \u975e\u540c\u6b65 PostgreSQL \u7684\u9996\u9078<\/h1>\n    <p>\u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c<\/p>\n\n    <div class=\"question\" id=\"q1\">\n      <h3>1. \u975e\u540c\u6b65\u8cc7\u6599\u5eab\u64cd\u4f5c\u76f8\u6bd4\u540c\u6b65\u64cd\u4f5c\u7684\u4e3b\u8981\u512a\u52e2\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(1, 'A', 'B')\">A. \u7a0b\u5f0f\u78bc\u66f4\u7c21\u55ae\u6613\u61c2<\/li>\n        <li onclick=\"checkAnswer(1, 'B', 'B')\">B. \u53ef\u4ee5\u540c\u6642\u57f7\u884c\u591a\u500b\u67e5\u8a62\uff0c\u6e1b\u5c11\u7e3d\u7b49\u5f85\u6642\u9593<\/li>\n        <li onclick=\"checkAnswer(1, 'C', 'B')\">C. \u4e0d\u9700\u8981\u95dc\u9589\u8cc7\u6599\u5eab\u9023\u7dda<\/li>\n        <li onclick=\"checkAnswer(1, 'D', 'B')\">D. \u53ef\u4ee5\u4f7f\u7528 %s \u53c3\u6578\u8a9e\u6cd5<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb1\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q2\">\n      <h3>2. asyncpg \u4f7f\u7528\u4ec0\u9ebc\u8a9e\u6cd5\u4f86\u7d81\u5b9a\u67e5\u8a62\u53c3\u6578\uff1f<\/h3>\n      <div class=\"code-block\">await conn.fetch(&#8216;SELECT * FROM users WHERE id = ??? AND status = ???&#8217;, 1, &#8216;active&#8217;)<\/div>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(2, 'A', 'C')\">A. %s, %s<\/li>\n        <li onclick=\"checkAnswer(2, 'B', 'C')\">B. ?, ?<\/li>\n        <li onclick=\"checkAnswer(2, 'C', 'C')\">C. $1, $2<\/li>\n        <li onclick=\"checkAnswer(2, 'D', 'C')\">D. :1, :2<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb2\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q3\">\n      <h3>3. \u5982\u679c\u53ea\u9700\u8981\u53d6\u5f97\u67e5\u8a62\u7d50\u679c\u7684\u55ae\u4e00\u503c\uff08\u4f8b\u5982 COUNT(*) \u7684\u7d50\u679c\uff09\uff0c\u61c9\u8a72\u4f7f\u7528\u54ea\u500b\u65b9\u6cd5\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(3, 'A', 'D')\">A. <code>conn.fetch()<\/code><\/li>\n        <li onclick=\"checkAnswer(3, 'B', 'D')\">B. <code>conn.fetchrow()<\/code><\/li>\n        <li onclick=\"checkAnswer(3, 'C', 'D')\">C. <code>conn.execute()<\/code><\/li>\n        <li onclick=\"checkAnswer(3, 'D', 'D')\">D. <code>conn.fetchval()<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb3\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q4\">\n      <h3>4. asyncpg \u7684 Record \u7269\u4ef6\u652f\u63f4\u4ee5\u4e0b\u54ea\u7a2e\u5b58\u53d6\u65b9\u5f0f\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(4, 'A', 'B')\">A. <code>row.name<\/code>\uff08\u7528\u5c6c\u6027\u5b58\u53d6\uff09<\/li>\n        <li onclick=\"checkAnswer(4, 'B', 'B')\">B. <code>row['name']<\/code> \u548c <code>row[0]<\/code>\uff08\u7528\u5b57\u5178 key \u6216 index\uff09<\/li>\n        <li onclick=\"checkAnswer(4, 'C', 'B')\">C. \u53ea\u80fd\u7528 <code>row.get('name')<\/code><\/li>\n        <li onclick=\"checkAnswer(4, 'D', 'B')\">D. \u53ea\u80fd\u8f49\u6210\u5b57\u5178\u5f8c\u624d\u80fd\u5b58\u53d6<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb4\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q5\">\n      <h3>5. \u5728\u4ec0\u9ebc\u60c5\u6cc1\u4e0b\u61c9\u8a72\u512a\u5148\u9078\u64c7 asyncpg \u800c\u975e psycopg2\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(5, 'A', 'C')\">A. \u4f7f\u7528 Django \u6846\u67b6\u958b\u767c<\/li>\n        <li onclick=\"checkAnswer(5, 'B', 'C')\">B. \u64b0\u5beb\u7c21\u55ae\u7684\u4e00\u6b21\u6027\u8173\u672c<\/li>\n        <li onclick=\"checkAnswer(5, 'C', 'C')\">C. \u4f7f\u7528 FastAPI \u958b\u767c\u9700\u8981\u9ad8\u4f75\u767c\u7684 Web API<\/li>\n        <li onclick=\"checkAnswer(5, 'D', 'C')\">D. \u9700\u8981\u539f\u751f\u652f\u63f4 SQLAlchemy ORM<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb5\"><\/div>\n    <\/div>\n\n    <div class=\"score\" id=\"score\" style=\"display:none;\"><\/div>\n<script>\n\n      let answered = 0;\n      let correct = 0;\n      const total = 5;\n      const explanations = {\n        1: \"\u975e\u540c\u6b65\u64cd\u4f5c\u7684\u6838\u5fc3\u512a\u52e2\u662f\u53ef\u4ee5\u540c\u6642\u767c\u51fa\u591a\u500b\u8acb\u6c42\u4e26\u7b49\u5f85\u5b83\u5011\u5b8c\u6210\uff0c\u5c31\u50cf\u6587\u7ae0\u4e2d\u7684 <code>asyncio.gather()<\/code> \u7bc4\u4f8b\uff0c\u4e09\u500b\u67e5\u8a62\u540c\u6642\u57f7\u884c\u53ea\u9700\u7b49\u6700\u6162\u7684\u90a3\u500b\uff0850ms\uff09\uff0c\u800c\u975e\u4f9d\u5e8f\u7b49\u5f85\uff08150ms\uff09\u3002\",\n        2: \"asyncpg \u4f7f\u7528 PostgreSQL \u539f\u751f\u7684 <code>$n<\/code> \u8a9e\u6cd5\uff08$1, $2, $3...\uff09\u4f86\u7d81\u5b9a\u53c3\u6578\uff0c\u9019\u8207 psycopg2 \u7684 %s \u6216\u5176\u4ed6\u8cc7\u6599\u5eab\u7684 ? \u8a9e\u6cd5\u4e0d\u540c\u3002\",\n        3: \"<code>fetchval()<\/code> \u76f4\u63a5\u56de\u50b3\u67e5\u8a62\u7d50\u679c\u7684\u7b2c\u4e00\u500b\u6b04\u4f4d\u503c\uff0c\u9069\u5408\u7528\u65bc COUNT(*)\u3001SUM() \u7b49\u53ea\u9700\u8981\u55ae\u4e00\u503c\u7684\u60c5\u6cc1\uff0c\u4e0d\u9700\u8981\u518d\u5f9e Record \u7269\u4ef6\u4e2d\u53d6\u503c\u3002\",\n        4: \"Record \u7269\u4ef6\u652f\u63f4\u7528\u5b57\u5178 key \u5b58\u53d6\uff08<code>row['name']<\/code>\uff09\u3001\u7528 index \u5b58\u53d6\uff08<code>row[0]<\/code>\uff09\u4ee5\u53ca <code>row.get('name')<\/code>\uff0c\u4f46\u4e0d\u652f\u63f4\u7528\u5c6c\u6027\u65b9\u5f0f\uff08<code>row.name<\/code>\uff09\u5b58\u53d6\u3002\",\n        5: \"\u6587\u7ae0\u6307\u51fa FastAPI \u9069\u5408\u642d\u914d asyncpg\uff0c\u56e0\u70ba FastAPI \u672c\u8eab\u662f\u975e\u540c\u6b65\u6846\u67b6\uff0c\u9700\u8981\u9ad8\u4f75\u767c\u6642 asyncpg \u53ef\u4ee5\u8f15\u9b06\u61c9\u5c0d\u3002Django \u5247\u5efa\u8b70\u7528 psycopg2\u3002\"\n      };\n\n      function checkAnswer(qNum, selected, correctAns) {\n        const question = document.getElementById(\"q\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answered++;\n\n        const options = question.querySelectorAll(\".options li\");\n        options.forEach((opt) => {\n          opt.classList.add(\"disabled\");\n          if (opt.textContent.startsWith(correctAns + \".\")) {\n            opt.classList.add(\"show-answer\");\n          }\n        });\n\n        const feedback = document.getElementById(\"fb\" + qNum);\n        if (selected === correctAns) {\n          correct++;\n          feedback.className = \"feedback correct\";\n          feedback.innerHTML = \"\u2713 \u6b63\u78ba\uff01\" + explanations[qNum];\n        } else {\n          feedback.className = \"feedback wrong\";\n          feedback.innerHTML =\n            \"\u2717 \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanations[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answered === total) {\n          const scoreDiv = document.getElementById(\"score\");\n          scoreDiv.style.display = \"block\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" +\n            correct +\n            \" \/ \" +\n            total +\n            (correct === total\n              ? \" \ud83c\udf89 \u5168\u5c0d\uff01\"\n              : correct >= Math.ceil(total * 0.6)\n                ? \" \ud83d\udc4d \u4e0d\u932f\uff01\"\n                : \" \ud83d\udcda \u518d\u8907\u7fd2\u4e00\u4e0b\u5427\");\n        }\n      }\n    \n<\/script>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e00\u53e5\u8a71\u8aaa\u660e<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">asyncpg \u662f\u5c08\u70ba Python asyncio \u8a2d\u8a08\u7684 PostgreSQL \u9a45\u52d5\u7a0b\u5f0f\uff0c\u6bd4\u50b3\u7d71\u540c\u6b65\u65b9\u5f0f\u5feb\u5f88\u591a\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u70ba\u4ec0\u9ebc\u9700\u8981\u975e\u540c\u6b65\u8cc7\u6599\u5eab\u64cd\u4f5c\uff1f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5148\u770b\u4e00\u500b\u554f\u984c\u60c5\u5883\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># \u540c\u6b65\u65b9\u5f0f\uff1a\u4e00\u500b\u4e00\u500b\u7b49<\/span>\nuser = db.get_user(<span class=\"hljs-number\">1<\/span>)      <span class=\"hljs-comment\"># \u7b49 50ms<\/span>\norders = db.get_orders(<span class=\"hljs-number\">1<\/span>)   <span class=\"hljs-comment\"># \u518d\u7b49 50ms<\/span>\nproducts = db.get_products() <span class=\"hljs-comment\"># \u518d\u7b49 50ms<\/span>\n<span class=\"hljs-comment\"># \u7e3d\u5171\u7b49\u4e86 150ms<\/span>\n\n<span class=\"hljs-comment\"># \u975e\u540c\u6b65\u65b9\u5f0f\uff1a\u540c\u6642\u7b49<\/span>\nuser, orders, products = await asyncio.gather(\n    db.get_user(<span class=\"hljs-number\">1<\/span>),         <span class=\"hljs-comment\"># \u540c\u6642<\/span>\n    db.get_orders(<span class=\"hljs-number\">1<\/span>),       <span class=\"hljs-comment\"># \u540c\u6642<\/span>\n    db.get_products()       <span class=\"hljs-comment\"># \u540c\u6642<\/span>\n)\n<span class=\"hljs-comment\"># \u7e3d\u5171\u53ea\u7b49 50ms\uff08\u6700\u6162\u7684\u90a3\u500b\uff09<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a\u540c\u6b65\u5c31\u50cf\u6392\u968a\u8cb7\u6771\u897f\uff0c\u4e00\u500b\u4e00\u500b\u4f86\uff1b\u975e\u540c\u6b65\u5c31\u50cf\u540c\u6642\u6d3e\u4e09\u500b\u4eba\u53bb\u8cb7\uff0c\u8ab0\u5148\u8cb7\u5230\u8ab0\u5148\u56de\u4f86\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u4ec0\u9ebc\u6642\u5019\u8a72\u7528\u975e\u540c\u6b65\uff1f<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u60c5\u5883<\/th>\n<th>\u7528\u540c\u6b65<\/th>\n<th>\u7528\u975e\u540c\u6b65<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u7c21\u55ae\u8173\u672c\u3001\u4e00\u6b21\u6027\u4efb\u52d9<\/td>\n<td>V<\/td>\n<\/tr>\n<tr>\n<td>Web API\uff08FastAPI\u3001Sanic\uff09<\/td>\n<td>V<\/td>\n<\/tr>\n<tr>\n<td>\u540c\u6642\u8655\u7406\u591a\u500b\u8acb\u6c42<\/td>\n<td>V<\/td>\n<\/tr>\n<tr>\n<td>\u9700\u8981\u9ad8\u4f75\u767c<\/td>\n<td>V<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">asyncpg vs psycopg2\uff1a\u9078\u54ea\u500b\uff1f<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u6bd4\u8f03\u9805\u76ee<\/th>\n<th>psycopg2<\/th>\n<th>asyncpg<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u6a21\u5f0f<\/td>\n<td>\u540c\u6b65\uff08blocking\uff09<\/td>\n<td>\u975e\u540c\u6b65\uff08async\uff09<\/td>\n<\/tr>\n<tr>\n<td>\u6548\u80fd<\/td>\n<td>\u57fa\u6e96<\/td>\n<td>\u5feb 5 \u500d\u5de6\u53f3<\/td>\n<\/tr>\n<tr>\n<td>\u9ad8\u4f75\u767c<\/td>\n<td>\u6703\u5361\u4f4f<\/td>\n<td>\u8f15\u9b06\u61c9\u5c0d<\/td>\n<\/tr>\n<tr>\n<td>\u9023\u7dda\u6c60<\/td>\n<td>\u9700\u8981\u984d\u5916\u5957\u4ef6<\/td>\n<td>\u5167\u5efa<\/td>\n<\/tr>\n<tr>\n<td>Django\/SQLAlchemy<\/td>\n<td>\u539f\u751f\u652f\u63f4<\/td>\n<td>\u9700\u8981\u984d\u5916\u8a2d\u5b9a<\/td>\n<\/tr>\n<tr>\n<td>\u5b78\u7fd2\u66f2\u7dda<\/td>\n<td>\u7c21\u55ae<\/td>\n<td>\u9700\u8981\u61c2 async\/await<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4e00\u53e5\u8a71\u9078\u64c7\u6307\u5357<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u7528 Django \u2192 \u7528 psycopg2<\/li>\n<li>\u7528 FastAPI \u2192 \u7528 asyncpg<\/li>\n<li>\u4e0d\u78ba\u5b9a \u2192 \u5148\u770b\u4f60\u7684\u6846\u67b6\u652f\u63f4\u4ec0\u9ebc<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">30 \u79d2\u5b89\u88dd\u8207\u7b2c\u4e00\u6b21\u9023\u7dda<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u5b89\u88dd<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># \u4f7f\u7528 uv\uff08\u63a8\u85a6\uff09<\/span>\nuv pip install asyncpg\n\n<span class=\"hljs-comment\"># \u6216\u4f7f\u7528 pip<\/span>\npip install asyncpg\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\u53ef\u904b\u884c\u7bc4\u4f8b<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">import asyncio\nimport asyncpg\n\nasync def main():\n    <span class=\"hljs-comment\"># \u5efa\u7acb\u9023\u7dda<\/span>\n    conn = await asyncpg.connect(\n        <span class=\"hljs-string\">'postgresql:\/\/postgres:password@localhost\/mydb'<\/span>\n    )\n\n    <span class=\"hljs-comment\"># \u57f7\u884c\u67e5\u8a62<\/span>\n    row = await conn.fetchrow(<span class=\"hljs-string\">'SELECT 1 as num, $1 as name'<\/span>, <span class=\"hljs-string\">'Alice'<\/span>)\n    <span class=\"hljs-keyword\">print<\/span>(row)  <span class=\"hljs-comment\"># &lt;Record num=1 name='Alice'&gt;<\/span>\n\n    <span class=\"hljs-comment\"># \u95dc\u9589\u9023\u7dda<\/span>\n    await conn.close()\n\n<span class=\"hljs-comment\"># \u57f7\u884c<\/span>\nasyncio.run(main())\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u9019\u6bb5\u4ee3\u78bc\u505a\u4e86\u4ec0\u9ebc<\/strong>\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>asyncpg.connect()<\/code> &#8211; \u9023\u7dda\u5230 PostgreSQL<\/li>\n<li><code>conn.fetchrow()<\/code> &#8211; \u57f7\u884c\u67e5\u8a62\uff0c\u53d6\u5f97\u4e00\u7b46\u8cc7\u6599<\/li>\n<li><code>conn.close()<\/code> &#8211; \u7528\u5b8c\u8981\u95dc\u9589\u9023\u7dda<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u6838\u5fc3\u6982\u5ff5\u7ffb\u8b6f<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u4f60\u6703\u770b\u5230<\/th>\n<th>\u610f\u601d<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>await asyncpg.connect(...)<\/code><\/td>\n<td>\u5efa\u7acb\u4e00\u500b\u8cc7\u6599\u5eab\u9023\u7dda<\/td>\n<\/tr>\n<tr>\n<td><code>await conn.fetch(...)<\/code><\/td>\n<td>\u67e5\u8a62\u4e26\u53d6\u5f97\u591a\u7b46\u8cc7\u6599\uff08List\uff09<\/td>\n<\/tr>\n<tr>\n<td><code>await conn.fetchrow(...)<\/code><\/td>\n<td>\u67e5\u8a62\u4e26\u53d6\u5f97\u4e00\u7b46\u8cc7\u6599<\/td>\n<\/tr>\n<tr>\n<td><code>await conn.fetchval(...)<\/code><\/td>\n<td>\u67e5\u8a62\u4e26\u53d6\u5f97\u55ae\u4e00\u503c<\/td>\n<\/tr>\n<tr>\n<td><code>await conn.execute(...)<\/code><\/td>\n<td>\u57f7\u884c SQL\uff08\u4e0d\u9700\u8981\u56de\u50b3\u8cc7\u6599\u6642\u7528\uff09<\/td>\n<\/tr>\n<tr>\n<td><code>$1, $2, $3<\/code><\/td>\n<td>\u53c3\u6578\u4f54\u4f4d\u7b26\uff08\u4e0d\u662f %s\uff09<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">AI \u6700\u5e38\u9019\u6a23\u7528<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u7528\u6cd5 1\uff1a\u67e5\u8a62\u591a\u7b46\u8cc7\u6599<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">async def get_all_users(conn):\n    <span class=\"hljs-comment\"># fetch \u56de\u50b3 List&#91;Record]<\/span>\n    rows = await conn.fetch(<span class=\"hljs-string\">'SELECT id, name FROM users'<\/span>)\n\n    <span class=\"hljs-keyword\">for<\/span> row in rows:\n        <span class=\"hljs-keyword\">print<\/span>(row&#91;<span class=\"hljs-string\">'id'<\/span>], row&#91;<span class=\"hljs-string\">'name'<\/span>])  <span class=\"hljs-comment\"># \u7528\u5b57\u5178\u65b9\u5f0f\u5b58\u53d6<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a<code>fetch<\/code> \u6703\u56de\u50b3\u4e00\u500b\u5217\u8868\uff0c\u88e1\u9762\u6bcf\u500b\u5143\u7d20\u90fd\u662f\u4e00\u7b46\u8cc7\u6599\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u7528\u6cd5 2\uff1a\u67e5\u8a62\u55ae\u7b46\u8cc7\u6599<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">async def get_user(conn, user_id: int):\n    <span class=\"hljs-comment\"># fetchrow \u56de\u50b3\u55ae\u4e00 Record\uff08\u6216 None\uff09<\/span>\n    row = await conn.fetchrow(\n        <span class=\"hljs-string\">'SELECT * FROM users WHERE id = $1'<\/span>,\n        user_id\n    )\n\n    <span class=\"hljs-keyword\">if<\/span> row:\n        <span class=\"hljs-keyword\">return<\/span> dict(row)  <span class=\"hljs-comment\"># \u8f49\u6210\u666e\u901a\u5b57\u5178<\/span>\n    <span class=\"hljs-keyword\">return<\/span> None\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a<code>fetchrow<\/code> \u53ea\u62ff\u4e00\u7b46\uff0c\u627e\u4e0d\u5230\u6703\u56de\u50b3 <code>None<\/code>\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u7528\u6cd5 3\uff1a\u53ea\u8981\u4e00\u500b\u503c<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">async def count_users(conn):\n    <span class=\"hljs-comment\"># fetchval \u53ea\u56de\u50b3\u7b2c\u4e00\u500b\u6b04\u4f4d\u7684\u503c<\/span>\n    count = await conn.fetchval(<span class=\"hljs-string\">'SELECT COUNT(*) FROM users'<\/span>)\n    <span class=\"hljs-keyword\">return<\/span> count  <span class=\"hljs-comment\"># \u76f4\u63a5\u662f\u6578\u5b57\uff0c\u4e0d\u662f Record<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a<code>fetchval<\/code> \u76f4\u63a5\u7d66\u4f60\u503c\uff0c\u4e0d\u7528\u518d\u5f9e Record \u88e1\u53d6\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u7528\u6cd5 4\uff1a\u57f7\u884c\u4e0d\u9700\u8981\u56de\u50b3\u7684\u64cd\u4f5c<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">async def create_user(conn, name: str, email: str):\n    <span class=\"hljs-comment\"># execute \u7528\u65bc INSERT\/UPDATE\/DELETE<\/span>\n    await conn.execute(\n        <span class=\"hljs-string\">'INSERT INTO users (name, email) VALUES ($1, $2)'<\/span>,\n        name, email\n    )\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a\u65b0\u589e\u3001\u4fee\u6539\u3001\u522a\u9664\u7528 <code>execute<\/code>\uff0c\u4e0d\u6703\u56de\u50b3\u8cc7\u6599\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Record \u7269\u4ef6\u600e\u9ebc\u7528<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">asyncpg \u67e5\u8a62\u56de\u4f86\u7684\u4e0d\u662f\u666e\u901a\u5b57\u5178\uff0c\u662f <code>Record<\/code> \u7269\u4ef6\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">row = await conn.fetchrow(<span class=\"hljs-string\">'SELECT id, name, email FROM users WHERE id = $1'<\/span>, <span class=\"hljs-number\">1<\/span>)\n\n<span class=\"hljs-comment\"># \u4e09\u7a2e\u5b58\u53d6\u65b9\u5f0f\u90fd\u53ef\u4ee5<\/span>\n<span class=\"hljs-keyword\">print<\/span>(row&#91;<span class=\"hljs-string\">'name'<\/span>])     <span class=\"hljs-comment\"># \u7528 key \u5b58\u53d6\uff08\u50cf\u5b57\u5178\uff09<\/span>\n<span class=\"hljs-keyword\">print<\/span>(row&#91;<span class=\"hljs-number\">1<\/span>])          <span class=\"hljs-comment\"># \u7528 index \u5b58\u53d6\uff08\u50cf tuple\uff09<\/span>\n<span class=\"hljs-keyword\">print<\/span>(row.get(<span class=\"hljs-string\">'name'<\/span>)) <span class=\"hljs-comment\"># \u7528 get \u5b58\u53d6\uff08\u627e\u4e0d\u5230\u56de\u50b3 None\uff09<\/span>\n\n<span class=\"hljs-comment\"># \u8f49\u6210\u666e\u901a\u5b57\u5178<\/span>\nuser_dict = dict(row)\n<span class=\"hljs-keyword\">print<\/span>(user_dict)  <span class=\"hljs-comment\"># {'id': 1, 'name': 'Alice', 'email': 'alice@example.com'}<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">Record vs \u5b57\u5178<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u64cd\u4f5c<\/th>\n<th>Record<\/th>\n<th>dict<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>row['name']<\/code><\/td>\n<td>V<\/td>\n<td>V<\/td>\n<\/tr>\n<tr>\n<td><code>row[0]<\/code><\/td>\n<td>V<\/td>\n<td>X<\/td>\n<\/tr>\n<tr>\n<td><code>row.get('name')<\/code><\/td>\n<td>V<\/td>\n<td>V<\/td>\n<\/tr>\n<tr>\n<td>\u8f49\u6210\u5b57\u5178<\/td>\n<td><code>dict(row)<\/code><\/td>\n<td>\u672c\u8eab\u5c31\u662f<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Vibe Coder \u63d0\u793a<\/strong>\uff1a\u5982\u679c AI \u5beb\u7684\u4ee3\u78bc\u7528 <code>row.name<\/code> \u6703\u5831\u932f\uff0cRecord \u4e0d\u652f\u63f4\u9019\u7a2e\u8a9e\u6cd5\uff0c\u8981\u7528 <code>row['name']<\/code>\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u53c3\u6578\u7d81\u5b9a\uff1a$1, $2, $3<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">asyncpg \u4f7f\u7528 <code>$n<\/code> \u8a9e\u6cd5\u7d81\u5b9a\u53c3\u6578\uff0c\u4e0d\u662f Python \u5e38\u898b\u7684 <code>%s<\/code> \u6216 <code>?<\/code>\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># asyncpg \u7684\u65b9\u5f0f<\/span>\nawait conn.fetch(<span class=\"hljs-string\">'SELECT * FROM users WHERE id = $1 AND status = $2'<\/span>, <span class=\"hljs-number\">1<\/span>, <span class=\"hljs-string\">'active'<\/span>)\n<span class=\"hljs-comment\">#                                                  \u2191         \u2191      \u2191     \u2191<\/span>\n<span class=\"hljs-comment\">#                                                 $1        $2     \u5c0d\u61c9    \u5c0d\u61c9<\/span>\n\n<span class=\"hljs-comment\"># \u4e0d\u662f\u9019\u6a23\uff08\u9019\u6703\u932f\uff09<\/span>\nawait conn.fetch(<span class=\"hljs-string\">'SELECT * FROM users WHERE id = %s'<\/span>, (<span class=\"hljs-number\">1<\/span>,))  <span class=\"hljs-comment\"># \u932f\uff01<\/span>\nawait conn.fetch(<span class=\"hljs-string\">'SELECT * FROM users WHERE id = ?'<\/span>, <span class=\"hljs-number\">1<\/span>)      <span class=\"hljs-comment\"># \u932f\uff01<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4e00\u53e5\u8a71<\/strong>\uff1a<code>$1<\/code> \u5c0d\u61c9\u7b2c\u4e00\u500b\u53c3\u6578\uff0c<code>$2<\/code> \u5c0d\u61c9\u7b2c\u4e8c\u500b\uff0c\u4ee5\u6b64\u985e\u63a8\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u5b8c\u6574\u7bc4\u4f8b\uff1aCRUD \u64cd\u4f5c<\/h2>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">import asyncio\nimport asyncpg\n\nasync def main():\n    <span class=\"hljs-comment\"># \u9023\u7dda<\/span>\n    conn = await asyncpg.connect(<span class=\"hljs-string\">'postgresql:\/\/postgres:password@localhost\/mydb'<\/span>)\n\n    <span class=\"hljs-comment\"># Create - \u65b0\u589e<\/span>\n    await conn.execute(\n        <span class=\"hljs-string\">'INSERT INTO users (name, email) VALUES ($1, $2)'<\/span>,\n        <span class=\"hljs-string\">'Bob'<\/span>, <span class=\"hljs-string\">'bob@example.com'<\/span>\n    )\n\n    <span class=\"hljs-comment\"># Read - \u67e5\u8a62\u55ae\u7b46<\/span>\n    user = await conn.fetchrow(<span class=\"hljs-string\">'SELECT * FROM users WHERE name = $1'<\/span>, <span class=\"hljs-string\">'Bob'<\/span>)\n    <span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"\u627e\u5230\u7528\u6236: {user&#91;'name']}\"<\/span>)\n\n    <span class=\"hljs-comment\"># Read - \u67e5\u8a62\u591a\u7b46<\/span>\n    all_users = await conn.fetch(<span class=\"hljs-string\">'SELECT * FROM users'<\/span>)\n    <span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"\u5171\u6709 {len(all_users)} \u4f4d\u7528\u6236\"<\/span>)\n\n    <span class=\"hljs-comment\"># Update - \u66f4\u65b0<\/span>\n    await conn.execute(\n        <span class=\"hljs-string\">'UPDATE users SET email = $1 WHERE name = $2'<\/span>,\n        <span class=\"hljs-string\">'bob.new@example.com'<\/span>, <span class=\"hljs-string\">'Bob'<\/span>\n    )\n\n    <span class=\"hljs-comment\"># Delete - \u522a\u9664<\/span>\n    await conn.execute(<span class=\"hljs-string\">'DELETE FROM users WHERE name = $1'<\/span>, <span class=\"hljs-string\">'Bob'<\/span>)\n\n    <span class=\"hljs-comment\"># \u95dc\u9589\u9023\u7dda<\/span>\n    await conn.close()\n\nasyncio.run(main())\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">Vibe Coder \u6aa2\u67e5\u9ede<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u770b\u5230 AI \u7528 asyncpg \u6642\u78ba\u8a8d\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>[ ] <strong>\u6709\u6c92\u6709 await\uff1f<\/strong> &#8211; \u6240\u6709 asyncpg \u64cd\u4f5c\u90fd\u8981\u52a0 await<\/li>\n<li>[ ] <strong>\u9023\u7dda\u6709\u6c92\u6709\u95dc\u9589\uff1f<\/strong> &#8211; \u7528\u5b8c\u8981 <code>await conn.close()<\/code> \u6216\u7528 context manager<\/li>\n<li>[ ] <strong>\u53c3\u6578\u7528 $1, $2\uff1f<\/strong> &#8211; \u4e0d\u662f %s \u6216 ?<\/li>\n<li>[ ] <strong>fetchrow \u6709\u6c92\u6709\u8655\u7406 None\uff1f<\/strong> &#8211; \u67e5\u7121\u8cc7\u6599\u6703\u56de\u50b3 None<\/li>\n<li>[ ] <strong>Record \u5b58\u53d6\u65b9\u5f0f\u5c0d\u55ce\uff1f<\/strong> &#8211; \u7528 <code>row['column']<\/code> \u4e0d\u662f <code>row.column<\/code><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u5e38\u898b\u932f\u8aa4\u8207\u89e3\u6cd5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u932f\u8aa4 1\uff1a\u5fd8\u8a18 await<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-11\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># \u932f\u8aa4<\/span>\nrow = conn.fetchrow(<span class=\"hljs-string\">'SELECT * FROM users'<\/span>)  <span class=\"hljs-comment\"># \u5c11\u4e86 await<\/span>\n<span class=\"hljs-keyword\">print<\/span>(row)  <span class=\"hljs-comment\"># \u6703\u5370\u51fa coroutine \u7269\u4ef6\uff0c\u4e0d\u662f\u8cc7\u6599<\/span>\n\n<span class=\"hljs-comment\"># \u6b63\u78ba<\/span>\nrow = await conn.fetchrow(<span class=\"hljs-string\">'SELECT * FROM users'<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-11\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u932f\u8aa4 2\uff1a\u7528\u932f\u53c3\u6578\u8a9e\u6cd5<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-12\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># \u932f\u8aa4<\/span>\nawait conn.fetch(<span class=\"hljs-string\">'SELECT * FROM users WHERE id = %s'<\/span>, <span class=\"hljs-number\">1<\/span>)  <span class=\"hljs-comment\"># psycopg2 \u8a9e\u6cd5<\/span>\n\n<span class=\"hljs-comment\"># \u6b63\u78ba<\/span>\nawait conn.fetch(<span class=\"hljs-string\">'SELECT * FROM users WHERE id = $1'<\/span>, <span class=\"hljs-number\">1<\/span>)  <span class=\"hljs-comment\"># asyncpg \u8a9e\u6cd5<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-12\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u932f\u8aa4 3\uff1a\u5728\u540c\u6b65\u51fd\u5f0f\u88e1\u547c\u53eb async<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-13\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># \u932f\u8aa4<\/span>\ndef get_user():  <span class=\"hljs-comment\"># \u4e0d\u662f async<\/span>\n    <span class=\"hljs-keyword\">return<\/span> await conn.fetchrow(...)  <span class=\"hljs-comment\"># \u6703\u5831\u932f<\/span>\n\n<span class=\"hljs-comment\"># \u6b63\u78ba<\/span>\nasync def get_user():  <span class=\"hljs-comment\"># \u52a0\u4e0a async<\/span>\n    <span class=\"hljs-keyword\">return<\/span> await conn.fetchrow(...)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-13\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u5ef6\u4f38\uff1a\u77e5\u9053\u5c31\u597d<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u4e9b\u9032\u968e\u529f\u80fd\u4e4b\u5f8c\u6703\u6559\uff0c\u73fe\u5728\u5148\u77e5\u9053\u5b58\u5728\u5c31\u597d\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u9023\u7dda\u6c60\uff08Connection Pool\uff09<\/strong>\uff1a\u7ba1\u7406\u591a\u500b\u9023\u7dda\uff0c\u9069\u5408 Web \u61c9\u7528<\/li>\n<li><strong>\u4ea4\u6613\uff08Transaction\uff09<\/strong>\uff1a\u591a\u500b\u64cd\u4f5c\u8981\u540c\u6642\u6210\u529f\u6216\u5931\u6557<\/li>\n<li><strong>Prepared Statements<\/strong>\uff1a\u91cd\u8907\u67e5\u8a62\u6642\u63d0\u5347\u6548\u80fd<\/li>\n<li><strong>COPY \u64cd\u4f5c<\/strong>\uff1a\u5927\u91cf\u8cc7\u6599\u532f\u5165\u532f\u51fa<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e0b\u4e00\u6b65<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b78\u5b8c\u9019\u7bc7\uff0c\u4f60\u5df2\u7d93\u6703\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u7406\u89e3\u540c\u6b65 vs \u975e\u540c\u6b65\u7684\u5dee\u7570<\/li>\n<li>\u5b89\u88dd asyncpg \u4e26\u5efa\u7acb\u9023\u7dda<\/li>\n<li>\u4f7f\u7528 fetch \/ fetchrow \/ fetchval \/ execute<\/li>\n<li>\u6b63\u78ba\u4f7f\u7528 $1, $2 \u53c3\u6578\u7d81\u5b9a<\/li>\n<li>\u8655\u7406 Record \u7269\u4ef6<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0b\u4e00\u7bc7\u6211\u5011\u6703\u5b78\u7fd2\u300c\u9023\u7dda\u6c60\u300d- \u5728 Web \u61c9\u7528\u4e2d\u6b63\u78ba\u7ba1\u7406\u8cc7\u6599\u5eab\u9023\u7dda\u7684\u65b9\u5f0f\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u53c3\u8003\u8cc7\u6e90<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/magicstack.github.io\/asyncpg\/current\/\">asyncpg \u5b98\u65b9\u6587\u4ef6<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/MagicStack\/asyncpg\">asyncpg GitHub<\/a><\/li>\n<li><a href=\"https:\/\/pypi.org\/project\/asyncpg\/\">asyncpg PyPI<\/a><\/li>\n<\/ul>\n\n\n\n<div id=\"quiz-advanced\">\n<style>\n#quiz-advanced .badge {\n        display: inline-block;\n        padding: 4px 10px;\n        border-radius: 12px;\n        font-size: 0.75em;\n        font-weight: bold;\n        margin-left: 8px;\n      }#quiz-advanced .badge.scenario {\n        background: #ebf8ff;\n        color: #2b6cb0;\n      }#quiz-advanced .badge.debug {\n        background: #fef3c7;\n        color: #92400e;\n      }#quiz-advanced .question-adv {\n        background: white;\n        border-radius: 10px;\n        padding: 24px;\n        margin: 20px 0;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n        border-left: 4px solid #ed8936;\n      }#quiz-advanced .question-adv h3 {\n        margin-top: 0;\n        color: #2d3748;\n      }#quiz-advanced .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Menlo\", \"Monaco\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }#quiz-advanced .options-adv {\n        list-style: none;\n        padding: 0;\n      }#quiz-advanced .options-adv li {\n        padding: 14px 16px;\n        margin: 10px 0;\n        border: 2px solid #e2e8f0;\n        border-radius: 8px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-advanced .options-adv li:hover:not(.disabled) {\n        border-color: #ed8936;\n        background: #fffaf0;\n      }#quiz-advanced .options-adv li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-advanced .options-adv li.show-answer {\n        border-color: #48bb78;\n        background: #f0fff4;\n      }#quiz-advanced .options-adv li.wrong {\n        border-color: #fc8181;\n        background: #fff5f5;\n      }#quiz-advanced .feedback-adv {\n        margin-top: 16px;\n        padding: 14px;\n        border-radius: 8px;\n        display: none;\n        line-height: 1.6;\n      }#quiz-advanced .feedback-adv.correct {\n        background: #f0fff4;\n        color: #276749;\n        display: block;\n      }#quiz-advanced .feedback-adv.wrong {\n        background: #fff5f5;\n        color: #c53030;\n        display: block;\n      }#quiz-advanced .feedback-adv \n      .score-adv {\n        text-align: center;\n        font-size: 1.4em;\n        padding: 24px;\n        background: white;\n        border-radius: 10px;\n        margin-top: 24px;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n      }#quiz-advanced .intro {\n        background: #ebf8ff;\n        padding: 16px;\n        border-radius: 8px;\n        margin-bottom: 20px;\n        color: #2c5282;\n      }\n<\/style>\n<h1>\u9032\u968e\u6e2c\u9a57\uff1a\u8a8d\u8b58 asyncpg &#8211; Python \u975e\u540c\u6b65 PostgreSQL \u7684\u9996\u9078<\/h1>\n    <div class=\"intro\">\n      <strong>\u6e2c\u9a57\u76ee\u6a19\uff1a<\/strong>\u9a57\u8b49\u4f60\u662f\u5426\u80fd\u5728\u5be6\u969b\u60c5\u5883\u4e2d\u61c9\u7528\u6240\u5b78\u3002<br \/>\n      \u5171 5 \u984c\uff0c\u5305\u542b\u60c5\u5883\u984c\u8207\u932f\u8aa4\u8a3a\u65b7\u984c\u3002\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv1\">\n      <h3>1. \u4f60\u6b63\u5728\u958b\u767c\u4e00\u500b\u7528\u6236\u5100\u8868\u677f API\uff0c\u9700\u8981\u540c\u6642\u53d6\u5f97\u7528\u6236\u8cc7\u6599\u3001\u8a02\u55ae\u5217\u8868\u548c\u7522\u54c1\u6e05\u55ae\u3002\u5982\u4f55\u7528 asyncpg \u6700\u6709\u6548\u7387\u5730\u5b8c\u6210\u9019\u500b\u9700\u6c42\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(1, 'A', 'B')\">A. \u4f9d\u5e8f\u547c\u53eb\u4e09\u500b <code>await conn.fetch()<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(1, 'B', 'B')\">B. \u4f7f\u7528 <code>asyncio.gather()<\/code> \u540c\u6642\u57f7\u884c\u4e09\u500b\u67e5\u8a62<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'C', 'B')\">C. \u4f7f\u7528\u4e00\u500b JOIN \u5c07\u4e09\u500b\u8868\u5408\u4f75\u67e5\u8a62<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'D', 'B')\">D. \u5efa\u7acb\u4e09\u500b\u7368\u7acb\u7684\u8cc7\u6599\u5eab\u9023\u7dda\u5206\u5225\u67e5\u8a62<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv1\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv2\">\n      <h3>2. \u5c0f\u660e\u5beb\u4e86\u4ee5\u4e0b\u7a0b\u5f0f\u78bc\uff0c\u4f46\u57f7\u884c\u5f8c\u5370\u51fa\u7684\u662f\u4e00\u500b\u5947\u602a\u7684\u7269\u4ef6\u800c\u4e0d\u662f\u8cc7\u6599\u3002\u554f\u984c\u51fa\u5728\u54ea\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">async def get_user(conn, user_id):\n    row = conn.fetchrow(&#8216;SELECT * FROM users WHERE id = $1&#8217;, user_id)\n    print(row)\n    return row<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(2, 'A', 'C')\">A. \u53c3\u6578\u8a9e\u6cd5\u932f\u8aa4\uff0c\u61c9\u8a72\u7528 <code>%s<\/code> \u800c\u4e0d\u662f <code>$1<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(2, 'B', 'C')\">B. <code>fetchrow<\/code> \u61c9\u8a72\u6539\u7528 <code>fetch<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(2, 'C', 'C')\">C. \u5fd8\u8a18\u5728 <code>conn.fetchrow()<\/code> \u524d\u52a0 <code>await<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(2, 'D', 'C')\">D. <code>user_id<\/code> \u53c3\u6578\u4f4d\u7f6e\u932f\u8aa4<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv2\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv3\">\n      <h3>3. \u4f60\u9700\u8981\u5be6\u4f5c\u4e00\u500b\u51fd\u5f0f\u4f86\u8a08\u7b97\u8cc7\u6599\u5eab\u4e2d\u7684\u7528\u6236\u7e3d\u6578\uff0c\u4e26\u76f4\u63a5\u56de\u50b3\u6578\u5b57\u3002\u4ee5\u4e0b\u54ea\u500b\u5be6\u4f5c\u6700\u5408\u9069\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(3, 'A', 'D')\">A. <code>rows = await conn.fetch('SELECT COUNT(*) FROM users'); return len(rows)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(3, 'B', 'D')\">B. <code>row = await conn.fetchrow('SELECT COUNT(*) FROM users'); return row[0]<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(3, 'C', 'D')\">C. <code>await conn.execute('SELECT COUNT(*) FROM users')<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(3, 'D', 'D')\">D. <code>count = await conn.fetchval('SELECT COUNT(*) FROM users'); return count<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv3\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv4\">\n      <h3>4. \u5c0f\u83ef\u7684\u7a0b\u5f0f\u78bc\u5728\u57f7\u884c\u6642\u62cb\u51fa\u932f\u8aa4\u3002\u8acb\u5224\u65b7\u554f\u984c\u6240\u5728\uff1a <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">row = await conn.fetchrow(&#8216;SELECT id, name, email FROM users WHERE id = $1&#8217;, 1)\nprint(f&#8221;User name: {row.name}&#8221;)<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(4, 'A', 'B')\">A. \u67e5\u8a62\u8a9e\u6cd5\u932f\u8aa4<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'B', 'B')\">B. Record \u4e0d\u652f\u63f4 <code>row.name<\/code> \u5c6c\u6027\u5b58\u53d6\uff0c\u61c9\u6539\u7528 <code>row['name']<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(4, 'C', 'B')\">C. \u7f3a\u5c11 <code>await<\/code> \u95dc\u9375\u5b57<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'D', 'B')\">D. \u61c9\u8a72\u5148\u7528 <code>dict(row)<\/code> \u8f49\u63db\u624d\u80fd\u5b58\u53d6<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv4\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv5\">\n      <h3>5. \u4f60\u5728\u5efa\u7acb\u4e00\u500b FastAPI \u61c9\u7528\uff0c\u9700\u8981\u5c07\u65b0\u7528\u6236\u8cc7\u6599\u5beb\u5165\u8cc7\u6599\u5eab\u3002\u7528\u6236\u8cc7\u6599\u5305\u542b name \u548c email\u3002\u4ee5\u4e0b\u54ea\u500b\u5beb\u6cd5\u6b63\u78ba\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">async def create_user(conn, name: str, email: str):\n    # \u9078\u64c7\u6b63\u78ba\u7684\u5be6\u4f5c\u65b9\u5f0f<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(5, 'A', 'C')\">A. <code>await conn.fetch('INSERT INTO users (name, email) VALUES (%s, %s)', name, email)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(5, 'B', 'C')\">B. <code>await conn.fetchrow('INSERT INTO users (name, email) VALUES ($1, $2)', name, email)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(5, 'C', 'C')\">C. <code>await conn.execute('INSERT INTO users (name, email) VALUES ($1, $2)', name, email)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(5, 'D', 'C')\">D. <code>await conn.fetchval('INSERT INTO users (name, email) VALUES ($1, $2)', name, email)<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv5\"><\/div>\n    <\/div>\n\n    <div class=\"score-adv\" id=\"scoreAdv\" style=\"display:none;\"><\/div>\n<script>\n\n      let answeredAdv = 0;\n      let correctAdv = 0;\n      const totalAdv = 5;\n      const explanationsAdv = {\n        1: \"\u4f7f\u7528 <code>asyncio.gather()<\/code> \u662f\u975e\u540c\u6b65\u7a0b\u5f0f\u8a2d\u8a08\u7684\u6838\u5fc3\u6280\u5de7\uff0c\u53ef\u4ee5\u540c\u6642\u767c\u51fa\u4e09\u500b\u67e5\u8a62\u4e26\u7b49\u5f85\u5b83\u5011\u5168\u90e8\u5b8c\u6210\u3002\u5982\u6587\u7ae0\u6240\u8ff0\uff0c\u9019\u6a23\u7e3d\u7b49\u5f85\u6642\u9593\u53ea\u7b49\u65bc\u6700\u6162\u7684\u67e5\u8a62\uff0c\u800c\u975e\u4e09\u500b\u67e5\u8a62\u6642\u9593\u76f8\u52a0\u3002\u4f9d\u5e8f\u547c\u53eb\u6703\u5931\u53bb\u975e\u540c\u6b65\u7684\u512a\u52e2\uff1bJOIN \u53ef\u80fd\u4e0d\u9069\u7528\u65bc\u7121\u95dc\u806f\u7684\u8868\uff1b\u5efa\u7acb\u591a\u500b\u9023\u7dda\u6703\u589e\u52a0\u8cc7\u6e90\u6d88\u8017\u3002\",\n        2: \"\u6240\u6709 asyncpg \u7684\u64cd\u4f5c\u90fd\u662f\u975e\u540c\u6b65\u7684\uff0c\u5fc5\u9808\u4f7f\u7528 <code>await<\/code> \u95dc\u9375\u5b57\u3002\u5fd8\u8a18\u52a0 <code>await<\/code> \u6703\u5c0e\u81f4\u51fd\u5f0f\u56de\u50b3\u4e00\u500b coroutine \u7269\u4ef6\u800c\u975e\u5be6\u969b\u7684\u67e5\u8a62\u7d50\u679c\uff0c\u9019\u662f\u4f7f\u7528 asyncpg \u6700\u5e38\u898b\u7684\u932f\u8aa4\u4e4b\u4e00\u3002\",\n        3: \"<code>fetchval()<\/code> \u5c08\u9580\u8a2d\u8a08\u7528\u4f86\u76f4\u63a5\u53d6\u5f97\u55ae\u4e00\u503c\uff0c\u4e0d\u9700\u8981\u518d\u5f9e Record \u7269\u4ef6\u4e2d\u63d0\u53d6\u3002\u9078\u9805 A \u7684 <code>len(rows)<\/code> \u6703\u5f97\u5230\u7d50\u679c\u5217\u6578\uff081\uff09\uff0c\u4e0d\u662f COUNT \u503c\uff1b\u9078\u9805 B \u53ef\u884c\u4f46\u591a\u4e86\u4e00\u6b65\uff1b\u9078\u9805 C \u7684 <code>execute()<\/code> \u4e0d\u6703\u56de\u50b3\u8cc7\u6599\u3002\",\n        4: \"asyncpg \u7684 Record \u7269\u4ef6\u4e0d\u652f\u63f4\u7528\u5c6c\u6027\u65b9\u5f0f\uff08<code>row.name<\/code>\uff09\u5b58\u53d6\u6b04\u4f4d\u503c\uff0c\u5fc5\u9808\u4f7f\u7528\u5b57\u5178\u8a9e\u6cd5\uff08<code>row['name']<\/code>\uff09\u6216\u7d22\u5f15\uff08<code>row[0]<\/code>\uff09\u3002\u6587\u7ae0\u7279\u5225\u63d0\u5230\u9019\u662f AI \u751f\u6210\u7a0b\u5f0f\u78bc\u6642\u5e38\u898b\u7684\u932f\u8aa4\u3002\u96d6\u7136\u8f49\u6210\u5b57\u5178\u4e5f\u53ef\u4ee5\u5b58\u53d6\uff0c\u4f46\u4e0d\u662f\u5fc5\u8981\u6b65\u9a5f\u3002\",\n        5: \"INSERT\u3001UPDATE\u3001DELETE \u7b49\u4e0d\u9700\u8981\u56de\u50b3\u8cc7\u6599\u7684\u64cd\u4f5c\u61c9\u4f7f\u7528 <code>execute()<\/code> \u65b9\u6cd5\u3002\u9078\u9805 A \u4f7f\u7528\u4e86\u932f\u8aa4\u7684\u53c3\u6578\u8a9e\u6cd5\uff08%s\uff09\uff0casyncpg \u4f7f\u7528 $n \u8a9e\u6cd5\u3002<code>fetch<\/code> \u548c <code>fetchrow<\/code> \u7528\u65bc\u9700\u8981\u56de\u50b3\u8cc7\u6599\u7684 SELECT \u67e5\u8a62\uff0c<code>fetchval<\/code> \u7528\u65bc\u53d6\u5f97\u55ae\u4e00\u503c\u3002\"\n      };\n\n      function checkAnswerAdv(qNum, selected, correctAns) {\n        const question = document.getElementById(\"qAdv\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answeredAdv++;\n\n        const options = question.querySelectorAll(\".options-adv li\");\n        options.forEach((opt) => {\n          opt.classList.add(\"disabled\");\n          if (opt.textContent.startsWith(correctAns + \".\")) {\n            opt.classList.add(\"show-answer\");\n          }\n        });\n\n        const feedback = document.getElementById(\"fbAdv\" + qNum);\n        if (selected === correctAns) {\n          correctAdv++;\n          feedback.className = \"feedback-adv correct\";\n          feedback.innerHTML = \"\u2713 \u6b63\u78ba\uff01\" + explanationsAdv[qNum];\n        } else {\n          feedback.className = \"feedback-adv wrong\";\n          feedback.innerHTML =\n            \"\u2717 \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanationsAdv[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answeredAdv === totalAdv) {\n          const scoreDiv = document.getElementById(\"scoreAdv\");\n          scoreDiv.style.display = \"block\";\n          let msg = \"\";\n          if (correctAdv === totalAdv) msg = \"\ud83c\udfaf \u5b8c\u7f8e\uff01\u4f60\u5df2\u7d93\u6e96\u5099\u597d\u5be6\u6230\u4e86\uff01\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.8))\n            msg = \"\ud83d\udcaa \u5f88\u68d2\uff01\u518d\u8907\u7fd2\u4e00\u4e0b\u932f\u7684\u984c\u76ee\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.6))\n            msg = \"\ud83d\udcd6 \u5efa\u8b70\u91cd\u8b80\u76f8\u95dc\u6bb5\u843d\u5f8c\u518d\u8a66\u4e00\u6b21\";\n          else msg = \"\ud83d\udd04 \u5efa\u8b70\u91cd\u65b0\u95b1\u8b80\u6587\u4ef6\uff0c\u7279\u5225\u6ce8\u610f\u64cd\u4f5c\u6d41\u7a0b\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" + correctAdv + \" \/ \" + totalAdv + \"<br>\" + msg;\n        }\n      }\n    \n<\/script>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u6e2c\u9a57\uff1a\u8a8d\u8b58 asyncpg &#8211; Python \u975e\u540c\u6b65 PostgreSQL \u7684\u9996\u9078 \u5171 5 \u984c\uff0c\u9ede [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rolpb_likes":0,"footnotes":""},"categories":[316],"tags":[317],"class_list":["post-298","post","type-post","status-publish","format-standard","hentry","category-asyncpg","tag-asyncpg"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":7}},"_links":{"self":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/298","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/comments?post=298"}],"version-history":[{"count":0,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/298\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/media?parent=298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/categories?post=298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/tags?post=298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}