Repository navigation
Expand file tree
/
Copy pathdb_app.py
More file actions
71 lines (51 loc) · 1.92 KB
/
Copy pathdb_app.py
File metadata and controls
71 lines (51 loc) · 1.92 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
from collections.abc import Generator
from contextlib import asynccontextmanager
from typing import Annotated
from fastapi import Depends, FastAPI, HTTPException
from pydantic import BaseModel, ConfigDict, EmailStr, Field
from sqlalchemy import String, create_engine, select
from sqlalchemy.exc import IntegrityError
from sqlalchemy.orm import DeclarativeBase, Mapped, Session, mapped_column, sessionmaker
engine = create_engine(
"sqlite:///./fastapi-sync.db",
connect_args={"check_same_thread": False},
)
SessionLocal = sessionmaker(bind=engine)
class Base(DeclarativeBase):
pass
class UserDB(Base):
__tablename__ = "users"
id: Mapped[int] = mapped_column(primary_key=True)
username: Mapped[str] = mapped_column(String(50))
email: Mapped[str] = mapped_column(String(200), unique=True)
class UserCreate(BaseModel):
username: str = Field(min_length=3, max_length=50)
email: EmailStr
class UserOut(UserCreate):
model_config = ConfigDict(from_attributes=True)
id: int
@asynccontextmanager
async def lifespan(app: FastAPI):
try:
Base.metadata.create_all(engine)
yield
finally:
engine.dispose()
app = FastAPI(lifespan=lifespan)
def get_session() -> Generator[Session, None, None]:
with SessionLocal() as session:
yield session
@app.post("/users", response_model=UserOut, status_code=201)
def create_user(user: UserCreate, session: Annotated[Session, Depends(get_session)]):
row = UserDB(**user.model_dump())
session.add(row)
try:
session.commit()
except IntegrityError as exc:
session.rollback()
raise HTTPException(409, "Email уже используется") from exc
session.refresh(row)
return UserOut.model_validate(row)
@app.get("/users", response_model=list[UserOut])
def list_users(session: Annotated[Session, Depends(get_session)]):
return session.scalars(select(UserDB).order_by(UserDB.id)).all()