python - Querying with function on Flask-SQLAlchemy model gives BaseQuery object is not callable error

25
votes

I want to query services between two dates and sum their prices. When I try to use func.sum with Services.query, I get TypeError: BaseQuery object is not callable. How do I query using a function with Flask-SQLAlchemy?

Services.query(func.sum(Services.price)).filter(Services.dateAdd.between(start, end))
2
pythonflasksqlalchemyflask-sqlalchemy

2 Answers

31
votes

Model.query is a shortcut to db.session.query(Model), it's not callable. If you're not querying a model, continue to use db.session.query(...) as you would with regular SQLAlchemy.

db.session.query(db.func.sum(Services.price)).filter(
    Services.dateAdd.between(start, end)
)
0
votes

fwiw after this long time, you can use Flask-SQLAlchemy syntax by using:

Services.query(func.sum(Services.price)).filter(Services.dateAdd.between(start, end)).scalar()  # or you can use .scalar() ; .one() ; .first() ; .all() depending on what you want to achieve

Basically, syntax Model.query(...).filter(...) needs to end with what you want to get. This is what is missing from your query generating the error.

Query object in SQLAlchemy