from utils import DATABASE_URL, create_db_and_tables, get_engine

# DATABASE_URL is read from the environment (falls back to sqlite:///./database.db)
engine = get_engine(echo=False)
create_db_and_tables()

from typing import Optional
from sqlmodel import SQLModel, Field
from utils import get_session, save, get, get_by_id, update, delete

class Item(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    name: str

# Create
with next(get_session()) as session:
    item = save(session, Item(name="hello"))

# Read
with next(get_session()) as session:
    all_items = get(session, Item)
    first = get_by_id(session, Item, item.id)

# Update (using another SQLModel/Pydantic object with updates)
class ItemUpdate(SQLModel):
    name: str

with next(get_session()) as session:
    updated = update(session, Item, item.id, ItemUpdate(name="updated"))

# Delete
with next(get_session()) as session:
    delete(session, Item, item.id)

from fastapi import FastAPI
from sqlmodel import SQLModel, Field
from utils.api import make_crud_router
from utils import get_session

class Book(SQLModel, table=True):
    id: int | None = Field(default=None, primary_key=True)
    title: str

class BookCreate(SQLModel):
    title: str

class BookRead(SQLModel):
    id: int
    title: str

class BookUpdate(SQLModel):
    title: str

app = FastAPI()
book_router = make_crud_router(
    model=Book,
    create_schema=BookCreate,
    read_schema=BookRead,
    update_schema=BookUpdate,
    prefix="/books",
    tags=["books"],
)
app.include_router(book_router)

from fastapi import FastAPI
from utils import lifespan

app = FastAPI(lifespan=lifespan)