How can I bind a list to a parameter in a custom query in SQLAlchemy?

by

A new approach to this problem that works for any database (not just relying on psycopg2’s type adaptation) uses expanding bind parameters:

sql_tmpl = """delete from Data where id_data in :iddata"""
params = { 'iddata': [1, 2, 3, 4], }
# session is a session object from sqlalchemy
t = text(sql_tmpl)
t = t.bindparams(bindparam('iddata', expanding=True))
self.session.execute(t, params)

More Related Contents:

  1. How to serialize SqlAlchemy result to JSON?
  2. How to execute raw SQL in Flask-SQLAlchemy app
  3. SQLAlchemy: print the actual query
  4. Query for list of attribute instead of tuples in SQLAlchemy
  5. SQLAlchemy: unexpected results when using `and` and `or`
  6. sqlalchemy: how to join several tables by one query?
  7. How to create an SQL View with SQLAlchemy?
  8. Serve image stored in SQLAlchemy LargeBinary column
  9. When do I need to use sqlalchemy back_populates?
  10. SQLAlchemy ManyToMany secondary table with additional fields
  11. Can SQLAlchemy be used with Google Cloud SQL?
  12. Updates to JSON field don’t persist to DB
  13. ImportError: No module named MySQLdb
  14. How do I select literal values in an sqlalchemy query?
  15. Get inserted key before commit session
  16. SQLAlchemy multiple foreign keys in one mapped class to the same primary key
  17. SQLAlchemy default DateTime
  18. Setting SQLAlchemy autoincrement start value
  19. Getting random row through SQLAlchemy
  20. Select NULL Values in SQLAlchemy
  21. How to delete a table in SQLAlchemy?
  22. sqlalchemy existing database query
  23. How to get number of affected rows in sqlalchemy?
  24. Flask-SQLAlchemy Constructor
  25. convert selected datetime to date in sqlalchemy
  26. ImportError: cannot import name ‘_ColumnEntity’ from ‘sqlalchemy.orm.query’
  27. Is possible to mapping view with class using mapper in SqlAlchemy?
  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