{"id":26235,"date":"2023-06-08T20:02:17","date_gmt":"2023-06-08T16:32:17","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/day-46-47-beginner-fastapi-series-part-3-4i14\/"},"modified":"2023-06-08T20:02:17","modified_gmt":"2023-06-08T16:32:17","slug":"day-46-47-beginner-fastapi-series-part-3-4i14","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/day-46-47-beginner-fastapi-series-part-3-4i14\/","title":{"rendered":"\u0631\u0648\u0632 46-47: \u0633\u0631\u06cc FastAPI \u0645\u0628\u062a\u062f\u06cc &#8211; \u0642\u0633\u0645\u062a 3"},"content":{"rendered":"<div data-article-id=\"1497134\" id=\"article-body\">\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u067e\u0633\u062a\u060c \u0645\u0627 \u0628\u0647 \u062c\u0632\u0626\u06cc\u0627\u062a \u0628\u06cc\u0634\u062a\u0631 FastAPI \u0645\u06cc \u067e\u0631\u062f\u0627\u0632\u06cc\u0645 \u06a9\u0647 \u0634\u0646\u06cc\u062f\u0647 \u0627\u0645 \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a API \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0639\u0627\u0644\u06cc \u0627\u0633\u062a.  \u0645\u0627 \u06cc\u06a9 API \u0633\u0627\u062f\u0647 \u0648 \u0633\u0631\u0631\u0627\u0633\u062a \u0627\u06cc\u062c\u0627\u062f \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f\u060c \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u06a9 &#8220;Person&#8221; \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062f\u0644 \u062e\u0648\u062f \u0628\u0627 \u0633\u0647 \u0648\u06cc\u0698\u06af\u06cc: first_name\u060c last_name\u060c \u0648 active.  \u0647\u062f\u0641 \u062f\u0631\u06a9 \u0648 \u0628\u0647 \u06a9\u0627\u0631\u06af\u06cc\u0631\u06cc \u062a\u06a9\u0646\u06cc\u06a9 \u0647\u0627 \u0648 \u0645\u0641\u0627\u0647\u06cc\u0645\u06cc \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0686\u0646\u062f \u0631\u0648\u0632 \u06af\u0630\u0634\u062a\u0647 \u062f\u0631 \u0645\u0648\u0631\u062f \u0622\u0646\u0647\u0627 \u0645\u0637\u0627\u0644\u0639\u0647 \u06a9\u0631\u062f\u0647 \u0627\u0645.<\/p>\n<p>\u062f\u0631 \u0642\u0633\u0645\u062a 2 \u0646\u062d\u0648\u0647 \u06a9\u0627\u0631 \u0645\u0633\u06cc\u0631\u0647\u0627 \u0631\u0627 \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u06cc\u0645.  \u0627\u06cc\u0646 \u0628\u0627\u0631 \u0645\u0627 \u062f\u0631 \u0648\u0627\u0642\u0639 \u0628\u0627 \u06cc\u06a9 \u0645\u062f\u0644 Person \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0648 \u0639\u0645\u0644\u06a9\u0631\u062f\u06cc \u0628\u0631\u0627\u06cc \u0645\u0627\u0646\u062f\u06af\u0627\u0631\u06cc \u0648 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645.  \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u062a\u0645\u0631\u06cc\u0646\u060c SQLite \u0631\u0627 \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0633\u0628\u06a9 \u0648\u0632\u0646 \u0648 \u0648\u06cc\u0698\u06af\u06cc\u200c\u0647\u0627\u06cc \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u062f\u06cc\u0633\u06a9 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0631\u062f\u0645.  SqlLite \u0638\u0627\u0647\u0631\u0627 \u067e\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062a\u0631\u06cc\u0646 \u0645\u0648\u062a\u0648\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u0631 \u062c\u0647\u0627\u0646 \u0627\u0633\u062a \u0632\u06cc\u0631\u0627 \u062f\u0631 \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 \u062a\u0644\u0641\u0646 \u0647\u0627\u06cc \u0647\u0645\u0631\u0627\u0647 \u062a\u0639\u0628\u06cc\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u062f\u0631 \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u0631\u0648\u0632\u0627\u0646\u0647 \u0646\u06cc\u0632 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u062f\u0631 \u06cc\u06a9 \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u062c\u0627\u0646\u0628\u06cc\u060c \u0645\u0646 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0631\u062e\u06cc \u0627\u0632 \u067e\u0633\u062a \u0647\u0627\u06cc \u0622\u06cc\u0646\u062f\u0647 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 PostgreSQL \u0648 \u062d\u062a\u06cc MySQL \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0645\u060c \u0632\u06cc\u0631\u0627\u060c \u0686\u0631\u0627 \u06a9\u0647 \u0646\u0647\u061f  \u0628\u0647 \u0646\u0638\u0631 \u0645\u06cc \u0631\u0633\u062f \u06cc\u06a9 \u062a\u0645\u0631\u06cc\u0646 \u0627\u0633\u062a.  \u0627\u0645\u0627 \u0628\u0647 \u0647\u0631 \u062d\u0627\u0644 SQLite \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f [here] https:\/\/www.sqlitetutorial.net\/).<\/p>\n<p>\u0627\u0628\u0632\u0627\u0631 \u0645\u0627 \u06a9\u0647 \u0642\u0631\u0627\u0631 \u0627\u0633\u062a \u0628\u0631\u0627\u06cc \u0627\u0631\u062a\u0628\u0627\u0637 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u060c SQLAlchemy \u0627\u0633\u062a\u060c \u06cc\u06a9 \u062c\u0639\u0628\u0647 \u0627\u0628\u0632\u0627\u0631 SQL \u06a9\u0647 \u06cc\u06a9 API \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f.  \u0627\u06af\u0631 FastAPI \u0631\u0627 \u0628\u0627 <code>pip install \"fastapi[all]\"<\/code>\u060c SQLAlchemy \u062f\u0631 \u062d\u0627\u0644 \u062d\u0627\u0636\u0631 \u0628\u062e\u0634\u06cc \u0627\u0632 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0634\u0645\u0627 \u0627\u0633\u062a.  \u0627\u0645\u0627 \u0627\u06af\u0631 FastAPI \u0631\u0627 \u0628\u0647 \u062a\u0646\u0647\u0627\u06cc\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0631\u062f\u06cc\u062f\u060c \u0628\u0627\u06cc\u062f SQLAlchemy \u0631\u0627 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f <code>pip install sqlalchemy<\/code>.<\/p>\n<p>\u0645\u0646 \u0641\u0642\u0637 \u0628\u0647 \u0646\u06a9\u0627\u062a \u0642\u0627\u0628\u0644 \u062a\u0648\u062c\u0647 \u06a9\u062f \u0627\u0634\u0627\u0631\u0647 \u0645\u06cc \u06a9\u0646\u0645.  \u06a9\u062f \u06a9\u0627\u0645\u0644 \u062f\u0631 \u06cc\u06a9 \u0645\u062e\u0632\u0646 Github \u0648\u0627\u0642\u0639 \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f: https:\/\/github.com\/jenad88\/enad-project-1<\/p>\n<p>\u06cc\u06a9 \u0641\u0627\u06cc\u0644 db.py \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u062d\u0627\u0648\u06cc \u06a9\u062f\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0627\u0632 SQLAlchemy \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u06cc\u06a9 \u062c\u0639\u0628\u0647 \u0627\u0628\u0632\u0627\u0631 SQL \u0648 \u0633\u06cc\u0633\u062a\u0645 \u0646\u0642\u0634\u0647 \u0628\u0631\u062f\u0627\u0631\u06cc \u0634\u06cc\u0621-\u0631\u0627\u0628\u0637\u0647 \u0627\u06cc (ORM) \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u062a\u0648\u0646 \u0627\u0633\u062a \u0648 \u06cc\u06a9 \u0627\u0631\u062a\u0628\u0627\u0637 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f\u060c \u0633\u067e\u0633 \u0646\u062d\u0648\u0647 \u0627\u06cc\u062c\u0627\u062f \u062c\u0644\u0633\u0627\u062a \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u0645\u06cc \u06a9\u0646\u062f. <br \/>\u0648 \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u06cc\u06a9 \u06a9\u0644\u0627\u0633 Base \u0628\u0631\u0627\u06cc \u062a\u0639\u0631\u06cc\u0641 \u062c\u062f\u0627\u0648\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>from sqlalchemy import create_engine, Column, Integer, String, Boolean\nfrom sqlalchemy.ext.declarative import declarative_base\nfrom sqlalchemy.orm import sessionmaker\n\n# Create a sqlite engine instance\nengine = create_engine(\"sqlite:\/\/\/enad-core.db\")\n\n# Create SessionLocal class from sessionmaker factory\nSessionLocal = sessionmaker(bind=engine, expire_on_commit=False)\n\n# Create a DeclarativeMeta instance\nBase = declarative_base()\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><code>create_engine<\/code>  \u0628\u0631\u0627\u06cc \u062a\u0646\u0638\u06cc\u0645 \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u0648 Column\u060c Integer\u060c String \u0648 Boolean \u06a9\u0644\u0627\u0633 \u0647\u0627\u06cc\u06cc \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0628\u0631\u0627\u06cc \u062a\u0639\u0631\u06cc\u0641 \u0633\u0627\u062e\u062a\u0627\u0631 \u062c\u062f\u0648\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f.<\/p>\n<p><code>declarative_base<\/code>  \u06cc\u06a9 \u06a9\u0644\u0627\u0633 \u067e\u0627\u06cc\u0647 \u0627\u0633\u062a \u06a9\u0647 \u062a\u0648\u0633\u0637 \u0647\u0645\u0647 \u0645\u062f\u0644 \u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 sessionmaker \u06a9\u0627\u0631\u062e\u0627\u0646\u0647 \u0627\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0627\u0634\u06cc\u0627\u0621 Session \u062c\u062f\u06cc\u062f \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>\u0631\u0627 <code>create_engine<\/code> \u062a\u0627\u0628\u0639 \u06cc\u06a9 \u0646\u0645\u0648\u0646\u0647 \u0645\u0648\u062a\u0648\u0631 \u062c\u062f\u06cc\u062f \u0631\u0627 \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u0641\u0627\u06cc\u0644\u06cc \u0628\u0647 \u0646\u0627\u0645 enad-core.db \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u06a9\u0646\u062f.  \u062a\u0645\u0627\u0645 \u0627\u062a\u0635\u0627\u0644\u0627\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 SQLAlchemy \u0627\u0632 \u0627\u06cc\u0646 \u0645\u0648\u062a\u0648\u0631 \u0645\u06cc \u0622\u06cc\u062f.<\/p>\n<p><code>SessionLocal<\/code>  \u0627\u0632 \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0633\u062a <code>sessionmaker<\/code> \u0639\u0645\u0644\u06a9\u0631\u062f \u06a9\u0627\u0631\u062e\u0627\u0646\u0647  \u0645\u0646 \u0647\u0646\u06af\u0627\u0645 \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u0627\u0634\u06cc\u0627\u0621 Session \u062c\u062f\u06cc\u062f \u062a\u0648\u0644\u06cc\u062f \u0645\u06cc \u06a9\u0646\u0645.  \u0633\u067e\u0633 \u0627\u0632 \u0627\u06cc\u0646 \u0627\u0634\u06cc\u0627\u0621 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 &#8220;\u062f\u0633\u062a\u0647&#8221; \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u06a9\u0647 \u0627\u0645\u06a9\u0627\u0646 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>\u0631\u0627 <code>declarative_base<\/code> \u062a\u0627\u0628\u0639 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u062c\u062f\u06cc\u062f \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u0645\u06cc \u0634\u0648\u062f <code>Base<\/code> \u06a9\u0644\u0627\u0633  \u0627\u06cc\u0646 <code>Base<\/code> \u06a9\u0644\u0627\u0633 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06a9\u0644\u0627\u0633 \u067e\u0627\u06cc\u0647 \u0628\u0631\u0627\u06cc \u0647\u0645\u0647 \u0645\u062f\u0644\u200c\u0647\u0627\u06cc SQLAlchemy \u0639\u0645\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0628\u0639\u062f\u0627\u064b \u0646\u0634\u0627\u0646 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f.<\/p>\n<p>\u0634\u0631\u0648\u0639 \u0628\u0631\u0646\u0627\u0645\u0647 \u062f\u0631 \u067e\u0648\u0634\u0647 \/backend\/app \u062f\u0631 \u0641\u0627\u06cc\u0644\u06cc \u0628\u0647 \u0646\u0627\u0645 main.py \u0627\u0633\u062a<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>from fastapi import FastAPI\nfrom backend.app.routers import person_routers_v1\nfrom backend.app.db import Base, engine\n\ndef create_app():\n    app = FastAPI()\n\n    app.include_router(person_routers_v1.router, prefix=\"\/api\")\n\n    return app\n\n# Create the database\nBase.metadata.create_all(engine)\n\napp = create_app()\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u06a9\u062f \u0642\u0628\u0644\u06cc \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 FastAPI \u0628\u0627 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u06cc \u0627\u0632 \u0645\u0633\u06cc\u0631\u0647\u0627 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 SQLAlchemy \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u06cc \u06a9\u0646\u062f. <\/p>\n<p>\u062c\u062f\u0627 \u0627\u0632 \u0648\u0627\u0631\u062f \u0634\u062f\u0646 fastapi\u060c \u0645\u0627\u0698\u0648\u0644 person_routers_v1 \u06a9\u0647 \u062d\u0627\u0648\u06cc \u0631\u0648\u062a\u0631\u0647\u0627\u06cc &#8220;person&#8221; \u0627\u0633\u062a \u0646\u06cc\u0632 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a.  \u067e\u0627\u06cc\u0647 \u0648 \u0645\u0648\u062a\u0648\u0631 \u06a9\u0644\u0627\u0633 \u0647\u0627\u06cc SQLAlchemy \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0628\u0631\u0627\u06cc \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f.<\/p>\n<p>\u06a9\u0627\u0631\u06a9\u0631\u062f <code>create_app<\/code> \u062a\u0627\u0628\u0639\u06cc \u0627\u0633\u062a \u06a9\u0647 \u06cc\u06a9 \u0646\u0645\u0648\u0646\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 FastAPI \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u0648 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f.  \u0627\u06cc\u0646 \u0634\u0627\u0645\u0644 \u0645\u0633\u06cc\u0631\u0647\u0627\u06cc \u0631\u0648\u062a\u0631 person_routers_v1 \u0627\u0633\u062a \u0648 \u062f\u0627\u0631\u0627\u06cc \u067e\u06cc\u0634\u0648\u0646\u062f &#8220;\/api&#8221; \u0627\u0633\u062a.  \u0627\u06cc\u0646 \u0628\u062f\u0627\u0646 \u0645\u0639\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u062a\u0645\u0627\u0645 \u0645\u0633\u06cc\u0631\u0647\u0627\u06cc \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u062f\u0631 person_routers_v1 \u062f\u0627\u0631\u0627\u06cc &#8220;\/api&#8221; \u0642\u0628\u0644 \u0627\u0632 \u0645\u0633\u06cc\u0631 \u062e\u0648\u062f \u0647\u0633\u062a\u0646\u062f. <\/p>\n<p>\u0631\u0627 <code>Base.metadata.create_all(engine)<\/code> \u062e\u0637 \u062a\u0645\u0627\u0645 \u062c\u062f\u0627\u0648\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0627\u0632 \u06a9\u0644\u0627\u0633 \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0627\u0632 Base \u0628\u0647 \u0627\u0631\u062b \u0645\u06cc \u0628\u0631\u0646\u062f \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f. <\/p>\n<p><code>app = create_app()<\/code>  \u06cc\u06a9 \u0646\u0645\u0648\u0646\u0647 \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 FastAPI \u0631\u0627 \u0628\u0627 \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f <code>create_app<\/code> \u062a\u0627\u0628\u0639.<\/p>\n<p>\u06a9\u062f \u0628\u0627\u0642\u06cc\u0645\u0627\u0646\u062f\u0647 \u0633\u067e\u0633 \u062f\u0631 \u0633\u0647 \u067e\u0648\u0634\u0647 \u0633\u0627\u0632\u0645\u0627\u0646\u062f\u0647\u06cc \u0634\u062f\u0647 \u0627\u0633\u062a: \u0645\u062f\u0644 \u0647\u0627\u060c \u0631\u0648\u062a\u0631\u0647\u0627 \u0648 \u0637\u0631\u062d\u0648\u0627\u0631\u0647 \u0647\u0627<\/p>\n<p>\u062f\u0631 \u067e\u0648\u0634\u0647 \u0631\u0648\u062a\u0631\u0647\u0627 \u0641\u0627\u06cc\u0644 person_routers_v1.py \u0631\u0627 \u062f\u0627\u0631\u06cc\u0645.  \u0627\u06cc\u0646 \u0634\u0627\u0645\u0644 \u0627\u062c\u0631\u0627\u06cc CRUD (\u0627\u06cc\u062c\u0627\u062f\u060c \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc\u060c \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc\u060c \u062d\u0630\u0641) API \u0628\u0631\u0627\u06cc \u06cc\u06a9 \u0645\u062f\u0644 &#8220;Person&#8221; \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0686\u0627\u0631\u0686\u0648\u0628 FastAPI \u0627\u0633\u062a \u0648 \u0627\u0632 SQLAlchemy \u0628\u0631\u0627\u06cc \u0627\u0631\u062a\u0628\u0627\u0637\u0627\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>from fastapi import APIRouter, Depends, HTTPException, status\nfrom backend.app.db import SessionLocal\nfrom sqlalchemy.orm import Session\n\nimport backend.app.models.person_models_v1 as person_models_v1\nimport backend.app.schemas.person_schemas_v1 as person_schemas_v1\n\ndef get_session():\n    session = SessionLocal()\n    try:\n        yield session\n    finally:\n        session.close()\n\n\nrouter = APIRouter(\n    prefix=\"\/v1\/persons\",\n    tags=[\"persons\"],\n    responses={404: {\"description\": \"Not found\"}},\n)\n\n@router.get(\"\", response_model=person_schemas_v1.PersonListResponse, status_code=status.HTTP_200_OK)\ndef get_persons(session: Session = Depends(get_session)):\n\n    # get all persons\n    persons_list = session.query(person_models_v1.Person).all()\n\n    return {\"data\": persons_list}\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062a\u0648\u062c\u0647: \u0628\u0642\u06cc\u0647 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0631 \u0645\u062e\u0632\u0646 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f: https:\/\/github.com\/jenad88\/enad-project-1<\/p>\n<p>\u0631\u0627 <code>get_session<\/code> \u062a\u0627\u0628\u0639 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 SQLAlchemy \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0631\u062a\u0628\u0627\u0637 \u0628\u0631\u0642\u0631\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f <code>SessionLocal<\/code> \u0648 \u0633\u067e\u0633 \u062c\u0644\u0633\u0647 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0645\u0639\u0627\u0645\u0644\u0647 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f.  \u067e\u0633 \u0627\u0632 \u0627\u0646\u062c\u0627\u0645 \u0645\u0639\u0627\u0645\u0644\u0647\u060c \u062c\u0644\u0633\u0647 \u0628\u0633\u062a\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u0631\u0648\u062a\u0631 APIRouter \u0628\u0627 \u067e\u06cc\u0634\u0648\u0646\u062f URL \u0648 \u0628\u0631\u062e\u06cc \u0641\u0631\u0627\u062f\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u0645\u0633\u062a\u0646\u062f\u0627\u062a \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062e\u0637\u0627 \u0645\u0642\u062f\u0627\u0631\u062f\u0647\u06cc \u0627\u0648\u0644\u06cc\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u062f\u06a9\u0648\u0631\u0627\u062a\u0648\u0631 \u0631\u0648\u062a\u0631 \u0628\u0631\u0627\u06cc \u0645\u0631\u062a\u0628\u0637 \u06a9\u0631\u062f\u0646 \u0631\u0648\u0634 \u0647\u0627\u06cc \u062f\u0631\u062e\u0648\u0627\u0633\u062a HTTP (GET\u060c POST\u060c PUT\u060c DELETE) \u0628\u0627 \u0639\u0645\u0644\u06a9\u0631\u062f\u0647\u0627\u06cc \u0645\u0631\u0628\u0648\u0637\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.  \u0627\u06cc\u0646 \u062a\u0648\u0627\u0628\u0639 \u0645\u0633\u0626\u0648\u0644 \u0631\u0633\u06cc\u062f\u06af\u06cc \u0628\u0647 \u0639\u0645\u0644\u06cc\u0627\u062a CRUD \u062f\u0631 \u0645\u062f\u0644 &#8220;Person&#8221; \u0647\u0633\u062a\u0646\u062f.<\/p>\n<p>\u0631\u0627 <code>get_persons<\/code> \u062a\u0627\u0628\u0639 \u062a\u0645\u0627\u0645 \u0648\u0631\u0648\u062f\u06cc \u0647\u0627\u06cc Person \u0631\u0627 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0622\u0646\u0647\u0627 \u0631\u0627 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f.<\/p>\n<p>\u06a9\u0645\u06cc \u0637\u0648\u0644\u0627\u0646\u06cc \u0645\u06cc \u0634\u0648\u062f\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0641\u0639\u0644\u0627\u064b \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0628\u0647 \u067e\u0627\u06cc\u0627\u0646 \u0645\u06cc \u0631\u0633\u062f.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u062f\u0631 \u0627\u06cc\u0646 \u067e\u0633\u062a\u060c \u0645\u0627 \u0628\u0647 \u062c\u0632\u0626\u06cc\u0627\u062a \u0628\u06cc\u0634\u062a\u0631 FastAPI \u0645\u06cc \u067e\u0631\u062f\u0627\u0632\u06cc\u0645 \u06a9\u0647 \u0634\u0646\u06cc\u062f\u0647 \u0627\u0645 \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a API \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0639\u0627\u0644\u06cc \u0627\u0633\u062a. \u0645\u0627 \u06cc\u06a9 API \u0633\u0627\u062f\u0647 \u0648 \u0633\u0631\u0631\u0627\u0633\u062a \u0627\u06cc\u062c\u0627\u062f \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f\u060c \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u06a9 &#8220;Person&#8221; \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062f\u0644 \u062e\u0648\u062f \u0628\u0627 \u0633\u0647 \u0648\u06cc\u0698\u06af\u06cc: first_name\u060c last_name\u060c \u0648 active. \u0647\u062f\u0641 \u062f\u0631\u06a9 \u0648 \u0628\u0647 \u06a9\u0627\u0631\u06af\u06cc\u0631\u06cc \u062a\u06a9\u0646\u06cc\u06a9 \u0647\u0627 \u0648 \u0645\u0641\u0627\u0647\u06cc\u0645\u06cc \u0627\u0633\u062a &hellip;<\/p>\n","protected":false},"author":2,"featured_media":26236,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-26235","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/26235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=26235"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/26235\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/26236"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=26235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=26235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=26235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}