我在python中使用SQLAlchemy的查询语句时,查询所有结果得到的列表的数量不是mysql中表的数据数量,但是用count()查询数量时正确,是哪里出错了呢。代码如下
engine = create_engine('mysql+pymysql://root:123456@localhost:3306/test')
Base = declarative_base()
class Users(Base):
__tablename__ = "test"
id = Column(Integer, primary_key=True)
name = Column(String(64), unique=True)
email = Column(String(64))
def __init__(self, name, email):
self.name = name
self.email = email
DbSession = sessionmaker(bind=engine)
session = DbSession()
users = session.query(Users).all()