SQLAlchemy: 登録されているrowを数える

ここを読めば何となく分かる．

    from sqlalchemy.orm import declarative_base
    from sqlalchemy import Column, Integer, String
    from sqlalchemy import func
    from sqlalchemy.orm import sessionmaker
    
    Base = declarative_base()

    class User(Base):
        __tablename__ = 'users'
        id = Column(Integer, primary_key=True)
        name = Column(String)
        fullname = Column(String)
        nickname = Column(String)

    engine = create_engine('sqlite:///test.db', future=True)
    Base.metadata.create_all(bind=engine)

    inspector = inspect(engine)
    my_session = sessionmaker(bind=engine)
    session = my_session()
    print('#Data:', session.query(func.count('*')).select_from(User).scalar())