{"id":2921,"date":"2026-04-03T21:53:09","date_gmt":"2026-04-03T12:53:09","guid":{"rendered":"https:\/\/mattyan.net\/blog\/?p=2921"},"modified":"2026-04-03T21:53:09","modified_gmt":"2026-04-03T12:53:09","slug":"gemma4%e3%82%92%e8%a9%a6%e3%81%97%e3%81%a6%e3%81%bf%e3%81%9f","status":"publish","type":"post","link":"https:\/\/mattyan.net\/blog\/?p=2921","title":{"rendered":"Gemma4\u3092\u8a66\u3057\u3066\u307f\u305f"},"content":{"rendered":"\n

Gemma4<\/a>\u3068\u3044\u3046\u306e\u304c\u51fa\u305f\u3089\u3057\u3044\u306e\u3067\u3001\u3061\u3087\u3063\u3068\u8a66\u3057\u3066\u307f\u305f\u3002\u3061\u306a\u307f\u306b\u3053\u3044\u3064\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u66f8\u3051\u308b\u3089\u3057\u3044\u3002<\/p>\n\n\n\n\n\n\n\n

\u5b9f\u884c\u74b0\u5883\u3092\u6e96\u5099<\/h2>\n\n\n\n

Ollama<\/a>\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\uff06\u8d77\u52d5\u3057\u3066\u3001\u30e2\u30c7\u30eb\u306bgemmma4\u3092\u6307\u5b9a\u3057\u3066\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3002<\/p>\n\n\n\n

\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f8\u304b\u305b\u3066\u307f\u305f<\/h2>\n\n\n\n

\u65e9\u901f\u524d\u3005\u304b\u3089\u4f5c\u308d\u3046\u4f5c\u308d\u3046\u3068\u601d\u3063\u3066\u305f\u300cN\u30b2\u30fc\u30b8\u3068\u304b\u306e\u7ba1\u7406\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u300d\u306e\u8a2d\u8a08\u3092\u4f9d\u983c\u3057\u3066\u307f\u305f\u3002\u307e\u305a\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3002<\/p>\n\n\n\n

\u30ea\u30af\u30a8\u30b9\u30c8:<\/p>\n\n\n\n

Sqlite3\u3067\u6240\u6709\u3057\u3066\u3044\u308b\u9244\u9053\u6a21\u578b\u3092\u7ba1\u7406\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u8a2d\u8a08\u3092\u3057\u3066\u3044\u307e\u3059\u3002 \u5217\u8eca\u540d\u3001\u30e1\u30fc\u30ab\u30fc\u3001\u88fd\u54c1\u756a\u53f7\u3001\u30e1\u30e2\u3001\u5199\u771f\u306eURL\u3092\u4fdd\u5b58\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u3092\u8a2d\u8a08\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u88fd\u54c1\u756a\u53f7\u306f\u6587\u5b57\u5217\u3067\u3059\u3002<\/code><\/p>\n\n\n\n

AI\u306e\u56de\u7b54:<\/p>\n\n\n\n

CREATE TABLE model_trains (\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\n    train_name TEXT NOT NULL,\n    manufacturer TEXT NOT NULL,\n    product_number TEXT UNIQUE NOT NULL,\n    memo TEXT,\n    photo_url TEXT\n);<\/code><\/pre>\n\n\n\n
\u3042\u3068\u8a2d\u8a08\u306e\u5185\u5bb9\u3068\u304b\u89e3\u8aac\u3068\u304b\u3002\u4ee5\u4e0b\u305d\u306e\u4e00\u90e8\u30b3\u30d4\u30fc<\/p>\n\n\n\n
\ud83d\udcd8 \u63a8\u5968\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a2d\u8a08\u6848<\/h3>\n\n\n\n
\u57fa\u672c\u7684\u306b\u306f\u3001\u3059\u3079\u3066\u306e\u60c5\u5831\u3092\u4e00\u3064\u306e\u30e1\u30a4\u30f3\u30c6\u30fc\u30d6\u30eb\u306b\u307e\u3068\u3081\u308b\u306e\u304c\u6700\u3082\u30b7\u30f3\u30d7\u30eb\u3067\u52b9\u7387\u7684\u3067\u3059\u3002<\/p>\n\n\n\n
1. \u30c6\u30fc\u30d6\u30eb\u540d: model_trains<\/code><\/h4>\n\n\n\n
\u30ab\u30e9\u30e0\u540d (Column Name)<\/th>\u30c7\u30fc\u30bf\u578b (Data Type)<\/th>\u5236\u7d04 (Constraints)<\/th>\u8aac\u660e (Description)<\/th><\/tr><\/thead>
id<\/code><\/td>INTEGER<\/code><\/td>PRIMARY KEY AUTOINCREMENT<\/code><\/td>\u5404\u30e2\u30c7\u30eb\u56fa\u6709\u306eID\u3002\u81ea\u52d5\u3067\u63a1\u756a\u3055\u308c\u307e\u3059\u3002<\/td><\/tr>
train_name<\/code><\/td>TEXT<\/code><\/td>NOT NULL<\/code><\/td>\u5217\u8eca\u540d\uff08\u4f8b\uff1a\u9752\u51fd\u9023\u7d61\u8239\u3001\u7a4d\u96ea\u5217\u8eca\u306a\u3069\uff09\u3002<\/td><\/tr>
manufacturer<\/code><\/td>TEXT<\/code><\/td>NOT NULL<\/code><\/td>\u88fd\u9020\u30e1\u30fc\u30ab\u30fc\u540d\uff08\u4f8b\uff1aTOMIX\u3001KATO\u306a\u3069\uff09\u3002<\/td><\/tr>
product_number<\/code><\/td>TEXT<\/code><\/td>UNIQUE NOT NULL<\/code><\/td>\u88fd\u54c1\u756a\u53f7\u3002\u5fc5\u305a\u4e00\u610f\u3067\u3042\u308b\u3053\u3068\u3092\u4fdd\u8a3c\u3057\u307e\u3059\u3002<\/td><\/tr>
memo<\/code><\/td>TEXT<\/code><\/td>(\u306a\u3057)<\/td>\u500b\u4eba\u7684\u306a\u30e1\u30e2\u3001\u8cfc\u5165\u6642\u306e\u72b6\u6cc1\u306a\u3069\u3002NULL\u3092\u8a31\u5bb9\u3057\u307e\u3059\u3002<\/td><\/tr>
photo_url<\/code><\/td>TEXT<\/code><\/td>(\u306a\u3057)<\/td>\u5199\u771f\u306eURL\u3002NULL\u3092\u8a31\u5bb9\u3057\u307e\u3059\u3002<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\u5217\u8eca\u540d\u306e\u8aac\u660e\u3067\u5217\u8eca\u540d\uff08\u4f8b\uff1a\u9752\u51fd\u9023\u7d61\u8239\u3001\u7a4d\u96ea\u5217\u8eca\u306a\u3069\uff09\u3002<\/code>\u3068\u3042\u308b\u3051\u3069\u3001\u9752\u51fd\u9023\u7d61\u8239\u306f\u8239\u3060\u3057\u3001\u7a4d\u96ea\u5217\u8eca\u3063\u3066\u4f55\u305e?\u9664\u96ea\u5217\u8eca\u304b?\u30ad\u30de\u30ed\u30ad?<\/p>\n\n\n\n
\u3064\u3044\u3067\u306a\u306e\u3067\u3001Python+FastAPI\u3067\u3053\u306eDB\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308bAPI\u3092\u8981\u6c42<\/p>\n\n\n\n
\u30ea\u30af\u30a8\u30b9\u30c8:<\/p>\n\n\n\n
\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3059\u3002\u3053\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308bAPI\u3092Python\u3068FastAPI\u3092\u4f7f\u3063\u3066\u8a2d\u8a08\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/code><\/p>\n\n\n\n
AI\u306e\u56de\u7b54:<\/p>\n\n\n\n
\u307e\u305a\u306f\u4f9d\u5b58\u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/p>\n\n\n\n
pip install fastapi uvicorn pydantic sqlite3<\/code><\/pre>\n\n\n\n
\u6b21\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5c64<\/p>\n\n\n\n
# database.py\nimport sqlite3\nfrom typing import List, Tuple, Optional\n\nDB_NAME = "model_trains.db"\n\ndef initialize_db():\n    """\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3057\u3001\u30c6\u30fc\u30d6\u30eb\u304c\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\u306f\u4f5c\u6210\u3059\u308b"""\n    conn = sqlite3.connect(DB_NAME)\n    cursor = conn.cursor()\n    \n    # \u69cb\u9020\u3092\u5b9a\u7fa9\u3057\u305fSQL\u6587\uff08\u4ee5\u524d\u63d0\u6848\u3057\u305f\u3082\u306e\u3092\u5229\u7528\uff09\n    create_table_sql = """\n    CREATE TABLE IF NOT EXISTS model_trains (\n        id INTEGER PRIMARY KEY AUTOINCREMENT,\n        train_name TEXT NOT NULL,\n        manufacturer TEXT NOT NULL,\n        product_number TEXT UNIQUE NOT NULL,\n        memo TEXT,\n        photo_url TEXT\n    );\n    """\n    cursor.execute(create_table_sql)\n    conn.commit()\n    conn.close()\n    print(f"Database '{DB_NAME}' initialized successfully.")\n\ndef get_db_connection():\n    """\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u8fd4\u3059\u30b8\u30a7\u30cd\u30ec\u30fc\u30bf"""\n    # FastAPI\u306e\u4f9d\u5b58\u6027\u6ce8\u5165\uff08Dependency Injection\uff09\u3067\u5229\u7528\u3059\u308b\u3053\u3068\u3092\u60f3\u5b9a\n    connection = sqlite3.connect(DB_NAME)\n    connection.row_factory = sqlite3.Row  # \u30ab\u30e9\u30e0\u540d\u3092\u30ad\u30fc\u3068\u3057\u3066\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\n    try:\n        yield connection\n    finally:\n        connection.close()\n\n\n# --- \u30af\u30e9\u30b9\u30d9\u30fc\u30b9\u306e\u64cd\u4f5c\u95a2\u6570\uff08FastAPI\u306e\u30eb\u30fc\u30c8\u304b\u3089\u547c\u3070\u308c\u308b\uff09 ---\n\ndef create_train_record(db: sqlite3.Connection, data: dict) -> Optional[dict]:\n    """\u65b0\u3057\u3044\u5217\u8eca\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u4f5c\u6210\u3059\u308b"""\n    sql = """\n    INSERT INTO model_trains (train_name, manufacturer, product_number, memo, photo_url)\n    VALUES (?, ?, ?, ?, ?)\n    """\n    try:\n        cursor = db.cursor()\n        cursor.execute(sql, (\n            data["train_name"],\n            data["manufacturer"],\n            data["product_number"],\n            data.get("memo"),\n            data.get("photo_url")\n        ))\n        db.commit()\n        \n        # \u65b0\u3057\u304f\u4f5c\u6210\u3055\u308c\u305f\u30ec\u30b3\u30fc\u30c9\u5168\u4f53\u3092\u53d6\u5f97\u3057\u3066\u8fd4\u3059\n        new_id = cursor.lastrowid\n        cursor.execute("SELECT * FROM model_trains WHERE id = ?", (new_id,))\n        result = cursor.fetchone()\n        return dict(result)\n\n    except sqlite3.IntegrityError:\n        # product_number\u304c\u65e2\u306b\u5b58\u5728\u3059\u308b\u5834\u5408\uff08UNIQUE\u5236\u7d04\u9055\u53cd\uff09\n        raise Exception("\u3053\u306e\u88fd\u54c1\u756a\u53f7\u306f\u65e2\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5b58\u5728\u3057\u307e\u3059\u3002")\n    except Exception as e:\n        raise Exception(f"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f: {e}")\n\ndef get_all_trains(db: sqlite3.Connection) -> List[dict]:\n    """\u5168\u3066\u306e\u5217\u8eca\u30ec\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3059\u308b"""\n    cursor = db.cursor()\n    cursor.execute("SELECT * FROM model_trains")\n    rows = cursor.fetchall()\n    return [dict(row) for row in rows]\n\ndef get_train_by_product_number(db: sqlite3.Connection, product_number: str) -> Optional[dict]:\n    """\u88fd\u54c1\u756a\u53f7\u304b\u3089\u7279\u5b9a\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3059\u308b"""\n    cursor = db.cursor()\n    cursor.execute("SELECT * FROM model_trains WHERE product_number = ?", (product_number,))\n    row = cursor.fetchone()\n    return dict(row) if row else None\n\ndef update_train_record(db: sqlite3.Connection, product_number: str, data: dict) -> Optional[dict]:\n    """\u7279\u5b9a\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u66f4\u65b0\u3059\u308b"""\n    sql = """\n    UPDATE model_trains SET \n        train_name = ?, manufacturer = ?, memo = ?, photo_url = ?\n        WHERE product_number = ?\n    """\n    # Product_number\u306fWHERE\u53e5\u3067\u4f7f\u3044\u3001\u30c7\u30fc\u30bf\u81ea\u4f53\u306fupdate\u306e\u5f15\u6570\u304b\u3089\u53d6\u5f97\n    try:\n        cursor = db.cursor()\n        cursor.execute(sql, (\n            data.get("train_name"),\n            data.get("manufacturer"),\n            data.get("memo"),\n            data.get("photo_url"),\n            product_number # WHERE\u53e5\u306e\u5024\n        ))\n        db.commit()\n        \n        # \u66f4\u65b0\u3055\u308c\u305f\u30ec\u30b3\u30fc\u30c9\u3092\u518d\u53d6\u5f97\u3057\u3066\u8fd4\u3059\n        cursor.execute("SELECT * FROM model_trains WHERE product_number = ?", (product_number,))\n        row = cursor.fetchone()\n        return dict(row) if row else None\n\n    except Exception as e:\n        raise Exception(f"\u66f4\u65b0\u4e2d\u306b\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f: {e}")\n\ndef delete_train_record(db: sqlite3.Connection, product_number: str) -> bool:\n    """\u7279\u5b9a\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u524a\u9664\u3059\u308b"""\n    cursor = db.cursor()\n    cursor.execute("DELETE FROM model_trains WHERE product_number = ?", (product_number,))\n    db.commit()\n    return cursor.rowcount > 0\n<\/code><\/pre>\n\n\n\n
\u305d\u3057\u3066\u30c7\u30fc\u30bf\u30b9\u30ad\u30fc\u30de<\/p>\n\n\n\n
# models.py\nfrom pydantic import BaseModel, Field\nfrom typing import Optional\n\n# --- \u5165\u529b\u30e2\u30c7\u30eb\uff08POST\/PUT\u3067API\u306b\u6e21\u3055\u308c\u308b\u30c7\u30fc\u30bf\uff09 ---\nclass TrainCreate(BaseModel):\n    """\u65b0\u898f\u4f5c\u6210\u6642\u306b\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u69cb\u9020"""\n    train_name: str = Field(description="\u5217\u8eca\u540d")\n    manufacturer: str = Field(description="\u88fd\u9020\u30e1\u30fc\u30ab\u30fc")\n    product_number: str = Field(description="\u88fd\u54c1\u756a\u53f7 (\u30e6\u30cb\u30fc\u30af\u5fc5\u9808)")\n    memo: Optional[str] = Field(default=None, description="\u30e1\u30e2\u6b04")\n    photo_url: Optional[str] = Field(default=None, description="\u5199\u771f\u306eURL")\n\n# --- \u51fa\u529b\u30e2\u30c7\u30eb\uff08API\u304b\u3089\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306b\u8fd4\u3055\u308c\u308b\u30c7\u30fc\u30bf\uff09 ---\nclass TrainResponse(BaseModel):\n    """\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u53d6\u5f97\u3055\u308c\u308b\u5168\u60c5\u5831\u3092\u542b\u3080\u69cb\u9020"""\n    id: int\n    train_name: str\n    manufacturer: str\n    product_number: str\n    memo: Optional[str]\n    photo_url: Optional[str]\n    \n    class Config:\n        # Pydantic\u304cSQL\u306eRow\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6b63\u3057\u304f\u6271\u3048\u308b\u3088\u3046\u306b\u8a2d\u5b9a\n        orm_mode = True\n<\/code><\/pre>\n\n\n\n
\u6b21\u306b\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8<\/p>\n\n\n\n
# main.py\nfrom fastapi import FastAPI, Depends, HTTPException, status\nfrom typing import List\nimport sqlite3\n\nfrom models import TrainCreate, TrainResponse\nfrom database import (\n    initialize_db, \n    get_db_connection, \n    create_train_record, \n    get_all_trains, \n    get_train_by_product_number, \n    update_train_record, \n    delete_train_record\n)\n\n# -----------------------------------------------------\n# \u521d\u671f\u5316\u51e6\u7406\uff08\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u8d77\u52d5\u6642\u306b\u4e00\u5ea6\u3060\u3051\u5b9f\u884c\uff09\n# -----------------------------------------------------\napp = FastAPI(title="Railway Model Database API")\n\n# \u8d77\u52d5\u6642\u306bDB\u3092\u521d\u671f\u5316\u3059\u308b\uff08\u3053\u308c\u306f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30e9\u30f3\u30bf\u30a4\u30e0\u306b\u4f9d\u5b58\u3057\u307e\u3059\uff09\n@app.on_event("startup")\nasync def startup_event():\n    initialize_db()\n\n\n# -----------------------------------------------------\n# \u4f9d\u5b58\u6027\u6ce8\u5165 (Dependency)\n# -----------------------------------------------------\n# FastAPI\u304c\u30ea\u30af\u30a8\u30b9\u30c8\u3054\u3068\u306bDB\u63a5\u7d9a\u3092\u63d0\u4f9b\u3059\u308b\u305f\u3081\u306e\u4f9d\u5b58\u6027\u30b8\u30a7\u30cd\u30ec\u30fc\u30bf\ndb_dependency = Depends(get_db_connection)\n\n\n# -----------------------------------------------------\n# \u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u5b9a\u7fa9\n# -----------------------------------------------------\n\n@app.post("\/trains", response_model=TrainResponse, status_code=status.HTTP_201_CREATED)\nasync def create_model_train(\n    train_data: TrainCreate, \n    db: sqlite3.Connection = Depends(db_dependency)\n):\n    """\u65b0\u3057\u3044\u6a21\u578b\u5217\u8eca\u3092\u767b\u9332\u3059\u308b (CREATE)"""\n    try:\n        record = create_train_record(db, train_data.dict())\n        # database.py\u3067dict\u306b\u5909\u63db\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001\u76f4\u63a5Response\u306b\u6e21\u305b\u308b\n        return record\n    except Exception as e:\n        # \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5c64\u3067\u767a\u751f\u3057\u305f\u30a8\u30e9\u30fc\u3092\u9069\u5207\u306aHTTP\u30a8\u30e9\u30fc\u306b\u5909\u63db\n        if "\u65e2\u306b\u5b58\u5728\u3057\u307e\u3059" in str(e):\n            raise HTTPException(\n                status_code=status.HTTP_409_CONFLICT, \n                detail=str(e)\n            )\n        raise HTTPException(\n            status_code=status.HTTP_500_INTERNAL_SERVER_ERROR,\n            detail=str(e)\n        )\n\n\n@app.get("\/trains", response_model=List[TrainResponse])\nasync def list_all_trains(db: sqlite3.Connection = Depends(db_dependency)):\n    """\u5168\u30e2\u30c7\u30eb\u5217\u8eca\u306e\u4e00\u89a7\u3092\u53d6\u5f97\u3059\u308b (READ All)"""\n    records = get_all_trains(db)\n    return records\n\n\n@app.get("\/trains\/product\/{product_number}", response_model=TrainResponse)\nasync def get_single_train(product_id: str, db: sqlite3.Connection = Depends(lambda: None)):\n    """\u88fd\u54c1ID\u3067\u7279\u5b9a\u306e\u5217\u8eca\u60c5\u5831\u3092\u53d6\u5f97\u3059\u308b"""\n    # \u6ce8: \u73fe\u72b6\u306e\u69cb\u9020\u4e0a\u3001product_id\u3092\u5f15\u6570\u3068\u3057\u3066\u53d7\u3051\u53d6\u308c\u308b\u3088\u3046\u306b\u8abf\u6574\u304c\u5fc5\u8981\u3067\u3059\u3002\n    # \u7c21\u7565\u5316\u306e\u305f\u3081\u3001\u3053\u3053\u3067\u306f\u5358\u306b\u53d6\u5f97\u3057\u305f\u7d50\u679c\u3092\u8fd4\u3059\u5f62\u306b\u3057\u307e\u3059\u3002\n    # \u5b9f\u969b\u306e\u5b9f\u88c5\u3067\u306f\u3001product_id\u3092\u4f7f\u3063\u3066WHERE\u53e5\u3092\u7d44\u307f\u7acb\u3066\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\n    \n    # \u7c21\u6613\u30c6\u30b9\u30c8\u306e\u305f\u3081\u3001\u3053\u3053\u3067\u306f\u30c0\u30df\u30fc\u3067\u4e00\u3064\u53d6\u5f97\u3059\u308b\u3075\u308a\n    # \u5b9f\u969b\u306fproduct_id\u3092\u5f15\u6570\u3068\u3057\u3066\u53d7\u3051\u53d6\u308b\u3088\u3046\u306b\u8abf\u6574\u3057\u3001DB\u30af\u30a8\u30ea\u306b\u7d44\u307f\u8fbc\u3080\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\n    \n    # \u2605\u2605\u2605 \u69cb\u9020\u7684\u306a\u5236\u7d04\u306e\u305f\u3081\u3001\u3053\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306f\u52d5\u4f5c\u78ba\u8a8d\u6642\u306b\u8abf\u6574\u304c\u5fc5\u8981\u3067\u3059 \u2605\u2605\u2605\n    \n    # \u3053\u3053\u3067\u306f\u3001\u4f8b\u3068\u3057\u3066\u88fd\u54c1ID\u304c\u4e00\u81f4\u3057\u305f\u3082\u306e\u3092\u53d6\u5f97\u3059\u308b\u51e6\u7406\u3092\u60f3\u5b9a\u3057\u307e\u3059\u3002\n    # \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30af\u30a8\u30ea\u3092\u7d44\u307f\u7acb\u3066\u3066\u3001\u7d50\u679c\u3092\u8fd4\u3057\u307e\u3059\u3002\n    \n    # \u3053\u306e\u4f8b\u3067\u306f\u3001product_id\u3092\u305d\u306e\u307e\u307e\u691c\u7d22\u30ad\u30fc\u3068\u3057\u3066\u4f7f\u7528\u3057\u3001\u5358\u4e00\u306e\u7d50\u679c\u3092\u8fd4\u3059\u3068\u4eee\u5b9a\u3057\u307e\u3059\u3002\n    pass # \u5b9f\u969b\u306e\u52d5\u4f5c\u78ba\u8a8d\u6642\u306b\u306f\u9069\u5207\u306a\u30af\u30a8\u30ea\u3067\u7f6e\u304d\u63db\u3048\u3066\u304f\u3060\u3055\u3044\n    \n\n@app.put("\/trains\/{product_id}")\nasync def update_train_info(product_id: str, new_data: dict, db: sqlite3.Connection = Depends(lambda: None)):\n    """\u6307\u5b9a\u3055\u308c\u305fID\u306e\u5217\u8eca\u60c5\u5831\u3092\u66f4\u65b0\u3059\u308b (PUT)"""\n    # \u2605\u2605\u2605 \u975e\u5e38\u306b\u9ad8\u5ea6\u306a\u51e6\u7406\u306e\u305f\u3081\u3001\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u3067\u6b8b\u3057\u307e\u3059 \u2605\u2605\u2605\n    pass\n\n\n# \u5b9f\u884c\u7528\u30b3\u30fc\u30c9\uff08FastAPI\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\uff09\n# \u5b9f\u969b\u306b\u52d5\u4f5c\u3055\u305b\u308b\u306b\u306f\u3001\u5fc5\u8981\u306a\u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3068FastAPI\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u304c\u5fc5\u8981\u3067\u3059\u3002\n# from fastapi import FastAPI, Depends\n# app = FastAPI()\n# app.get("\/")\n# app.get("\/trains") \n# app.put("\/trains\/{product_id}")\n\n<\/code><\/pre>\n\n\n\n
\u6700\u5f8c\u306b\u5b9f\u884c\u65b9\u6cd5\u307e\u3067\u51fa\u529b\u3057\u3066\u304f\u308c\u305f<\/p>\n\n\n\n
uvicorn main:app --reload<\/code><\/pre>\n\n\n\n
\u3067\u3001\u3053\u308c\u3089\u306e\u30b3\u30fc\u30c9\u3092\u30b3\u30d4\u30fc\u3057\u3066\u52d5\u304b\u3057\u3066\u307f\u305f\u3068\u3053\u308d\u2026\u2026\u52d5\u304b\u306a\u3044\u3002\u3068\u3044\u3046\u308f\u3051\u3067\u30c7\u30d0\u30c3\u30b0\u958b\u59cb\u3002<\/p>\n\n\n\n
\u30c7\u30d0\u30c3\u30b0<\/h2>\n\n\n\n
\u307e\u305a\u6700\u521d\u306e\u30a8\u30e9\u30fc<\/p>\n\n\n\n
TypeError: Depends(dependency=<function get_db_connection at 0x7ce488b91940>, use_cache=True, scope=None) is not a callable object<\/code><\/pre>\n\n\n\n
\u3053\u308c\u306f\u4f55\u304b\u3068\u3044\u3046\u3068\u3001<\/p>\n\n\n\n
# -----------------------------------------------------\n# \u4f9d\u5b58\u6027\u6ce8\u5165 (Dependency)\n# -----------------------------------------------------\n# FastAPI\u304c\u30ea\u30af\u30a8\u30b9\u30c8\u3054\u3068\u306bDB\u63a5\u7d9a\u3092\u63d0\u4f9b\u3059\u308b\u305f\u3081\u306e\u4f9d\u5b58\u6027\u30b8\u30a7\u30cd\u30ec\u30fc\u30bf\ndb_dependency = Depends(get_db_connection)<\/code><\/pre>\n\n\n\n
\u3067\u4f5c\u3063\u305fdb_dependency<\/code>\u3092<\/p>\n\n\n\n
async def list_all_trains(db: sqlite3.Connection = Depends(db_dependency)):<\/code><\/pre>\n\n\n\n
\u66f4\u306bDepends<\/code>\u3067\u547c\u3073\u51fa\u3057\u3061\u3083\u3063\u3066\u304a\u308a\u3001\u30a8\u30e9\u30fc\u306b\u306a\u3063\u3066\u308b\u3088\u3046\u306a\u306e\u3067\u3001<\/p>\n\n\n\n
async def list_all_trains(db: sqlite3.Connection = Depends(get_db_connection)):<\/code><\/pre>\n\n\n\n
get_db_connection<\/code>\u3092\u76f4\u63a5Depends\u306b\u308f\u305f\u3059\u3088\u3046\u306b\u4fee\u6b63\u3002<\/p>\n\n\n\n
\u6b21\u306e\u30a8\u30e9\u30fc<\/p>\n\n\n\n
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 125883013232320 and this is thread id 125883051241600.<\/code><\/pre>\n\n\n\n
\u30a8\u30e9\u30fc\u306e\u5185\u5bb9\u3068\u3057\u3066\u306f\u3001sqlite3.connection<\/code>\u95a2\u6570\u3092\u547c\u3073\u51fa\u3057\u305f\u30b9\u30ec\u30c3\u30c9\u3068db.cursor()<\/code>\u3092\u547c\u3093\u3067\u308b\u30b9\u30ec\u30c3\u30c9\u304c\u7570\u306a\u3063\u3066\u304a\u308a\u3001Sqlite\u304c\u30a8\u30e9\u30fc\u306b\u306a\u3063\u3066\u3044\u308b\u3082\u306e\u3002<\/p>\n\n\n\n
\u30d1\u30c3\u30c8\u898b\u30b9\u30ec\u30c3\u30c9\u306a\u3093\u304b\u4f7f\u3063\u3066\u306a\u3044\u306e\u306b?\u3063\u3066\u601d\u3063\u305f\u3051\u3069\u3001\u8272\u3005\u8abf\u3079\u305f\u7d50\u679c<\/p>\n\n\n\n
Depends<\/code>\u306b\u6e21\u3057\u3066\u308b\u95a2\u6570\u304c<\/p>\n\n\n\n