Hello, I use sqlalchemy to execute my tests on Postgres Database. I run like ~200 tests, every test uses its own setup and teardown. creates a connection and closes it after all.
I sometimes get *ResourceClosedError *(*"StatementError: (sqlalchemy.exc.ResourceClosedError) This Connection is closed"* in random places when tests are running one after another. It was not present on Sybase database. It seems like it wants to work on a closed connection...? For a single test run I never got that. Do you have any idea, what I could improve? This is a part of my code: from sqlalchemy import create_engine from sqlalchemy.orm import create_session from configuration import PostgresConfiguration as PGS class PostgresDatabase: def __init__(self): self.connection_string = r'postgresql://{}:{}@{}:{}/{}'.format( PGS.DB_USER, PGS.DB_PASSWORD, PGS.DB_HOST.split(":")[0], PGS.DB_HOST.split(":")[1], PGS.DB_NAME) self.engine = create_engine(self.connection_string, echo=True, label_length=30) self.session = create_session(self.engine) self.database_name = PGS.DB_NAME def get_session(self): """ Retrieves current session. :return: current session. """ return self.session def close_session(self): """ Closes all open sessions. """ self.session.close_all() def execute_query(self, query, commit=True): """ Executes query passes as a parameter. :param query: passed query to be executed. :param commit: if True session will be committed :return query execution results """ if commit: self.session.begin() results = self.session.execute(query) self.session.commit() else: results = self.session.execute(query) return results -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/95b083fa-6fb7-4000-b0f9-6e9787f5f540%40googlegroups.com.