SQLALchemy dynamic filter_by

by

Instead of using filter_by I would recommend using filter, it gives you a lot more options.

For example (from the manual):

db.session.query(MyClass).filter(
    MyClass.name == 'some name',
    MyClass.id > 5,
)

In relation to your case:

filters = (
    Transaction.amount > 10,
    Transaction.amount < 100,
)
db.session.query(Transaction).filter(*filters)

More Related Contents:

  1. SQL Alchemy ORM returning a single column, how to avoid common post processing
  2. Efficiently updating database using SQLAlchemy ORM
  3. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  4. SQLAlchemy ManyToMany secondary table with additional fields
  5. Bulk insert with SQLAlchemy ORM
  6. How can I verify Column data types in the SQLAlchemy ORM?
  7. SQLAlchemy: engine, connection and session difference
  8. sqlalchemy: create relations but without foreign key constraint in db?
  9. SQLAlchemy: how to filter date field?
  10. flask-sqlalchemy or sqlalchemy
  11. How to update sqlalchemy orm object by a python dict
  12. Is possible to mapping view with class using mapper in SqlAlchemy?
  13. SQLAlchemy ordering by count on a many to many relationship
  14. SQLAlchemy create_all() does not create tables
  15. How do I execute inserts and updates in an Alembic upgrade script?
  16. SQLAlchemy, get object not bound to a Session
  17. Flask sqlalchemy many-to-many insert data
  18. How to delete a record by id in Flask-SQLAlchemy
  19. How to do an upsert with SqlAlchemy?
  20. SQLAlchemy printing raw SQL from create()
  21. method of iterating over sqlalchemy model’s defined columns?
  22. How to execute “left outer join” in SqlAlchemy
  23. Getting random row through SQLAlchemy
  24. Select NULL Values in SQLAlchemy
  25. How to delete a table in SQLAlchemy?
  26. Trigger in sqlachemy
  27. ImportError: cannot import name ‘_ColumnEntity’ from ‘sqlalchemy.orm.query’
  28. SQLAlchemy: filtering on values stored in nested list of the JSONB field
  29. How to prevent UUID primary key for new SQLAlchemy objects being created with the same value
  30. flask sqlalchemy query with keyword as variable

Leave a Comment