Ok, I see that. Could you give me some hint how could I provide the useful
stack trace? What tool should I use?
W dniu czwartek, 16 stycznia 2020 01:24:52 UTC+1 użytkownik Mike Bayer
napisał:
>
> 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 [email protected] <javascript:>.
> 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/7004867d-f728-4133-8099-6509d010ae4d%40googlegroups.com.
