SQLAlchemy, get object not bound to a Session

by

If you want a bunch of objects produced by querying a session to be usable outside the scope of the session, you need to expunge them for the session.

In your first function example, you will need to add a line:

session.expunge_all()

before

session.close()

More generally, let’s say the session is not closed right away, like in the first example. Perhaps this is a session that is kept active during entire duration of a web request or something like that. In such cases, you don’t want to do expunge_all. You will want to be more surgical:

for item in lst:
    session.expunge(item)

More Related Contents:

  1. Does SQLAlchemy have an equivalent of Django’s get_or_create?
  2. Speeding up pandas.DataFrame.to_sql with fast_executemany of pyODBC
  3. CS50: LIKE operator, variable substitution with % expansion
  4. Group by & count function in sqlalchemy
  5. Debugging (displaying) SQL command sent to the db by SQLAlchemy
  6. Flask-SQLalchemy update a row’s information
  7. Efficiently updating database using SQLAlchemy ORM
  8. SQLAlchemy ORDER BY DESCENDING?
  9. SQLAlchemy ON DUPLICATE KEY UPDATE
  10. Flask sqlalchemy many-to-many insert data
  11. How to upsert pandas DataFrame to PostgreSQL table?
  12. How to do an upsert with SqlAlchemy?
  13. SQLAlchemy: how to filter date field?
  14. method of iterating over sqlalchemy model’s defined columns?
  15. How to execute “left outer join” in SqlAlchemy
  16. Getting random row through SQLAlchemy
  17. Select NULL Values in SQLAlchemy
  18. How to delete a table in SQLAlchemy?
  19. sqlalchemy existing database query
  20. How to update sqlalchemy orm object by a python dict
  21. How to get number of affected rows in sqlalchemy?
  22. Flask-SQLAlchemy Constructor
  23. Trigger in sqlachemy
  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. How to prevent UUID primary key for new SQLAlchemy objects being created with the same value
  28. Retrieve query results as dict in SQLAlchemy
  29. SQLALchemy dynamic filter_by
  30. SQLAlchemy ordering by count on a many to many relationship

Leave a Comment