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

by

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)
)

More Related Contents:

  1. How to execute raw SQL in Flask-SQLAlchemy app
  2. jsonify a SQLAlchemy result set in Flask [duplicate]
  3. How to build a flask application around an already existing database?
  4. Flask sqlalchemy many-to-many insert data
  5. How to delete a record by id in Flask-SQLAlchemy
  6. Get inserted key before commit session
  7. AttributeError: ‘int’ object has no attribute ‘_sa_instance_state’
  8. Getting first row from sqlalchemy
  9. flask-sqlalchemy or sqlalchemy
  10. Flask-SQLAlchemy Constructor
  11. SQLAlchemy ordering by count on a many to many relationship
  12. flask sqlalchemy query with keyword as variable
  13. Flask SQLAlchemy query, specify column names
  14. SQLAlchemy ORM conversion to pandas DataFrame
  15. Flask-SQLAlchemy import/context issue
  16. How to update SQLAlchemy row entry?
  17. Serve image stored in SQLAlchemy LargeBinary column
  18. SQLAlchemy ManyToMany secondary table with additional fields
  19. Can SQLAlchemy be used with Google Cloud SQL?
  20. Updates to JSON field don’t persist to DB
  21. ImportError: No module named MySQLdb
  22. ImportError: No module named flaskext.sqlalchemy
  23. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  24. SQLAlchemy – performing a bulk upsert (if exists, update, else insert) in postgresql
  25. ImportError: No module named sqlalchemy
  26. creating a database outside the application context
  27. Using SQLAlchemy models in and out of Flask
  28. Flask, SQLAlchemy : KeyError: ‘SQLALCHEMY_TRACK_MODIFICATIONS’
  29. Which SQLAlchemy column type should be used for binary data?
  30. Tyring to set up modelview with Flask-Admin causes ImportError

Leave a Comment