Installation fails due to conflicting sqlalchemy version

[NeolithEra]

Hi, users are unable to run ego due to dependency conflict with sqlalchemy package. As shown in the following full dependency graph of ego, etrago requires sqlalchemy >=1.0.15,<=1.1.4，while ego requires sqlalchemy ==1.2.0.

According to pip’s “first found wins” installation strategy, sqlalchemy 1.2.0 is the actually installed version. However, sqlalchemy 1.2.0 does not satisfy >=1.0.15,<=1.1.4.

Dependency tree-----------

ego  - 0.3.4
| +- descartes(install version:1.1.0 version range:*)
| | +- matplotlib(install version:3.2.0rc1 version range:*)
| | | +- cycler(install version:0.10.0 version range:>=0.10)
| | | | +- six(install version:1.13.0 version range:*)
| | | +- kiwisolver(install version:1.1.0 version range:>=1.0.1)
| | | | +- setuptools(install version:42.0.2 version range:*)
| | | +- numpy(install version:1.17.4 version range:>=1.11)
| | | +- pyparsing(install version:2.4.5 version range:>=2.0.1)
| | | +- python-dateutil(install version:2.8.1 version range:>=2.1)
| +- ding0 (install version:v0.1.9 version range:==v0.1.9)
| +- edisgo (install version:v0.0.9 version range:==v0.0.9)
| +- egoio (install version:0.4.5 version range:==0.4.5)
| | +- geoalchemy2 (install version:0.4.0 version range:>=0.3.0,<=0.4.1)
| | | +- sqlalchemy(install version:1.2.0 version range:>=0.8)
| | +- keyring (install version:19.3.0 version range:>=4.0)
| | +- keyrings-alt(install version:3.2.0 version range:*)
| | +- psycopg2(install version:2.8.4 version range:*)
| | +- sqlalchemy (install version:1.2.0 version range:>=1.0.11,<=1.2.0)
| +- etrago (install version:0.7.1 version range:==0.7.1)
| | +- egoio (install version:0.4.5 version range:==0.4.5)
| | | +- geoalchemy2 (install version:0.4.0 version range:>=0.3.0,<=0.4.1)
| | | | +- sqlalchemy(install version:1.2.0 version range:>=0.8)
| | | +- keyring (install version:19.3.0 version range:>=4.0)
| | | +- keyrings-alt(install version:3.2.0 version range:*)
| | | +- psycopg2(install version:2.8.4 version range:*)
| | | +- sqlalchemy (install version:1.2.0 version range:>=1.0.11,<=1.2.0)
| | +- geoalchemy2 (install version:0.4.0 version range:>=0.3.0,<=0.4.0)
| | | +- sqlalchemy(install version:1.2.0 version range:>=0.8)
| | +- matplotlib (install version: version range:>=1.5.3,<=1.5.3)
| | +- oedialect(install version:0.0.6.dev0 version range:*)
| | +- pandas (install version:0.20.3 version range:>=0.19.0,<=0.20.3)
| | +- pypsa(install version:0.11.0fork version range:==0.11.0fork)
| | +- scikit-learn (install version:0.19.0 version range:==0.19.0)
| | +- shapely(install version:1.7a2 version range:*)
| | +- sqlalchemy (install version:1.1.4 version range:>=1.0.15,<=1.1.4)
| | +- tsam(install version:0.9.9 version range:==0.9.9)
| | | +- numpy(install version:1.17.4 version range:>=1.11.0)
| | | +- pandas(install version:0.25.3 version range:>=0.18.1)
| | | +- pyomo(install version:5.6.7 version range:>=5.3)
| | | | +- appdirs(install version:1.4.3 version range:*)
| | | | +- ply(install version:3.11 version range:*)
| | | | +- pyutilib(install version:5.7.2 version range:>=5.7.2)
| | | | +- six(install version:1.13.0 version range:>=1.4)
| | | +- sklearn(install version:0.0 version range:>=0.0)
| | | | +- scikit-learn(install version:0.22 version range:*)
| +- folium(install version:0.10.1 version range:*)
| +- geoalchemy2 (install version:0.4.0 version range:>=0.3.0,<=0.4.0)
| | +- sqlalchemy(install version:1.2.0 version range:>=0.8)
| +- geopandas(install version:0.6.2 version range:*)
| +- matplotlib (install version:3.0.0 version range:==3.0.0)
| +- multiprocess(install version:0.70.9 version range:*)
| +- oedialect(install version:0.0.6.dev0 version range:*)
| +- pandas (install version:0.20.3 version range:==0.20.3)
| +- plotly(install version:2.2.3 version range:==2.2.3)
| | +- decorator(install version:4.4.1 version range:>=4.0.6)
| | +- nbformat(install version:4.4.0 version range:>=4.2)
| | +- pytz(install version:2019.3 version range:*)
| | +- requests(install version:2.22.0 version range:*)
| | | +- certifi(install version:2019.11.28 version range:>=2017.4.17)
| | | +- chardet(install version:3.0.4 version range:<3.1.0,>=3.0.2)
| | | +- idna(install version:2.8 version range:>=2.5,<2.9)
| | | +- urllib3(install version:1.25.7 version range:<1.26,>=1.21.1)
| | +- six(install version:1.13.0 version range:*)
| +- pycallgraph(install version:1.0.1 version range:*)
| +- pyproj(install version:2.4.2.post1 version range:*)
| +- pypsa(install version:0.11.0fork version range:==0.11.0fork)
| +- rtree(install version:0.9.1 version range:*)
| | +- setuptools(install version:42.0.2 version range:*)
| +- scikit-learn (install version:0.19.0 version range:==0.19.0)
| +- shapely(install version:1.7a2 version range:*)
| +- sqlalchemy (install version:1.2.0 version range:==1.2.0)
| +- tsam(install version:0.9.9 version range:==0.9.9)
| | +- numpy(install version:1.17.4 version range:>=1.11.0)
| | +- pandas(install version:0.25.3 version range:>=0.18.1)
| | +- pyomo(install version:5.6.7 version range:>=5.3)
| | | +- appdirs(install version:1.4.3 version range:*)
| | | +- ply(install version:3.11 version range:*)
| | | +- pyutilib(install version:5.7.2 version range:>=5.7.2)
| | | | +- nose(install version:1.3.7 version range:*)
| | | | +- six(install version:1.13.0 version range:*)
| | | +- six(install version:1.13.0 version range:>=1.4)
| | +- sklearn(install version:0.0 version range:>=0.0)
| | | +- scikit-learn(install version:0.22 version range:*)

Thanks for your help.
Best,
Neolith

[NeolithEra]

Suggested Solution

1. Fix your direct dependency to be sqlalchemy==1.1.4. I have checked this revision will not affect your downstream projects now.
2. Ask your upstream project eTraGo to loose the version range of sqlalchemy.
3. Ask your upstream project eTraGo to remove his direct dependency sqlalchemy, and use sqlalchemy transitively introduced by egoio.

@wolfbunke Which solution do you prefer, 1, 2 or 3?
Please let me know your choice. I can submit a PR to solve this issue.

[wolfbunke]

Hi @NeolithEra,

long time that I was sign in on github. Back on github I saw our request. As I am no longer involved in this project, please contact: @EvaWie or @ClaraBuettner

I unsubscribed the message feed of the old repositories and saw these notes just by accident. If you need help with the onboarding, feel free to write me PM @EvaWie @ClaraBuettner .

See ya!