{"id":5783,"date":"2022-04-03T09:59:40","date_gmt":"2022-04-03T01:59:40","guid":{"rendered":"https:\/\/egonlin.com\/?p=5783"},"modified":"2022-04-10T16:52:06","modified_gmt":"2022-04-10T08:52:06","slug":"05-02-django%e4%b9%8b%e6%a8%a1%e5%9e%8b%e5%b1%82%e7%ac%ac%e4%ba%8c%e7%af%87%ef%bc%9a%e5%a4%9a%e8%a1%a8%e6%93%8d%e4%bd%9c","status":"publish","type":"post","link":"https:\/\/egonlin.com\/?p=5783","title":{"rendered":"05-02 \u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c"},"content":{"rendered":"<h1>Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c<\/h1>\n<h1>\u4e00 \u8868\u5173\u7cfb\u56de\u987e<\/h1>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-1.png'><img class=\"lazyload lazyload-style-2\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  data-original=\"https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-1.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<p>\u200b    \u5728\u8bb2\u89e3MySQL\u65f6\uff0c\u6211\u4eec\u63d0\u5230\uff0c\u628a\u5e94\u7528\u7a0b\u5e8f\u7684\u6240\u6709\u6570\u636e\u90fd\u653e\u5728\u4e00\u5f20\u8868\u91cc\u662f\u6781\u4e0d\u5408\u7406\u7684\u3002<\/p>\n<p>\u200b    \u6bd4\u5982\u6211\u4eec\u5f00\u53d1\u4e00\u4e2a\u5458\u5de5\u7ba1\u7406\u7cfb\u7edf\uff0c\u5728\u6570\u636e\u5e93\u91cc\u53ea\u521b\u5efa\u4e00\u5f20\u5458\u5de5\u4fe1\u606f\u8868\uff0c\u8be5\u8868\u6709\u56db\u4e2a\u5b57\u6bb5\uff1a\u5de5\u53f7\u3001\u59d3\u540d\u3001\u90e8\u95e8\u540d\u3001\u90e8\u95e8\u804c\u80fd\u63cf\u8ff0\uff0c\u6b64\u65f6\u82e5\u516c\u53f8\u67091\u4e07\u540d\u5458\u5de5\uff0c\u4f46\u53ea\u67093\u4e2a\u90e8\u95e8\uff0c\u56e0\u4e3a\u6bcf\u4e00\u540d\u5458\u5de5\u540e\u90fd\u9700\u8981\u8ddf\u7740\u90e8\u95e8\u4fe1\u606f\uff08\u90e8\u95e8\u540d\u3001\u90e8\u95e8\u804c\u80fd\uff09\uff0c\u6240\u4ee5\u5c06\u4f1a\u5bfc\u81f4\u90e8\u95e8\u4fe1\u606f\u51fa\u73b0\u5927\u91cf\u91cd\u590d\u3001\u6d6a\u8d39\u7a7a\u95f4\u3002<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-2.gif'><img class=\"lazyload lazyload-style-2\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  data-original=\"https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-2.gif\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<p>\u200b    \u89e3\u51b3\u65b9\u6cd5\u5c31\u662f\u5c06\u6570\u636e\u5b58\u653e\u4e8e\u4e0d\u540c\u7684\u8868\u4e2d\uff0c\u7136\u540e\u57fa\u4e8eforeign key\u5efa\u7acb\u8868\u4e4b\u95f4\u7684\u5173\u8054\u5173\u7cfb\u3002<\/p>\n<p>\u200b    \u7ec6\u8bf4\u7684\u8bdd\uff0c\u8868\u4e4b\u95f4\u5b58\u5728\u4e09\u79cd\u5173\u7cfb\uff1a\u591a\u5bf9\u4e00\u3001\u4e00\u5bf9\u4e00\u3001\u591a\u5bf9\u591a\uff0c\u90a3\u5982\u4f55\u786e\u5b9a\u4e24\u5f20\u8868\u4e4b\u95f4\u7684\u5173\u7cfb\u5462\uff1f\u6309\u7167\u4e0b\u8ff0\u6b65\u9aa4\u64cd\u4f5c\u5373\u53ef<\/p>\n<pre><code class=\"language-python\">\u5de6\u8868&lt;-------------------------------&gt;\u53f3\u8868\n\n# \u6b65\u9aa4\u4e00\uff1a\u5148\u5206\u6790\n#\u5206\u67901\u3001\u5148\u7ad9\u5728\u5de6\u8868\u7684\u89d2\u5ea6\n\u662f\u5426\u5de6\u8868\u7684\u591a\u6761\u8bb0\u5f55\u53ef\u4ee5\u5bf9\u5e94\u53f3\u8868\u7684\u4e00\u6761\u8bb0\u5f55\n\n#\u5206\u67902\u3001\u518d\u7ad9\u5728\u53f3\u8868\u7684\u89d2\u5ea6\u53bb\u627e\n\u662f\u5426\u53f3\u8868\u7684\u591a\u6761\u8bb0\u5f55\u53ef\u4ee5\u5bf9\u5e94\u5de6\u8868\u7684\u4e00\u6761\u8bb0\u5f55\n\n# \u6b65\u9aa4\u4e8c\uff1a\u540e\u786e\u5b9a\u5173\u7cfb\n# \u591a\u5bf9\u4e00\n\u5982\u679c\u53ea\u6709&quot;\u5206\u67901&quot;\u6210\u7acb\uff0c\u90a3\u4e48\u53ef\u4ee5\u786e\u5b9a\u4e24\u5f20\u8868\u7684\u5173\u7cfb\u662f\uff1a\u5de6\u8868\u591a\u5bf9\u4e00\u53f3\u8868\uff0c\u5173\u8054\u5b57\u6bb5\u5e94\u8be5\u521b\u5efa\u5728\u5de6\u8868\u4e2d\uff0c\u7136\u540eforeign key \u53f3\u8868\u4e00\u4e2a\u5b57\u6bb5\uff08\u901a\u5e38\u662fid\uff09\n\u5982\u679c\u53ea\u6709&quot;\u5206\u67902&quot;\u6210\u7acb\uff0c\u90a3\u4e48\u53ef\u4ee5\u786e\u5b9a\u4e24\u5f20\u8868\u7684\u5173\u7cfb\u662f\uff1a\u53f3\u8868\u591a\u5bf9\u4e00\u5de6\u8868\uff0c\u5173\u8054\u5b57\u6bb5\u5e94\u8be5\u521b\u5efa\u5728\u53f3\u8868\u4e2d\uff0c\u7136\u540eforeign key \u5de6\u8868\u4e00\u4e2a\u5b57\u6bb5\uff08\u901a\u5e38\u662fid\uff09\n\n# \u4e00\u5bf9\u4e00\n\u5982\u679c&quot;\u5206\u67901&quot;\u548c&quot;\u5206\u67902&quot;\u90fd\u4e0d\u6210\u7acb\uff0c\u800c\u662f\u5de6\u8868\u7684\u4e00\u6761\u8bb0\u5f55\u552f\u4e00\u5bf9\u5e94\u53f3\u8868\u7684\u4e00\u6761\u8bb0\u5f55\uff0c\u53cd\u4e4b\u4ea6\u7136\u3002\u8fd9\u79cd\u60c5\u51b5\u5f88\u7b80\u5355\uff0c\u5c31\u662f\u5728\u5de6\u8868foreign key\u53f3\u8868\u7684\u57fa\u7840\u4e0a\uff0c\u5c06\u5de6\u8868\u7684\u5173\u8054\u5b57\u6bb5\u8bbe\u7f6e\u6210unique\u5373\u53ef\n\n# \u591a\u5bf9\u591a\n\u5982\u679c&quot;\u5206\u67901&quot;\u548c&quot;\u5206\u67902&quot;\u540c\u65f6\u6210\u7acb\uff0c\u5219\u8bc1\u660e\u8fd9\u4e24\u5f20\u8868\u662f\u4e00\u4e2a\u53cc\u5411\u7684\u591a\u5bf9\u4e00\uff0c\u5373\u591a\u5bf9\u591a,\u9700\u8981\u521b\u5efa\u4e00\u5f20\u5355\u72ec\u7684\u65b0\u8868\u6765\u4e13\u95e8\u5b58\u653e\u4e8c\u8005\u7684\u5173\u7cfb\uff0c\u5173\u8054\u5b57\u6bb5\u5e94\u8be5\u521b\u5efa\u5728\u65b0\u8868\u4e2d\uff0c\u7136\u540e\u5728\u65b0\u8868\u4e2d\u5206\u522bforeign key\u4e24\u5f20\u8868\u7684id\u5b57\u6bb5<\/code><\/pre>\n<p>\u6211\u4eec\u4ee5\u4e00\u4e2a\u56fe\u4e66\u7ba1\u7406\u7cfb\u7edf\u4e3a\u80cc\u666f\uff0c\u8bbe\u8ba1\u4e86\u4e0b\u8ff0\u56db\u5f20\u8868\uff0c\u8ba9\u6211\u4eec\u6765\u627e\u4e00\u627e\u5b83\u4eec\u4e4b\u95f4\u7684\u5173\u7cfb<\/p>\n<p>\u4e66\u7c4d\u8868\uff1aapp01_book<\/p>\n<p>\u51fa\u7248\u793e\u8868\uff1aapp01_publish<\/p>\n<p>\u4f5c\u8005\u8868\uff1aapp01_author<\/p>\n<p>\u4f5c\u8005\u8be6\u7ec6\u4fe1\u606f\u8868\uff1aapp01_authordetail<\/p>\n<h4>\u4f8b1\u3001app01_book\u4e0eapp01_publish<\/h4>\n<p>\u627e\u5173\u7cfb<\/p>\n<pre><code class=\"language-python\">\u5de6\u8868(app01_book)&lt;-------------------------------&gt;\u53f3\u8868(app01_publish)\n\n# \u6b65\u9aa4\u4e00\uff1a\n#\u5206\u67901\u3001\u5148\u7ad9\u5728\u5de6\u8868\u7684\u89d2\u5ea6\n\u5de6\u8868\u7684\u591a\u6761\u8bb0\u5f55\u4ee3\u8868\u591a\u7248\u672c\u4e66\u7c4d\uff0c\u53f3\u8868\u7684\u4e00\u6761\u8bb0\u5f55\u4ee3\u8868\u4e00\u4e2a\u51fa\u7248\u793e\uff0c\u591a\u672c\u4e66\u7c4d\u5bf9\u5e94\u540c\u4e00\u4e2a\u51fa\u7248\u793e \u2714\ufe0f\n\n#\u5206\u67902\u3001\u518d\u7ad9\u5728\u53f3\u8868\u7684\u89d2\u5ea6\u53bb\u627e\n\u53f3\u8868\u7684\u591a\u6761\u8bb0\u5f55\u4ee3\u8868\u591a\u4e2a\u51fa\u7248\u793e\uff0c\u5de6\u8868\u7684\u4e00\u6761\u8bb0\u5f55\u4ee3\u8868\u4e00\u672c\u4e66\uff0c\u591a\u4e2a\u51fa\u7248\u793e\u4e0d\u80fd\u51fa\u7248\u540c\u4e00\u672c\u4e66 \u2718\n\n# \u6b65\u9aa4\u4e8c\uff1a\u540e\u786e\u5b9a\u5173\u7cfb\n# \u591a\u5bf9\u4e00\n\u53ea\u6709&quot;\u5206\u67901&quot;\u6210\u7acb\uff0c\u90a3\u4e48\u53ef\u4ee5\u786e\u5b9a\u4e24\u5f20\u8868\u7684\u5173\u7cfb\u662f\uff1a\u5de6\u8868(app01_book)\u591a\u5bf9\u4e00\u53f3\u8868(app01_publish)\uff0c\u5173\u8054\u5b57\u6bb5\u5e94\u8be5\u521b\u5efa\u5728\u5de6\u8868(app01_book)\u4e2d\uff0c\u7136\u540eforeign key \u53f3\u8868(app01_publish)\u7684id\u5b57\u6bb5<\/code><\/pre>\n<p>sql\u8bed\u53e5<\/p>\n<pre><code class=\"language-python\"># 1\u3001\u7531\u4e8eforeign key\u7684\u5f71\u54cd,\u5fc5\u987b\u5148\u521b\u5efa\u88ab\u5173\u8054\u8868\nCREATE TABLE app01_publish (\n    id INT PRIMARY KEY auto_increment,\n    name VARCHAR (20)\n);\n\n# 2\u3001\u624d\u80fd\u521b\u5efa\u51fa\u5173\u8054\u8868\nCREATE TABLE app01_book (\n    id INT PRIMARY KEY auto_increment,\n    title VARCHAR (20),\n    price DECIMAL (8, 2),\n    pub_date DATE,\n    publish_id INT, # \u65b0\u589e\u5173\u8054\u5b57\u6bb5\n    FOREIGN KEY (publish_id) REFERENCES app01_publish (id) \n    ON UPDATE CASCADE ON DELETE CASCADE\n);<\/code><\/pre>\n<h4>\u4f8b2\u3001app01_author\u4e0eapp01_authordetail<\/h4>\n<p>\u627e\u5173\u7cfb<\/p>\n<pre><code class=\"language-python\">\u5de6\u8868(app01_author)&lt;-------------------------------&gt;\u53f3\u8868(app01_authordetail)\n\n\u4e00\u4e2a\u4f5c\u8005\u552f\u4e00\u5bf9\u5e94\u4e00\u6761\u81ea\u5df1\u7684\u8be6\u60c5\u4fe1\u606f\uff0c\u53cd\u4e4b\u4ea6\u7136\uff0c\u6240\u4ee5\u4e24\u5f20\u8868\u662f\u4e00\u5bf9\u4e00\u7684\u5173\u7cfb\u3002\u5728\u5de6\u8868\u4e2d\u65b0\u589e\u5173\u8054\u5b57\u6bb5\u5e76\u6dfb\u52a0unique\u7ea6\u675f\uff0c\u7136\u540eforeign key\u53f3\u8868<\/code><\/pre>\n<p>sql\u8bed\u53e5<\/p>\n<pre><code class=\"language-python\"># 1\u3001\u7531\u4e8eforeign key\u7684\u5f71\u54cd,\u5fc5\u987b\u5148\u521b\u5efa\u88ab\u5173\u8054\u8868\nCREATE TABLE app01_authordetail (\n    id INT PRIMARY KEY auto_increment,\n    tel VARCHAR (20)\n);\n\n# 2\u3001\u624d\u80fd\u521b\u5efa\u51fa\u5173\u8054\u8868\nCREATE TABLE app01_author (\n    id INT PRIMARY KEY auto_increment,\n    name VARCHAR (20),\n    age INT,\n    authordetail_id INT UNIQUE, # \u65b0\u589e\u5173\u8054\u5b57\u6bb5,\u5e76\u6dfb\u52a0\u552f\u4e00\u6027\u7ea6\u675funique\n    FOREIGN KEY (authordetail_id) REFERENCES app01_authordetail (id) \n    ON UPDATE CASCADE ON DELETE CASCADE\n);<\/code><\/pre>\n<h4>\u4f8b3\u3001app01_book\u4e0eapp01_author<\/h4>\n<p>\u627e\u5173\u7cfb<\/p>\n<pre><code class=\"language-python\">\u5de6\u8868(app01_book)&lt;-------------------------------&gt;\u53f3\u8868(app01_author)\n\n# \u6b65\u9aa4\u4e00\uff1a\n#\u5206\u67901\u3001\u5148\u7ad9\u5728\u5de6\u8868\u7684\u89d2\u5ea6\n\u5de6\u8868\u7684\u591a\u6761\u8bb0\u5f55\u4ee3\u8868\u591a\u7248\u672c\u4e66\u7c4d\uff0c\u53f3\u8868\u7684\u4e00\u6761\u8bb0\u5f55\u4ee3\u8868\u4e00\u4e2a\u4f5c\u8005\uff0c\u591a\u672c\u4e66\u7c4d\u53ef\u4ee5\u7531\u540c\u4e00\u4e2a\u4f5c\u8005\u7f16\u5199 \u2714\ufe0f\n\n#\u5206\u67902\u3001\u518d\u7ad9\u5728\u53f3\u8868\u7684\u89d2\u5ea6\u53bb\u627e\n\u53f3\u8868\u7684\u591a\u6761\u8bb0\u5f55\u4ee3\u8868\u591a\u4e2a\u4f5c\u8005\uff0c\u5de6\u8868\u7684\u4e00\u6761\u8bb0\u5f55\u4ee3\u8868\u4e00\u672c\u4e66\uff0c\u591a\u4e2a\u4f5c\u8005\u53ef\u4ee5\u5408\u4f5c\u7f16\u5199\u540c\u4e00\u672c\u4e66 \u2714\ufe0f\n\n# \u6b65\u9aa4\u4e8c\uff1a\u540e\u786e\u5b9a\u5173\u7cfb\n# \u591a\u5bf9\u591a\n&quot;\u5206\u67901&quot;\u548c&quot;\u5206\u67902&quot;\u540c\u65f6\u6210\u7acb\uff0c\u8bc1\u660e\u8fd9\u4e24\u5f20\u8868\u662f\u591a\u5bf9\u591a\u7684\u5173\u7cfb,\u9700\u8981\u521b\u5efa\u4e00\u5f20\u5355\u72ec\u7684\u65b0\u8868\u6765\u4e13\u95e8\u5b58\u653e\u4e8c\u8005\u7684\u5173\u7cfb\uff0c\u5173\u8054\u5b57\u6bb5\u5e94\u8be5\u521b\u5efa\u5728\u65b0\u8868\u4e2d\uff0c\u7136\u540e\u5728\u65b0\u8868\u4e2d\u5206\u522bforeign key\u4e24\u5f20\u8868\u7684id\u5b57\u6bb5<\/code><\/pre>\n<p>sql\u8bed\u53e5<\/p>\n<pre><code class=\"language-python\"># 1\u3001\u521b\u5efa\u88ab\u5173\u8054\u8868\u4e00\uff1aapp01_book\uff0c\u4f8b1\u4e2d\u5df2\u521b\u5efa\n# 2\u3001\u521b\u5efa\u88ab\u5173\u8054\u8868\u4e8c\uff1aapp01_author\uff0c\u4f8b2\u4e2d\u5df2\u521b\u5efa\n\n# 3\u3001\u521b\u5efa\u65b0\u8868\uff0c\u5b58\u653eapp01_book\u4e8eapp01_author\u7684\u5173\u8054\u5173\u7cfb\nCREATE TABLE app01_book_authors (\n    id INT PRIMARY KEY auto_increment,\n    book_id INT, # \u65b0\u589e\u5173\u8054\u5b57\u6bb5\uff0c\u7528\u6765\u5173\u8054\u8868app01_book\n    author_id INT, # \u65b0\u589e\u5173\u8054\u5b57\u6bb5\uff0c\u7528\u6765\u5173\u8054\u8868app01_author\n    FOREIGN KEY (book_id) REFERENCES app01_book (id) ON UPDATE CASCADE ON DELETE CASCADE,\n    FOREIGN KEY (author_id) REFERENCES app01_author (id) ON UPDATE CASCADE ON DELETE CASCADE\n);<\/code><\/pre>\n<p>\u4e0a\u8ff0\u4e09\u4e2a\u4f8b\u5b50\u4e2d\u751f\u6210\u7684\u8868\u5982\u4e0b<\/p>\n<p>\u63d2\u56fe5\uff0c\u4fee\u6539\u94fe\u63a5\uff1a<a href=\"https:\/\/www.processon.com\/diagraming\/5a895fdde4b0874437c9c580\">https:\/\/www.processon.com\/diagraming\/5a895fdde4b0874437c9c580<\/a><\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-3.png'><img class=\"lazyload lazyload-style-2\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  data-original=\"https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-3.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<h1>\u4e8c \u521b\u5efa\u6a21\u578b<\/h1>\n<p>\u6a21\u578b\u7c7b\u5982\u4e0b<\/p>\n<pre><code class=\"language-python\">from django.db import models\n\n# \u8868app01_publish\nclass Publish(models.Model):\n    nid = models.AutoField(primary_key=True)\n    name = models.CharField(max_length=20)\n\n# \u8868app01_book\nclass Book(models.Model):\n    nid = models.AutoField(primary_key=True)\n    title = models.CharField(max_length=20)\n    price = models.DecimalField(max_digits=8, decimal_places=2)\n    pub_date = models.DateField()\n\n    # \u8868app01_book\u591a\u5bf9\u4e00\u8868app01_publish\uff0c\u53c2\u6570to\u6307\u5b9a\u6a21\u578b\u540d\uff0c\u53c2\u6570to_field\u6307\u5b9a\u8981\u5173\u8054\u7684\u90a3\u4e2a\u5b57\u6bb5\n    publish = models.ForeignKey(to=&#039;Publish&#039;,to_field=&#039;nid&#039;,on_delete=models.CASCADE)\n\n    # \u6211\u4eec\u81ea\u5df1\u5199sql\u65f6\uff0c\u9488\u5bf9\u4e66\u7c4d\u8868\u4e0e\u4f5c\u8005\u8868\u7684\u591a\u5bf9\u5173\u7cfb\uff0c\u9700\u8981\u81ea\u5df1\u521b\u5efa\u65b0\u8868\uff0c\u800c\u57fa\u4e8edjango\u7684orm\uff0c\u4e0b\u9762\u8fd9\u4e00\u884c\u4ee3\u7801\u53ef\u4ee5\u5e2e\u6211\u4eec\u81ea\u52a8\u521b\u5efa\u90a3\u5f20\u5173\u7cfb\u8868\n    authors=models.ManyToManyField(to=&#039;Author&#039;) \n    # \u53d8\u91cf\u540d\u4e3aauthors\uff0c\u5219\u65b0\u8868\u540d\u4e3aapp01_book_authors\uff0c\u82e5\u53d8\u91cf\u540d\u4e3axxx\uff0c\u5219\u65b0\u8868\u540d\u4e3aapp01_book_xxx\n\n# \u8868app01_author\nclass Author(models.Model):\n    nid = models.AutoField(primary_key=True)\n    name = models.CharField(max_length=20)\n    age = models.IntegerField()\n\n    # \u8868app01_author\u4e00\u5bf9\u4e00\u8868app01_authordetail\n    author_detail = models.OneToOneField(to=&#039;AuthorDetail&#039;,to_field=&#039;nid&#039;,unique=True,on_delete=models.CASCADE)\n\n# \u8868app01_authordetail\nclass AuthorDetail(models.Model):\n    nid = models.AutoField(primary_key=True)\n    tel = models.CharField(max_length=20)<\/code><\/pre>\n<p>\u5f3a\u8c03\uff1a<\/p>\n<pre><code class=\"language-python\">\u5728\u521b\u5efa\u5173\u8054\u65f6\uff0c\u9488\u5bf9\u53c2\u6570to\uff0c\u5982\u679c\u4f20\u5165\u7684\u662f\u5b57\u7b26\u4e32\uff08to=&quot;\u6a21\u578b\u540d&quot;\uff09\uff0c\u5219\u6a21\u578b\u7c7b\u7684\u5b9a\u4e49\u4e0d\u533a\u5206\u5148\u540e\u987a\u5e8f\uff0c\u5982\u679c\u4f20\u5165\u7684\u662f\u6a21\u578b\u540d\uff08to=Author\uff09\uff0c\u5219Author\u7c7b\u5fc5\u987b\u4e8b\u5148\u5b9a\u4e49<\/code><\/pre>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-4.png'><img class=\"lazyload lazyload-style-2\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  data-original=\"https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-4.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<h1>\u4e09 \u6dfb\u52a0\u3001\u5220\u9664\u3001\u4fee\u6539\u8bb0\u5f55<\/h1>\n<h3>3.1 \u6dfb\u52a0\u8bb0\u5f55<\/h3>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-5.png'><img class=\"lazyload lazyload-style-2\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  data-original=\"https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-5.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<p>\uff01\uff01\u5f3a\u8c03\uff01\uff01\uff1a\u4e0a\u56fe\u6240\u793a\u7684\u8868\u540d\u3001\u5b57\u6bb5\u540d\u90fd\u662fmysql\u4e2d\u7684\u771f\u5b9e\u8868\/\u7269\u7406\u8868\uff0c\u800c\u6211\u4eec\u4e0b\u8ff0\u6240\u793a\u6240\u6709\u64cd\u4f5c\uff0c\u90fd\u662f\u901a\u8fc7\u6a21\u578b\u7c7b\u6765\u64cd\u4f5c\u7269\u7406\u8868\uff0c\u4f8b\u5982\u65e0\u8bba\u589e\u5220\u6539\u67e5\uff0c\u6240\u4f7f\u7528\u7684\u5b57\u6bb5\u540d\u90fd\u6a21\u578b\u7c7b\u4e2d\u7684\u5b57\u6bb5<\/p>\n<p>\u6309\u7167\u4e0a\u56fe\u6240\u793a\uff0c\u7531\u4e8eforeign key\u7684\u5173\u7cfb\uff0c\u6211\u4eec\u9700\u8981\u4e8b\u5148\u5f80app01_publish\u4e0eapp01_authordetail\u91cc\u63d2\u5165\u8bb0\u5f55<\/p>\n<pre><code class=\"language-python\"># 1\u3001\u9700\u6c42\uff1a\u901a\u8fc7\u6a21\u578bPublish\u5f80\u8868app01_publish\u91cc\u63d2\u5165\u4e09\u5bb6\u51fa\u7248\u793e\nPublish.objects.create(name=&#039;\u5317\u4eac\u51fa\u7248\u793e&#039;)\nPublish.objects.create(name=&#039;\u957f\u6625\u51fa\u7248\u793e&#039;)\nPublish.objects.create(name=&#039;\u5927\u8fde\u51fa\u7248\u793e&#039;)\n\n# 2\u3001\u9700\u6c42\uff1a\u901a\u8fc7\u6a21\u578bAuthorDetail\u5f80\u8868app01_authordetail\u91cc\u63d2\u5165\u4e09\u6761\u4f5c\u8005\u8be6\u60c5\nAuthorDetail.objects.create(tel=&#039;18611312331&#039;)\nAuthorDetail.objects.create(tel=&#039;15033413881&#039;)\nAuthorDetail.objects.create(tel=&#039;13011453220&#039;)<\/code><\/pre>\n<p>\u6309\u7167\u4e0a\u56fe\u6240\u793a\uff0c\u63d2\u5165\u65f6\u4f1a\u6d89\u53ca\u5230\u591a\u5f20\u8868\uff0c\u6211\u4eec\u540c\u6837\u5206\u4e09\u79cd\u60c5\u51b5\u6765\u4ecb\u7ecd<\/p>\n<p>1\u3001\u591a\u5bf9\u4e00\uff1aapp01_book\u4e0eapp01_publish<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u4e66\u7c4d(\u8475\u82b1\u5b9d\u5178\u3001\u83ca\u82b1\u5b9d\u5178\u3001\u6843\u82b1\u5b9d\u5178)\u90fd\u662f\u5728\u5317\u4eac\u51fa\u7248\u793e\u51fa\u7248\u7684\n# 1\u3001\u5148\u901a\u8fc7\u6a21\u578bPublish\u4ece\u51fa\u7248\u793e\u8868app01_publish\u67e5\u51fa\u5317\u4eac\u51fa\u7248\u793e\npublish_obj=Publish.objects.filter(name=&#039;\u5317\u4eac\u51fa\u7248\u793e&#039;).first()\n# \u4e0a\u8ff0\u4ee3\u7801\u4e5f\u53ef\u4ee5\u7b80\u5199\u4e3a\uff1apublish_obj=Publish.objects.get(name=&#039;\u5317\u4eac\u51fa\u7248\u793e&#039;)\n\n# 2\u3001\u518d\u901a\u8fc7\u6a21\u578bBook\u5f80\u4e66\u7c4d\u8868app01_book\u91cc\u63d2\u5165\u4e09\u672c\u4e66\u7c4d\u4e0e\u51fa\u7248\u793e\u7684\u5bf9\u5e94\u5173\u7cfb\n# \u65b9\u5f0f\u4e00\uff1a\u4f7f\u7528publish\u53c2\u6570\u6307\u5b9a\u5173\u8054\nbook_obj1=Book.objects.create(title=&#039;\u8475\u82b1\u5b9d\u5178&#039;,price=2000,pub_date=&#039;1985-3-11&#039;,publish=publish_obj)\n\nbook_obj2=Book.objects.create(title=&#039;\u83ca\u82b1\u5b9d\u5178&#039;,price=3000,pub_date=&#039;1990-1-21&#039;,publish=publish_obj)\n\nbook_obj3=Book.objects.create(title=&#039;\u6843\u82b1\u5b9d\u5178&#039;,price=4000,pub_date=&#039;1991-1-23&#039;,publish=publish_obj)\n\n# \u65b9\u5f0f\u4e8c\uff1a\u4f7f\u7528publish_id\u53c2\u6570\u6307\u5b9a\u5173\u8054\nbook_obj1=Book.objects.create(title=&#039;\u8475\u82b1\u5b9d\u5178&#039;,price=2000,pub_date=&#039;1985-3-11&#039;,publish_id=publish_obj.nid)\n\nbook_obj2=Book.objects.create(title=&#039;\u83ca\u82b1\u5b9d\u5178&#039;,price=3000,pub_date=&#039;1990-1-21&#039;,publish_id=1) # \u5728\u5df2\u7ecf\u51fa\u7248\u793eid\u7684\u60c5\u51b5\u4e0b\uff0c\u53ef\u4ee5\u76f4\u63a5\u6307\u5b9a\n\nbook_obj3=Book.objects.create(title=&#039;\u6843\u82b1\u5b9d\u5178&#039;,price=4000,pub_date=&#039;1991-1-23&#039;,publish_id=1)\n\n# \u6ce8\u610f\uff1a\u65e0\u8bba\u65b9\u5f0f\u4e00\u8fd8\u662f\u65b9\u5f0f\u4e8c\u5f97\u5230\u7684\u4e66\u7c4d\u5bf9\u8c61book_obj1\u3001book_obj2\u3001book_obj3\n#      \u90fd\u53ef\u4ee5\u8c03\u7528publish\u5b57\u6bb5\u6765\u8bbf\u95ee\u5173\u8054\u7684\u90a3\u4e00\u4e2a\u51fa\u7248\u793e\u5bf9\u8c61\n#      \u90fd\u53ef\u4ee5\u8c03\u7528publish_id\u6765\u8bbf\u95ee\u5173\u8054\u7684\u90a3\u4e00\u4e2a\u51fa\u7248\u793e\u5bf9\u8c61\u7684nid\nprint(book_obj1.publish,book_obj1.publish_id) \nprint(book_obj2.publish,book_obj2.publish_id) \nprint(book_obj3.publish,book_obj3.publish_id)\n# \u4e09\u672c\u4e66\u5173\u8054\u7684\u662f\u540c\u4e00\u4e2a\u51fa\u7248\u793e\uff0c\u6240\u4ee5\u8f93\u51fa\u7ed3\u679c\u5747\u76f8\u540c<\/code><\/pre>\n<p>\u53c2\u7167\u4e0a\u8ff0\u6b65\u9aa4\uff0c\u628a\u5269\u4f59\u4e09\u672c\u4e66\u4e0e\u51fa\u7248\u793e\u7684\u5bf9\u5e94\u5173\u7cfb\u4e5f\u63d2\u5165<\/p>\n<pre><code class=\"language-python\">book_obj1 = Book.objects.create(title=&#039;\u7389\u5973\u5fc3\u7ecf&#039;, price=5000, pub_date=&#039;1988-3-24&#039;, publish_id=2)\n\nbook_obj2 = Book.objects.create(title=&#039;\u7389\u7537\u5fc3\u7ecf&#039;, price=3000, pub_date=&#039;1985-6-17&#039;, publish_id=2)\n\nbook_obj3 = Book.objects.create(title=&#039;\u4e5d\u9634\u771f\u7ecf&#039;, price=6000, pub_date=&#039;1983-8-17&#039;, publish_id=3)<\/code><\/pre>\n<p>2\u3001\u4e00\u5bf9\u4e00\uff1aapp01_author\u4e0eapp01_authordetail<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u63d2\u5165\u4e09\u4e2a\u4f5c\u8005\uff0c\u5e76\u4e0e\u4f5c\u8005\u8be6\u60c5\u8868\u4e00\u4e00\u5bf9\u5e94\n# \u7531\u4e8e\u4f5c\u8005\u8be6\u60c5\u8868\u6211\u4eec\u5df2\u7ecf\u4e8b\u5148\u521b\u5efa\u597d\u8bb0\u5f55\uff0c\u6240\u4ee5\u53ea\u9700\u8981\u5f80\u4f5c\u8005\u8868\u63d2\u5165\u8bb0\u5f55\u5373\u53ef\n# \u65b9\u5f0f\u4e00\uff1a\u9700\u8981\u4e8b\u5148\u8fc7\u6ee4\u51fa\u4f5c\u8005\u8be6\u60c5\u7684\u5bf9\u8c61\uff0c\u7136\u540e\u901a\u8fc7\u6a21\u578bAuthor\u7684\u5b57\u6bb5author\u6765\u6307\u5b9a\u8981\u5173\u8054\u7684\u4f5c\u8005\u8be6\u60c5\u5bf9\u8c61(\u7565)\n\n# \u65b9\u5f0f\u4e8c\uff1a\u786e\u5b9a\u4f5c\u8005\u8be6\u60c5\u5bf9\u8c61\u7684id\uff0c\u7136\u540e\u901a\u8fc7\u6a21\u578bAuthor\u901a\u8fc7\u5b57\u6bb5author_id\u6765\u6307\u5b9a\u5173\u8054\u5173\u7cfb\uff0c\nAuthor.objects.create(name=&#039;egon&#039;,age=18,author_detail_id=1)\nAuthor.objects.create(name=&#039;kevin&#039;,age=38,author_detail_id=2)\nAuthor.objects.create(name=&#039;rose&#039;,age=28,author_detail_id=3)<\/code><\/pre>\n<p>3\u3001\u591a\u5bf9\u591a\uff1aapp01_book\u4e0eapp01_author<\/p>\n<pre><code class=\"language-python\"># \u6211\u4eec\u53c2\u7167\u7269\u7406\u8868app01_book_authors\u5236\u5b9a\u9700\u6c42\uff0c\u9700\u8981\u521b\u5efa\u5982\u4e0b\u5173\u7cfb\n# 1\u3001\u8475\u82b1\u5b9d\u5178\u7684\u4f5c\u8005\u4e3a\uff1aegon\u3001kevin\n# 2\u3001\u83ca\u82b1\u5b9d\u5178\u7684\u4f5c\u8005\u4e3a\uff1aegon\u3001kevin\u3001rose\n# 3\u3001\u6843\u82b1\u5b9d\u5178\u7684\u4f5c\u8005\u4e3a\uff1aegon\u3001kevin\n# 4\u3001\u7389\u5973\u5fc3\u7ecf\u7684\u4f5c\u8005\u4e3a\uff1akevin\u3001rose\n# 5\u3001\u7389\u7537\u5fc3\u7ecf\u7684\u4f5c\u8005\u4e3a\uff1akevin\n# 6\u3001\u4e5d\u9634\u771f\u7ecf\u7684\u4f5c\u8005\u4e3a\uff1aegon\u3001rose\n\n# \u9700\u8981\u521b\u5efa\u51fa\u4e0a\u8ff0\u5173\u7cfb\uff0c\u5177\u4f53\u505a\u6cd5\u5982\u4e0b\n# 1\u3001\u5148\u83b7\u53d6\u4e66\u7c4d\u5bf9\u8c61\nbook_obj1=Book.objects.get(title=&#039;\u8475\u82b1\u5b9d\u5178&#039;)\nbook_obj2=Book.objects.get(title=&#039;\u83ca\u82b1\u5b9d\u5178&#039;)\nbook_obj3=Book.objects.get(title=&#039;\u6843\u82b1\u5b9d\u5178&#039;)\nbook_obj4=Book.objects.get(title=&#039;\u7389\u5973\u5fc3\u7ecf&#039;)\nbook_obj5=Book.objects.get(title=&#039;\u7389\u7537\u5fc3\u7ecf&#039;)\nbook_obj6=Book.objects.get(title=&#039;\u4e5d\u9634\u771f\u7ecf&#039;)\n\n# 2\u3001\u7136\u540e\u83b7\u53d6\u4f5c\u8005\u5bf9\u8c61\negon=Author.objects.get(name=&#039;egon&#039;)\nkevin=Author.objects.get(name=&#039;kevin&#039;)\nrose=Author.objects.get(name=&#039;rose&#039;)\n\n# 3\u3001\u6700\u540e\u4f9d\u6b21\u521b\u5efa\u4e0a\u8ff0\u5173\u7cfb\uff1a\u5728\u539f\u751fSQL\u4e2d\u591a\u5bf9\u591a\u5173\u7cfb\u6d89\u53ca\u5230\u64cd\u4f5c\u7b2c\u4e09\u5f20\u5173\u7cfb\u8868\uff0c\u4f46\u662f\u5728ORM\u4e2d\u6211\u4eec\u53ea\u9700\u8981\u64cd\u4f5c\u6a21\u578b\u7c7bBook\u4e0b\u7684\u5b57\u6bb5author\u5373\u53ef\nbook_obj1.authors.add(egon,kevin)\nbook_obj2.authors.add(egon,kevin,rose)\nbook_obj3.authors.add(egon,kevin)\nbook_obj4.authors.add(kevin,rose)\nbook_obj5.authors.add(kevin)\nbook_obj6.authors.add(egon,rose)<\/code><\/pre>\n<p>\u53ef\u4ee5\u901a\u8fc7\u4e66\u7c4d\u5bf9\u8c61\u4e0b\u7684authors\u5b57\u6bb5\u83b7\u53d6\u5176\u6240\u5173\u8054\u7684\u6240\u6709\u4f5c\u8005\u5bf9\u8c61<\/p>\n<pre><code class=\"language-python\">book_obj1.authors.all() # \u8fd4\u56de\u4e00\u4e2a\u5b58\u6709\u591a\u4e2a\u4f5c\u8005\u7684queryset<\/code><\/pre>\n<h3>3.2 \u5220\u9664\u3001\u4fee\u6539\u8bb0\u5f55<\/h3>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-6.gif'><img class=\"lazyload lazyload-style-2\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  data-original=\"https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-6.gif\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<pre><code class=\"language-python\"># 1\u3001book_obj.authors.remove() \uff1a\u5c06\u67d0\u4e2a\u7279\u5b9a\u7684\u5bf9\u8c61\u4ece\u88ab\u5173\u8054\u5bf9\u8c61\u96c6\u5408\u4e2d\u53bb\u9664\n# \u4ece\u83ca\u82b1\u5b9d\u5178\u7684\u4f5c\u8005\u96c6\u5408\u4e2d\u53bb\u6389\u4f5c\u8005rose\nrose = Author.objects.get(name=&#039;rose&#039;)\nbook_obj2 = Book.objects.get(title=&#039;\u83ca\u82b1\u5b9d\u5178&#039;)\nbook_obj2.authors.remove(rose)\n\n# 2\u3001book_obj.authors.clear()\uff1a\u6e05\u7a7a\u88ab\u5173\u8054\u5bf9\u8c61\u96c6\u5408\n# \u6e05\u7a7a\u83ca\u82b1\u5b9d\u5178\u6240\u5173\u8054\u7684\u6240\u6709\u4f5c\u8005\nbook_obj2 = Book.objects.get(title=&#039;\u83ca\u82b1\u5b9d\u5178&#039;)\nbook_obj2.authors.clear()\n\n# 3\u3001book_obj.authors.set()\uff1a\u5148\u6e05\u7a7a\u518d\u91cd\u65b0\u8bbe\u7f6e\u3000\n# \u7389\u7537\u5fc3\u7ecf\u7684\u4f5c\u8005\u539f\u6765\u4e3akevin\uff0c\u8981\u6c42\u8bbe\u7f6e\u4e3aegon\u3001rose\negon=Author.objects.get(name=&#039;egon&#039;)\nrose=Author.objects.get(name=&#039;rose&#039;)\n\nbook_obj5 = Book.objects.get(title=&#039;\u7389\u7537\u5fc3\u7ecf&#039;)\n\nbook_obj5.authors.set([egon,rose]) # \u591a\u4e2a\u4f5c\u8005\u5bf9\u8c61\u653e\u5230\u5217\u8868\u91cc<\/code><\/pre>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-7.png'><img class=\"lazyload lazyload-style-2\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  data-original=\"https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-7.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<h1>\u56db \u67e5\u8be2\u8bb0\u5f55<\/h1>\n<p>\u6570\u636e\u5e93\u64cd\u4f5c\u6700\u5e38\u7528\u7684\u8fd8\u662f\u67e5\u8be2\u64cd\u4f5c\uff0c\u5728\u4ecb\u7ecdORM\u4e0b\u591a\u8868\u5173\u8054\u67e5\u8be2\u65f6\uff0c\u9700\u8981\u4e8b\u5148\u8bb0\u4f4f\u5173\u4e8eORM\u6a21\u578b\u7684\u4e00\u4e2a\u975e\u5e38\u91cd\u8981\u7684\u6982\u5ff5\uff1a\u5728\u4f7f\u7528\u6a21\u578b\u7c7b\u8fdb\u884c\u591a\u8868\u5173\u8054\u67e5\u8be2\u65f6\uff0c\u5982\u679c\u786e\u5b9a\u4e24\u5f20\u8868\u5b58\u5728\u5173\u8054\u5173\u7cfb\uff0c\u90a3\u4e48\u5728\u9009\u53d6\u4e00\u4e2a\u8868\u4f5c\u4e3a\u8d77\u59cb\uff08\u4e3a\u4e86\u540e\u7eed\u63cf\u8ff0\u65b9\u4fbf\uff0c\u6211\u4eec\u5c06\u5176\u7b80\u79f0\u4e3a&quot;\u57fa\u8868&quot;\uff09\u540e\uff0c\u53ef\u4ee5\u8de8\u8868\u5f15\u7528\u6765\u81ea\u53e6\u5916\u4e00\u5f20\u4e2d\u7684\u5b57\u6bb5\u503c\uff0c\u8fd9\u5b58\u5728\u6b63\u5411\u4e0e\u53cd\u5411\u4e4b\u5206<\/p>\n<p>\u5982\u679c\u5173\u8054\u5b57\u6bb5\u5b58\u5728\u4e8e\u57fa\u8868\u4e2d\uff0c\u79f0\u4e4b\u4e3a\u6b63\u5411\u67e5\u8be2\uff0c\u5426\u5219\uff0c\u79f0\u4e4b\u4e3a\u53cd\u5411\u67e5\u8be2<\/p>\n<p>\u4f8b\u5982\u8868\u6a21Book\u4e0ePublish\uff0c\u5173\u8054\u5b57\u6bb5\u5b58\u5728\u4e8eBook\u4e2d<\/p>\n<pre><code class=\"language-python\"># \u5f53\u4ee5Book\u4e3a\u57fa\u8868\u65f6\uff0c\u79f0\u4e4b\u4e3a\u6b63\u5411\u67e5\u8be2\nBook(\u57fa\u8868)-------\u6b63\u5411----------&gt;Publish\n\n# \u5f53\u4ee5Publish\u4e3a\u57fa\u8868\u65f6\uff0c\u79f0\u4e4b\u4e3a\u53cd\u5411\u67e5\u8be2\nBook&lt;-------\u53cd\u5411----------Publish(\u57fa\u8868)<\/code><\/pre>\n<p>\u4f7f\u7528\u539f\u751fsql\u8fdb\u884c\u591a\u8868\u5173\u8054\u67e5\u8be2\u65f6\u65e0\u975e\u4e24\u79cd\u65b9\u5f0f\uff1a\u5b50\u67e5\u8be2\u3001join\u8fde\u8868\u67e5\u8be2\uff0cORM\u91cc\u540c\u6837\u6709\u4e24\u79cd\u67e5\u8be2\u65b9\u5f0f\uff08\u4e25\u683c\u4f9d\u8d56\u6b63\u5411\u3001\u53cd\u5411\u7684\u6982\u5ff5\uff09<\/p>\n<h3>4.1 \u57fa\u4e8e\u5bf9\u8c61\u7684\u8de8\u8868\u67e5\u8be2<\/h3>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-8.gif'><img class=\"lazyload lazyload-style-2\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  data-original=\"https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-8.gif\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<h4>1\u3001\u8de8\u4e24\u5f20\u8868\u67e5\u8be2<\/h4>\n<h5>1.1\u3001\u4e00\u5bf9\u4e00\u67e5\u8be2\uff08\u6a21\u578b\u7c7bAuthor\u4e0eAuthorDetail\uff09<\/h5>\n<p>\u6b63\u5411\u67e5\u8be2\uff0c\u6309\u5173\u8054\u5b57\u6bb5\uff1aauthor_detail<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u67e5\u8be2\u4f5c\u8005egon\u7684\u624b\u673a\u53f7\n# 1\u3001\u5148\u53d6\u51fa\u4f5c\u8005\u5bf9\u8c61\negon=Author.objects.filter(name=&#039;egon&#039;).first() \n# 2\u3001\u6b63\u5411\u67e5\u8be2\uff1a\u6839\u636e\u4f5c\u8005\u5bf9\u8c61\u4e0b\u7684\u5173\u8054\u5b57\u6bb5author_detail\u53d6\u5230\u4f5c\u8005\u8be6\u60c5\nprint(egon.author_detail.tel) # \u8f93\u51fa\uff1a18611312331<\/code><\/pre>\n<p>\u53cd\u5411\u67e5\u8be2\uff0c\u6309\u6a21\u578b\u540d(\u5c0f\u5199)\uff1aauthor<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u67e5\u8be2\u624b\u673a\u53f7\u4e3a&#039;18611312331&#039;\u7684\u4f5c\u8005\u540d\n# 1\u3001\u5148\u53d6\u51fa\u4f5c\u8005\u7684\u8be6\u60c5\u5bf9\u8c61\ntel=AuthorDetail.objects.filter(tel=&#039;18611312331&#039;).first()\n# 2\u3001\u53cd\u5411\u67e5\u8be2\uff1a\u6839\u636e\u5c0f\u5199\u7684\u6a21\u578b\u540dauthor\u53d6\u5230\u4f5c\u8005\u5bf9\u8c61\nprint(tel.author.name) # \u8f93\u51fa\uff1aegon<\/code><\/pre>\n<h5>1.2\u3001\u591a\u5bf9\u4e00\u67e5\u8be2\uff08\u6a21\u578b\u7c7bBook\u4e0ePublish\uff09<\/h5>\n<p>\u6b63\u5411\u67e5\u8be2\uff0c\u6309\u5173\u8054\u5b57\u6bb5\uff1apublish<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u67e5\u8be2\u8475\u82b1\u5b9d\u5178\u7684\u51fa\u7248\u793e\u540d\u5b57\n# 1\u3001\u5148\u53d6\u4e66\u7c4d\u5bf9\u8c61\nbook_obj=Book.objects.filter(title=&#039;\u8475\u82b1\u5b9d\u5178&#039;).first()\n# 2\u3001\u6b63\u5411\u67e5\u8be2\uff1a\u6839\u636e\u4e66\u7c4d\u5bf9\u8c61\u4e0b\u7684\u5173\u8054\u5b57\u6bb5publish\u53d6\u5230\u51fa\u7248\u793e\nprint(book_obj.publish.name) # \u8f93\u51fa\uff1a\u5317\u4eac\u51fa\u7248\u793e<\/code><\/pre>\n<p>\u53cd\u5411\u67e5\u8be2\uff0c\u6309\u6a21\u578b\u540d(\u5c0f\u5199)_set\uff1abook_set<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u67e5\u8be2\u5317\u4eac\u51fa\u7248\u793e\u90fd\u51fa\u7248\u7684\u6240\u6709\u4e66\u7c4d\u540d\u5b57\n# 1\u3001\u5148\u53d6\u51fa\u51fa\u7248\u793e\u5bf9\u8c61\npublish_obj=Publish.objects.filter(name=&#039;\u5317\u4eac\u51fa\u7248\u793e&#039;).first()\n# 2\u3001\u53cd\u5411\u67e5\u8be2\uff1a\u6839\u636ebook_set\u53d6\u5230\u6240\u6709\u7684\u4e66\u7c4d\nbook_objs=publish_obj.book_set.all()\nprint([book_obj.title for book_obj in book_objs]) # \u8f93\u51fa\uff1a[&#039;\u8475\u82b1\u5b9d\u5178&#039;, &#039;\u83ca\u82b1\u5b9d\u5178&#039;, &#039;\u6843\u82b1\u5b9d\u5178&#039;]<\/code><\/pre>\n<h5>1.3\u3001\u591a\u5bf9\u591a\u67e5\u8be2\uff08\u6a21\u578b\u7c7bBook\u4e0eAuthor\uff09<\/h5>\n<p>\u6b63\u5411\u67e5\u8be2\uff0c\u6309\u5173\u8054\u5b57\u6bb5\uff0c\u5982authors<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u67e5\u8be2\u8475\u82b1\u5b9d\u5178\u7684\u6240\u6709\u4f5c\u8005\n# 1\u3001\u5148\u53d6\u51fa\u4e66\u7c4d\u5bf9\u8c61\nbook_obj=Book.objects.filter(title=&#039;\u8475\u82b1\u5b9d\u5178&#039;).first()\n# 2\u3001\u6b63\u5411\u67e5\u8be2\uff1a\u6839\u636e\u4e66\u7c4d\u5bf9\u8c61\u4e0b\u7684\u5173\u8054\u5b57\u6bb5authors\u53d6\u5230\u6240\u6709\u4f5c\u8005\nauthor_objs=book_obj.authors.all()\nprint([obj.name for obj in author_objs]) # \u8f93\u51fa\uff1a[&#039;egon&#039;, &#039;kevin&#039;]<\/code><\/pre>\n<p>\u53cd\u5411\u67e5\u8be2\uff0c\u6309\u6a21\u578b\u540d(\u5c0f\u5199)_set\uff1a\u5982author_set<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u67e5\u8be2\u4f5c\u8005rose\u51fa\u7248\u7684\u6240\u6709\u4e66\u7c4d\n# 1\u3001\u5148\u53d6\u51fa\u4f5c\u8005\u5bf9\u8c61\negon=Author.objects.filter(name=&#039;rose&#039;).first() \n# 2\u3001\u53cd\u5411\u67e5\u8be2\uff1a\u6839\u636ebook_set\u53d6\u5230\u4f5c\u8005\u5bf9\u8c61\nbook_objs=egon.book_set.all()\nprint([book_obj.title for book_obj in book_objs]) # \u8f93\u51fa\uff1a[&#039;\u7389\u5973\u5fc3\u7ecf&#039;, &#039;\u4e5d\u9634\u771f\u7ecf&#039;, &#039;\u7389\u7537\u5fc3\u7ecf&#039;]<\/code><\/pre>\n<h4>2\u3001\u8fde\u7eed\u8de8&gt;2\u5f20\u8868\u67e5\u8be2<\/h4>\n<p>\u8fde\u7eed\u8de8&gt;2\u5f20\u8868\u7684\u64cd\u4f5c\u7684\u5957\u8def\u4e0e\u4e0a\u9762\u7684\u6848\u4f8b\u90fd\u662f\u4e00\u6837\u7684<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u67e5\u8be2\u8475\u82b1\u5b9d\u5178\u7684\u4f5c\u8005\u4eec\u7684\u624b\u673a\u53f7\n\nbook_obj=Book.objects.filter(title=&#039;\u8475\u82b1\u5b9d\u5178&#039;).first()\nauthor_objs=book_obj.authors.all()\nprint([author_obj.author_detail.tel for author_obj in author_objs]) \n# \u8f93\u51fa\uff1a[&#039;18611312331&#039;, &#039;15033413881&#039;]<\/code><\/pre>\n<h3>4.2 \u57fa\u4e8e\u53cc\u4e0b\u5212\u7ebf\u7684\u8de8\u8868\u67e5\u8be2<\/h3>\n<h4>1\u3001\u8de8\u4e24\u5f20\u8868\u67e5\u8be2<\/h4>\n<h5>1.1\u3001\u4e00\u5bf9\u4e00\u67e5\u8be2\uff08\u6a21\u578b\u7c7bAuthor\u4e0eAuthorDetail\uff09<\/h5>\n<p>\u6b63\u5411\u67e5\u8be2\uff0c\u6309\u5173\u8054\u5b57\u6bb5+\u53cc\u4e0b\u5212\u7ebf\uff1aauthor_detail__<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u67e5\u8be2\u4f5c\u8005egon\u7684\u624b\u673a\u53f7\n# \u6ce8\u610fvalues()\u4e2d\u7684\u53c2\u6570\u662f\uff1a\u5173\u8054\u5b57\u6bb5\u540d__\u8981\u53d6\u7684\u90a3\u5f20\u88ab\u5173\u8054\u8868\u4e2d\u7684\u5b57\u6bb5\nres = Author.objects.filter(name=&#039;egon&#039;).values(&#039;author_detail__tel&#039;).first()\nprint(res[&#039;author_detail__tel&#039;]) # {&#039;author_detail__tel&#039;: &#039;18611312331&#039;}\n\n# \u6ce8\u610f\uff1a\u57fa\u4e8e\u53cc\u4e0b\u5212\u7ebf\u7684\u8de8\u8868\u67e5\u8be2\u4f1a\u88abdjango\u7684orm\u8bc6\u522b\u4e3ajoin\u64cd\u4f5c\uff0c\u6240\u4ee5\u4e0a\u8ff0\u4ee3\u7801\u76f8\u5f53\u4e8e\u5982\u4e0bsql\uff0c\u540e\u7eed\u6848\u4f8b\u5747\u662f\u76f8\u540c\u539f\u7406\uff0c\u6211\u4eec\u4e0d\u518d\u7d2f\u8ff0\nselect app01_authordetail.tel from app01_author inner join app01_authordetail on app01_author.author_detail_id = app01_authordetail.nid where app01_author.name = &#039;egon&#039;;<\/code><\/pre>\n<p>\u53cd\u5411\u67e5\u8be2\uff0c\u6309\u6a21\u578b\u540d(\u5c0f\u5199)+\u53cc\u4e0b\u5212\u7ebf\uff1aauthor__<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u67e5\u8be2\u624b\u673a\u53f7\u4e3a&#039;18611312331&#039;\u7684\u4f5c\u8005\u540d\n# \u6ce8\u610fvalues()\u4e2d\u7684\u53c2\u6570\u662f\uff1a\u5c0f\u5199\u7684\u6a21\u578b\u540d__\u8981\u53d6\u7684\u90a3\u5f20\u88ab\u5173\u8054\u8868\u4e2d\u7684\u5b57\u6bb5\nres=AuthorDetail.objects.filter(tel=&#039;18611312331&#039;).values(&#039;author__name&#039;).first()\nprint(res) # {&#039;author__name&#039;: &#039;egon&#039;}<\/code><\/pre>\n<p>\u8865\u5145\uff1a\u57fa\u8868\u51b3\u5b9a\u4e86\u6b63\u5411\u8fd8\u662f\u53cd\u5411<\/p>\n<pre><code class=\"language-python\"># 1\u3001\u9488\u5bf9\u4e0a\u4f8b\u4e2d\u6b63\u5411\u67e5\u8be2\u7684\u9700\u6c42\uff1a\u67e5\u8be2\u4f5c\u8005egon\u7684\u624b\u673a\u53f7\uff0c\u5982\u679c\u6211\u4eec\u9009\u53d6\u7684\u57fa\u8868\u662fAuthorDetail\uff0c\u90a3\u4e48\u5c31\u6210\u4e86\u53cd\u5411\u67e5\u8be2\uff0c\u5e94\u8be5\u7528\u53cd\u5411\u67e5\u8be2\u7684\u8bed\u6cd5\nres = AuthorDetail.objects.filter(author__name=&#039;egon&#039;).values(&#039;tel&#039;).first()\nprint(res)  # {&#039;tel&#039;: &#039;18611312331&#039;}\n\n# 2\u3001\u9488\u5bf9\u4e0a\u4f8b\u4e2d\u53cd\u5411\u67e5\u8be2\u7684\u9700\u6c42\uff1a\u67e5\u8be2\u624b\u673a\u53f7\u4e3a&#039;18611312331&#039;\u7684\u4f5c\u8005\u540d\uff0c\u5982\u679c\u6211\u4eec\u9009\u53d6\u7684\u57fa\u8868\u662fAuthor\uff0c\u90a3\u4e48\u5c31\u6210\u4e86\u6b63\u5411\u67e5\u8be2\uff0c\u5e94\u8be5\u7528\u6b63\u5411\u67e5\u8be2\u7684\u8bed\u6cd5\nres=Author.objects.filter(author_detail__tel=&#039;18611312331&#039;).values(&#039;name&#039;).first()\nprint(res) # {&#039;name&#039;: &#039;egon&#039;}<\/code><\/pre>\n<h5>1.2\u3001\u591a\u5bf9\u4e00\u67e5\u8be2\uff08\u6a21\u578b\u7c7bBook\u4e0ePublish\uff09<\/h5>\n<p>\u6b63\u5411\u67e5\u8be2\uff0c\u6309\u5173\u8054\u5b57\u6bb5+\u53cc\u4e0b\u5212\u7ebf\uff1apublish__<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u67e5\u8be2\u8475\u82b1\u5b9d\u5178\u7684\u51fa\u7248\u793e\u540d\u5b57\n# \u6ce8\u610fvalues()\u4e2d\u7684\u53c2\u6570\u662f\uff1a\u5173\u8054\u5b57\u6bb5\u540d__\u8981\u53d6\u7684\u90a3\u5f20\u88ab\u5173\u8054\u8868\u4e2d\u7684\u5b57\u6bb5\nres=Book.objects.filter(title=&#039;\u8475\u82b1\u5b9d\u5178&#039;).values(&#039;publish__name&#039;).first()\nprint(res[&#039;publish__name&#039;]) # {&#039;publish__name&#039;: &#039;\u5317\u4eac\u51fa\u7248\u793e&#039;}<\/code><\/pre>\n<p>\u53cd\u5411\u67e5\u8be2\uff0c\u6309\u6a21\u578b\u540d(\u5c0f\u5199)+\u53cc\u4e0b\u5212\u7ebf\uff1abook__<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u67e5\u8be2\u5317\u4eac\u51fa\u7248\u793e\u90fd\u51fa\u7248\u7684\u6240\u6709\u4e66\u7c4d\u540d\u5b57\n# \u6ce8\u610fvalues()\u4e2d\u7684\u53c2\u6570\u662f\uff1a\u5c0f\u5199\u7684\u6a21\u578b\u540d__\u8981\u53d6\u7684\u90a3\u5f20\u88ab\u5173\u8054\u8868\u4e2d\u7684\u5b57\u6bb5\nres = Publish.objects.filter(name=&#039;\u5317\u4eac\u51fa\u7248\u793e&#039;).values(&#039;book__title&#039;)\nprint(res)  # &lt;QuerySet [{&#039;book__title&#039;: &#039;\u8475\u82b1\u5b9d\u5178&#039;}, {&#039;book__title&#039;: &#039;\u83ca\u82b1\u5b9d\u5178&#039;}, {&#039;book__title&#039;: &#039;\u6843\u82b1\u5b9d\u5178&#039;}]&gt;<\/code><\/pre>\n<p>\u8865\u5145\uff1a\u57fa\u8868\u51b3\u5b9a\u4e86\u6b63\u5411\u8fd8\u662f\u53cd\u5411<\/p>\n<pre><code class=\"language-python\"># 1\u3001\u9488\u5bf9\u4e0a\u4f8b\u4e2d\u6b63\u5411\u67e5\u8be2\u7684\u9700\u6c42\uff1a\u67e5\u8be2\u8475\u82b1\u5b9d\u5178\u7684\u51fa\u7248\u793e\u540d\u5b57\uff0c\u5982\u679c\u6211\u4eec\u9009\u53d6\u7684\u57fa\u8868\u662fPublish\uff0c\u90a3\u4e48\u5c31\u6210\u4e86\u53cd\u5411\u67e5\u8be2\uff0c\u5e94\u8be5\u7528\u53cd\u5411\u67e5\u8be2\u7684\u8bed\u6cd5\nres = Publish.objects.filter(book__title=&#039;\u8475\u82b1\u5b9d\u5178&#039;).values(&#039;name&#039;).first()\nprint(res)  # {&#039;name&#039;: &#039;\u5317\u4eac\u51fa\u7248\u793e&#039;}\n\n# 2\u3001\u9488\u5bf9\u4e0a\u4f8b\u4e2d\u53cd\u5411\u67e5\u8be2\u7684\u9700\u6c42\uff1a\u67e5\u8be2\u5317\u4eac\u51fa\u7248\u793e\u90fd\u51fa\u7248\u7684\u6240\u6709\u4e66\u7c4d\u540d\u5b57\uff0c\u5982\u679c\u6211\u4eec\u9009\u53d6\u7684\u57fa\u8868\u662fBook\uff0c\u90a3\u4e48\u5c31\u6210\u4e86\u6b63\u5411\u67e5\u8be2\uff0c\u5e94\u8be5\u7528\u6b63\u5411\u67e5\u8be2\u7684\u8bed\u6cd5\nres=Book.objects.filter(publish__name=&#039;\u5317\u4eac\u51fa\u7248\u793e&#039;).values(&#039;title&#039;)\nprint(res) # &lt;QuerySet [{&#039;title&#039;: &#039;\u8475\u82b1\u5b9d\u5178&#039;}, {&#039;title&#039;: &#039;\u83ca\u82b1\u5b9d\u5178&#039;}, {&#039;title&#039;: &#039;\u6843\u82b1\u5b9d\u5178&#039;}]&gt;<\/code><\/pre>\n<h5>1.3\u3001\u591a\u5bf9\u591a\u67e5\u8be2\uff08\u6a21\u578b\u7c7bBook\u4e0eAuthor\uff09<\/h5>\n<p>\u6b63\u5411\u67e5\u8be2\uff0c\u6309\u5173\u8054\u5b57\u6bb5+\u53cc\u4e0b\u5212\u7ebf\uff1aauthors__<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u67e5\u8be2\u8475\u82b1\u5b9d\u5178\u7684\u6240\u6709\u4f5c\u8005\n# \u6ce8\u610fvalues()\u4e2d\u7684\u53c2\u6570\u662f\uff1a\u5173\u8054\u5b57\u6bb5\u540d__\u8981\u53d6\u7684\u90a3\u5f20\u88ab\u5173\u8054\u8868\u4e2d\u7684\u5b57\u6bb5\nres=Book.objects.filter(title=&#039;\u8475\u82b1\u5b9d\u5178&#039;).values(&#039;authors__name&#039;)\nprint(res) # &lt;QuerySet [{&#039;authors__name&#039;: &#039;egon&#039;}, {&#039;authors__name&#039;: &#039;kevin&#039;}]&gt; <\/code><\/pre>\n<p>\u53cd\u5411\u67e5\u8be2\uff0c\u6309\u6a21\u578b\u540d(\u5c0f\u5199)+\u53cc\u4e0b\u5212\u7ebf\uff1a\u5982book__<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c42\uff1a\u67e5\u8be2\u4f5c\u8005rose\u51fa\u7248\u7684\u6240\u6709\u4e66\u7c4d\n# \u6ce8\u610fvalues()\u4e2d\u7684\u53c2\u6570\u662f\uff1a\u5c0f\u5199\u7684\u6a21\u578b\u540d__\u8981\u53d6\u7684\u90a3\u5f20\u88ab\u5173\u8054\u8868\u4e2d\u7684\u5b57\u6bb5\nres = Author.objects.filter(name=&#039;rose&#039;).values(&#039;book__title&#039;)\nprint(res) # &lt;QuerySet [{&#039;book__title&#039;: &#039;\u7389\u5973\u5fc3\u7ecf&#039;}, {&#039;book__title&#039;: &#039;\u4e5d\u9634\u771f\u7ecf&#039;}, {&#039;book__title&#039;: &#039;\u7389\u7537\u5fc3\u7ecf&#039;}]&gt;<\/code><\/pre>\n<p>\u8865\u5145\uff1a\u57fa\u8868\u51b3\u5b9a\u4e86\u6b63\u5411\u8fd8\u662f\u53cd\u5411<\/p>\n<pre><code class=\"language-python\"># 1\u3001\u9488\u5bf9\u4e0a\u4f8b\u4e2d\u6b63\u5411\u67e5\u8be2\u7684\u9700\u6c42\uff1a\u67e5\u8be2\u8475\u82b1\u5b9d\u5178\u7684\u6240\u6709\u4f5c\u8005\uff0c\u5982\u679c\u6211\u4eec\u9009\u53d6\u7684\u57fa\u8868\u662fauthors\uff0c\u90a3\u4e48\u5c31\u6210\u4e86\u53cd\u5411\u67e5\u8be2\uff0c\u5e94\u8be5\u7528\u53cd\u5411\u67e5\u8be2\u7684\u8bed\u6cd5\nres=Author.objects.filter(book__title=&#039;\u8475\u82b1\u5b9d\u5178&#039;).values(&#039;name&#039;)\nprint(res) # &lt;QuerySet [{&#039;name&#039;: &#039;egon&#039;}, {&#039;name&#039;: &#039;kevin&#039;}]&gt;\n\n# 2\u3001\u9488\u5bf9\u4e0a\u4f8b\u4e2d\u53cd\u5411\u67e5\u8be2\u7684\u9700\u6c42\uff1a\u67e5\u8be2\u4f5c\u8005rose\u51fa\u7248\u7684\u6240\u6709\u4e66\u7c4d\uff0c\u5982\u679c\u6211\u4eec\u9009\u53d6\u7684\u57fa\u8868\u662fBook\uff0c\u90a3\u4e48\u5c31\u6210\u4e86\u6b63\u5411\u67e5\u8be2\uff0c\u5e94\u8be5\u7528\u6b63\u5411\u67e5\u8be2\u7684\u8bed\u6cd5\nres=Book.objects.filter(authors__name=&#039;rose&#039;).values(&#039;title&#039;)\nprint(res) # &lt;QuerySet [{&#039;title&#039;: &#039;\u7389\u5973\u5fc3\u7ecf&#039;}, {&#039;title&#039;: &#039;\u4e5d\u9634\u771f\u7ecf&#039;}, {&#039;title&#039;: &#039;\u7389\u7537\u5fc3\u7ecf&#039;}]&gt;<\/code><\/pre>\n<h4>2\u3001\u8fde\u7eed\u8de8&gt;2\u5f20\u8868\u67e5\u8be2<\/h4>\n<p>\u8fde\u7eed\u8de8&gt;2\u5f20\u8868\u7684\u64cd\u4f5c\u7684\u5957\u8def\u4e0e\u4e0a\u9762\u7684\u6848\u4f8b\u90fd\u662f\u4e00\u6837\u7684,\u53ef\u4ee5\u8fde\u7eed\u63a5n\u4e2a\u53cc\u4e0b\u5212\u7ebf\uff0c\u53ea\u9700\u8981\u5728\u6bcf\u6b21\u8fde\u53cc\u4e0b\u5212\u7ebf\u65f6\uff0c\u786e\u5b9a\u662f\u6b63\u5411\u8fd8\u662f\u53cd\u5411\u5373\u53ef<\/p>\n<pre><code class=\"language-python\"># \u9700\u6c421\uff1a\u67e5\u8be2\u5317\u4eac\u51fa\u7248\u793e\u51fa\u7248\u8fc7\u7684\u6240\u6709\u4e66\u7c4d\u7684\u540d\u5b57\u4ee5\u53ca\u4f5c\u8005\u7684\u59d3\u540d\u3001\u624b\u673a\u53f7\n# \u65b9\u5f0f\u4e00\uff1a\u57fa\u8868\u4e3aPublish\nres=Publish.objects.filter(name=&#039;\u5317\u4eac\u51fa\u7248\u793e&#039;).values_list(&#039;book__title&#039;,&#039;book__authors__name&#039;,&#039;book__authors__author_detail__tel&#039;)\n\n# \u65b9\u5f0f\u4e8c\uff1a\u57fa\u8868\u4e3aBook\nres=Book.objects.filter(publish__name=&#039;\u5317\u4eac\u51fa\u7248\u793e&#039;).values_list(&#039;title&#039;,&#039;authors__name&#039;,&#039;authors__author_detail__tel&#039;)\n\n# \u5faa\u73af\u6253\u5370\u7ed3\u679c\u5747\u4e3a\nfor obj in res:\n    print(obj)\n&#039;&#039;&#039;\n\u8f93\u51fa\uff1a\n(&#039;\u8475\u82b1\u5b9d\u5178&#039;, &#039;egon&#039;, &#039;18611312331&#039;)\n(&#039;\u83ca\u82b1\u5b9d\u5178&#039;, &#039;egon&#039;, &#039;18611312331&#039;)\n(&#039;\u6843\u82b1\u5b9d\u5178&#039;, &#039;egon&#039;, &#039;18611312331&#039;)\n(&#039;\u8475\u82b1\u5b9d\u5178&#039;, &#039;kevin&#039;, &#039;15033413881&#039;)\n(&#039;\u83ca\u82b1\u5b9d\u5178&#039;, &#039;kevin&#039;, &#039;15033413881&#039;)\n(&#039;\u6843\u82b1\u5b9d\u5178&#039;, &#039;kevin&#039;, &#039;15033413881&#039;)\n(&#039;\u83ca\u82b1\u5b9d\u5178&#039;, &#039;rose&#039;, &#039;13011453220&#039;)\n&#039;&#039;&#039;\n\n# \u9700\u6c422\uff1a\u67e5\u8be2\u624b\u673a\u53f7\u4ee5186\u5f00\u5934\u7684\u4f5c\u8005\u51fa\u7248\u8fc7\u7684\u6240\u6709\u4e66\u7c4d\u540d\u79f0\u4ee5\u53ca\u51fa\u7248\u793e\u540d\u79f0\n# \u65b9\u5f0f\u4e00\uff1a\u57fa\u8868\u4e3aAuthorDetail\nres=AuthorDetail.objects.filter(tel__startswith=&#039;186&#039;).values_list(&#039;author__book__title&#039;,&#039;author__book__publish__name&#039;)\n\n# \u65b9\u5f0f\u4e8c\uff1a\u57fa\u8868\u4e3aBook\nres=Book.objects.filter(authors__author_detail__tel__startswith=&#039;186&#039;).values_list(&#039;title&#039;,&#039;publish__name&#039;)\n\n# \u65b9\u5f0f\u4e09\uff1a\u57fa\u8868\u4e3aPublish\nres=Publish.objects.filter(book__authors__author_detail__tel__startswith=&#039;186&#039;).values_list(&#039;book__title&#039;,&#039;name&#039;)\n\n# \u5faa\u73af\u6253\u5370\u7ed3\u679c\u5747\u4e3a\nfor obj in res:\n    print(obj)\n&#039;&#039;&#039;\n\u8f93\u51fa\uff1a\n(&#039;\u8475\u82b1\u5b9d\u5178&#039;, &#039;\u5317\u4eac\u51fa\u7248\u793e&#039;)\n(&#039;\u83ca\u82b1\u5b9d\u5178&#039;, &#039;\u5317\u4eac\u51fa\u7248\u793e&#039;)\n(&#039;\u6843\u82b1\u5b9d\u5178&#039;, &#039;\u5317\u4eac\u51fa\u7248\u793e&#039;)\n(&#039;\u4e5d\u9634\u771f\u7ecf&#039;, &#039;\u5927\u8fde\u51fa\u7248\u793e&#039;)\n&#039;&#039;&#039;<\/code><\/pre>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-9.png'><img class=\"lazyload lazyload-style-2\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  data-original=\"https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c-9.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Django\u4e4b\u6a21\u578b\u5c42\u7b2c\u4e8c\u7bc7\uff1a\u591a\u8868\u64cd\u4f5c \u4e00 \u8868\u5173\u7cfb\u56de\u987e \u200b \u5728\u8bb2\u89e3MySQL\u65f6\uff0c\u6211\u4eec\u63d0\u5230\uff0c\u628a\u5e94\u7528\u7a0b\u5e8f\u7684\u6240\u6709\u6570\u636e\u90fd [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[385,389],"tags":[],"_links":{"self":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts\/5783"}],"collection":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5783"}],"version-history":[{"count":0,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts\/5783\/revisions"}],"wp:attachment":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}