[GH-ISSUE #404] AttributeError: module 'sqlalchemy' has no attribute 'all' #91

New issue

Open

opened 2026-02-26 01:33:05 +03:00 by kerem · 0 comments

kerem commented

2026-02-26 01:33:05 +03:00

Owner

Originally created by @Michael-chent on GitHub (Nov 1, 2024).
Original GitHub issue: https://github.com/jeffknupp/sandman2/issues/404

I want to use sandman2 connect to GaussDB,I encountered a problem:

(sandman2Env) [root@ecs-michael ~]# sandman2ctl postgresql+psycopg2://root:password@MyServiceIP:8000/michaeltest
Traceback (most recent call last):
  File "/home/Envs/sandman2Env/bin/sandman2ctl", line 33, in <module>
    sys.exit(load_entry_point('sandman2', 'console_scripts', 'sandman2ctl')())
  File "/home/Envs/sandman2Env/bin/sandman2ctl", line 25, in importlib_load_entry_point
    return next(matches).load()
  File "/usr/lib64/python3.9/importlib/metadata.py", line 86, in load
    module = import_module(match.group('module'))
  File "/usr/lib64/python3.9/importlib/__init__.py", line 127, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 1030, in _gcd_import
  File "<frozen importlib._bootstrap>", line 1007, in _find_and_load
  File "<frozen importlib._bootstrap>", line 972, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed
  File "<frozen importlib._bootstrap>", line 1030, in _gcd_import
  File "<frozen importlib._bootstrap>", line 1007, in _find_and_load
  File "<frozen importlib._bootstrap>", line 986, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 680, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 850, in exec_module
  File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed
  File "/home/dev_projects/sandman2/sandman2/__init__.py", line 2, in <module>
    from sandman2.app import get_app, db, AutomapModel
  File "/home/dev_projects/sandman2/sandman2/app.py", line 18, in <module>
    from sandman2.service import Service
  File "/home/dev_projects/sandman2/sandman2/service.py", line 12, in <module>
    from sandman2.model import db
  File "/home/dev_projects/sandman2/sandman2/model.py", line 13, in <module>
    db = SQLAlchemy()
  File "/home/Envs/sandman2Env/lib64/python3.9/site-packages/flask_sqlalchemy/__init__.py", line 720, in __init__
    _include_sqlalchemy(self, query_class)
  File "/home/Envs/sandman2Env/lib64/python3.9/site-packages/flask_sqlalchemy/__init__.py", line 74, in _include_sqlalchemy
    for key in module.__all__:
  File "/home/Envs/sandman2Env/lib64/python3.9/site-packages/sqlalchemy/__init__.py", line 294, in __getattr__
    raise AttributeError(f"module {__name__!r} has no attribute {name!r}")
AttributeError: module 'sqlalchemy' has no attribute '__all__'
(sandman2Env) [root@ecs-michael ~]# pip list
Package           Version Editable project location
----------------- ------- ---------------------------
attrs             24.2.0
click             8.1.7
coverage          5.3
Flask             1.1.2
Flask-Admin       1.5.7
Flask-Cors        3.0.9
Flask-HTTPAuth    4.8.0
Flask-SQLAlchemy  2.4.0
greenlet          3.1.1
iniconfig         2.0.0
itsdangerous      2.0.1
Jinja2            3.0.3
MarkupSafe        3.0.2
packaging         24.1
pip               24.3.1
pluggy            0.13.1
psycopg2-binary   2.9.10
py                1.11.0
pytest            6.2.0
pytest-cov        2.10.1
pytest-flask      1.1.0
sandman2          1.2.2   /home/dev_projects/sandman2
setuptools        75.3.0
six               1.15.0
SQLAlchemy        2.0.36
toml              0.10.2
typing_extensions 4.12.2
wcwidth           0.2.5
Werkzeug          1.0.1
wheel             0.44.0
WTForms           2.3.3
zipp              3.4.0

The above information describes my environment.
Please help me！
Thanks a lot!

Originally created by @Michael-chent on GitHub (Nov 1, 2024). Original GitHub issue: https://github.com/jeffknupp/sandman2/issues/404 I want to use sandman2 connect to GaussDB,I encountered a problem: ```` (sandman2Env) [root@ecs-michael ~]# sandman2ctl postgresql+psycopg2://root:password@MyServiceIP:8000/michaeltest Traceback (most recent call last): File "/home/Envs/sandman2Env/bin/sandman2ctl", line 33, in <module> sys.exit(load_entry_point('sandman2', 'console_scripts', 'sandman2ctl')()) File "/home/Envs/sandman2Env/bin/sandman2ctl", line 25, in importlib_load_entry_point return next(matches).load() File "/usr/lib64/python3.9/importlib/metadata.py", line 86, in load module = import_module(match.group('module')) File "/usr/lib64/python3.9/importlib/__init__.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 1030, in _gcd_import File "<frozen importlib._bootstrap>", line 1007, in _find_and_load File "<frozen importlib._bootstrap>", line 972, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed File "<frozen importlib._bootstrap>", line 1030, in _gcd_import File "<frozen importlib._bootstrap>", line 1007, in _find_and_load File "<frozen importlib._bootstrap>", line 986, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 680, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 850, in exec_module File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed File "/home/dev_projects/sandman2/sandman2/__init__.py", line 2, in <module> from sandman2.app import get_app, db, AutomapModel File "/home/dev_projects/sandman2/sandman2/app.py", line 18, in <module> from sandman2.service import Service File "/home/dev_projects/sandman2/sandman2/service.py", line 12, in <module> from sandman2.model import db File "/home/dev_projects/sandman2/sandman2/model.py", line 13, in <module> db = SQLAlchemy() File "/home/Envs/sandman2Env/lib64/python3.9/site-packages/flask_sqlalchemy/__init__.py", line 720, in __init__ _include_sqlalchemy(self, query_class) File "/home/Envs/sandman2Env/lib64/python3.9/site-packages/flask_sqlalchemy/__init__.py", line 74, in _include_sqlalchemy for key in module.__all__: File "/home/Envs/sandman2Env/lib64/python3.9/site-packages/sqlalchemy/__init__.py", line 294, in __getattr__ raise AttributeError(f"module {__name__!r} has no attribute {name!r}") AttributeError: module 'sqlalchemy' has no attribute '__all__' (sandman2Env) [root@ecs-michael ~]# pip list Package Version Editable project location ----------------- ------- --------------------------- attrs 24.2.0 click 8.1.7 coverage 5.3 Flask 1.1.2 Flask-Admin 1.5.7 Flask-Cors 3.0.9 Flask-HTTPAuth 4.8.0 Flask-SQLAlchemy 2.4.0 greenlet 3.1.1 iniconfig 2.0.0 itsdangerous 2.0.1 Jinja2 3.0.3 MarkupSafe 3.0.2 packaging 24.1 pip 24.3.1 pluggy 0.13.1 psycopg2-binary 2.9.10 py 1.11.0 pytest 6.2.0 pytest-cov 2.10.1 pytest-flask 1.1.0 sandman2 1.2.2 /home/dev_projects/sandman2 setuptools 75.3.0 six 1.15.0 SQLAlchemy 2.0.36 toml 0.10.2 typing_extensions 4.12.2 wcwidth 0.2.5 Werkzeug 1.0.1 wheel 0.44.0 WTForms 2.3.3 zipp 3.4.0 ```` The above information describes my environment. Please help me！ Thanks a lot!