簡單記錄一下使用FastAPI完成對數(shù)據(jù)庫的CRUD操作。在參考文檔的基礎(chǔ)上，增加了U、D部分忌愚，全部代碼可以參考Github 。
1. Installation
pip install fastapi
pip install uvicorn
pip install sqlalchemy
2. File Structure
1581931091044.jpg
其中：
- crud.py 完成對數(shù)據(jù)庫的CRUD操作
- database.py 關(guān)于數(shù)據(jù)庫相關(guān)配置
- main.py fastapi路由部分
- models.py 定義表結(jié)構(gòu)
- schemas.py 定義pydantic models信息却邓，也就是schemas
- init.py
3. Details
3.1 database.py
首先需要定義數(shù)據(jù)庫部分菜循，作為demo，使用sqlite作為我們的數(shù)據(jù)庫申尤。這部分都是常規(guī)配置操作癌幕。
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
SQLALCHEMY_DATABASE_URL = "sqlite:///./test.db"
engine = create_engine(
SQLALCHEMY_DATABASE_URL, connect_args={"check_same_thread": False}
)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
Base = declarative_base()
3.2 models.py
第二步需要定義我們的表結(jié)構(gòu)，這里定義了User表存儲用戶數(shù)據(jù)昧穿，item表用于存儲物品數(shù)據(jù)勺远，兩者關(guān)系是一對多。
from sqlalchemy import Boolean, Column, ForeignKey, Integer, String
from sqlalchemy.orm import relationship
from .database import Base
class User(Base):
__tablename__ = "users"
id = Column(Integer, primary_key=True, index=True)
email = Column(String, unique=True, index=True)
hashed_password = Column(String)
is_active = Column(Boolean, default=True)
items = relationship("Item", back_populates="owner")
def to_dict(self):
return {c.name: getattr(self, c.name) for c in self.__table__.columns}
class Item(Base):
__tablename__ = "items"
id = Column(Integer, primary_key=True, index=True)
title = Column(String, index=True)
description = Column(String, index=True)
owner_id = Column(Integer, ForeignKey("users.id"))
owner = relationship("User", back_populates="items")
def to_dict(self):
return {c.name: getattr(self, c.name) for c in self.__table__.columns}
3.3 schemas.py
第三步需要定義fastapi中schemas信息时鸵，后續(xù)路由胶逢、CRUD時都需要使用。由于增刪改查需要不同的schema饰潜，所以官網(wǎng)的最佳實踐一般都是通過繼承解決初坠。
from typing import List
from pydantic import BaseModel
class ItemBase(BaseModel):
title: str
description: str = None
class ItemCreate(ItemBase):
pass
class ItemUpdate(ItemBase):
pass
class Item(ItemBase):
id: int
owner_id: int
class Config:
orm_mode = True
class UserBase(BaseModel):
email: str
class UserCreate(UserBase):
password: str
class UserUpdate(UserBase):
is_active: bool
class User(UserBase):
id: int
is_active: bool
items: List[Item] = []
class Config:
orm_mode = True
3.4 crud.py
接下來就是實際完成CRUD，官網(wǎng)上沒有對update彭雾、delete做實例展示碟刺，這里補充一下。
from sqlalchemy.orm import Session
from . import models, schemas
def get_user(db: Session, user_id: int):
return db.query(models.User).filter(models.User.id == user_id).first()
def get_user_by_email(db: Session, email: str):
return db.query(models.User).filter(models.User.email == email).first()
def get_users(db: Session, skip: int = 0, limit: int = 100):
return db.query(models.User).offset(skip).limit(limit).all()
def create_user(db: Session, user: schemas.UserCreate):
fake_hashed_password = user.password + "notreallyhashed"
db_user = models.User(email=user.email, hashed_password=fake_hashed_password)
db.add(db_user)
db.commit()
db.refresh(db_user)
return db_user
def update_user(db: Session, user_id: int, update_user: schemas.UserUpdate):
db_user = db.query(models.User).filter(models.User.id == user_id).first()
if db_user:
update_dict = update_user.dict(exclude_unset=True)
for k, v in update_dict.items():
setattr(db_user, k, v)
db.commit()
db.flush()
db.refresh(db_user)
return db_user
def delete_user(db: Session, user_id: int):
db_user = db.query(models.User).filter(models.User.id == user_id).first()
if db_user:
db.delete(db_user)
db.commit()
db.flush()
return db_user
def get_items(db: Session, skip: int = 0, limit: int = 100):
return db.query(models.Item).offset(skip).limit(limit).all()
def create_user_item(db: Session, item: schemas.ItemCreate, user_id: int):
db_item = models.Item(**item.dict(), owner_id=user_id)
db.add(db_item)
db.commit()
db.refresh(db_item)
return db_item
def relate_user_item(db: Session, user_id: int, item_id: int):
db_item = db.query(models.Item).filter(models.Item.id == item_id).first()
if db_item:
db_item.owner_id = user_id
db.commit()
db.flush()
return db.query(models.User).filter(models.User.id == user_id).first()
def update_item(db: Session, item_id: int, update_item: schemas.ItemUpdate):
db_item = db.query(models.Item).filter(models.Item.id == item_id).first()
if db_item:
update_dict = update_item.dict(exclude_unset=True)
for k, v in update_dict.items():
setattr(db_item, k, v)
db.commit()
db.flush()
db.refresh(db_item)
return db_item
def delete_item(db: Session, item_id: int):
db_item = db.query(models.Item).filter(models.Item.id == item_id).first()
if db_item:
db.delete(db_item)
db.commit()
db.flush()
return db_item
3.5 main.py
最后完成路由的配置薯酝，基本都是按照官網(wǎng)上來的半沽，只是稍微補充了一些刪和改的內(nèi)容，為了讓這個demo更加完善吴菠。
from typing import List
from fastapi import Depends, FastAPI, HTTPException
from sqlalchemy.orm import Session
from . import crud, models, schemas
from .database import SessionLocal, engine
models.Base.metadata.create_all(bind=engine)
app = FastAPI()
# Dependency
def get_db():
try:
db = SessionLocal()
yield db
finally:
db.close()
@app.post("/users/", response_model=schemas.User)
def create_user(user: schemas.UserCreate, db: Session = Depends(get_db)):
db_user = crud.get_user_by_email(db, email=user.email)
if db_user:
raise HTTPException(status_code=400, detail="Email already registered")
return crud.create_user(db=db, user=user)
@app.get("/users/", response_model=List[schemas.User])
def read_users(skip: int = 0, limit: int = 100, db: Session = Depends(get_db)):
users = crud.get_users(db, skip=skip, limit=limit)
return users
@app.get("/users/{user_id}", response_model=schemas.User)
def read_user(user_id: int, db: Session = Depends(get_db)):
db_user = crud.get_user(db, user_id=user_id)
if db_user is None:
raise HTTPException(status_code=404, detail="User not found")
return db_user
@app.delete('/users/{user_id}', response_model=schemas.User)
def delete_user(user_id: int, db: Session = Depends(get_db)):
db_user = crud.delete_user(db, user_id=user_id)
if db_user is None:
raise HTTPException(status_code=404, detail="User not found")
return db_user
@app.put("/users/{user_id}", response_model=schemas.User)
def update_user(user_id: int, update_user: schemas.UserUpdate, db: Session = Depends(get_db)):
updated_user = crud.update_user(db, user_id, update_user)
if updated_user is None:
raise HTTPException(status_code=404, detail="User not found")
return updated_user
@app.post("/users/{user_id}/items/", response_model=schemas.Item)
def create_item_for_user(
user_id: int, item: schemas.ItemCreate, db: Session = Depends(get_db)
):
return crud.create_user_item(db=db, item=item, user_id=user_id)
@app.get("/items/", response_model=List[schemas.Item])
def read_items(skip: int = 0, limit: int = 100, db: Session = Depends(get_db)):
items = crud.get_items(db, skip=skip, limit=limit)
return items
@app.put("/items/{user_id}/{item_id}/", response_model=schemas.User)
def relate_user_item(user_id: int, item_id: int, db: Session = Depends(get_db)):
user = crud.relate_user_item(db=db, item_id=item_id, user_id=user_id)
return user
@app.put("/items/{item_id}", response_model=schemas.Item)
def update_item(item_id: int, update_item: schemas.ItemUpdate, db: Session = Depends(get_db)):
updated_item = crud.update_item(db, item_id, update_item)
if updated_item is None:
raise HTTPException(status_code=404, detail="Item not found")
return updated_item
@app.delete('/items/{item_id}', response_model=schemas.Item)
def delete_item(item_id: int, db: Session = Depends(get_db)):
db_item = crud.delete_item(db, item_id=item_id)
if db_item is None:
raise HTTPException(status_code=404, detail="User not found")
return db_item
4. Tests
在文件路徑下執(zhí)行者填，--reload當(dāng)代碼有修改時，可以自動加載做葵。
uvicorn sql_app.main:app --reload
可以通過postman發(fā)送請求做測試占哟，這里貼圖一張。
1581943691192.jpg
最后fastapi還可以自動生成文檔，可以訪問http://127.0.0.1:8000/docs查閱榨乎。
1581943651716.jpg
