import contextlib
from sqlalchemy import Column, Integer, String, create_engine
from sqlalchemy.orm import declarative_base
Base = declarative_base()
engine = create_engine(
"sqlite:///example.db",
connect_args={"check_same_thread": False},
)
class Book(Base):
__tablename__ = "books"
id = Column(Integer, primary_key=True)
name = Column(String)
@contextlib.asynccontextmanager
async def lifespan(app):
Base.metadata.create_all(engine) # create teables
yield