How to give column name dynamically from string variable in sql alchemy filter?

by

Just use getattr standard python library function to get an attribute by name:

col_name="subject"
db_session.query(Notice).filter(getattr(Notice, col_name).like("%" + query + "%"))

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: What’s the difference between flush() and commit()?
  7. Group by & count function in sqlalchemy
  8. Debugging (displaying) SQL command sent to the db by SQLAlchemy
  9. SQL Alchemy ORM returning a single column, how to avoid common post processing
  10. How do I execute inserts and updates in an Alembic upgrade script?
  11. SQLAlchemy, get object not bound to a Session
  12. Flask sqlalchemy many-to-many insert data
  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. SQLAlchemy: how to filter date field?
  18. method of iterating over sqlalchemy model’s defined columns?
  19. How to execute “left outer join” in SqlAlchemy
  20. flask-sqlalchemy or sqlalchemy
  21. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  22. SQLAlchemy Obtain Primary Key With Autoincrement Before Commit
  23. How to set connection timeout in SQLAlchemy
  24. SQLAlchemy – can you add custom methods to the query object?
  25. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  26. Which SQLAlchemy column type should be used for binary data?
  27. SQLAlchemy classes across files
  28. VALUES clause in SQLAlchemy
  29. How can I achieve a self-referencing many-to-many relationship on the SQLAlchemy ORM back referencing to the same attribute?
  30. flask sqlalchemy query with keyword as variable

Leave a Comment