{"id":942,"date":"2026-05-26T23:13:33","date_gmt":"2026-05-26T15:13:33","guid":{"rendered":"https:\/\/junai.ai\/blog\/fastapi-db-sqlalchemy-7\/"},"modified":"2026-05-26T23:13:33","modified_gmt":"2026-05-26T15:13:33","slug":"fastapi-db-sqlalchemy-7","status":"publish","type":"post","link":"https:\/\/junai.ai\/blog\/fastapi-db-sqlalchemy-7\/","title":{"rendered":"FastAPI \ub370\uc774\ud130\ubca0\uc774\uc2a4 \u2014 SQLAlchemy \uc5f0\ub3d9"},"content":{"rendered":"\n<!-- WordPress REST API \ubc1c\ud589\uc6a9 HTML (\uc790\ub3d9 \uc0dd\uc131) -->\n<!-- WP-FEATURED-MEDIA-ID: 929 -->\n<div style=\"max-width:800px;margin:0 auto;\">\n<style>\n:root {--color-primary:#00897b;--color-accent:#009688;--color-bg:#fafbfc;--color-bg-card:#fff;--color-text:#1a202c;--color-text-muted:#64748b;--hero-start:#004d40;--hero-end:#00897b;}\n*{box-sizing:border-box;}\n.container{max-width:760px;margin:0 auto;padding:0 24px 80px;}\n.hero{background:linear-gradient(135deg,var(--hero-start) 0%,var(--hero-end) 100%);color:#fff;padding:80px 24px 60px;text-align:center;}\n.hero .eyebrow{display:inline-block;font-size:14px;color:#80cbc4;font-weight:700;letter-spacing:0.1em;text-transform:uppercase;margin-bottom:14px;}\n.hero h1{font-size:36px;margin:0 0 16px;line-height:1.3;font-weight:800;}\n.hero p{color:#b2dfdb;font-size:18px;max-width:640px;margin:0 auto;line-height:1.6;}\n.hero img{width:100%;max-width:640px;height:auto;margin:32px auto 0;border-radius:10px;display:block;}\narticle{padding-top:48px;}\narticle h2{font-size:26px;margin:56px 0 20px;padding-left:14px;border-left:5px solid var(--color-accent);line-height:1.4;}\narticle h3{font-size:19px;margin:32px 0 12px;color:var(--color-primary);}\narticle p{margin:16px 0;}\narticle strong{color:var(--color-primary);font-weight:700;}\narticle code{background:#b2dfdb;padding:2px 8px;border-radius:4px;font-family:'SF Mono',Menlo,Consolas,monospace;font-size:14px;color:#004d40;}\n.databox{background:#b2dfdb;border-left:4px solid var(--color-accent);padding:16px 20px;margin:24px 0;border-radius:0 8px 8px 0;font-size:15.5px;}\n.databox strong{color:var(--color-primary);}\n.warnbox{background:linear-gradient(135deg,#fef3c7 0%,#fde68a 100%);padding:16px 20px;margin:24px 0;border-radius:8px;font-size:15.5px;}\n.tablewrap{overflow-x:auto;-webkit-overflow-scrolling:touch;margin:22px 0;}\ntable{width:100%;border-collapse:collapse;font-size:15px;background:var(--color-bg-card);}\nth,td{padding:11px 12px;text-align:left;border-bottom:1px solid #e2e8f0;vertical-align:top;}\nth{background:#f1f5f9;font-weight:700;color:#0f172a;}\ntd:first-child,th:first-child{font-weight:700;}\n@media (max-width:560px){.tablewrap table,.tablewrap thead,.tablewrap tbody,.tablewrap tr,.tablewrap th,.tablewrap td{display:block;width:auto;}.tablewrap thead{display:none;}.tablewrap tr{margin:0 0 14px;border:1px solid #e2e8f0;border-radius:10px;overflow:hidden;}.tablewrap td{border:none;border-bottom:1px solid #f1f5f9;padding:9px 14px;}.tablewrap td:first-child{background:#f1f5f9;font-weight:800;font-size:15.5px;}.tablewrap td:last-child{border-bottom:none;}.tablewrap td[data-label]::before{content:attr(data-label) \" \u2014 \";font-weight:700;color:var(--color-primary);}}\n.code-block{background:#0f172a;color:#e2e8f0;padding:16px 20px;border-radius:8px;font-family:'SF Mono',Menlo,Consolas,monospace;font-size:14px;line-height:1.6;margin:20px 0;overflow-x:auto;white-space:pre;}\n.cta{background:linear-gradient(135deg,#00897b 0%,#009688 100%);color:#fff;padding:28px 24px;border-radius:12px;margin:48px 0 0;text-align:center;}\n.cta h3{color:#fff;margin:0 0 8px;font-size:20px;}\n.cta p{color:#b2dfdb;margin:0;font-size:15.5px;}\n.footer-nav{margin-top:32px;padding-top:20px;border-top:1px solid #e2e8f0;font-size:14px;color:var(--color-text-muted);}\n.footer-nav a{color:var(--color-primary);text-decoration:none;}\n@media (max-width:480px){.hero h1{font-size:26px;}.hero p{font-size:16px;}article h2{font-size:21px;}article h3{font-size:17px;}body{font-size:16px;}}\n<\/style>\n<section class=\"hero\">\n  <span class=\"eyebrow\">FastAPI \uad50\uc7ac \u00b7 7\ud3b8 \u00b7 \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/span>\n  <h1>FastAPI \ub370\uc774\ud130\ubca0\uc774\uc2a4 \u2014 SQLAlchemy \uc5f0\ub3d9<\/h1>\n  <p>\uc11c\ubc84\ub97c \ub044\uba74 \ub370\uc774\ud130\uac00 \ud1b5\uc9f8\ub85c \uc0ac\ub77c\uc9c4\ub2e4\uba74, \uadf8\uac74 \uc544\uc9c1 \uc9c4\uc9dc \uc800\uc7a5\uc774 \uc544\ub2c8\ub2e4. SQLAlchemy \ub85c \ud30c\uc77c DB \ub97c \ubd99\uc5ec \ub370\uc774\ud130\ub97c \uc601\uad6c\ud788 \ub0a8\uaca8 \ubcf4\uc790.<\/p>\n  <img decoding=\"async\" src=\"https:\/\/junai.ai\/blog\/wp-content\/uploads\/2026\/05\/hero-5-104.jpg\" alt=\"\ud30c\uc774\uc36c \uc11c\ubc84\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2e4\ub9b0\ub354\uc5d0 \uc5f0\uacb0\ub418\uc5b4 \ud30c\uc774\uc36c \ud074\ub798\uc2a4 \uac1d\uccb4\ub97c \ud14c\uc774\ube14\uc5d0 \ub9e4\ud551\ud558\uace0 \ub370\uc774\ud130\uac00 \uc601\uad6c \uc800\uc7a5\ub418\ub294 SQLAlchemy ORM \ucee8\uc149 \uc544\uc774\uc18c\uba54\ud2b8\ub9ad \uc77c\ub7ec\uc2a4\ud2b8\">\n<\/section>\n\n<div class=\"container\">\n<article>\n\n<p>\uc9c0\uae08\uae4c\uc9c0 \uc6b0\ub9ac\uac00 \ub9cc\ub4e0 API \ub4e4\uc740 \ub370\uc774\ud130\ub97c \uc5b4\ub514\uc5d0 \ub2f4\uc544 \ub480\uc744\uae4c. \uc194\uc9c1\ud788 \ub9d0\ud558\uba74 <strong>\ud30c\uc774\uc36c \ubcc0\uc218<\/strong> \uc548\uc5d0 \ub2f4\uc544 \ub480\ub2e4. <code>items = []<\/code> \uac19\uc740 \ub9ac\uc2a4\ud2b8, <code>users = {}<\/code> \uac19\uc740 \ub515\uc154\ub108\ub9ac\uc5d0 \ucc28\uace1\ucc28\uace1 \ub123\uace0 \ube7c\uba74\uc11c &#8220;\uc800\uc7a5\ub410\ub2e4&#8221; \uace0 \uc5ec\uacbc\ub2e4. \uc785\ubb38 \ub2e8\uacc4\uc5d0\uc11c\ub294 \ucda9\ubd84\ud788 \uc88b\uc740 \ubc29\ubc95\uc774\uace0, \uac1c\ub150\uc744 \uc775\ud788\ub294 \ub370 \uad70\ub354\ub354\uae30\uac00 \uc5c6\ub2e4.<\/p>\n\n<p>\uadf8\ub7f0\ub370 \uac70\uae30\uc5d0\ub294 \uce58\uba85\uc801\uc778 \ud568\uc815\uc774 \ud558\ub098 \uc788\ub2e4. 7\ud3b8\uc740 \uadf8 \ud568\uc815\uc744 \uc815\uba74\uc73c\ub85c \ub2e4\ub8ec\ub2e4. <strong>\ub370\uc774\ud130\ubca0\uc774\uc2a4<\/strong> \u2014 \uc774\ub984\uc740 \uac70\ucc3d\ud558\uc9c0\ub9cc, 5\ud3b8\uc5d0\uc11c \ub9db\ubcf8 <code>get_db<\/code> \ud328\ud134\uc744 \ub5a0\uc62c\ub9ac\uba74 \uc808\ubc18\uc740 \uc774\ubbf8 \uc640 \uc788\ub2e4. \uc774\ubc88 \ud3b8\uc744 \ub9c8\uce58\uba74 SQLite \ud30c\uc77c \ud558\ub098\ub85c \uc9c4\uc9dc DB \ub97c \ubd99\uc774\uace0, \uc11c\ubc84\ub97c \uaed0\ub2e4 \ucf1c\ub3c4 \ub370\uc774\ud130\uac00 \uadf8\ub300\ub85c \ub0a8\uc544 \uc788\ub294 API \ub97c \uac16\uac8c \ub41c\ub2e4.<\/p>\n\n<h2>1. \uc65c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ud544\uc694\ud55c\uac00 \u2014 \ub9ac\uc2a4\ud2b8\ub294 \ud718\ubc1c\ud55c\ub2e4<\/h2>\n\n<p>\ub2e4\uc74c \ucf54\ub4dc\ub294 \ub204\uad6c\ub098 \ud55c \ubc88\ucbe4 \uc9dc \ubcf8 &#8220;\uba54\ubaa8\ub9ac \uc800\uc7a5&#8221; \ubc29\uc2dd\uc774\ub2e4. \ud68c\uc6d0\uc744 \ub9ac\uc2a4\ud2b8\uc5d0 \ub2f4\uace0, \uc870\ud68c\ud558\uba74 \uadf8 \ub9ac\uc2a4\ud2b8\ub97c \ub3cc\ub824\uc900\ub2e4.<\/p>\n\n<div class=\"code-block\">users = []  # \uadf8\ub0e5 \ud30c\uc774\uc36c \ub9ac\uc2a4\ud2b8\n\n@app.post(&#8220;\/users&#8221;)\ndef create_user(name: str):\n    users.append({&#8220;name&#8221;: name})\n    return {&#8220;saved&#8221;: name}\n\n@app.get(&#8220;\/users&#8221;)\ndef list_users():\n    return users   # \uc798 \ub3d9\uc791\ud558\ub294 \uac83\ucc98\ub7fc \ubcf4\uc778\ub2e4<\/div>\n\n<p>\uc774 \ucf54\ub4dc\ub294 \uc798 \ub3c8\ub2e4. \ud68c\uc6d0\uc744 \ucd94\uac00\ud558\uba74 \ub9ac\uc2a4\ud2b8\uc5d0 \uc313\uc774\uace0, \uc870\ud68c\ud558\uba74 \uadf8\ub300\ub85c \ub098\uc628\ub2e4. \ubb38\uc81c\ub294 <strong>\uc11c\ubc84\ub97c \ud55c \ubc88 \uaed0\ub2e4 \ucf1c\ub294 \uc21c\uac04<\/strong> \ub4dc\ub7ec\ub09c\ub2e4. \ucf54\ub4dc \uc218\uc815, \ubc30\ud3ec, \uc11c\ubc84 \uc7ac\uc2dc\uc791, \ub2e8\uc21c\ud55c \ud06c\ub798\uc2dc \u2014 \ubb34\uc5c7\uc774\ub4e0 \ud504\ub85c\uc138\uc2a4\uac00 \ub2e4\uc2dc \ub728\uba74 \uadf8 <code>users = []<\/code> \ub294 \ube48 \ub9ac\uc2a4\ud2b8\ub85c \ucd08\uae30\ud654\ub41c\ub2e4. \uc5b4\uc81c \uac00\uc785\ud55c \ud68c\uc6d0 1,000\uba85\uc774 \ud754\uc801\ub3c4 \uc5c6\uc774 \uc0ac\ub77c\uc9c4\ub2e4.<\/p>\n\n<p>\uc774\uc720\ub294 \ub2e8\uc21c\ud558\ub2e4. \ud30c\uc774\uc36c \ubcc0\uc218\ub294 <strong>\ub7a8(\uba54\ubaa8\ub9ac)<\/strong> \uc5d0 \uc0b0\ub2e4. \uba54\ubaa8\ub9ac\ub294 \ube60\ub974\uc9c0\ub9cc \ud718\ubc1c\uc131\uc774\ub2e4. \uc804\uc6d0\uc774 \ub04a\uae30\uac70\ub098 \ud504\ub85c\uc138\uc2a4\uac00 \uc8fd\uc73c\uba74 \ub0b4\uc6a9\ubb3c\uc774 \ud1b5\uc9f8\ub85c \ub0a0\uc544\uac04\ub2e4. \ub370\uc774\ud130\ub97c <strong>\uc624\ub798 \uc0b4\ub9ac\ub824\uba74 \ub514\uc2a4\ud06c\uc5d0 \uc801\uc5b4 \ub450\uc5b4\uc57c<\/strong> \ud558\uace0, \uadf8 \uc77c\uc744 \uc548\uc804\ud558\uace0 \ube60\ub974\uac8c \ud574 \uc8fc\ub294 \uc804\ubb38 \ub3c4\uad6c\uac00 \ubc14\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub2e4.<\/p>\n\n<div class=\"databox\">\n<strong>\uc65c \uadf8\ub0e5 \ud30c\uc77c\uc774 \uc544\ub2c8\ub77c DB \uc778\uac00<\/strong> \u2014 &#8220;\uadf8\ub7fc \ud14d\uc2a4\ud2b8 \ud30c\uc77c\uc5d0 \uc800\uc7a5\ud558\uba74 \ub418\uc796\uc544?&#8221; \ub77c\uace0 \ud560 \uc218 \uc788\ub2e4. \uac00\ub2a5\uc740 \ud558\ub2e4. \ud558\uc9c0\ub9cc \ub3d9\uc2dc\uc5d0 \ub450 \uc694\uccad\uc774 \uac19\uc740 \ud30c\uc77c\uc744 \uc4f0\uba74 \ub0b4\uc6a9\uc774 \uae68\uc9c0\uace0(\ub3d9\uc2dc\uc131), 100\ub9cc \uac74 \uc911 \ud55c \uba85\uc744 \ucc3e\uc73c\ub824\uba74 \ud30c\uc77c \uc804\uccb4\ub97c \uc77d\uc5b4\uc57c \ud558\uba70(\uac80\uc0c9 \uc18d\ub3c4), \uc4f0\ub2e4\uac00 \uba48\ucd94\uba74 \uc808\ubc18\ub9cc \uc801\ud78c\ub2e4(\ubb34\uacb0\uc131). \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc774 \uc138 \ubb38\uc81c\ub97c \ucc98\uc74c\ubd80\ud130 \ud574\uacb0\ud574 \ub454 \uc800\uc7a5 \uc804\ubb38\uac00\ub2e4.\n<\/div>\n\n<p>\uc774\ubc88 \ud3b8\uc740 \uac00\uc7a5 \uac00\ubcbc\uc6b4 <strong>SQLite<\/strong> \ub85c \uc2dc\uc791\ud55c\ub2e4. SQLite \ub294 \ubcc4\ub3c4 \uc11c\ubc84 \ud504\ub85c\uadf8\ub7a8\uc744 \uae54 \ud544\uc694 \uc5c6\uc774 <strong>\ud30c\uc77c \ud558\ub098\uac00 \uace7 \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/strong> \uc778 \ub0b4\uc7a5\ud615 DB \ub2e4. \ud30c\uc774\uc36c\uc5d0 \uae30\ubcf8 \ud3ec\ud568\ub3fc \uc788\uc5b4 \uc124\uce58\ub3c4 \ud544\uc694 \uc5c6\uace0, <code>app.db<\/code> \ub77c\ub294 \ud30c\uc77c \ud55c \uac1c\uc5d0 \ubaa8\ub4e0 \ud14c\uc774\ube14\uacfc \ub370\uc774\ud130\uac00 \ub2f4\uae34\ub2e4. \ud559\uc2b5\uacfc \uc18c\uaddc\ubaa8 \uc11c\ube44\uc2a4\uc5d0 \uc644\ubcbd\ud558\uace0, \ub098\uc911\uc5d0 PostgreSQL\u00b7MySQL \ub85c \uac08\uc544\ud0c8 \ub54c\ub3c4 \ucf54\ub4dc \ub300\ubd80\ubd84\uc744 \uadf8\ub300\ub85c \uc4f4\ub2e4.<\/p>\n\n<h2>2. \uc124\uce58\uc640 \uc5d4\uc9c4\u00b7\uc138\uc158 \u2014 DB \ub85c \uac00\ub294 \ud1b5\ub85c \ub9cc\ub4e4\uae30<\/h2>\n\n<p>\ud30c\uc774\uc36c\uc5d0\uc11c DB \ub97c \ub2e4\ub8f0 \ub54c \uac70\uc758 \ud45c\uc900\ucc98\ub7fc \uc4f0\uc774\ub294 \ub77c\uc774\ube0c\ub7ec\ub9ac\uac00 <strong>SQLAlchemy<\/strong> \ub2e4. \uc124\uce58\ub294 \ud55c \uc904\uc774\ub2e4.<\/p>\n\n<div class=\"code-block\">$ pip install sqlalchemy<\/div>\n\n<p>\uc774\uc81c DB \uc5f0\uacb0\uc744 \ub2f4\ub2f9\ud560 \ud30c\uc77c \ud558\ub098\ub97c \ub9cc\ub4e0\ub2e4. <code>database.py<\/code> \ub77c\uace0 \ubd80\ub974\uc790. \uc5ec\uae30\uc11c \ub4f1\uc7a5\ud558\ub294 \uc138 \uac00\uc9c0 \ubd80\ud488 \u2014 <strong>\uc5d4\uc9c4, \uc138\uc158, Base<\/strong> \u2014 \ub9cc \uc774\ud574\ud558\uba74 \ub098\uba38\uc9c0\ub294 \uc751\uc6a9\uc774\ub2e4.<\/p>\n\n<div class=\"code-block\"># database.py\nfrom sqlalchemy import create_engine\nfrom sqlalchemy.orm import sessionmaker, declarative_base\n\n# 1) \uc5d4\uc9c4 \u2014 DB \ud30c\uc77c\ub85c \uac00\ub294 \uc2e4\uc81c \uc5f0\uacb0\nengine = create_engine(\n    &#8220;sqlite:\/\/\/.\/app.db&#8221;,\n    connect_args={&#8220;check_same_thread&#8221;: False},\n)\n\n# 2) \uc138\uc158 \uacf5\uc7a5 \u2014 \uc694\uccad\ub9c8\ub2e4 \uc138\uc158 \ud558\ub098\uc529 \ucc0d\uc5b4\ub0b8\ub2e4\nSessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)\n\n# 3) Base \u2014 \ubaa8\ub378 \ud074\ub798\uc2a4\ub4e4\uc774 \uc0c1\uc18d\ud560 \ubd80\ubaa8\nBase = declarative_base()<\/div>\n\n<p>\ud55c \ubd80\ud488\uc529 \ud480\uc5b4 \ubcf8\ub2e4. <strong>\uc5d4\uc9c4(engine)<\/strong> \uc740 DB \uc640 \ud1b5\ud558\ub294 <strong>\uc2e4\uc81c \uc5f0\uacb0 \ud1b5\ub85c<\/strong> \ub2e4. <code>\"sqlite:\/\/\/.\/app.db\"<\/code> \ub294 &#8220;\ud604\uc7ac \ud3f4\ub354\uc758 <code>app.db<\/code> \ud30c\uc77c\uc744 SQLite DB \ub85c \uc4f0\uaca0\ub2e4&#8221; \ub294 \uc8fc\uc18c\ub2e4. \ub9cc\uc57d PostgreSQL \uc774\uc5c8\ub2e4\uba74 \uc774 \ud55c \uc904\ub9cc <code>\"postgresql:\/\/...\"<\/code> \ub85c \ubc14\ub010\ub2e4 \u2014 \uadf8\ub798\uc11c DB \uad50\uccb4\uac00 \uc27d\ub2e4.<\/p>\n\n<p><code>check_same_thread: False<\/code> \ub294 SQLite \uc5d0\ub9cc \ubd99\uc774\ub294 \uc635\uc158\uc774\ub2e4. SQLite \ub294 \uae30\ubcf8\uc801\uc73c\ub85c &#8220;\ud55c \uc5f0\uacb0\uc740 \ub9cc\ub4e0 \uc2a4\ub808\ub4dc\uc5d0\uc11c\ub9cc \uc368\ub77c&#8221; \uace0 \ub9c9\ub294\ub370, FastAPI \ub294 \uc5ec\ub7ec \uc2a4\ub808\ub4dc\uc5d0\uc11c \uac19\uc740 \uc5f0\uacb0\uc744 \ub2e4\ub8f0 \uc218 \uc788\uc5b4 \uc774 \ube57\uc7a5\uc744 \ud480\uc5b4 \uc918\uc57c \ud55c\ub2e4. <strong>SQLite \ud55c\uc815 \uc8fc\ubb38<\/strong> \uc774\ub77c\uace0 \uc678\uc6cc \ub450\uba74 \ub41c\ub2e4.<\/p>\n\n<p><strong>\uc138\uc158(session)<\/strong> \uc740 DB \uc640\uc758 <strong>\ud55c \ubc88\uc758 \ub300\ud654 \ubb36\uc74c<\/strong> \uc774\ub2e4. \uc870\ud68c\u00b7\ucd94\uac00\u00b7\uc218\uc815\uc744 \ubaa8\uc544 \ub450\uc5c8\ub2e4\uac00 \ud55c\uaebc\ubc88\uc5d0 \ubc18\uc601(commit)\ud558\uac70\ub098 \ucde8\uc18c(rollback)\ud55c\ub2e4. <code>sessionmaker<\/code> \ub294 \uadf8 \uc138\uc158\uc744 \ucc0d\uc5b4\ub0b4\ub294 <strong>\uacf5\uc7a5<\/strong> \uc774\uace0, \uc6b0\ub9ac\ub294 \uadf8 \uacf5\uc7a5 \uc774\ub984\uc744 <code>SessionLocal<\/code> \uc774\ub77c \uc9c0\uc5c8\ub2e4. <code>SessionLocal()<\/code> \uc744 \ud638\ucd9c\ud560 \ub54c\ub9c8\ub2e4 \uc0c8 \uc138\uc158\uc774 \ud558\ub098 \ub098\uc628\ub2e4. <code>autocommit=False<\/code> \uc640 <code>autoflush=False<\/code> \ub294 &#8220;\ub0b4\uac00 \uba85\uc2dc\uc801\uc73c\ub85c <code>commit()<\/code> \ud558\uae30 \uc804\uc5d4 \ud568\ubd80\ub85c \uc800\uc7a5\ud558\uc9c0 \ub9c8\ub77c&#8221; \ub294 \uc548\uc804\ud55c \uae30\ubcf8 \uc124\uc815\uc774\ub2e4.<\/p>\n\n<p>\ub9c8\uc9c0\ub9c9 <strong>Base<\/strong> \ub294 \uc7a0\uc2dc \ub4a4 \ub9cc\ub4e4 \ubaa8\ub378 \ud074\ub798\uc2a4\ub4e4\uc774 \uacf5\ud1b5\uc73c\ub85c \ubb3c\ub824\ubc1b\uc744 <strong>\ubd80\ubaa8 \ud074\ub798\uc2a4<\/strong> \ub2e4. SQLAlchemy \ub294 \uc774 <code>Base<\/code> \ub97c \ud1b5\ud574 &#8220;\uc5b4\ub5a4 \ud074\ub798\uc2a4\uac00 \uc5b4\ub5a4 \ud14c\uc774\ube14\uc778\uc9c0&#8221; \ub97c \ucd94\uc801\ud55c\ub2e4.<\/p>\n\n<h2>3. \ubaa8\ub378 \uc815\uc758 \u2014 \ud30c\uc774\uc36c \ud074\ub798\uc2a4\uac00 \uace7 \ud14c\uc774\ube14<\/h2>\n\n<p>\uc774\uc81c \ud575\uc2ec \uac1c\ub150\uc778 <strong>ORM<\/strong> \uc744 \ub9cc\ub09c\ub2e4. ORM(Object-Relational Mapping)\uc740 <strong>\ud30c\uc774\uc36c \ud074\ub798\uc2a4 \u2194 DB \ud14c\uc774\ube14<\/strong>, <strong>\ud074\ub798\uc2a4\uc758 \uac1d\uccb4 \u2194 \ud14c\uc774\ube14\uc758 \ud55c \uc904(\ud589)<\/strong> \uc744 \uc790\ub3d9\uc73c\ub85c \uc774\uc5b4 \uc8fc\ub294 \ub2e4\ub9ac\ub2e4. \uc6b0\ub9ac\ub294 SQL \ubb38\uc744 \uc9c1\uc811 \uc4f0\ub294 \ub300\uc2e0 \ud3c9\uc18c\ucc98\ub7fc \ud30c\uc774\uc36c \uac1d\uccb4\ub97c \ub2e4\ub8e8\uace0, SQLAlchemy \uac00 \uadf8\uac83\uc744 <code>INSERT<\/code>\u00b7<code>SELECT<\/code> \uac19\uc740 SQL \ub85c \ubc88\uc5ed\ud574 \uc900\ub2e4. &#8220;\ud14c\uc774\ube14\uc744 \ud30c\uc774\uc36c \ud074\ub798\uc2a4\ub85c \uadf8\ub9b0\ub2e4&#8221; \uace0 \uc0dd\uac01\ud558\uba74 \uc815\ud655\ud558\ub2e4.<\/p>\n\n<div class=\"code-block\"># models.py\nfrom sqlalchemy import Column, Integer, String, Boolean\nfrom database import Base\n\nclass User(Base):\n    __tablename__ = &#8220;users&#8221;        # \uc2e4\uc81c \ud14c\uc774\ube14 \uc774\ub984\n\n    id = Column(Integer, primary_key=True, index=True)\n    email = Column(String, unique=True, index=True)\n    name = Column(String)\n    is_active = Column(Boolean, default=True)<\/div>\n\n<p>\uc77d\ub294 \ubc95\uc740 \uc9c1\uad00\uc801\uc774\ub2e4. <code>class User(Base)<\/code> \u2014 <code>Base<\/code> \ub97c \ubb3c\ub824\ubc1b\uc558\uc73c\ub2c8 SQLAlchemy \uac00 \uad00\ub9ac\ud558\ub294 \ubaa8\ub378\uc774\ub2e4. <code>__tablename__ = \"users\"<\/code> \ub85c \uc2e4\uc81c \ud14c\uc774\ube14 \uc774\ub984\uc744 \uc815\ud558\uace0, \uadf8 \uc544\ub798 <code>Column<\/code> \ud558\ub098\ud558\ub098\uac00 \ud14c\uc774\ube14\uc758 <strong>\uc5f4(\uceec\ub7fc)<\/strong> \uc774 \ub41c\ub2e4. <code>id = Column(Integer, primary_key=True)<\/code> \ub294 &#8220;\uc815\uc218\ud615 id \uc5f4\uc774\uace0 \uc774\uac8c \uae30\ubcf8 \ud0a4(\uac01 \ud589\uc744 \uad6c\ubcc4\ud558\ub294 \uace0\uc720 \ubc88\ud638)&#8221; \ub77c\ub294 \ub73b\uc774\ub2e4.<\/p>\n\n<p>\uc635\uc158\ub4e4\ub3c4 \uc774\ub984\uac12\uc744 \ud55c\ub2e4. <code>primary_key=True<\/code> \ub294 \uadf8 \ud589\uc758 \uace0\uc720 \uc2dd\ubcc4\uc790, <code>unique=True<\/code> \ub294 \uac19\uc740 \uac12\uc774 \ub450 \ubc88 \ubabb \ub4e4\uc5b4\uc624\uac8c(\uc774\uba54\uc77c \uc911\ubcf5 \uac00\uc785 \ucc28\ub2e8), <code>index=True<\/code> \ub294 \uadf8 \uc5f4\ub85c \uac80\uc0c9\ud560 \ub54c \ube60\ub974\ub3c4\ub85d \uc0c9\uc778\uc744 \ub9cc\ub4e4\ub77c\ub294 \uc9c0\uc2dc, <code>default=True<\/code> \ub294 \uac12\uc744 \uc548 \uc8fc\uba74 \uae30\ubcf8\uc73c\ub85c \ucc44\uc6b8 \uac12\uc774\ub2e4. \uc774 \ud55c \ud074\ub798\uc2a4\uac00 \uace7 <code>users<\/code> \ud14c\uc774\ube14\uc758 \uc124\uacc4\ub3c4 \uc804\uccb4\ub2e4.<\/p>\n\n<p>\uc124\uacc4\ub3c4\ub97c \uadf8\ub838\uc73c\ub2c8 \uc2e4\uc81c \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4\uc57c \ud55c\ub2e4. \uadf8 \ud55c \uc904\uc740 \uc774\ub807\ub2e4.<\/p>\n\n<div class=\"code-block\"># \uc571\uc774 \uc2dc\uc791\ub420 \ub54c \ud55c \ubc88 \uc2e4\ud589 \u2014 \ud14c\uc774\ube14\uc774 \uc5c6\uc73c\uba74 \ub9cc\ub4e0\ub2e4\nfrom database import engine, Base\nimport models  # User \ubaa8\ub378\uc774 Base \uc5d0 \ub4f1\ub85d\ub418\ub3c4\ub85d \ubd88\ub7ec\uc628\ub2e4\n\nBase.metadata.create_all(bind=engine)<\/div>\n\n<p><code>Base.metadata<\/code> \ub294 \uc9c0\uae08\uae4c\uc9c0 <code>Base<\/code> \ub97c \uc0c1\uc18d\ud55c \ubaa8\ub4e0 \ubaa8\ub378\uc758 \uc815\ubcf4\ub97c \ubaa8\uc544 \ub454 \uc7a5\ubd80\ub2e4. <code>create_all(bind=engine)<\/code> \uc740 \uadf8 \uc7a5\ubd80\ub97c \ubcf4\uace0 <strong>\uc544\uc9c1 \uc5c6\ub294 \ud14c\uc774\ube14\ub9cc \uace8\ub77c \ub9cc\ub4e0\ub2e4.<\/strong> \uc774\ubbf8 \uc788\uc73c\uba74 \uac74\ub4dc\ub9ac\uc9c0 \uc54a\uc73c\ub2c8 \uc5ec\ub7ec \ubc88 \uc2e4\ud589\ud574\ub3c4 \uc548\uc804\ud558\ub2e4. \uc774 \ud55c \uc904\uc744 \uc2e4\ud589\ud558\uba74 \ud3f4\ub354\uc5d0 <code>app.db<\/code> \ud30c\uc77c\uc774 \uc0dd\uae30\uace0 \uadf8 \uc548\uc5d0 <code>users<\/code> \ud14c\uc774\ube14\uc774 \ub4e4\uc5b4\uc549\ub294\ub2e4.<\/p>\n\n<div class=\"warnbox\">\n<strong>\uc8fc\uc758 \u2014 create_all \uc740 &#8220;\uc5c6\ub294 \uac83\ub9cc&#8221; \ub9cc\ub4e0\ub2e4<\/strong> \u2014 \uc774\ubbf8 \ub9cc\ub4e4\uc5b4\uc9c4 \ud14c\uc774\ube14\uc758 <strong>\uad6c\uc870\ub97c \ubc14\uafb8\uc9c0\ub294 \ubabb\ud55c\ub2e4.<\/strong> \ub098\uc911\uc5d0 <code>User<\/code> \uc5d0 \uc5f4\uc744 \ud558\ub098 \ucd94\uac00\ud574\ub3c4 <code>create_all<\/code> \uc740 \uae30\uc874 <code>users<\/code> \ud14c\uc774\ube14\uc744 \uadf8\ub300\ub85c \ub454\ub2e4. \uc2e4\uc11c\ube44\uc2a4\uc5d0\uc11c \ud14c\uc774\ube14 \uad6c\uc870\ub97c \ubc14\uafb8\ub294 \uc77c(\ub9c8\uc774\uadf8\ub808\uc774\uc158)\uc740 <strong>Alembic<\/strong> \uac19\uc740 \uc804\uc6a9 \ub3c4\uad6c\uac00 \ub9e1\ub294\ub2e4. \uc9c0\uae08\uc740 &#8220;\ucc98\uc74c \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4 \ub54c \uc4f0\ub294 \ud55c \uc904&#8221; \ub85c\ub9cc \uc54c\uc544 \ub450\uba74 \ucda9\ubd84\ud558\ub2e4.\n<\/div>\n\n<h2>4. get_db \uc758\uc874\uc131 \u2014 \ub77c\uc6b0\ud2b8\uc5d0 \uc138\uc158\uc744 \ub07c\uc6cc \ub123\uae30<\/h2>\n\n<p>\uc5ec\uae30\uc11c 5\ud3b8\uc774 \ube5b\uc744 \ubc1c\ud55c\ub2e4. \uc6b0\ub9ac\ub294 \uadf8\ub54c <code>yield<\/code> \uc758\uc874\uc131\uc73c\ub85c &#8220;\uc4f0\uae30 \uc804 \uc900\ube44 \u2192 \uc5d4\ub4dc\ud3ec\uc778\ud2b8 \uc2e4\ud589 \u2192 \uc4f4 \ub4a4 \uc815\ub9ac&#8221; \ub97c \ud55c \ud568\uc218\uc5d0 \ub2f4\ub294 \ubc95\uc744 \ubc30\uc6e0\uace0, \ub9c8\uc9c0\ub9c9\uc5d0 <strong>&#8220;7\ud3b8\uc5d0\uc11c \uc774 <code>get_db<\/code> \ud328\ud134\uc744 \uac70\uc758 \uadf8\ub300\ub85c \ub2e4\uc2dc \ub9cc\ub09c\ub2e4&#8221;<\/strong> \uace0 \uc608\uace0\ud588\ub2e4. \uc57d\uc18d\ud55c \uadf8 \uc21c\uac04\uc774\ub2e4.<\/p>\n\n<div class=\"code-block\"># \uc138\uc158\uc744 \uc5f4\uace0, \ub118\uaca8\uc8fc\uace0, \ub05d\ub098\uba74 \ubc18\ub4dc\uc2dc \ub2eb\ub294\ub2e4\nfrom database import SessionLocal\n\ndef get_db():\n    db = SessionLocal()      # \uc900\ube44: \uc138\uc158 \ud558\ub098 \uc0dd\uc131\n    try:\n        yield db             # \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ub85c \ub118\uae40\n    finally:\n        db.close()           # \uc815\ub9ac: \ubb34\uc2a8 \uc77c\uc774 \uc788\uc5b4\ub3c4 \ub2eb\ub294\ub2e4<\/div>\n\n<p>\ud750\ub984\uc740 5\ud3b8\uacfc \ub611\uac19\ub2e4. \uc694\uccad\uc774 \ub4e4\uc5b4\uc624\uba74 <code>get_db<\/code> \uac00 <code>SessionLocal()<\/code> \ub85c \uc0c8 \uc138\uc158\uc744 \ub9cc\ub4e4\uace0, <code>yield db<\/code> \uc5d0\uc11c <strong>\uc7a0\uc2dc \uba48\ucdb0<\/strong> \uadf8 \uc138\uc158\uc744 \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uc5d0 \uac74\ub128\ub2e4. \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uac00 \uc77c\uc744 \ub05d\ub0b4\uba74 FastAPI \uac00 \ub2e4\uc2dc <code>get_db<\/code> \ub85c \ub3cc\uc544\uc640 <code>finally<\/code> \uc758 <code>db.close()<\/code> \ub97c \uc2e4\ud589\ud55c\ub2e4. \uc911\uac04\uc5d0 \uc5d0\ub7ec\uac00 \ud130\uc838\ub3c4 <code>finally<\/code> \ub77c\uc11c \uc138\uc158\uc740 <strong>\ud56d\uc0c1<\/strong> \ub2eb\ud78c\ub2e4 \u2014 \uc5f0\uacb0 \ub204\uc218\uac00 \uc6d0\ucc9c \ucc28\ub2e8\ub41c\ub2e4. \uc694\uccad\ub9c8\ub2e4 \uc138\uc158\uc774 \ud558\ub098\uc529 \uae54\ub054\ud558\uac8c \uc5f4\ub9ac\uace0 \ub2eb\ud788\ub294 \uac83\uc774\ub2e4.<\/p>\n\n<p>\uc774\uc81c \ub77c\uc6b0\ud2b8\uc5d0\uc11c \uc774 \uc138\uc158\uc744 \ubc1b\uc544 \uc4f4\ub2e4. \uc778\uc790 \uc790\ub9ac\uc5d0 <code>Depends(get_db)<\/code> \ub97c \uc801\uae30\ub9cc \ud558\uba74 \ub41c\ub2e4.<\/p>\n\n<div class=\"code-block\">from fastapi import FastAPI, Depends\nfrom sqlalchemy.orm import Session\nfrom database import get_db\nimport models\n\napp = FastAPI()\n\n@app.get(&#8220;\/users&#8221;)\ndef list_users(db: Session = Depends(get_db)):\n    users = db.query(models.User).all()   # SELECT * FROM users\n    return users\n\n@app.get(&#8220;\/users\/{user_id}&#8221;)\ndef get_user(user_id: int, db: Session = Depends(get_db)):\n    user = db.query(models.User).filter(models.User.id == user_id).first()\n    return user<\/div>\n\n<p><code>db: Session = Depends(get_db)<\/code> \ud55c \uc904\uc774 \ud575\uc2ec\uc774\ub2e4. <strong>&#8220;\uc774 \ub77c\uc6b0\ud2b8\ub294 DB \uc138\uc158\uc774 \ud544\uc694\ud574 \u2014 <code>get_db<\/code> \uac00 \uc900\ube44\ud574 \uc8fc\ub294 \uac78 <code>db<\/code> \ub85c \ubc1b\uc744\uac8c&#8221;<\/strong> \ub77c\ub294 \uc120\uc5b8\uc774\ub2e4. \uadf8 \ub2e4\uc74c\ubd80\ud130 <code>db<\/code> \ub294 \ud3c9\ubc94\ud55c \uc138\uc158 \uac1d\uccb4\ub77c \ub9c8\uc74c\uaecf \uc9c8\uc758\ud560 \uc218 \uc788\ub2e4. <code>db.query(models.User).all()<\/code> \uc740 &#8220;users \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ud589&#8221; \uc744, <code>.filter(...).first()<\/code> \ub294 &#8220;\uc870\uac74\uc5d0 \ub9de\ub294 \uccab \ud55c \ud589&#8221; \uc744 \uac00\uc838\uc628\ub2e4. SQL \uc744 \ud55c \uae00\uc790\ub3c4 \uc548 \uc801\uc5c8\uc9c0\ub9cc SQLAlchemy \uac00 \uc54c\uc544\uc11c <code>SELECT<\/code> \ubb38\uc73c\ub85c \ubc88\uc5ed\ud574 \uc2e4\ud589\ud55c\ub2e4.<\/p>\n\n<p>\uc8fc\ubaa9\ud560 \uc810\uc740 <strong>\ubaa8\ub4e0 \ub77c\uc6b0\ud2b8\uac00 \uc138\uc158\uc744 \uc9c1\uc811 \ub9cc\ub4e4\uc9c0 \uc54a\ub294\ub2e4<\/strong> \ub294 \uac83\uc774\ub2e4. \uc138\uc158\uc744 \uc5f4\uace0 \ub2eb\ub294 \ucc45\uc784\uc740 \uc804\ubd80 <code>get_db<\/code> \ud55c \uacf3\uc5d0 \uc788\uace0, \ub77c\uc6b0\ud2b8\ub294 \uadf8\uc800 \ubc1b\uc544 \uc4f0\uae30\ub9cc \ud55c\ub2e4. \uc774\uac83\uc774 5\ud3b8 \uc758\uc874\uc131 \uc8fc\uc785\uc774 7\ud3b8\uc5d0\uc11c \uacb0\uc2e4\uc744 \ub9fa\ub294 \uc9c0\uc810\uc774\ub2e4 \u2014 <strong>\uc900\ube44\uc640 \uc815\ub9ac\ub294 \ud55c \uacf3\uc5d0, \uc0ac\uc6a9\uc740 \uc5b4\ub514\uc11c\ub4e0.<\/strong><\/p>\n\n<div class=\"databox\">\n<strong>\uc870\ud68c\ub294 \ud588\ub294\ub370 \uc800\uc7a5(\uc4f0\uae30)\uc740?<\/strong> \u2014 \uc774\ubc88 \ud3b8\uc740 \uc5f0\uacb0 \ud1b5\ub85c\ub97c \uae4c\ub294 \ub370 \uc9d1\uc911\ud588\uae30\uc5d0 \uc608\uc81c\uac00 \ub300\ubd80\ubd84 <code>db.query(...)<\/code> \uc870\ud68c\ub2e4. \uc0c8 \ud68c\uc6d0\uc744 \uc2e4\uc81c\ub85c \ub123\uc73c\ub824\uba74 <code>db.add(user)<\/code> \u2192 <code>db.commit()<\/code> \u2192 <code>db.refresh(user)<\/code> \uc758 3\ub2e8\uacc4\uac00 \ud544\uc694\ud558\uace0, \uc218\uc815\uacfc \uc0ad\uc81c\ub3c4 \uc9dd\uc774 \uc788\ub2e4. \uc774 \uc0dd\uc131\u00b7\uc870\ud68c\u00b7\uc218\uc815\u00b7\uc0ad\uc81c \ub124 \uac00\uc9c0\ub97c \ubb36\uc5b4 <strong>CRUD<\/strong> \ub77c \ubd80\ub974\ub294\ub370, \ubc14\ub85c \uadf8\uac8c \ub2e4\uc74c 8\ud3b8\uc758 \uc8fc\uc81c\ub2e4.\n<\/div>\n\n<h2>5. \uc815\ub9ac \u2014 \ub370\uc774\ud130\uac00 \uc0b4\uc544\ub0a8\ub294 \uad6c\uc870<\/h2>\n\n<p>7\ud3b8\uc744 \ud55c \uc7a5\uc758 \uc9c0\ub3c4\ub85c \uc555\ucd95\ud558\uba74 \uc774\ub807\ub2e4.<\/p>\n\n<div class=\"tablewrap\">\n<table>\n<thead><tr><th>\ubd80\ud488<\/th><th>\uc5ed\ud560<\/th><th>\ud575\uc2ec \ucf54\ub4dc<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>\uc5d4\uc9c4<\/td><td data-label=\"\uc5ed\ud560\">DB \ud30c\uc77c\ub85c \uac00\ub294 \uc2e4\uc81c \uc5f0\uacb0 \ud1b5\ub85c<\/td><td data-label=\"\ud575\uc2ec \ucf54\ub4dc\">create_engine(&#8220;sqlite:\/\/\/.\/app.db&#8221;)<\/td><\/tr>\n<tr><td>\uc138\uc158 \uacf5\uc7a5<\/td><td data-label=\"\uc5ed\ud560\">\uc694\uccad\ub9c8\ub2e4 \uc138\uc158 \ud558\ub098\uc529 \uc0dd\uc131<\/td><td data-label=\"\ud575\uc2ec \ucf54\ub4dc\">SessionLocal = sessionmaker(bind=engine)<\/td><\/tr>\n<tr><td>Base<\/td><td data-label=\"\uc5ed\ud560\">\ubaa8\ub378\ub4e4\uc774 \uc0c1\uc18d\ud560 \ubd80\ubaa8 \ud074\ub798\uc2a4<\/td><td data-label=\"\ud575\uc2ec \ucf54\ub4dc\">Base = declarative_base()<\/td><\/tr>\n<tr><td>\ubaa8\ub378<\/td><td data-label=\"\uc5ed\ud560\">\ud30c\uc774\uc36c \ud074\ub798\uc2a4 = DB \ud14c\uc774\ube14<\/td><td data-label=\"\ud575\uc2ec \ucf54\ub4dc\">class User(Base): __tablename__=&#8221;users&#8221;<\/td><\/tr>\n<tr><td>\ud14c\uc774\ube14 \uc0dd\uc131<\/td><td data-label=\"\uc5ed\ud560\">\uc5c6\ub294 \ud14c\uc774\ube14\ub9cc \uc2e4\uc81c\ub85c \ub9cc\ub4e0\ub2e4<\/td><td data-label=\"\ud575\uc2ec \ucf54\ub4dc\">Base.metadata.create_all(bind=engine)<\/td><\/tr>\n<tr><td>get_db<\/td><td data-label=\"\uc5ed\ud560\">\uc138\uc158\uc744 \uc5f4\uace0\u00b7\ub118\uae30\uace0\u00b7\ub2eb\ub294 \uc758\uc874\uc131<\/td><td data-label=\"\ud575\uc2ec \ucf54\ub4dc\">Depends(get_db)<\/td><\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n\n<h3>\uc694\uc57d<\/h3>\n\n<p>\ub9ac\uc2a4\ud2b8\uc640 \ub515\uc154\ub108\ub9ac\uc5d0 \ub2f4\uc740 \ub370\uc774\ud130\ub294 \uc11c\ubc84\uac00 \uaebc\uc9c0\uba74 \ud568\uaed8 \uc0ac\ub77c\uc9c4\ub2e4. \uadf8\ub798\uc11c \uc6b0\ub9ac\ub294 <strong>SQLAlchemy<\/strong> \ub85c SQLite \ud30c\uc77c DB \ub97c \ubd99\uc600\ub2e4. <code>create_engine<\/code> \uc73c\ub85c <strong>\uc5d4\uc9c4<\/strong>(\uc5f0\uacb0 \ud1b5\ub85c)\uc744, <code>sessionmaker<\/code> \ub85c <strong>\uc138\uc158 \uacf5\uc7a5<\/strong>\uc744, <code>declarative_base<\/code> \ub85c \ubaa8\ub378\uc758 \ubd80\ubaa8 <strong>Base<\/strong> \ub97c \ub9cc\ub4e4\uace0, <code>User<\/code> \ud074\ub798\uc2a4 \ud558\ub098\ub85c \ud14c\uc774\ube14\uc744 \uc124\uacc4\ud574 <code>create_all<\/code> \ub85c \uc2e4\uc81c \ud14c\uc774\ube14\uc744 \ucc0d\uc5b4 \ub0c8\ub2e4. \ud575\uc2ec\uc740 <strong>ORM<\/strong> \u2014 \ud30c\uc774\uc36c \ud074\ub798\uc2a4\uac00 \uace7 \ud14c\uc774\ube14\uc774\uace0, \uac1d\uccb4\uac00 \uace7 \ud55c \ud589\uc774\ub77c SQL \uc744 \uc9c1\uc811 \uc4f0\uc9c0 \uc54a\ub294\ub2e4. \uadf8\ub9ac\uace0 5\ud3b8\uc5d0\uc11c \uc608\uace0\ud588\ub358 <code>get_db<\/code> \uc758\uc874\uc131\uc774 \ub9c8\uce68\ub0b4 \uc81c \uc5ed\ud560\uc744 \ud588\ub2e4. <code>db: Session = Depends(get_db)<\/code> \ud55c \uc904\uc774\uba74 \ub77c\uc6b0\ud2b8\ub294 \uc694\uccad\ub9c8\ub2e4 \uae68\ub057\ud55c \uc138\uc158\uc744 \ubc1b\uc544 \uc4f0\uace0, \uc138\uc158\uc744 \ub2eb\ub294 \ub4b7\uc815\ub9ac\ub294 <code>finally<\/code> \uac00 \ucc45\uc784\uc9c4\ub2e4. \uc774\uc81c \ub370\uc774\ud130\ub294 \uc11c\ubc84\ub97c \uaed0\ub2e4 \ucf1c\ub3c4 \uc0b4\uc544\ub0a8\ub294\ub2e4.<\/p>\n\n<div class=\"cta\">\n<h3>\ub2e4\uc74c \ud3b8 \uc608\uace0 \u2014 CRUD \uc644\uc131\ud558\uae30<\/h3>\n<p>\uc870\ud68c\ub9cc \ud574 \ubcf8 \uc138\uc158\uc73c\ub85c \uc774\ubc88\uc5d4 \uc0dd\uc131\u00b7\uc870\ud68c\u00b7\uc218\uc815\u00b7\uc0ad\uc81c\ub97c \uc804\ubd80 \uc9e0\ub2e4. db.add \u00b7 commit \u00b7 refresh \uc758 \uc815\uc11d \ud750\ub984\uc73c\ub85c \ud68c\uc6d0 API \ub97c \uc644\uc131\ud55c\ub2e4.<\/p>\n<\/div>\n\n<div class=\"footer-nav\">\n\uc2dc\ub9ac\uc988 \u00b7 <a href=\"https:\/\/junai.ai\/blog\/category\/fastapi\/\">\uc27d\uac8c \ubc30\uc6b0\ub294 FastAPI<\/a> \u00b7 \ud568\uaed8 \ubcf4\uae30: <a href=\"https:\/\/junai.ai\/blog\/category\/python\/\">\ud30c\uc774\uc36c \uae30\ucd08 \uc2dc\ub9ac\uc988<\/a>\n<\/div>\n\n<\/article>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\uc11c\ubc84\ub97c \ub044\uba74 \uc0ac\ub77c\uc9c0\ub358 \ub370\uc774\ud130\ub97c SQLAlchemy \ub85c \uc9c4\uc9dc DB \uc5d0 \uc601\uad6c \uc800\uc7a5\ud55c\ub2e4. SQLite\u00b7\uc5d4\uc9c4\u00b7\uc138\uc158\u00b7\ubaa8\ub378\u00b7get_db \uc758\uc874\uc131\uae4c\uc9c0 \ud55c \ud3b8\uc5d0. \uad50\uc7ac 7\ud3b8.<\/p>\n","protected":false},"author":1,"featured_media":929,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-942","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fastapi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts\/942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/comments?post=942"}],"version-history":[{"count":0,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts\/942\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media\/929"}],"wp:attachment":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media?parent=942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/categories?post=942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/tags?post=942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}