On Mon, Mar 9, 2020, at 5:40 PM, Don Smiley wrote:
> In unit testing with multiple configurations, I am having trouble closing out
> everything to go on to the next iteration. For example, the test creates a
> class Address. I get the following kind of error:
>
> ```
> /venv/lib/python3.6/site-packages/SQLAlchemy-1.3.13-py3.6-linux-x86_64.egg/sqlalchemy/ext/declarative/clsregistry.py",
> line 97, in attempt_get\n % (".".join(path +
> [key]))\nsqlalchemy.exc.InvalidRequestError: Multiple classes found for path
> "Address" in the registry of this declarative base. Please use a fully
> module-qualified path.\n')
that error refers to the declarative base class. If your tests set up new
mappers against a Base each time,, you should use a new Base for each test run
that sets up those mappers. otherwise you will get conflicting names like above.
> ```
>
> My endcycle consists of among other things:
> * drop_all(echo=True)
> * drop database
>>
> ```
> engine = create_engine(config)
> conn = engine.connect()
> conn.execute("COMMIT")
> result = conn.execute(f"DROP DATABASE IF EXISTS {dbname}")
> result.close()
> conn.close()
> engine.dispose()
> ```
> * orm.session.close_all_sessions()
> * I have even tried del objects that have been created, but that seemed
> futile and desperate.
>
> Is there something else that I should be doing here, or in a different order?
> Or, should approach unit testing in a different way?
>
> I am thinking that I could probably unittest by shelling out each
> configuration to a separate process, but it seems to me that if I had a
> better understanding I would not need to do that.
>
> Any advice is welcome.
>
>
>
> --
> 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/83a39dbf-2062-416b-9f77-bfea51b90661%40googlegroups.com
>
> .
--
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/6bfbee5c-4526-494d-8230-19c941fea410%40www.fastmail.com.
