Skip to content

AttributeError: module 'sqlalchemy' has no attribute '__all__' #404

@Michael-chent

Description

@Michael-chent

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!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions