tipu
Reputation: 9604
sqlalchemy returning result as Query object instead of MyModel type
accounts = db.query(models.MyModel).filter(models.MyModel.id == user_id)
print(accounts)
results in
<sqlalchemy.orm.query.Query object at 0x1dbafd0>,
I expected a list or something of MyModel but i get back an object query. How can I get a list of MyModel instead?
Upvotes: 4
Views: 7874
Answers (1)
dwerner
Reputation: 6602
You need to call .all() on that query. The object you are getting back is the unmaterialized query.
Upvotes: 11
Related Questions
- SQLAlchemy getting a class object instead of actual result
- SQLAlchemy - Why I keep receiving the object model instead of the value of query, after .query().all()?
- Accessing the data from SQLalchemy query object?
- SQLalechemy query returns object instead of value
- Querying DB inside SQLAlchemy Model
- Get SQL data type from sqlalchemy model
- query from sqlalchemy returns AttributeError: 'NoneType' object
- Problem with sqlAlchemy model
- How to map the result from a query to a custom object in sqlalchemy?
- SQLAlchemy expects an object, but finds a Table