How to close a SQLAlchemy session?

by

There’s a central confusion here over the word “session”. I’m not sure here, but it appears like you may be confusing the SQLAlchemy Session with a MySQL @@session, which refers to the scope of when you first make a connection to MySQL and when you disconnect.

These two concepts are not the same. A SQLAlchemy Session generally represents the scope of one or more transactions, upon a particular database connection.

Therefore, the answer to your question as literally asked, is to call session.close(), that is, “how to properly close a SQLAlchemy session”.

However, the rest of your question indicates you’d like some functionality whereby when a particular Session is closed, you’d like the actual DBAPI connection to be closed as well.

What this basically means is that you wish to disable connection pooling. Which as other answers mention, easy enough, use NullPool.

More Related Contents:

  1. SQLAlchemy: engine, connection and session difference
  2. How to serialize SqlAlchemy result to JSON?
  3. How to execute raw SQL in Flask-SQLAlchemy app
  4. jsonify a SQLAlchemy result set in Flask [duplicate]
  5. Using OR in SQLAlchemy
  6. SQLAlchemy: print the actual query
  7. Query for list of attribute instead of tuples in SQLAlchemy
  8. How to give column name dynamically from string variable in sql alchemy filter?
  9. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  10. SQLAlchemy: unexpected results when using `and` and `or`
  11. sqlalchemy: how to join several tables by one query?
  12. Is there an easy way to make sessions timeout in flask?
  13. When do I need to use sqlalchemy back_populates?
  14. Python call sql-server stored procedure with table valued parameter
  15. Generate sql with subquery as a column in select statement using SQLAlchemy
  16. How to expire session due to inactivity in Django?
  17. Bulk insert with SQLAlchemy ORM
  18. Can SQLAlchemy be used with Google Cloud SQL?
  19. How can I verify Column data types in the SQLAlchemy ORM?
  20. Complex foreign key constraint in SQLAlchemy
  21. Connection problems with SQLAlchemy and multiple processes
  22. How to upsert pandas DataFrame to Microsoft SQL Server table?
  23. Relations on composite keys using sqlalchemy
  24. SQLAlchemy default DateTime
  25. flake8 complains on boolean comparison “==” in filter clause
  26. SQLAlchemy – Mapping self-referential relationship as one to many (declarative form)
  27. Setting SQLAlchemy autoincrement start value
  28. Can’t change system default SQLite binary
  29. SQLAlchemy column name with space
  30. using sqlalchemy to load csv file into a database

Leave a Comment