FastAPI\ub294 \ud30c\uc774\uc36c\uc73c\ub85c \uc791\uc131\ub41c \ud604\ub300\uc801\uc778 \uc6f9 \ud504\ub808\uc784\uc6cc\ud06c\ub85c, APIs\ub97c \ube60\ub974\uac8c \uad6c\ucd95\ud558\uace0 \ubb38\uc11c\ud654\ud558\ub294 \ub370 \uc788\uc5b4 \ud6a8\uc728\uc131\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 FastAPI\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubc31\uc5d4\ub4dc \uc11c\ubc84\ub97c \uac1c\ubc1c\ud558\ub294 \ubc29\ubc95\uacfc \ud568\uaed8 \ube44\ub3d9\uae30 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud074\ub77c\uc774\uc5b8\ud2b8\uc778 FastAPI\ub294 \ube44\ub3d9\uae30 \uc9c0\uc6d0\uc744 \uc81c\uacf5\ud558\uba70, Starlette \ubc0f Pydantic\uc744 \uae30\ubc18\uc73c\ub85c \uac1c\ubc1c\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \ud504\ub808\uc784\uc6cc\ud06c\uc758 \uac00\uc7a5 \ud070 \uc7a5\uc810 \uc911 \ud558\ub098\ub294 \ub370\uc774\ud130 \uac80\uc99d \ubc0f \uc9c1\ub82c\ud654\uac00 \uc790\ub3d9\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c4\ub2e4\ub294 \uc810\uc785\ub2c8\ub2e4. \uc774\ub294 \uac1c\ubc1c\uc790\uac00 API\ub97c \uac1c\ubc1c\ud558\ub294 \ub370 \ub4dc\ub294 \uc2dc\uac04\uc744 \ud06c\uac8c \ub2e8\ucd95\uc2dc\ucf1c \uc90d\ub2c8\ub2e4.<\/p>\n FastAPI\ub97c \uc124\uce58\ud558\uae30 \uc704\ud574\uc11c\ub294 FastAPI\ub97c \uc124\uce58\ud55c \ud6c4, \uae30\ubcf8 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ub9cc\ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc544\ub798 \uc608\uc81c \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc704 \ucf54\ub4dc\ub294 \uae30\ubcf8 FastAPI \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uc124\uc815\ud558\ub294 \ucf54\ub4dc\ub85c, \ub8e8\ud2b8 endpoint\uc5d0 GET \uc694\uccad\uc744 \ubcf4\ub0b4\uba74 \uc5ec\uae30\uc11c \uc774\uc81c FastAPI \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc5f0\uacb0\ud558\uae30 \uc704\ud574 aiomysql\uc744 \uc124\uce58\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. aiomysql\uc740 asyncio \uae30\ubc18\uc758 MySQL \ud074\ub77c\uc774\uc5b8\ud2b8\ub85c, \ube44\ub3d9\uae30\uc801\uc73c\ub85c MySQL\uacfc \uc0c1\ud638\uc791\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc90d\ub2c8\ub2e4. aiomysql\uc744 \uc124\uce58\ud558\uae30 \uc704\ud574 \uc544\ub798 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4:<\/p>\n \uc124\uce58\uac00 \uc644\ub8cc\ub418\uba74 MySQL \uc11c\ubc84\ub97c \uc900\ube44\ud574\uc57c \ud569\ub2c8\ub2e4. MySQL \uc11c\ubc84\ub97c \uc2e4\ud589\ud558\uace0, \uc544\ub798 \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc0c8 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4:<\/p>\n \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc548\uc5d0 \uc0ac\uc6a9\ud560 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uc774\uc81c FastAPI \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c MySQL\uc5d0 \uc5f0\uacb0\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc544\ub798 \ucf54\ub4dc\ub294 FastAPI\uc640 aiomysql\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud558\uace0, \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud558\uace0 \uc870\ud68c\ud558\ub294 \uae30\ubcf8\uc801\uc778 API\ub97c \ub9cc\ub4dc\ub294 \ubc29\ubc95\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \uc544\ub798 \ucf54\ub4dc\ub97c \uc774\uc81c FastAPI \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ub2e4\uc2dc \uc2e4\ud589\ud55c \ud6c4 API\ub97c \ud14c\uc2a4\ud2b8\ud574\ubcf4\uc138\uc694. \uc608\ub97c \ub4e4\uc5b4, \uc0ac\uc6a9\uc790 \ucd94\uac00\ub97c \uc704\ud574 \ub2e4\uc74c\uacfc \uac19\uc740 POST \uc694\uccad\uc744 \ubcf4\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n \uc774 \ud6c4, \uc0ac\uc6a9\uc790 \ubaa9\ub85d \uc870\ud68c\ub97c \uc704\ud574 \ub2e4\uc74c GET \uc694\uccad\uc744 \ubcf4\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n FastAPI\uc5d0\uc11c\uc758 \uc5d0\ub7ec \ud578\ub4e4\ub9c1\uc740 \ub9e4\uc6b0 \uac04\ub2e8\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc0ac\uc6a9\uc790\uac00 \uc774\uba54\uc77c\uc744 \uc911\ubcf5\ud574\uc11c \ucd94\uac00\ud558\ub824 \ud560 \uacbd\uc6b0\ub97c \ucc98\ub9ac\ud558\uae30 \uc704\ud55c \uae30\ub2a5\uc744 \ucd94\uac00\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p>\n FastAPI\ub294 \uac04\ub2e8\ud558\uba74\uc11c\ub3c4 \ub9e4\uc6b0 \uac15\ub825\ud55c \uc6f9 \ud504\ub808\uc784\uc6cc\ud06c\uc785\ub2c8\ub2e4. aiomysql\uc744 \ud1b5\ud574 \ube44\ub3d9\uae30\uc801\uc73c\ub85c MySQL\uacfc \uc5f0\uacb0\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6e0\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \ube60\ub978 \uc131\ub2a5\uc744 \uad6c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ucd94\uac00\uc801\uc73c\ub85c, FastAPI\uc758 \ub2e4\uc591\ud55c \uae30\ub2a5(\uc608: \uc758\uc874\uc131 \uc8fc\uc785, \ub354 \ubcf5\uc7a1\ud55c \ub370\uc774\ud130 \ubaa8\ub378 \ub4f1)\uc744 \ud0d0\uad6c\ud558\uba70 \ub354 \ubc1c\uc804\ub41c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ub9cc\ub4e4\uc5b4\ubcf4\uae38 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n \uac10\uc0ac\ud569\ub2c8\ub2e4!<\/p>\n <\/body><\/p>\n","protected":false},"excerpt":{"rendered":"aiomysql<\/code>\uc758 \uc124\uce58 \ubc0f \ud65c\uc6a9 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n1. FastAPI \uc18c\uac1c<\/h2>\n
1.1 FastAPI\uc758 \uc8fc\uc694 \ud2b9\uc9d5<\/h3>\n
\n
2. FastAPI \uc124\uce58<\/h2>\n
pip<\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac04\ub2e8\ud788 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud574 \uc124\uce58\ud574 \uc8fc\uc138\uc694:<\/p>\npip install fastapi[all]<\/code><\/pre>\n3. \uae30\ubcf8 FastAPI \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ub9cc\ub4e4\uae30<\/h2>\n
main.py<\/code>\ub77c\ub294 \ud30c\uc77c\uc744 \uc0dd\uc131\ud558\uace0, \ub2e4\uc74c \ucf54\ub4dc\ub97c \ubd99\uc5ec \ub123\uc2b5\ub2c8\ub2e4:<\/p>\nfrom fastapi import FastAPI\n\napp = FastAPI()\n\n@app.get(\"\/\")\nasync def read_root():\n return {\"Hello\": \"World\"}\n <\/code><\/pre>\n{\"Hello\": \"World\"}<\/code>\ub77c\ub294 JSON \uc751\ub2f5\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4. FastAPI \uc11c\ubc84\ub97c \uc2e4\ud589\ud558\ub824\uba74 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \ud130\ubbf8\ub110\uc5d0 \uc785\ub825\ud558\uc138\uc694:<\/p>\nuvicorn main:app --reload<\/code><\/pre>\n--reload<\/code> \uc635\uc158\uc740 \ucf54\ub4dc \ubcc0\uacbd \uc2dc \uc11c\ubc84\ub97c \uc790\ub3d9\uc73c\ub85c \uc7ac\uc2dc\uc791\ud574 \uc8fc\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc11c\ubc84\uac00 \uc2e4\ud589\ub418\uba74 http:\/\/127.0.0.1:8000<\/code> \uc8fc\uc18c\uc5d0\uc11c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n4. aiomysql \uc124\uce58<\/h2>\n
pip install aiomysql<\/code><\/pre>\n5. MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uc815<\/h2>\n
CREATE DATABASE fastapi_db;<\/code><\/pre>\n5.1 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14 \uc0dd\uc131<\/h3>\n
Users<\/code>\ub77c\ub294 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uace0, \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \uc800\uc7a5\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p>\nCREATE TABLE Users (\n id INT AUTO_INCREMENT PRIMARY KEY,\n name VARCHAR(100) NOT NULL,\n email VARCHAR(100) NOT NULL UNIQUE\n );<\/code><\/pre>\n6. FastAPI\uc640 aiomysql \ud1b5\ud569<\/h2>\n
main.py<\/code>\uc5d0 \ucd94\uac00\ud558\uc138\uc694:<\/p>\nimport aiomysql\nfrom fastapi import FastAPI, HTTPException\nfrom pydantic import BaseModel\nfrom typing import List, Optional\n\napp = FastAPI()\n\n# MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0 \uc124\uc815\nDB_CONFIG = {\n \"host\": \"localhost\",\n \"port\": 3306,\n \"user\": \"your_username\",\n \"password\": \"your_password\",\n \"db\": \"fastapi_db\"\n}\n\n# \ub370\uc774\ud130 \ubaa8\ub378 \uc815\uc758\nclass User(BaseModel):\n name: str\n email: str\n\n# \ube44\ub3d9\uae30 \ud568\uc218: \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0\nasync def get_db_connection():\n conn = await aiomysql.connect(**DB_CONFIG)\n return conn\n\n# \uc0ac\uc6a9\uc790 \ucd94\uac00\n@app.post(\"\/users\/\", response_model=User)\nasync def create_user(user: User):\n conn = await get_db_connection()\n async with conn.cursor() as cursor:\n await cursor.execute(\"INSERT INTO Users (name, email) VALUES (%s, %s)\", (user.name, user.email))\n await conn.commit()\n user_id = cursor.lastrowid\n conn.close()\n return {**user.dict(), \"id\": user_id}\n\n# \uc0ac\uc6a9\uc790 \ubaa9\ub85d \uc870\ud68c\n@app.get(\"\/users\/\", response_model=List[User])\nasync def read_users():\n conn = await get_db_connection()\n async with conn.cursor(aiomysql.DictCursor) as cursor:\n await cursor.execute(\"SELECT * FROM Users\")\n result = await cursor.fetchall()\n conn.close()\n return result\n <\/code><\/pre>\n6.1 API \ud14c\uc2a4\ud2b8<\/h3>\n
curl -X POST \"http:\/\/127.0.0.1:8000\/users\/\" -H \"Content-Type: application\/json\" -d \"{\\\"name\\\": \\\"John\\\", \\\"email\\\": \\\"john@example.com\\\"}\"<\/code><\/pre>\ncurl -X GET \"http:\/\/127.0.0.1:8000\/users\/\"<\/code><\/pre>\n7. \uc5d0\ub7ec \ud578\ub4e4\ub9c1<\/h2>\n
from fastapi import HTTPException\n\n@app.post(\"\/users\/\", response_model=User)\nasync def create_user(user: User):\n conn = await get_db_connection()\n async with conn.cursor() as cursor:\n await cursor.execute(\"SELECT * FROM Users WHERE email = %s\", (user.email,))\n existing_user = await cursor.fetchone()\n if existing_user:\n raise HTTPException(status_code=400, detail=\"Email already registered\")\n await cursor.execute(\"INSERT INTO Users (name, email) VALUES (%s, %s)\", (user.name, user.email))\n await conn.commit()\n user_id = cursor.lastrowid\n conn.close()\n return {**user.dict(), \"id\": user_id}\n <\/code><\/pre>\n8. \ub9c8\uce58\uba70<\/h2>\n