{"id":301,"date":"2026-01-25T02:19:43","date_gmt":"2026-01-24T18:19:43","guid":{"rendered":"https:\/\/skwp.zeabur.app\/2026\/01\/25\/asyncpg-%e9%80%b2%e9%9a%8e%e6%8a%80%e5%b7%a7%e5%bf%ab%e9%80%9f%e7%9c%8b%e6%87%82%ef%bc%9avibe-coder-%e5%bf%85%e7%9f%a5\/"},"modified":"2026-01-25T02:19:43","modified_gmt":"2026-01-24T18:19:43","slug":"asyncpg-%e9%80%b2%e9%9a%8e%e6%8a%80%e5%b7%a7%e5%bf%ab%e9%80%9f%e7%9c%8b%e6%87%82%ef%bc%9avibe-coder-%e5%bf%85%e7%9f%a5","status":"publish","type":"post","link":"https:\/\/blog.itsmygo.uk\/wordpress\/2026\/01\/25\/asyncpg-%e9%80%b2%e9%9a%8e%e6%8a%80%e5%b7%a7%e5%bf%ab%e9%80%9f%e7%9c%8b%e6%87%82%ef%bc%9avibe-coder-%e5%bf%85%e7%9f%a5\/","title":{"rendered":"asyncpg \u9032\u968e\u6280\u5de7\u5feb\u901f\u770b\u61c2\uff1aVibe Coder \u5fc5\u77e5"},"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\uff1aasyncpg \u9032\u968e\u6280\u5de7\u5feb\u901f\u770b\u61c2<\/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. \u5728 asyncpg \u4e2d\uff0c<code>async with conn.transaction()<\/code> \u7684\u4e3b\u8981\u4f5c\u7528\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(1, 'A', 'B')\">A. \u52a0\u901f\u67e5\u8a62\u57f7\u884c\u901f\u5ea6<\/li>\n        <li onclick=\"checkAnswer(1, 'B', 'B')\">B. \u78ba\u4fdd\u5340\u584a\u5167\u7684\u64cd\u4f5c\u5168\u90e8\u6210\u529f\u6216\u5168\u90e8\u5931\u6557<\/li>\n        <li onclick=\"checkAnswer(1, 'C', 'B')\">C. \u81ea\u52d5\u5efa\u7acb\u8cc7\u6599\u5eab\u9023\u7dda\u6c60<\/li>\n        <li onclick=\"checkAnswer(1, 'D', 'B')\">D. \u9810\u5148\u7de8\u8b6f SQL \u8a9e\u53e5<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb1\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q2\">\n      <h3>2. \u7576\u9700\u8981\u532f\u5165\u5927\u91cf\u8cc7\u6599\uff08\u4f8b\u5982 10000 \u7b46\uff09\u5230\u8cc7\u6599\u5eab\u6642\uff0c\u6700\u6709\u6548\u7387\u7684\u505a\u6cd5\u662f\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(2, 'A', 'C')\">A. \u4f7f\u7528\u8ff4\u5708\u4e00\u7b46\u4e00\u7b46\u57f7\u884c INSERT<\/li>\n        <li onclick=\"checkAnswer(2, 'B', 'C')\">B. \u4f7f\u7528 <code>prepare()<\/code> \u9810\u7de8\u8b6f\u5f8c\u518d\u57f7\u884c<\/li>\n        <li onclick=\"checkAnswer(2, 'C', 'C')\">C. \u4f7f\u7528 <code>copy_records_to_table()<\/code><\/li>\n        <li onclick=\"checkAnswer(2, 'D', 'C')\">D. \u4f7f\u7528\u591a\u57f7\u884c\u7dd2\u540c\u6642 INSERT<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb2\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q3\">\n      <h3>3. \u4ee5\u4e0b\u7a0b\u5f0f\u78bc\u4e2d\uff0c<code>prepare()<\/code> \u7684\u4e3b\u8981\u7528\u9014\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <div class=\"code-block\">stmt = await conn.prepare(&#8220;SELECT * FROM users WHERE id = $1&#8221;)\nuser = await stmt.fetchrow(123)<\/div>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(3, 'A', 'B')\">A. \u5c07\u67e5\u8a62\u7d50\u679c\u5feb\u53d6\u5728\u8a18\u61b6\u9ad4\u4e2d<\/li>\n        <li onclick=\"checkAnswer(3, 'B', 'B')\">B. \u9810\u7de8\u8b6f SQL \u8a9e\u53e5\uff0c\u8b93\u4e4b\u5f8c\u53ea\u9700\u50b3\u53c3\u6578\u5373\u53ef\u57f7\u884c<\/li>\n        <li onclick=\"checkAnswer(3, 'C', 'B')\">C. \u5efa\u7acb\u65b0\u7684\u8cc7\u6599\u5eab\u9023\u7dda<\/li>\n        <li onclick=\"checkAnswer(3, 'D', 'B')\">D. \u9a57\u8b49 SQL \u8a9e\u6cd5\u662f\u5426\u6b63\u78ba<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb3\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q4\">\n      <h3>4. \u5728 asyncpg \u4e2d\uff0c<code>InterfaceError<\/code> \u4ee3\u8868\u4ec0\u9ebc\u985e\u578b\u7684\u932f\u8aa4\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(4, 'A', 'C')\">A. SQL \u8a9e\u6cd5\u932f\u8aa4<\/li>\n        <li onclick=\"checkAnswer(4, 'B', 'C')\">B. \u9055\u53cd\u552f\u4e00\u6027\u7d04\u675f\uff08\u4e3b\u9375\u91cd\u8907\uff09<\/li>\n        <li onclick=\"checkAnswer(4, 'C', 'C')\">C. \u9023\u7dda\u5c64\u9762\u7684\u932f\u8aa4\uff08\u9023\u4e0d\u4e0a\u3001\u9023\u7dda\u65b7\u4e86\uff09<\/li>\n        <li onclick=\"checkAnswer(4, 'D', 'C')\">D. \u9055\u53cd\u5916\u9375\u7d04\u675f<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb4\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q5\">\n      <h3>5. \u5728\u91cd\u8a66\u7b56\u7565\u4e2d\u4f7f\u7528\u300c\u6307\u6578\u9000\u907f\u300d\u7684\u76ee\u7684\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <div class=\"code-block\">await asyncio.sleep(2 ** attempt)  # \u7b49\u5f85\u6642\u9593\uff1a1\u79d2\u30012\u79d2\u30014\u79d2&#8230;<\/div>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(5, 'A', 'B')\">A. \u8b93\u7a0b\u5f0f\u57f7\u884c\u66f4\u5feb<\/li>\n        <li onclick=\"checkAnswer(5, 'B', 'B')\">B. \u907f\u514d\u9023\u7e8c\u5feb\u901f\u91cd\u8a66\u800c\u6253\u7206\u8cc7\u6599\u5eab<\/li>\n        <li onclick=\"checkAnswer(5, 'C', 'B')\">C. \u78ba\u4fdd\u6bcf\u6b21\u91cd\u8a66\u90fd\u4f7f\u7528\u4e0d\u540c\u7684\u9023\u7dda<\/li>\n        <li onclick=\"checkAnswer(5, 'D', 'B')\">D. \u8b93\u4f7f\u7528\u8005\u6709\u6642\u9593\u624b\u52d5\u4fee\u5fa9\u554f\u984c<\/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: \"\u4ea4\u6613\uff08transaction\uff09\u63d0\u4f9b\u300c\u5168\u6709\u6216\u5168\u7121\u300d\u7684\u4fdd\u8b49\u3002\u5982\u679c\u5340\u584a\u5167\u4efb\u4f55\u64cd\u4f5c\u5931\u6557\uff0c\u6240\u6709\u64cd\u4f5c\u90fd\u6703\u88ab\u56de\u6efe\uff0c\u78ba\u4fdd\u8cc7\u6599\u4e00\u81f4\u6027\u3002\",\n        2: \"<code>copy_records_to_table()<\/code> \u4f7f\u7528 PostgreSQL \u7684 COPY \u547d\u4ee4\uff0c\u6bd4\u4e00\u7b46\u4e00\u7b46 INSERT \u5feb\u7d04 50-100 \u500d\uff0c\u975e\u5e38\u9069\u5408\u5927\u91cf\u8cc7\u6599\u532f\u5165\u3002\",\n        3: \"<code>prepare()<\/code> \u6703\u9810\u5148\u7de8\u8b6f SQL \u8a9e\u53e5\uff0c\u8cc7\u6599\u5eab\u6703\u5feb\u53d6\u57f7\u884c\u8a08\u756b\u3002\u4e4b\u5f8c\u91cd\u8907\u57f7\u884c\u6642\u53ea\u9700\u50b3\u5165\u53c3\u6578\uff0c\u9069\u5408\u540c\u4e00\u500b\u67e5\u8a62\u8981\u8dd1\u5f88\u591a\u6b21\u7684\u60c5\u6cc1\u3002\",\n        4: \"<code>InterfaceError<\/code> \u662f\u9023\u7dda\u5c64\u9762\u7684\u932f\u8aa4\uff0c\u4f8b\u5982\u9023\u4e0d\u4e0a\u8cc7\u6599\u5eab\u3001\u9023\u7dda\u65b7\u6389\u7b49\u3002\u800c <code>PostgresError<\/code> \u624d\u662f SQL \u6216\u8cc7\u6599\u5eab\u5c64\u9762\u7684\u932f\u8aa4\u3002\",\n        5: \"\u6307\u6578\u9000\u907f\u8b93\u6bcf\u6b21\u91cd\u8a66\u7684\u7b49\u5f85\u6642\u9593\u52a0\u500d\uff081\u79d2\u30012\u79d2\u30014\u79d2...\uff09\uff0c\u907f\u514d\u5728\u8cc7\u6599\u5eab\u6709\u554f\u984c\u6642\u9084\u4e00\u76f4\u5feb\u901f\u91cd\u8a66\uff0c\u7d66\u8cc7\u6599\u5eab\u5598\u606f\u548c\u6062\u5fa9\u7684\u6a5f\u6703\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\">\u4ea4\u6613\u78ba\u4fdd\u64cd\u4f5c\u5168\u505a\u6216\u5168\u4e0d\u505a\uff0c\u6279\u6b21\u532f\u5165\u52a0\u901f\u5927\u91cf\u8cc7\u6599\u8655\u7406\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u70ba\u4ec0\u9ebc Vibe Coder \u8981\u61c2\u9019\u4e9b\uff1f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576 AI \u5e6b\u4f60\u5beb\u8cc7\u6599\u5eab\u64cd\u4f5c\u6642\uff0c\u5b83\u7d93\u5e38\u6703\u7528\u5230\u4ea4\u6613\uff08transaction\uff09\u3001\u6279\u6b21\u64cd\u4f5c\u3001prepared statements \u9019\u4e9b\u9032\u968e\u529f\u80fd\u3002\u4f60\u9700\u8981\u770b\u61c2\u9019\u4e9b\u7a0b\u5f0f\u78bc\u5728\u505a\u4ec0\u9ebc\uff0c\u624d\u80fd\u78ba\u4fdd\u8cc7\u6599\u5b89\u5168\u3001\u6548\u80fd\u826f\u597d\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u4f60\u6703\u9047\u5230\u7684\u60c5\u6cc1<\/th>\n<th>\u9032\u968e\u6280\u5de7\u80fd\u5e6b\u4f60<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u8f49\u5e33\u8981\u540c\u6642\u6263\u6b3e\u548c\u5165\u5e33<\/td>\n<td>\u7528\u4ea4\u6613\u78ba\u4fdd\u5169\u908a\u540c\u6b65<\/td>\n<\/tr>\n<tr>\n<td>\u8981\u532f\u5165\u5e7e\u842c\u7b46\u8cc7\u6599<\/td>\n<td>\u7528 COPY \u547d\u4ee4\u52a0\u901f<\/td>\n<\/tr>\n<tr>\n<td>\u540c\u4e00\u500b\u67e5\u8a62\u8dd1\u5f88\u591a\u6b21<\/td>\n<td>\u7528 prepared statement \u7701\u6548\u80fd<\/td>\n<\/tr>\n<tr>\n<td>\u8cc7\u6599\u5eab\u9023\u7dda\u65b7\u4e86<\/td>\n<td>\u7528\u91cd\u8a66\u7b56\u7565\u81ea\u52d5\u6062\u5fa9<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u4ea4\u6613\u7ba1\u7406\uff1aasync with connection.transaction()<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\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-1\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">async<\/span> <span class=\"hljs-keyword\">with<\/span> conn.transaction():\n    <span class=\"hljs-keyword\">await<\/span> conn.execute(<span class=\"hljs-string\">\"UPDATE accounts SET balance = balance - 100 WHERE id = 1\"<\/span>)\n    <span class=\"hljs-keyword\">await<\/span> conn.execute(<span class=\"hljs-string\">\"UPDATE accounts SET balance = balance + 100 WHERE id = 2\"<\/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\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u9010\u884c\u7ffb\u8b6f<\/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\">async with conn.transaction():           <span class=\"hljs-comment\"># \u958b\u59cb\u4ea4\u6613\uff0c\u5340\u584a\u5167\u7684\u64cd\u4f5c\u6703\u4e00\u8d77\u6210\u529f\u6216\u4e00\u8d77\u5931\u6557<\/span>\n    await conn.execute(<span class=\"hljs-string\">\"UPDATE ...\"<\/span>)     <span class=\"hljs-comment\"># \u7b2c\u4e00\u500b\u64cd\u4f5c\uff1a\u6263\u6b3e<\/span>\n    await conn.execute(<span class=\"hljs-string\">\"UPDATE ...\"<\/span>)     <span class=\"hljs-comment\"># \u7b2c\u4e8c\u500b\u64cd\u4f5c\uff1a\u5165\u5e33<\/span>\n<span class=\"hljs-comment\"># \u96e2\u958b\u5340\u584a\u6642\u81ea\u52d5\u63d0\u4ea4\uff0c\u5982\u679c\u4e2d\u9593\u51fa\u932f\u6703\u81ea\u52d5\u56de\u6efe<\/span>\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<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a\u9019\u5c31\u50cf\u300c\u5168\u6709\u6216\u5168\u7121\u300d\u7684\u4fdd\u8b49\u3002\u5982\u679c\u6263\u6b3e\u6210\u529f\u4f46\u5165\u5e33\u5931\u6557\uff0c\u6263\u6b3e\u4e5f\u6703\u88ab\u53d6\u6d88\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">AI \u5e38\u898b\u5beb\u6cd5<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\u5beb\u6cd5 1\uff1a\u57fa\u672c\u4ea4\u6613<\/h4>\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\">async def transfer_money(conn, from_id, to_id, amount):\n    async with conn.transaction():\n        <span class=\"hljs-comment\"># \u6aa2\u67e5\u9918\u984d<\/span>\n        balance = await conn.fetchval(\n            <span class=\"hljs-string\">\"SELECT balance FROM accounts WHERE id = $1\"<\/span>, from_id\n        )\n        <span class=\"hljs-keyword\">if<\/span> balance &lt; amount:\n            raise ValueError(<span class=\"hljs-string\">\"\u9918\u984d\u4e0d\u8db3\"<\/span>)\n\n        <span class=\"hljs-comment\"># \u57f7\u884c\u8f49\u5e33<\/span>\n        await conn.execute(\n            <span class=\"hljs-string\">\"UPDATE accounts SET balance = balance - $1 WHERE id = $2\"<\/span>,\n            amount, from_id\n        )\n        await conn.execute(\n            <span class=\"hljs-string\">\"UPDATE accounts SET balance = balance + $1 WHERE id = $2\"<\/span>,\n            amount, to_id\n        )\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>\u7ffb\u8b6f<\/strong>\uff1a\u5148\u6aa2\u67e5\u9918\u984d\uff0c\u518d\u57f7\u884c\u8f49\u5e33\u3002\u6574\u500b\u904e\u7a0b\u5728\u4ea4\u6613\u4e2d\uff0c\u4efb\u4f55\u4e00\u6b65\u5931\u6557\u90fd\u6703\u56de\u6efe\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5beb\u6cd5 2\uff1a\u4f7f\u7528 Savepoint\uff08\u90e8\u5206\u56de\u6efe\uff09<\/h4>\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 with conn.transaction():\n    await conn.execute(<span class=\"hljs-string\">\"INSERT INTO orders ...\"<\/span>)  <span class=\"hljs-comment\"># \u4e00\u5b9a\u8981\u6210\u529f<\/span>\n\n    <span class=\"hljs-keyword\">try<\/span>:\n        async with conn.transaction():  <span class=\"hljs-comment\"># \u5de2\u72c0\u4ea4\u6613 = savepoint<\/span>\n            await conn.execute(<span class=\"hljs-string\">\"INSERT INTO notifications ...\"<\/span>)\n    except <span class=\"hljs-keyword\">Exception<\/span>:\n        pass  <span class=\"hljs-comment\"># \u901a\u77e5\u5931\u6557\u6c92\u95dc\u4fc2\uff0c\u8a02\u55ae\u9084\u662f\u6703\u6210\u7acb<\/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\u5de2\u72c0\u7684 <code>async with conn.transaction()<\/code> \u6703\u5efa\u7acb savepoint\u3002\u5167\u5c64\u5931\u6557\u53ea\u6703\u56de\u6efe\u5167\u5c64\uff0c\u5916\u5c64\u7e7c\u7e8c\u57f7\u884c\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5beb\u6cd5 3\uff1a\u660e\u78ba\u63a7\u5236\u63d0\u4ea4<\/h4>\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\">tr = conn.transaction()\nawait tr.start()\n<span class=\"hljs-keyword\">try<\/span>:\n    await conn.execute(<span class=\"hljs-string\">\"INSERT INTO ...\"<\/span>)\n    await tr.commit()  <span class=\"hljs-comment\"># \u660e\u78ba\u63d0\u4ea4<\/span>\nexcept <span class=\"hljs-keyword\">Exception<\/span>:\n    await tr.rollback()  <span class=\"hljs-comment\"># \u660e\u78ba\u56de\u6efe<\/span>\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\u4e0d\u7528 <code>async with<\/code>\uff0c\u624b\u52d5\u63a7\u5236\u4ea4\u6613\u7684\u958b\u59cb\u3001\u63d0\u4ea4\u3001\u56de\u6efe\u3002\u8f03\u5c11\u898b\uff0c\u4f46\u6709\u6642\u9700\u8981\u66f4\u7d30\u7dfb\u7684\u63a7\u5236\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u6279\u6b21\u532f\u5165\uff1acopy_records_to_table()<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\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-6\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">records = &#91;(<span class=\"hljs-number\">1<\/span>, <span class=\"hljs-string\">\"Alice\"<\/span>), (<span class=\"hljs-number\">2<\/span>, <span class=\"hljs-string\">\"Bob\"<\/span>), (<span class=\"hljs-number\">3<\/span>, <span class=\"hljs-string\">\"Charlie\"<\/span>)]\n<span class=\"hljs-keyword\">await<\/span> conn.copy_records_to_table(<span class=\"hljs-string\">\"users\"<\/span>, records=records)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><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><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u9010\u884c\u7ffb\u8b6f<\/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\">records = &#91;(<span class=\"hljs-number\">1<\/span>, <span class=\"hljs-string\">\"Alice\"<\/span>), (<span class=\"hljs-number\">2<\/span>, <span class=\"hljs-string\">\"Bob\"<\/span>), (<span class=\"hljs-number\">3<\/span>, <span class=\"hljs-string\">\"Charlie\"<\/span>)]  <span class=\"hljs-comment\"># \u6e96\u5099\u8cc7\u6599\uff0c\u6bcf\u500b tuple \u662f\u4e00\u5217<\/span>\nawait conn.copy_records_to_table(                      <span class=\"hljs-comment\"># \u4f7f\u7528 PostgreSQL COPY \u547d\u4ee4<\/span>\n    <span class=\"hljs-string\">\"users\"<\/span>,                                           <span class=\"hljs-comment\"># \u76ee\u6a19\u8cc7\u6599\u8868<\/span>\n    records=records                                    <span class=\"hljs-comment\"># \u8981\u532f\u5165\u7684\u8cc7\u6599<\/span>\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\u9019\u6bd4\u4e00\u7b46\u4e00\u7b46 INSERT \u5feb\u975e\u5e38\u591a\uff08\u53ef\u80fd\u5feb 10-100 \u500d\uff09\uff0c\u9069\u5408\u5927\u91cf\u8cc7\u6599\u532f\u5165\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">AI \u5e38\u898b\u5beb\u6cd5<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\u5beb\u6cd5 1\uff1a\u6307\u5b9a\u6b04\u4f4d<\/h4>\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\">await conn.copy_records_to_table(\n    <span class=\"hljs-string\">\"users\"<\/span>,\n    records=records,\n    columns=&#91;<span class=\"hljs-string\">\"id\"<\/span>, <span class=\"hljs-string\">\"name\"<\/span>]  <span class=\"hljs-comment\"># \u660e\u78ba\u6307\u5b9a\u6b04\u4f4d\u9806\u5e8f<\/span>\n)\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<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a\u7576\u8cc7\u6599\u8868\u6709\u5f88\u591a\u6b04\u4f4d\uff0c\u4f46\u4f60\u53ea\u60f3\u532f\u5165\u90e8\u5206\u6b04\u4f4d\u6642\u4f7f\u7528\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5beb\u6cd5 2\uff1a\u642d\u914d\u4ea4\u6613<\/h4>\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=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">async<\/span> <span class=\"hljs-keyword\">with<\/span> conn.transaction():\n    <span class=\"hljs-keyword\">await<\/span> conn.execute(<span class=\"hljs-string\">\"DELETE FROM temp_data\"<\/span>)\n    <span class=\"hljs-keyword\">await<\/span> conn.copy_records_to_table(<span class=\"hljs-string\">\"temp_data\"<\/span>, records=big_data)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><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><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a\u5148\u6e05\u7a7a\u518d\u532f\u5165\uff0c\u6574\u500b\u904e\u7a0b\u5728\u4ea4\u6613\u4e2d\u3002\u5982\u679c\u532f\u5165\u5931\u6557\uff0c\u6e05\u7a7a\u4e5f\u6703\u88ab\u53d6\u6d88\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5beb\u6cd5 3\uff1a\u5f9e\u6a94\u6848\u532f\u5165<\/h4>\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=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">async<\/span> <span class=\"hljs-keyword\">with<\/span> open(<span class=\"hljs-string\">\"data.csv\"<\/span>, <span class=\"hljs-string\">\"rb\"<\/span>) <span class=\"hljs-keyword\">as<\/span> f:\n    <span class=\"hljs-keyword\">await<\/span> conn.copy_to_table(\n        <span class=\"hljs-string\">\"users\"<\/span>,\n        source=f,\n        format=<span class=\"hljs-string\">\"csv\"<\/span>,\n        header=True\n    )\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><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><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a\u76f4\u63a5\u5f9e CSV \u6a94\u6848\u532f\u5165\u8cc7\u6599\u8868\uff0c\u6bd4\u5148\u8b80\u6a94\u518d\u8655\u7406\u66f4\u6709\u6548\u7387\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u9810\u7de8\u8b6f\u67e5\u8a62\uff1aprepare()<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\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-11\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">stmt = <span class=\"hljs-keyword\">await<\/span> conn.prepare(<span class=\"hljs-string\">\"SELECT * FROM users WHERE id = $1\"<\/span>)\nuser = <span class=\"hljs-keyword\">await<\/span> stmt.fetchrow(<span class=\"hljs-number\">123<\/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\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u9010\u884c\u7ffb\u8b6f<\/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\">stmt = await conn.prepare(<span class=\"hljs-string\">\"SELECT * FROM users WHERE id = $1\"<\/span>)  <span class=\"hljs-comment\"># \u9810\u7de8\u8b6f SQL\uff0c\u8cc7\u6599\u5eab\u6703\u5feb\u53d6\u57f7\u884c\u8a08\u756b<\/span>\nuser = await stmt.fetchrow(<span class=\"hljs-number\">123<\/span>)                                   <span class=\"hljs-comment\"># \u7528\u9810\u7de8\u8b6f\u7684\u8a9e\u53e5\u67e5\u8a62\uff0c\u53ea\u9700\u50b3\u53c3\u6578<\/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<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a\u628a SQL \u8a9e\u53e5\u5148\u300c\u7de8\u8b6f\u300d\u597d\u5b58\u8d77\u4f86\uff0c\u4e4b\u5f8c\u53ea\u9700\u8981\u50b3\u53c3\u6578\u3002\u9069\u5408\u540c\u4e00\u500b\u67e5\u8a62\u8981\u8dd1\u5f88\u591a\u6b21\u7684\u60c5\u6cc1\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">AI \u5e38\u898b\u5beb\u6cd5<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\u5beb\u6cd5 1\uff1a\u6279\u6b21\u67e5\u8a62<\/h4>\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\">stmt = await conn.prepare(<span class=\"hljs-string\">\"SELECT * FROM products WHERE id = $1\"<\/span>)\n\n<span class=\"hljs-keyword\">for<\/span> product_id in product_ids:\n    product = await stmt.fetchrow(product_id)\n    <span class=\"hljs-comment\"># \u8655\u7406\u6bcf\u500b\u7522\u54c1<\/span>\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<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a\u540c\u4e00\u500b\u67e5\u8a62\u8dd1 1000 \u6b21\uff0c\u7528 prepared statement \u6bd4\u6bcf\u6b21\u90fd\u5beb\u5b8c\u6574 SQL \u66f4\u5feb\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5beb\u6cd5 2\uff1a\u67e5\u770b\u57f7\u884c\u8a08\u756b<\/h4>\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-14\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">stmt = await conn.prepare(<span class=\"hljs-string\">\"SELECT * FROM users WHERE email = $1\"<\/span>)\n<span class=\"hljs-keyword\">print<\/span>(stmt.get_attributes())  <span class=\"hljs-comment\"># \u67e5\u770b\u56de\u50b3\u6b04\u4f4d\u8cc7\u8a0a<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-14\"><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\u53ef\u4ee5\u5728\u4e0d\u57f7\u884c\u67e5\u8a62\u7684\u60c5\u6cc1\u4e0b\uff0c\u5148\u77e5\u9053\u6703\u56de\u50b3\u54ea\u4e9b\u6b04\u4f4d\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u932f\u8aa4\u8655\u7406<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u5e38\u898b\u932f\u8aa4\u985e\u578b<\/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-15\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">import asyncpg\n\n<span class=\"hljs-keyword\">try<\/span>:\n    await conn.execute(<span class=\"hljs-string\">\"SELECT * FROM nonexistent\"<\/span>)\nexcept asyncpg.PostgresError <span class=\"hljs-keyword\">as<\/span> e:\n    <span class=\"hljs-comment\"># \u6240\u6709 PostgreSQL \u932f\u8aa4\u7684\u57fa\u985e<\/span>\n    <span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"\u8cc7\u6599\u5eab\u932f\u8aa4\uff1a{e}\"<\/span>)\nexcept asyncpg.InterfaceError <span class=\"hljs-keyword\">as<\/span> e:\n    <span class=\"hljs-comment\"># \u9023\u7dda\u76f8\u95dc\u932f\u8aa4\uff08\u9023\u7dda\u65b7\u4e86\u3001Pool \u95dc\u9589\u4e86\u7b49\uff09<\/span>\n    <span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"\u9023\u7dda\u932f\u8aa4\uff1a{e}\"<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-15\"><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\">\u6838\u5fc3\u932f\u8aa4\u7ffb\u8b6f<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u932f\u8aa4\u985e\u578b<\/th>\n<th>\u610f\u601d<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>PostgresError<\/code><\/td>\n<td>\u8cc7\u6599\u5eab\u5c64\u9762\u7684\u932f\u8aa4\uff08SQL \u932f\u8aa4\u3001\u9055\u53cd\u7d04\u675f\u7b49\uff09<\/td>\n<\/tr>\n<tr>\n<td><code>InterfaceError<\/code><\/td>\n<td>\u9023\u7dda\u5c64\u9762\u7684\u932f\u8aa4\uff08\u9023\u4e0d\u4e0a\u3001\u9023\u7dda\u65b7\u4e86\uff09<\/td>\n<\/tr>\n<tr>\n<td><code>UniqueViolationError<\/code><\/td>\n<td>\u9055\u53cd\u552f\u4e00\u6027\u7d04\u675f\uff08\u4e3b\u9375\u6216 unique \u6b04\u4f4d\u91cd\u8907\uff09<\/td>\n<\/tr>\n<tr>\n<td><code>ForeignKeyViolationError<\/code><\/td>\n<td>\u9055\u53cd\u5916\u9375\u7d04\u675f<\/td>\n<\/tr>\n<tr>\n<td><code>ConnectionDoesNotExistError<\/code><\/td>\n<td>\u9023\u7dda\u5df2\u7d93\u95dc\u9589<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">AI \u5e38\u898b\u932f\u8aa4\u8655\u7406\u6a21\u5f0f<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\u6a21\u5f0f 1\uff1a\u6355\u6349\u7279\u5b9a\u932f\u8aa4<\/h4>\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-16\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-keyword\">try<\/span>:\n    await conn.execute(\n        <span class=\"hljs-string\">\"INSERT INTO users (email) VALUES ($1)\"<\/span>, email\n    )\nexcept asyncpg.UniqueViolationError:\n    <span class=\"hljs-keyword\">print<\/span>(<span class=\"hljs-string\">\"\u9019\u500b email \u5df2\u7d93\u88ab\u8a3b\u518a\u4e86\"<\/span>)\nexcept asyncpg.PostgresError <span class=\"hljs-keyword\">as<\/span> e:\n    <span class=\"hljs-keyword\">print<\/span>(f<span class=\"hljs-string\">\"\u5176\u4ed6\u8cc7\u6599\u5eab\u932f\u8aa4\uff1a{e}\"<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-16\"><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\u5148\u6355\u6349\u6700\u5177\u9ad4\u7684\u932f\u8aa4\uff08\u552f\u4e00\u6027\u9055\u53cd\uff09\uff0c\u518d\u7528\u901a\u7528\u985e\u578b\u6355\u6349\u5176\u4ed6\u932f\u8aa4\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u6a21\u5f0f 2\uff1a\u4ea4\u6613\u4e2d\u7684\u932f\u8aa4\u8655\u7406<\/h4>\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-17\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-keyword\">try<\/span>:\n    async with conn.transaction():\n        await conn.execute(<span class=\"hljs-string\">\"INSERT INTO ...\"<\/span>)\n        await conn.execute(<span class=\"hljs-string\">\"UPDATE ...\"<\/span>)\nexcept asyncpg.PostgresError:\n    <span class=\"hljs-comment\"># \u4e0d\u9700\u8981\u624b\u52d5 rollback\uff0casync with \u6703\u81ea\u52d5\u8655\u7406<\/span>\n    <span class=\"hljs-keyword\">print<\/span>(<span class=\"hljs-string\">\"\u4ea4\u6613\u5931\u6557\uff0c\u5df2\u81ea\u52d5\u56de\u6efe\"<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-17\"><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\u5728 <code>async with conn.transaction()<\/code> \u4e2d\u767c\u751f\u932f\u8aa4\uff0c\u6703\u81ea\u52d5\u56de\u6efe\uff0c\u4e0d\u9700\u8981\u624b\u52d5\u8655\u7406\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u9023\u7dda\u4e2d\u65b7\u8207\u91cd\u8a66\u7b56\u7565<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\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-18\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">import asyncio\n\nasync def execute_with_retry(pool, query, *args, max_retries=<span class=\"hljs-number\">3<\/span>):\n    <span class=\"hljs-keyword\">for<\/span> attempt in range(max_retries):\n        <span class=\"hljs-keyword\">try<\/span>:\n            async with pool.acquire() <span class=\"hljs-keyword\">as<\/span> conn:\n                <span class=\"hljs-keyword\">return<\/span> await conn.execute(query, *args)\n        except asyncpg.InterfaceError:\n            <span class=\"hljs-keyword\">if<\/span> attempt == max_retries - <span class=\"hljs-number\">1<\/span>:\n                raise\n            await asyncio.sleep(<span class=\"hljs-number\">2<\/span> ** attempt)  <span class=\"hljs-comment\"># \u6307\u6578\u9000\u907f\uff1a1\u79d2\u30012\u79d2\u30014\u79d2<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-18\"><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\">\u9010\u884c\u7ffb\u8b6f<\/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-19\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">async def execute_with_retry(pool, query, *args, max_retries=<span class=\"hljs-number\">3<\/span>):\n    <span class=\"hljs-keyword\">for<\/span> attempt in range(max_retries):           <span class=\"hljs-comment\"># \u6700\u591a\u91cd\u8a66 3 \u6b21<\/span>\n        <span class=\"hljs-keyword\">try<\/span>:\n            async with pool.acquire() <span class=\"hljs-keyword\">as<\/span> conn:   <span class=\"hljs-comment\"># \u5f9e\u9023\u7dda\u6c60\u53d6\u5f97\u9023\u7dda<\/span>\n                <span class=\"hljs-keyword\">return<\/span> await conn.execute(query, *args)  <span class=\"hljs-comment\"># \u57f7\u884c\u67e5\u8a62<\/span>\n        except asyncpg.InterfaceError:           <span class=\"hljs-comment\"># \u9023\u7dda\u932f\u8aa4\uff08\u65b7\u7dda\u7b49\uff09<\/span>\n            <span class=\"hljs-keyword\">if<\/span> attempt == max_retries - <span class=\"hljs-number\">1<\/span>:       <span class=\"hljs-comment\"># \u6700\u5f8c\u4e00\u6b21\u5617\u8a66<\/span>\n                raise                            <span class=\"hljs-comment\"># \u9084\u662f\u5931\u6557\u5c31\u62cb\u51fa\u932f\u8aa4<\/span>\n            await asyncio.sleep(<span class=\"hljs-number\">2<\/span> ** attempt)    <span class=\"hljs-comment\"># \u7b49\u4e00\u4e0b\u518d\u91cd\u8a66<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-19\"><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\u9023\u7dda\u65b7\u4e86\u5c31\u91cd\u8a66\uff0c\u6bcf\u6b21\u7b49\u5f85\u6642\u9593\u52a0\u500d\uff081\u79d2\u30012\u79d2\u30014\u79d2\uff09\uff0c\u907f\u514d\u4e00\u76f4\u6253\u8cc7\u6599\u5eab\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">AI \u5e38\u898b\u91cd\u8a66\u6a21\u5f0f<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\u6a21\u5f0f 1\uff1a\u4f7f\u7528\u88dd\u98fe\u5668<\/h4>\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-20\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">from<\/span> functools <span class=\"hljs-keyword\">import<\/span> wraps\n\ndef with_retry(max_retries=<span class=\"hljs-number\">3<\/span>):\n    def decorator(func):\n        @wraps(func)\n        <span class=\"hljs-keyword\">async<\/span> def wrapper(*args, **kwargs):\n            <span class=\"hljs-keyword\">for<\/span> attempt <span class=\"hljs-keyword\">in<\/span> range(max_retries):\n                <span class=\"hljs-keyword\">try<\/span>:\n                    <span class=\"hljs-keyword\">return<\/span> <span class=\"hljs-keyword\">await<\/span> func(*args, **kwargs)\n                except asyncpg.InterfaceError:\n                    <span class=\"hljs-keyword\">if<\/span> attempt == max_retries - <span class=\"hljs-number\">1<\/span>:\n                        raise\n                    <span class=\"hljs-keyword\">await<\/span> asyncio.sleep(<span class=\"hljs-number\">2<\/span> ** attempt)\n        <span class=\"hljs-keyword\">return<\/span> wrapper\n    <span class=\"hljs-keyword\">return<\/span> decorator\n\n@with_retry(max_retries=<span class=\"hljs-number\">3<\/span>)\n<span class=\"hljs-keyword\">async<\/span> def get_user(pool, user_id):\n    <span class=\"hljs-keyword\">async<\/span> <span class=\"hljs-keyword\">with<\/span> pool.acquire() <span class=\"hljs-keyword\">as<\/span> conn:\n        <span class=\"hljs-keyword\">return<\/span> <span class=\"hljs-keyword\">await<\/span> conn.fetchrow(<span class=\"hljs-string\">\"SELECT * FROM users WHERE id = $1\"<\/span>, user_id)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-20\"><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><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a\u628a\u91cd\u8a66\u908f\u8f2f\u5305\u6210\u88dd\u98fe\u5668\uff0c\u4efb\u4f55\u51fd\u5f0f\u52a0\u4e0a <code>@with_retry()<\/code> \u5c31\u6709\u81ea\u52d5\u91cd\u8a66\u529f\u80fd\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u6a21\u5f0f 2\uff1a\u9023\u7dda\u6c60\u5065\u5eb7\u6aa2\u67e5<\/h4>\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-21\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">pool = await asyncpg.create_pool(\n    dsn,\n    min_size=<span class=\"hljs-number\">5<\/span>,\n    max_size=<span class=\"hljs-number\">20<\/span>,\n    command_timeout=<span class=\"hljs-number\">60<\/span>,           <span class=\"hljs-comment\"># \u55ae\u4e00\u6307\u4ee4\u8d85\u6642 60 \u79d2<\/span>\n    max_inactive_connection_lifetime=<span class=\"hljs-number\">300<\/span>  <span class=\"hljs-comment\"># \u9592\u7f6e\u9023\u7dda 5 \u5206\u9418\u5f8c\u95dc\u9589<\/span>\n)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-21\"><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\u8a2d\u5b9a\u9023\u7dda\u6c60\u53c3\u6578\uff0c\u81ea\u52d5\u7ba1\u7406\u9023\u7dda\u5065\u5eb7\u72c0\u614b\uff0c\u6e1b\u5c11\u9023\u7dda\u554f\u984c\u3002<\/p>\n\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\u9019\u4e9b\u9032\u968e\u529f\u80fd\u6642\u78ba\u8a8d\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>[ ] \u7528\u4e86 <code>transaction()<\/code> \u55ce\uff1f\u9700\u8981\u300c\u5168\u6709\u6216\u5168\u7121\u300d\u7684\u64cd\u4f5c\u61c9\u8a72\u7528\u4ea4\u6613\u5305\u8d77\u4f86<\/li>\n<li>[ ] \u5927\u91cf\u8cc7\u6599\u7528 <code>copy<em>records<\/em>to_table()<\/code> \u9084\u662f\u4e00\u7b46\u4e00\u7b46 INSERT\uff1f\u524d\u8005\u5feb\u5f88\u591a<\/li>\n<li>[ ] \u540c\u4e00\u500b\u67e5\u8a62\u8dd1\u5f88\u591a\u6b21\u6709\u7528 <code>prepare()<\/code> \u55ce\uff1f<\/li>\n<li>[ ] \u6709\u8655\u7406 <code>InterfaceError<\/code> \u9023\u7dda\u932f\u8aa4\u55ce\uff1f<\/li>\n<li>[ ] \u6709\u91cd\u8a66\u6a5f\u5236\u55ce\uff1f\u7528\u4e86\u6307\u6578\u9000\u907f\u907f\u514d\u6253\u7206\u8cc7\u6599\u5eab\u55ce\uff1f<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u5fc5\u770b\u61c2<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u4e9b\u9032\u968e\u529f\u80fd\u6703\u4e00\u76f4\u51fa\u73fe\uff0c\u8981\u719f\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u529f\u80fd<\/th>\n<th>\u8a18\u6cd5<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>async with conn.transaction()<\/code><\/td>\n<td>\u300c\u4ea4\u6613\uff0c\u5168\u505a\u6216\u5168\u4e0d\u505a\u300d<\/td>\n<\/tr>\n<tr>\n<td><code>copy_records_to_table()<\/code><\/td>\n<td>\u300c\u6279\u6b21\u532f\u5165\uff0c\u5f88\u5feb\u300d<\/td>\n<\/tr>\n<tr>\n<td><code>await conn.prepare()<\/code><\/td>\n<td>\u300c\u9810\u7de8\u8b6f\uff0c\u91cd\u8907\u67e5\u8a62\u7528\u9019\u500b\u300d<\/td>\n<\/tr>\n<tr>\n<td><code>asyncpg.InterfaceError<\/code><\/td>\n<td>\u300c\u9023\u7dda\u58de\u4e86\u300d<\/td>\n<\/tr>\n<tr>\n<td><code>asyncpg.PostgresError<\/code><\/td>\n<td>\u300cSQL \u6216\u8cc7\u6599\u5eab\u932f\u8aa4\u300d<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u77e5\u9053\u5c31\u597d<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u4e9b\u9032\u968e\u529f\u80fd\u9047\u5230\u518d\u67e5\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Cursor<\/strong>\uff1a\u8655\u7406\u8d85\u5927\u7d50\u679c\u96c6\uff0c\u4e00\u6b21\u8b80\u4e00\u90e8\u5206<\/li>\n<li><strong>LISTEN\/NOTIFY<\/strong>\uff1a\u8cc7\u6599\u5eab\u4e8b\u4ef6\u901a\u77e5\uff0c\u5373\u6642\u63a8\u9001<\/li>\n<li><strong>copy<em>from<\/em>query()<\/strong>\uff1a\u628a\u67e5\u8a62\u7d50\u679c\u532f\u51fa\u5230\u6a94\u6848<\/li>\n<li><strong>Connection.add<em>log<\/em>listener()<\/strong>\uff1a\u76e3\u807d\u8cc7\u6599\u5eab\u65e5\u8a8c<\/li>\n<li><strong>Pool.set<em>connect<\/em>args()<\/strong>\uff1a\u52d5\u614b\u66f4\u65b0\u9023\u7dda\u53c3\u6578<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u6548\u80fd\u5c0d\u7167<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u8b93\u4f60\u77e5\u9053\u9019\u4e9b\u6280\u5de7\u6709\u591a\u91cd\u8981\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u64cd\u4f5c<\/th>\n<th>\u4e00\u822c\u505a\u6cd5<\/th>\n<th>\u9032\u968e\u505a\u6cd5<\/th>\n<th>\u901f\u5ea6\u5dee\u7570<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u63d2\u5165 10000 \u7b46<\/td>\n<td>\u4e00\u7b46\u4e00\u7b46 INSERT<\/td>\n<td>copy_records_to_table<\/td>\n<td>\u7d04\u5feb 50-100 \u500d<\/td>\n<\/tr>\n<tr>\n<td>\u540c\u67e5\u8a62\u8dd1 1000 \u6b21<\/td>\n<td>\u6bcf\u6b21\u5b8c\u6574 SQL<\/td>\n<td>prepare()<\/td>\n<td>\u7d04\u5feb 20-30%<\/td>\n<\/tr>\n<tr>\n<td>\u8f49\u5e33\u64cd\u4f5c<\/td>\n<td>\u5169\u500b\u7368\u7acb UPDATE<\/td>\n<td>transaction()<\/td>\n<td>\u4fdd\u8b49\u8cc7\u6599\u4e00\u81f4\u6027<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u5c0f\u7d50<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">asyncpg \u9032\u968e\u6280\u5de7\u5c0d Vibe Coder \u4f86\u8aaa\u5c31\u662f\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u4ea4\u6613<\/strong>\uff1a\u7528 <code>async with conn.transaction()<\/code> \u78ba\u4fdd\u591a\u500b\u64cd\u4f5c\u4e00\u8d77\u6210\u529f\u6216\u5931\u6557<\/li>\n<li><strong>\u6279\u6b21\u532f\u5165<\/strong>\uff1a\u7528 <code>copy<em>records<\/em>to_table()<\/code> \u5feb\u901f\u532f\u5165\u5927\u91cf\u8cc7\u6599<\/li>\n<li><strong>\u9810\u7de8\u8b6f<\/strong>\uff1a\u7528 <code>prepare()<\/code> \u52a0\u901f\u91cd\u8907\u57f7\u884c\u7684\u67e5\u8a62<\/li>\n<li><strong>\u932f\u8aa4\u8655\u7406<\/strong>\uff1a\u5206\u6e05 <code>PostgresError<\/code>\uff08SQL \u932f\u8aa4\uff09\u548c <code>InterfaceError<\/code>\uff08\u9023\u7dda\u932f\u8aa4\uff09<\/li>\n<li><strong>\u91cd\u8a66\u7b56\u7565<\/strong>\uff1a\u9023\u7dda\u65b7\u4e86\u8981\u91cd\u8a66\uff0c\u7528\u6307\u6578\u9000\u907f\u907f\u514d\u6253\u7206\u8cc7\u6599\u5eab<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u8a18\u4f4f\u9019\u4e94\u500b\u91cd\u9ede\uff0c\u770b\u5230 AI \u5beb\u7684\u9032\u968e\u8cc7\u6599\u5eab\u64cd\u4f5c\u5c31\u4e0d\u6703\u614c\u4e86\uff01<\/p>\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\uff1aasyncpg \u9032\u968e\u6280\u5de7\u5feb\u901f\u770b\u61c2<\/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\u9280\u884c\u8f49\u5e33\u529f\u80fd\uff0c\u9700\u8981\u5f9e\u5e33\u6236 A \u6263\u6b3e\u4e26\u5b58\u5165\u5e33\u6236 B\u3002AI \u5e6b\u4f60\u7522\u751f\u4e86\u4ee5\u4e0b\u7a0b\u5f0f\u78bc\uff0c\u4f60\u61c9\u8a72\u5982\u4f55\u6539\u9032\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">async def transfer(conn, from_id, to_id, amount):\n    await conn.execute(\n        &#8220;UPDATE accounts SET balance = balance &#8211; $1 WHERE id = $2&#8221;,\n        amount, from_id\n    )\n    await conn.execute(\n        &#8220;UPDATE accounts SET balance = balance + $1 WHERE id = $2&#8221;,\n        amount, to_id\n    )<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(1, 'A', 'B')\">A. \u52a0\u4e0a <code>try\/except<\/code> \u6355\u6349\u932f\u8aa4\u5373\u53ef<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'B', 'B')\">B. \u7528 <code>async with conn.transaction()<\/code> \u5305\u4f4f\u5169\u500b\u64cd\u4f5c<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'C', 'B')\">C. \u7528 <code>prepare()<\/code> \u9810\u7de8\u8b6f SQL \u8a9e\u53e5<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'D', 'B')\">D. \u6539\u7528 <code>copy_records_to_table()<\/code> \u6279\u6b21\u8655\u7406<\/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\u4e00\u500b\u7a0b\u5f0f\u8981\u532f\u5165 50000 \u7b46\u4f7f\u7528\u8005\u8cc7\u6599\uff0c\u57f7\u884c\u5f8c\u975e\u5e38\u6162\u3002\u4ee5\u4e0b\u662f\u4ed6\u7684\u7a0b\u5f0f\u78bc\uff0c\u554f\u984c\u51fa\u5728\u54ea\u88e1\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">async def import_users(conn, users):\n    for user in users:  # users \u6709 50000 \u7b46\n        await conn.execute(\n            &#8220;INSERT INTO users (name, email) VALUES ($1, $2)&#8221;,\n            user[&#8216;name&#8217;], user[&#8217;email&#8217;]\n        )<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(2, 'A', 'C')\">A. \u7f3a\u5c11 <code>async with conn.transaction()<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(2, 'B', 'C')\">B. SQL \u8a9e\u6cd5\u932f\u8aa4\u5c0e\u81f4\u6548\u80fd\u554f\u984c<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'C', 'C')\">C. \u61c9\u8a72\u4f7f\u7528 <code>copy_records_to_table()<\/code> \u6279\u6b21\u532f\u5165<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'D', 'C')\">D. \u9700\u8981\u5148\u7528 <code>prepare()<\/code> \u9810\u7de8\u8b6f<\/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\u5728\u958b\u767c\u8a02\u55ae\u7cfb\u7d71\uff0c\u5efa\u7acb\u8a02\u55ae\u6642\u4e5f\u8981\u767c\u9001\u901a\u77e5\u3002\u4f46\u901a\u77e5\u5931\u6557\u4e0d\u61c9\u8a72\u5f71\u97ff\u8a02\u55ae\u7684\u5efa\u7acb\u3002\u4ee5\u4e0b\u54ea\u7a2e\u5beb\u6cd5\u6700\u9069\u5408\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(3, 'A', 'D')\">A. \u4e0d\u4f7f\u7528\u4ea4\u6613\uff0c\u8b93\u5169\u500b\u64cd\u4f5c\u7368\u7acb\u57f7\u884c<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'B', 'D')\">B. \u628a\u901a\u77e5\u64cd\u4f5c\u653e\u5728 <code>try\/except<\/code> \u4e2d\u4f46\u4e0d\u5728\u4ea4\u6613\u5167<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'C', 'D')\">C. \u7528\u4e00\u500b\u4ea4\u6613\u5305\u4f4f\u6240\u6709\u64cd\u4f5c\uff0c\u5931\u6557\u5c31\u5168\u90e8\u56de\u6efe<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'D', 'D')\">D. \u4f7f\u7528\u5de2\u72c0\u4ea4\u6613\uff08Savepoint\uff09\uff0c\u901a\u77e5\u5931\u6557\u53ea\u56de\u6efe\u5167\u5c64<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv3\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv4\">\n      <h3>4. \u7a0b\u5f0f\u57f7\u884c\u6642\u51fa\u73fe\u4ee5\u4e0b\u932f\u8aa4\uff0c\u6700\u53ef\u80fd\u7684\u539f\u56e0\u548c\u89e3\u6c7a\u65b9\u6cd5\u662f\u4ec0\u9ebc\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">asyncpg.exceptions.UniqueViolationError: duplicate key value violates unique constraint &#8220;users_email_key&#8221;<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(4, 'A', 'B')\">A. \u8cc7\u6599\u5eab\u9023\u7dda\u65b7\u958b\uff0c\u9700\u8981\u91cd\u65b0\u9023\u7dda<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'B', 'B')\">B. \u5617\u8a66\u63d2\u5165\u7684 email \u5df2\u7d93\u5b58\u5728\uff0c\u9700\u8981\u5148\u6aa2\u67e5\u6216\u4f7f\u7528 ON CONFLICT<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'C', 'B')\">C. SQL \u8a9e\u6cd5\u932f\u8aa4\uff0c\u9700\u8981\u4fee\u6b63\u67e5\u8a62\u8a9e\u53e5<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'D', 'B')\">D. \u5916\u9375\u7d04\u675f\u5931\u6557\uff0c\u9700\u8981\u5148\u63d2\u5165\u95dc\u806f\u8cc7\u6599<\/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\u7684\u61c9\u7528\u7a0b\u5f0f\u5728\u8cc7\u6599\u5eab\u91cd\u555f\u5f8c\u983b\u7e41\u51fa\u73fe <code>InterfaceError<\/code>\uff0c\u4e14\u9023\u7dda\u5931\u6557\u5f8c\u4e0d\u6703\u81ea\u52d5\u6062\u5fa9\u3002\u4f60\u61c9\u8a72\u5982\u4f55\u6539\u9032\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">async def get_user(pool, user_id):\n    async with pool.acquire() as conn:\n        return await conn.fetchrow(&#8220;SELECT * FROM users WHERE id = $1&#8221;, user_id)<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(5, 'A', 'C')\">A. \u6539\u7528 <code>prepare()<\/code> \u9810\u7de8\u8b6f\u67e5\u8a62<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'B', 'C')\">B. \u5728\u5916\u5c64\u52a0\u4e0a <code>async with conn.transaction()<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(5, 'C', 'C')\">C. \u52a0\u5165\u91cd\u8a66\u6a5f\u5236\uff0c\u6355\u6349 <code>InterfaceError<\/code> \u4e26\u4f7f\u7528\u6307\u6578\u9000\u907f<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'D', 'C')\">D. \u4f7f\u7528 <code>copy_records_to_table()<\/code> \u6539\u5584\u6548\u80fd<\/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: \"\u8f49\u5e33\u64cd\u4f5c\u9700\u8981\u300c\u5168\u6709\u6216\u5168\u7121\u300d\u7684\u4fdd\u8b49\u3002\u5982\u679c\u6263\u6b3e\u6210\u529f\u4f46\u5165\u5e33\u5931\u6557\uff0c\u6c92\u6709\u4ea4\u6613\u4fdd\u8b77\u7684\u8a71\u9322\u5c31\u6703\u6191\u7a7a\u6d88\u5931\u3002\u4f7f\u7528 <code>async with conn.transaction()<\/code> \u53ef\u4ee5\u78ba\u4fdd\u5169\u500b\u64cd\u4f5c\u8981\u561b\u90fd\u6210\u529f\uff0c\u8981\u561b\u90fd\u5931\u6557\u56de\u6efe\u3002\",\n        2: \"\u4e00\u7b46\u4e00\u7b46 INSERT 50000 \u7b46\u8cc7\u6599\u6703\u57f7\u884c 50000 \u6b21\u7db2\u8def\u5f80\u8fd4\u548c\u8cc7\u6599\u5eab\u64cd\u4f5c\uff0c\u975e\u5e38\u6162\u3002\u4f7f\u7528 <code>copy_records_to_table()<\/code> \u53ef\u4ee5\u5229\u7528 PostgreSQL \u7684 COPY \u547d\u4ee4\u6279\u6b21\u532f\u5165\uff0c\u901f\u5ea6\u5feb\u7d04 50-100 \u500d\u3002\u96d6\u7136\u52a0\u4e0a <code>prepare()<\/code> \u6216\u4ea4\u6613\u4e5f\u6709\u5e6b\u52a9\uff0c\u4f46\u6548\u80fd\u63d0\u5347\u9060\u4e0d\u5982 COPY \u547d\u4ee4\u3002\",\n        3: \"\u4f7f\u7528\u5de2\u72c0\u4ea4\u6613\uff08Savepoint\uff09\u662f\u6700\u4f73\u89e3\u3002\u5916\u5c64\u4ea4\u6613\u78ba\u4fdd\u8a02\u55ae\u4e00\u5b9a\u6703\u88ab\u5efa\u7acb\uff0c\u5167\u5c64\u4ea4\u6613\uff08\u5de2\u72c0\u7684 <code>async with conn.transaction()<\/code>\uff09\u8ca0\u8cac\u901a\u77e5\u3002\u5982\u679c\u5167\u5c64\u5931\u6557\uff0c\u53ea\u6703\u56de\u6efe\u5167\u5c64\u7684 savepoint\uff0c\u5916\u5c64\u7684\u8a02\u55ae\u64cd\u4f5c\u4e0d\u53d7\u5f71\u97ff\u3002\",\n        4: \"<code>UniqueViolationError<\/code> \u8868\u793a\u9055\u53cd\u4e86\u552f\u4e00\u6027\u7d04\u675f\uff0c\u9019\u88e1\u662f email \u6b04\u4f4d\u6709 unique \u9650\u5236\u3002\u932f\u8aa4\u8a0a\u606f\u660e\u78ba\u6307\u51fa\u662f <code>users_email_key<\/code> \u7d04\u675f\u88ab\u9055\u53cd\uff0c\u4ee3\u8868\u4f60\u5617\u8a66\u63d2\u5165\u7684 email \u5df2\u7d93\u5b58\u5728\u65bc\u8cc7\u6599\u5eab\u4e2d\u3002\u9019\u4e0d\u662f\u9023\u7dda\u554f\u984c\uff08\u90a3\u662f InterfaceError\uff09\u4e5f\u4e0d\u662f\u5916\u9375\u554f\u984c\uff08\u90a3\u662f ForeignKeyViolationError\uff09\u3002\",\n        5: \"<code>InterfaceError<\/code> \u662f\u9023\u7dda\u5c64\u9762\u7684\u932f\u8aa4\uff0c\u7576\u8cc7\u6599\u5eab\u91cd\u555f\u6216\u7db2\u8def\u4e0d\u7a69\u6642\u6703\u767c\u751f\u3002\u6b63\u78ba\u7684\u8655\u7406\u65b9\u5f0f\u662f\u52a0\u5165\u91cd\u8a66\u6a5f\u5236\uff1a\u6355\u6349 <code>InterfaceError<\/code>\uff0c\u7b49\u5f85\u4e00\u6bb5\u6642\u9593\u5f8c\u91cd\u8a66\uff0c\u4e26\u4f7f\u7528\u6307\u6578\u9000\u907f\uff08\u6bcf\u6b21\u7b49\u5f85\u6642\u9593\u52a0\u500d\uff09\u907f\u514d\u6301\u7e8c\u6253\u7206\u6b63\u5728\u6062\u5fa9\u7684\u8cc7\u6599\u5eab\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\uff1aasyncpg \u9032\u968e\u6280\u5de7\u5feb\u901f\u770b\u61c2 \u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c 1. \u5728 asyncpg \u4e2d\uff0ca [&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-301","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\/301","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=301"}],"version-history":[{"count":0,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/301\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/media?parent=301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/categories?post=301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/tags?post=301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}