Error using table name as secondary value in many-to-many relationships in postgreSQL about sqlacodegen HOT 4 CLOSED

What is the error you get? According to SQLAlchemy documentation, passing the secondary table by its name is perfectly legit.

from sqlacodegen.

The complete stack trace of the error, using the original generated file, in a basic test reading the table content, is:

Traceback (most recent call last):
File "F:/desarrollo flask-ubu-novamag-17-18/ubu-flask-experiments/persistence/test_database.py", line 28, in
for instance in session.query(Atom):
File "G:\Flask\myproject27\venv\lib\site-packages\sqlalchemy\orm\session.py", line 1362, in query
return self._query_cls(entities, self, **kwargs)
File "G:\Flask\myproject27\venv\lib\site-packages\sqlalchemy\orm\query.py", line 139, in init
self._set_entities(entities)
File "G:\Flask\myproject27\venv\lib\site-packages\sqlalchemy\orm\query.py", line 150, in _set_entities
self._set_entity_selectables(self._entities)
File "G:\Flask\myproject27\venv\lib\site-packages\sqlalchemy\orm\query.py", line 180, in _set_entity_selectables
ent.setup_entity(*d[entity])
File "G:\Flask\myproject27\venv\lib\site-packages\sqlalchemy\orm\query.py", line 3585, in setup_entity
self._with_polymorphic = ext_info.with_polymorphic_mappers
File "G:\Flask\myproject27\venv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 764, in get
obj.dict[self.name] = result = self.fget(obj)
File "G:\Flask\myproject27\venv\lib\site-packages\sqlalchemy\orm\mapper.py", line 1948, in _with_polymorphic_mappers
configure_mappers()
File "G:\Flask\myproject27\venv\lib\site-packages\sqlalchemy\orm\mapper.py", line 2872, in configure_mappers
mapper._post_configure_properties()
File "G:\Flask\myproject27\venv\lib\site-packages\sqlalchemy\orm\mapper.py", line 1765, in _post_configure_properties
prop.init()
File "G:\Flask\myproject27\venv\lib\site-packages\sqlalchemy\orm\interfaces.py", line 184, in init
self.do_init()
File "G:\Flask\myproject27\venv\lib\site-packages\sqlalchemy\orm\relationships.py", line 1653, in do_init
self._process_dependent_arguments()
File "G:\Flask\myproject27\venv\lib\site-packages\sqlalchemy\orm\relationships.py", line 1678, in _process_dependent_arguments
setattr(self, attr, attr_value())
File "G:\Flask\myproject27\venv\lib\site-packages\sqlalchemy\ext\declarative\clsregistry.py", line 293, in call
(self.prop.parent, self.arg, n.args[0], self.cls)
sqlalchemy.exc.InvalidRequestError: When initializing mapper Mapper|Author|authors, expression 'authoring' failed to locate a name ("name 'authoring' is not defined"). If this is a class name, consider adding this relationship() to the <class 'persistence.novamag_search_error.Author'> class after both dependent classes have been defined.

If I modify the code as previously has been indicated, the error dissapears.
Greetings.

from sqlacodegen.

from sqlacodegen.

It seems that the problem was the lack of the explicit schema qualifier. The problem has been fixed 3 years ago.

from sqlacodegen.