there's no way to tell from here, information like the stack trace, and how the
tests are being run (like what test runner, any multiprocessing in use, etc.)
would be places to start.
On Mon, Jan 13, 2020, at 9:35 AM, Mirek Morek wrote:
> 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
>
> <https://groups.google.com/d/msgid/sqlalchemy/95b083fa-6fb7-4000-b0f9-6e9787f5f540%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
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/56c9fa54-7f22-4c7a-81ab-08b57627b9cb%40www.fastmail.com.
