ModuleNotFoundError: No module named 'sqlalchemy' - db_updater.py -v

[LMS235]

Hello,

db_updater.py -v throw the following error:

  File "/usr/local/bin/alembic", line 5, in <module>
    from alembic.config import main
  File "/usr/local/lib/python3.10/dist-packages/alembic/__init__.py", line 1, in <module>
    from . import context
  File "/usr/local/lib/python3.10/dist-packages/alembic/context.py", line 1, in <module>
    from .runtime.environment import EnvironmentContext
  File "/usr/local/lib/python3.10/dist-packages/alembic/runtime/environment.py", line 19, in <module>
    from sqlalchemy.sql.schema import Column
ModuleNotFoundError: No module named 'sqlalchemy'

but the problem is that sqlalchemy cannot work with MongoDB

https://docs.sqlalchemy.org/en/13/dialects/
or https://stackoverflow.com/questions/51159461/flask-error-sqlalchemy-exc-nosuchmoduleerror-cant-load-plugin-sqlalchemy-dia

so if you install sqlalchemy you get another error "sqlalchemy.dialects:mongodb".

Could someone take a look at this?

[P-T-I]

@LMS235 Could you verify if this issue still exists? I believe it to be fixed (upstream)

[oh2fih]

This doesn't seem like a SQL vs. MongoDB issue as suggested. The ModuleNotFoundError suggests that sqlalchemy wasn't installed on the machine. Both python3-sqlalchemy package or installing the dependencies with pip3 install -r requirements.txt should solve this.

What might be an issue in CveXplore is if these modules are loaded even if SQL is not configured. The imports can be conditional, too.