openego / eTraGo

Optimization of flexibility options for transmission grids based on PyPSA
GNU Affero General Public License v3.0
30 stars 13 forks source link

Fix version for SQLAlchemy #614

Closed CarlosEpia closed 1 year ago

CarlosEpia commented 1 year ago

After installing eTraGo in a fresh virtual environment, the next error appears when trying to execute appl.py:

  File ~/venv/etrago_env12/lib/python3.8/site-packages/spyder_kernels/py3compat.py:356 in compat_exec
    exec(code, globals, locals)

  File ~/git/eTraGo/etrago/appl.py:514
    etrago = run_etrago(args, json_path=None)

  File ~/git/eTraGo/etrago/appl.py:442 in run_etrago
    etrago.build_network_from_db()

  File ~/git/eTraGo/etrago/tools/network.py:281 in build_network_from_db
    self.scenario = NetworkScenario(

  File ~/git/eTraGo/etrago/tools/io.py:129 in __init__
    super().__init__(engine, session, **kwargs)

  File ~/git/eTraGo/etrago/tools/io.py:90 in __init__
    saio.register_schema("grid", engine)

  File ~/venv/etrago_env12/lib/python3.8/site-packages/saio.py:112 in register_schema
    module = SchemaInspectorModule(f"{__name__}.{schema}", "", schema, engine)

  File ~/venv/etrago_env12/lib/python3.8/site-packages/saio.py:80 in __init__
    self.Base = sa.ext.declarative.declarative_base(bind=engine)

  File <string>:2 in declarative_base

  File ~/venv/etrago_env12/lib/python3.8/site-packages/sqlalchemy/util/deprecations.py:383 in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]

  File ~/venv/etrago_env12/lib/python3.8/site-packages/sqlalchemy/ext/declarative/__init__.py:27 in declarative_base
    return _declarative_base(*arg, **kw)

TypeError: declarative_base() got an unexpected keyword argument 'bind'

It is due to the version of the package sqalchemy (2.0.4). Once it is downgraded to 1.4.46 it works well.

CarlosEpia commented 1 year ago

Already mentioned in #587