{"id":787,"date":"2026-08-03T19:56:54","date_gmt":"2026-08-03T11:56:54","guid":{"rendered":"https:\/\/mitongxue.cn\/?p=787"},"modified":"2026-08-03T19:56:54","modified_gmt":"2026-08-03T11:56:54","slug":"sqlalchemy-%e6%8f%90%e4%be%9b%e4%ba%86%e5%87%a0%e7%a7%8d%e6%93%8d%e4%bd%9c%e6%95%b0%e6%8d%ae%e7%9a%84%e6%96%b9%e5%bc%8f","status":"publish","type":"post","link":"https:\/\/mitongxue.cn\/index.php\/2026\/08\/03\/sqlalchemy-%e6%8f%90%e4%be%9b%e4%ba%86%e5%87%a0%e7%a7%8d%e6%93%8d%e4%bd%9c%e6%95%b0%e6%8d%ae%e7%9a%84%e6%96%b9%e5%bc%8f\/","title":{"rendered":"SQLAlchemy \u63d0\u4f9b\u4e86\u51e0\u79cd\u64cd\u4f5c\u6570\u636e\u7684\u65b9\u5f0f"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">\u65b9\u5f0f\u2460 ORM \u5bf9\u8c61\u6a21\u5f0f\uff08Session.add\/delete\uff09<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>product = Product(name=\"xxx\")\nsession.add(product)\nawait session.commit()\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u539f\u7406\uff1a\u5229\u7528 Session \u53d8\u66f4\u8ffd\u8e2a\u3001Unit of Work\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2705\u9002\u7528\uff1a\u4e1a\u52a1 CRUD\u3001\u9700\u8981\u64cd\u4f5c<code>relationship<\/code>\u591a\u5bf9\u591a \/ \u4e00\u5bf9\u591a\u3001\u9886\u57df\u6a21\u578b\u3001\u9700\u8981\u5bf9\u8c61\u7f13\u5b58\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u274c\u4e0d\u9002\u5408\uff1a\u5927\u6279\u91cf\u6570\u636e\u5bfc\u5165\u3001\u590d\u6742\u7edf\u8ba1\u62a5\u8868\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u65b9\u5f0f\u2461 Core \u8868\u8fbe\u5f0f\u8bed\u6cd5\uff08select \/insert\/update \/delete\uff09<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>stmt = select(Product).where(Product.id == 1)\nstmt = insert(Product).values(...)\nawait session.execute(stmt)\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u2705\u9002\u7528\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6279\u91cf\u63d2\u5165\u3001\u590d\u6742\u67e5\u8be2\u3001\u52a8\u6001\u6761\u4ef6\u62fc\u63a5\u3001\u4e0d\u60f3\u6784\u9020 ORM \u5bf9\u8c61\uff1b<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u65e2\u80fd\u5728 <code>Session<\/code> \u8fd0\u884c\uff0c\u4e5f\u80fd\u76f4\u63a5\u5728 <code>Connection<\/code> \u5e95\u5c42\u8fd0\u884c\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u65b9\u5f0f\u2462 \u539f\u751f SQL text ()<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>from sqlalchemy import text\nsql = text(\"SELECT * FROM product WHERE id=:pid\")\nawait conn.execute(sql, {\"pid\":1})\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u2705\u9002\u7528\uff1a\u6781\u5ea6\u590d\u6742 SQL\u3001\u5b58\u50a8\u8fc7\u7a0b\u3001\u6570\u636e\u5e93\u7279\u6709\u8bed\u6cd5\u3001\u8fc1\u79fb\u811a\u672c\u3002<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u89c4\u8303\u5efa\u8bae\uff1a\u4e1a\u52a1\u63a5\u53e3\u4f18\u5148\u300cORM \u5bf9\u8c61 \/ Core \u8868\u8fbe\u5f0f\u300d\uff1b\u5c3d\u91cf\u5c11\u624b\u5199 text \u539f\u751f SQL\u3002<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u65b9\u5f0f\u2460 ORM \u5bf9\u8c61\u6a21\u5f0f\uff08Session.add\/..<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[52,14],"tags":[58,54],"class_list":["post-787","post","type-post","status-publish","format-standard","hentry","category-python","category-back","tag-fastapi","tag-python"],"featured_image_urls":{"full":"","thumbnail":"","medium":"","medium_large":"","large":"","1536x1536":"","2048x2048":""},"author_info":{"info":["\u9648 \u67d0\u4eba"]},"category_info":"<a href=\"https:\/\/mitongxue.cn\/index.php\/category\/back\/python\/\" rel=\"category tag\">Python<\/a> <a href=\"https:\/\/mitongxue.cn\/index.php\/category\/back\/\" rel=\"category tag\">\u540e\u7aef<\/a>","tag_info":"\u540e\u7aef","comment_count":"0","_links":{"self":[{"href":"https:\/\/mitongxue.cn\/index.php\/wp-json\/wp\/v2\/posts\/787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mitongxue.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mitongxue.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mitongxue.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mitongxue.cn\/index.php\/wp-json\/wp\/v2\/comments?post=787"}],"version-history":[{"count":1,"href":"https:\/\/mitongxue.cn\/index.php\/wp-json\/wp\/v2\/posts\/787\/revisions"}],"predecessor-version":[{"id":788,"href":"https:\/\/mitongxue.cn\/index.php\/wp-json\/wp\/v2\/posts\/787\/revisions\/788"}],"wp:attachment":[{"href":"https:\/\/mitongxue.cn\/index.php\/wp-json\/wp\/v2\/media?parent=787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mitongxue.cn\/index.php\/wp-json\/wp\/v2\/categories?post=787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mitongxue.cn\/index.php\/wp-json\/wp\/v2\/tags?post=787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}