SQLAlchemy IN clause

by

How about 

session.query(MyUserClass).filter(MyUserClass.id.in_((123,456))).all()

edit: Without the ORM, it would be 

session.execute(
    select(
        [MyUserTable.c.id, MyUserTable.c.name], 
        MyUserTable.c.id.in_((123, 456))
    )
).fetchall()

select() takes two parameters, the first one is a list of fields to retrieve, the second one is the where condition. You can access all fields on a table object via the c (or columns) property.

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. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  10. Debugging (displaying) SQL command sent to the db by SQLAlchemy
  11. SQL Alchemy ORM returning a single column, how to avoid common post processing
  12. How do I execute inserts and updates in an Alembic upgrade script?
  13. SQLAlchemy, get object not bound to a Session
  14. Bulk insert with SQLAlchemy ORM
  15. Flask sqlalchemy many-to-many insert data
  16. How to delete a record by id in Flask-SQLAlchemy
  17. Connection problems with SQLAlchemy and multiple processes
  18. How to upsert pandas DataFrame to PostgreSQL table?
  19. How to do an upsert with SqlAlchemy?
  20. SQLAlchemy printing raw SQL from create()
  21. SQLAlchemy: how to filter date field?
  22. method of iterating over sqlalchemy model’s defined columns?
  23. flake8 complains on boolean comparison “==” in filter clause
  24. How to execute “left outer join” in SqlAlchemy
  25. SQLAlchemy: get Model from table name. This may imply appending some function to a metaclass constructor as far as I can see
  26. pandas to_sql all columns as nvarchar
  27. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject
  28. Can’t change system default SQLite binary
  29. Connecting to SQL Server 2012 using sqlalchemy and pyodbc
  30. add column to SQLAlchemy Table

Leave a Comment