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

[RobertHana]

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

[rajivsarvepalli]

No, this is not supported as of yet.

I can look into adding fetchall() natively on all returned scalars, but I am not sure of the effort required and interest in such a feature. The unified core is also a request feature that I will look into: #134 .

[kentbull]

I would like this feature.