search

miki725 / alchemy-mock

SQLAlchemy mock helpers.
Other
82 stars 15 forks source link

Can mock-alchemy or alchemy-mock be used to mock session.execute(selectObject).where(...).scalars.fetchAll? #42

Open RobertHana opened 2 years ago

RobertHana commented 2 years ago

https://stackoverflow.com/q/69546839/6429049?sem=2

Can mock-alchemy or alchemy-mock be used to mock the following:

def fetch() -> List[MyEntity]:
  selectObject = sqlalchemy.select(MyEntity)
  with sqlalchemy.orm.Session(engine) as session:
    results = session.execute(selectObject)
    instances = results.scalars().fetchall()
    return instances
kentbull commented 8 months ago

I have a similar question minus the scalars() part. The fetchall() call is recognized by the mock yet it doesn't return the data I specify when using a UnifiedAlchemyMagicMock