cannot build pyfa with sqlalchemy 2.0.8

[yurats]

Bug Report

Looks like module relation was renamed to relationship in sqlalchemy 2.x.x

Expected behavior:

pyfa builds normally from git

Actual behavior:

File "/var/tmp/portage/games-util/pyfa-9999/work/pyfa-9999/eos/db/gamedata/alphaClones.py", line 21, in from sqlalchemy.orm import relation, mapper, synonym ImportError: cannot import name 'relation' from 'sqlalchemy.orm' (/usr/lib/python3.10/site-packages/sqlalchemy/orm/init.py)

Detailed steps to reproduce:

Release or development git branch? Please note the release version or commit hash:

b248cde

Operating system and version (eg: Windows 10, OS X 10.9, OS X 10.11, Ubuntu 16.10):

Gentoo Linux, Python 3.10, sqlalchemy 2.0.8

[UriAnteo]

Had this problem with Python 3.11; solved by also installing Python 3.7 (listed as requirement) and specifying it as the version to use when creating the virtual environment by doing py -3.7 -m venv PyfaEnv instead of python -m venv PyfaEnv

[yurats]

Had this problem with Python 3.11; solved by also installing Python 3.7 (listed as requirement) and specifying it as the version to use when creating the virtual environment by doing py -3.7 -m venv PyfaEnv instead of python -m venv PyfaEnv

but it does not make sense at all, i.e. for example python 3.7 removed from gentoo's portage tree (and outdated). Of course one can install it additionally only for pyfa and its not a good way to manage problems

[DarkFenX]

FYI i tried to migrate pyfa to sqlalchemy 2.x while bumping up dependency versions. It was a pain on many many levels. I gave up, pyfa stays on the newest 1.x