text: from typing import List, Optional
  
  from fastapi import FastAPI
  from sqlmodel import Field, Session, SQLModel, create_engine, select
  
  
  class Hero(SQLModel, table=True):
      id: Optional[int] = Field(default=None, primary_key=True)
      name: str = Field(index=True)
      secret_name: str
      age: Optional[int] = Field(default=None, index=True)
  
  
  sqlite_file_name = "database.db"
  sqlite_url = f"sqlite:///{sqlite_file_name}"
  
  connect_args = {"check_same_thread": False}
  engine = create_engine(sqlite_url, echo=True, connect_args=connect_args)
  
  
  def create_db_and_tables():
      SQLModel.metadata.create_all(engine)
  
  
  app = FastAPI()
  
  
  @app.on_event("startup")
  def on_startup():
      create_db_and_tables()
  
  
  @app.post("/heroes/", response_model=Hero)
  def create_hero(hero: Hero):
      with Session(engine) as session:
          session.add(hero)
          session.commit()
          session.refresh(hero)
          return hero
  
  
  @app.get("/heroes/", response_model=List[Hero])
  def read_heroes():
      with Session(engine) as session:
          heroes = session.exec(select(Hero)).all()
          return heroes
  