from typing import Optional

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
    secret_name: str
    age: Optional[int] = None


sqlite_file_name = "database.db"
sqlite_url = f"sqlite:///{sqlite_file_name}"

engine = create_engine(sqlite_url, echo=True)


def create_db_and_tables():
    SQLModel.metadata.create_all(engine)


def create_heroes():
    hero_1 = Hero(name="Deadpond", secret_name="<NAME>")
    hero_2 = Hero(name="Spider-Boy", secret_name="<NAME>")
    hero_3 = Hero(name="Rusty-Man", secret_name="<NAME>", age=48)
    hero_4 = Hero(name="Tarantula", secret_name="<NAME>", age=32)
    hero_5 = Hero(name="<NAME>", secret_name="<NAME>", age=35)
    hero_6 = Hero(name="<NAME>", secret_name="<NAME>", age=36)
    hero_7 = Hero(name="Captain North America", secret_name="<NAME>", age=93)

    with 