Error when system name is "intro"
When a system is named "intro" in the file tests.ymal
, sqlalchemy fails to find a foreign key.
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:71] Error "Could not determine join condition between parent/child tables on relationship SampleModel.Test_blabla_intro_intro - there are no foreign keys linking these tables. Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or specify a 'primaryjoin' expression."
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:72] Traceback:
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] Traceback (most recent call last):
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/sqlalchemy/orm/relationships.py", line 2745, in _determine_joins
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] self.primaryjoin = join_condition(
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "<string>", line 2, in join_condition
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/sqlalchemy/sql/selectable.py", line 1229, in _join_condition
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] raise exc.NoForeignKeysError(
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] sqlalchemy.exc.NoForeignKeysError: Can't find any foreign key relationships between 'Sample' and 'Test_blabla_intro'.
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74]
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] The above exception was the direct cause of the following exception:
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74]
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] Traceback (most recent call last):
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/flask/app.py", line 1523, in full_dispatch_request
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] rv = self.dispatch_request()
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/flask/app.py", line 1509, in dispatch_request
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/FlexEval/flexeval/core/Stage.py", line 487, in wrapper
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] return func(*args, **kwargs)
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/FlexEval/flexeval/core/Module.py", line 238, in wrapper
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] return f(*args, **kwargs)
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/FlexEval/flexeval/mods/test/__init__.py", line 38, in main
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] test = TestManager().get(stage.name)
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/FlexEval/flexeval/mods/test/src/Test.py", line 155, in get
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] self.register[name] = Test(name, config)
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/FlexEval/flexeval/mods/test/src/Test.py", line 364, in __init__
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] SampleModel.addRelationship(
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/FlexEval/flexeval/database.py", line 118, in addRelationship
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] setattr(cls, name, relationship(TargetClass.__name__, **kwargs))
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/sqlalchemy/orm/decl_api.py", line 80, in __setattr__
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] _add_attribute(cls, key, value)
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/sqlalchemy/orm/decl_base.py", line 1116, in _add_attribute
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] cls.__mapper__.add_property(key, value)
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/sqlalchemy/orm/mapper.py", line 1939, in add_property
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] self._configure_property(key, prop, init=self.configured)
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/sqlalchemy/orm/mapper.py", line 1805, in _configure_property
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] prop.init()
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/sqlalchemy/orm/interfaces.py", line 231, in init
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] self.do_init()
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/sqlalchemy/orm/relationships.py", line 2143, in do_init
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] self._setup_join_conditions()
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/sqlalchemy/orm/relationships.py", line 2239, in _setup_join_conditions
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] self._join_condition = jc = JoinCondition(
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/sqlalchemy/orm/relationships.py", line 2634, in __init__
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] self._determine_joins()
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/sqlalchemy/orm/relationships.py", line 2767, in _determine_joins
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] util.raise_(
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] File "/home/user/.anaconda3/envs/flexeval/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] raise exception
[27/Jun/2022: 11:41:54 ] [CRITICAL] — [ErrorHandler — error:74] sqlalchemy.exc.NoForeignKeysError: Could not determine join condition between parent/child tables on relationship SampleModel.Test_blabla_intro_intro - there are no foreign keys linking these tables. Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or specify a 'primaryjoin' expression.
Edited by LECORVE Gwenole