main.py

from fastapi import FastAPI, HTTPException, Depends
from pydantic import BaseModel
from typing import List, Annotated
import models 
from database import engine, SessionLocal
from sqlalchemy.orm import Session

app = FastAPI()
models.Base.metadata.create_all(bind=engine)


class ItemBase(BaseModel):
    id : int
    name: str
    price: float
    is_offer: bool = None

class ClientBase(BaseModel):
    id : int
    name: str
    phone: str

class OrderBase(BaseModel):
    id : int
    client: ClientBase
    items: List[ItemBase]

# CONEXION
    
def get_db():
    try:
        db = SessionLocal()
        yield db
    finally:
        db.close()

db_dependency = Annotated[Session, Depends(get_db)]

@app.post("/order/")
async def create_order(order: OrderBase, db: db_dependency):
    db_order = models.Order(client_id=order.client.id)
    db.add(db_order)
    db.commit()
    db.refresh(db_order)

    db_client = db.query(models.Client).filter(models.Client.name == order.client.name, models.Client.phone == order.client.phone).first()
    if not db_client:
        db_client = models.Client(name=order.client.name, phone=order.client.phone)
        db.add(db_client)
        db.commit()