How to manually create a SQLAlchemy query object?

Question

My goal is to mock my DAO class's methods so that I can preform unit tests without having to send a request to the database.

Currently, my plan is to use mock to set the return type of a specific method that returns a object of type sqlalchemy.engine.row.Row. However, I cannot find documentation on how to manually create this object.

Can someone point me in the right direction or show me how to create that object?

Does [this answer](https://stackoverflow.com/a/52357483/14316282) help? — Rolv Apneseth, Aug 28 '21 at 22:54
No, it does not for my specific use case. My code is vastly different than their setup and I cannot simply mock the connection object — desap, Aug 28 '21 at 23:03
I am looking for the answer on how to create a sqlalchemy.engine.row.Row object so that I can manually set a return value of an method — desap, Aug 28 '21 at 23:06
You could possibly substitute a named tuple - `Row` tries to emulate its API. — snakecharmerb, Aug 29 '21 at 16:42

score 0 · Answer 1 · answered Jun 05 '23 at 11:19

0

Just for futur vistors who might land on this page, as pointed out by snakecharmerb-on-strike, using a python builtin named tuple will do the job.

answered Jun 05 '23 at 11:19

Alexandre_Bon

126
7

How to manually create a SQLAlchemy query object?

1 Answers1