Difference between filter and filter_by in SQLAlchemy

by

filter_by is used for simple queries on the column names using regular kwargs, like

db.users.filter_by(name="Joe")

The same can be accomplished with filter, not using kwargs, but instead using the ‘==’ equality operator, which has been overloaded on the db.users.name object:

db.users.filter(db.users.name=='Joe')

You can also write more powerful queries using filter, such as expressions like:

db.users.filter(or_(db.users.name=='Ryan', db.users.country=='England'))

More Related Contents:

  1. Writing a connection string when password contains special characters
  2. Does SQLAlchemy have an equivalent of Django’s get_or_create?
  3. How to write DataFrame to postgres table
  4. Speeding up pandas.DataFrame.to_sql with fast_executemany of pyODBC
  5. CS50: LIKE operator, variable substitution with % expansion
  6. SQLAlchemy create_all() does not create tables
  7. SQLAlchemy: What’s the difference between flush() and commit()?
  8. Group by & count function in sqlalchemy
  9. Debugging (displaying) SQL command sent to the db by SQLAlchemy
  10. SQL Alchemy ORM returning a single column, how to avoid common post processing
  11. How do I execute inserts and updates in an Alembic upgrade script?
  12. SQLAlchemy, get object not bound to a Session
  13. How to delete a record by id in Flask-SQLAlchemy
  14. How to upsert pandas DataFrame to PostgreSQL table?
  15. How to do an upsert with SqlAlchemy?
  16. SQLAlchemy printing raw SQL from create()
  17. method of iterating over sqlalchemy model’s defined columns?
  18. How to execute “left outer join” in SqlAlchemy
  19. Getting random row through SQLAlchemy
  20. Select NULL Values in SQLAlchemy
  21. sqlalchemy existing database query
  22. How to get number of affected rows in sqlalchemy?
  23. Flask-SQLAlchemy Constructor
  24. convert selected datetime to date in sqlalchemy
  25. ImportError: cannot import name ‘_ColumnEntity’ from ‘sqlalchemy.orm.query’
  26. Is possible to mapping view with class using mapper in SqlAlchemy?
  27. SQLAlchemy: filtering on values stored in nested list of the JSONB field
  28. How to prevent UUID primary key for new SQLAlchemy objects being created with the same value
  29. SQLALchemy dynamic filter_by
  30. SQLAlchemy ordering by count on a many to many relationship

Leave a Comment