AttributeError: ‘sqlalchemy.cimmutabledict.immutabledict‘ object has no attribute ‘setdefault‘报错解决记录

AttributeError: ‘sqlalchemy.cimmutabledict.immutabledict‘ object has no attribute ‘setdefault‘报错解决记录

今天在练习Flask项目时，Python 版本为3.8.3，Flask的版本为1.0.2，Flask-SQLAlchemy的版本为2.4.0。SQLAlchemy的版本为1.4.27。

>>> from flasker import db
D:pythonenvflaskerlibsite-packagesflask_sqlalchemy__init__.py:834: FSADeprecationWarning: SQLALCHEMY_TRACK_MOD
IFICATIONS adds significant overhead and will be disabled by default in the future.  Set it to True or False to suppr
ess this warning.
  warnings.warn(FSADeprecationWarning(

>>> db.create_all()
Traceback (most recent call last):
  File "", line 1, in 
  File "D:pythonenvflaskerlibsite-packagesflask_sqlalchemy__init__.py", line 1033, in create_all
    self._execute_for_all_tables(app, bind, 'create_all')
  File "D:pythonenvflaskerlibsite-packagesflask_sqlalchemy__init__.py", line 1025, in _execute_for_all_tables
    op(bind=self.get_engine(app, bind), **extra)
  File "D:pythonenvflaskerlibsite-packagesflask_sqlalchemy__init__.py", line 956, in get_engine
    return connector.get_engine()
  File "D:pythonenvflaskerlibsite-packagesflask_sqlalchemy__init__.py", line 560, in get_engine
    options = self.get_options(sa_url, echo)
  File "D:pythonenvflaskerlibsite-packagesflask_sqlalchemy__init__.py", line 575, in get_options
    self._sa.apply_driver_hacks(self._app, sa_url, options)
  File "D:pythonenvflaskerlibsite-packagesflask_sqlalchemy__init__.py", line 878, in apply_driver_hacks
    sa_url.query.setdefault('charset', 'utf8')
AttributeError: 'sqlalchemy.cimmutabledict.immutabledict' object has no attribute 'setdefault'

关于AttributeError: 'sqlalchemy.cimmutabledict.immutabledict' object has no attribute 'setdefault'的报错，参考了其他同学的踩坑博文，在此，谢谢前辈的问题记录。

参考的博文链接：

1、AttributeError: ‘sqlalchemy.cimmutabledict.immutabledict‘ object has no attribute ‘setdefault‘_Alex抱着爆米花的博客-CSDN博客

2、AttributeError: ‘sqlalchemy.cimmutabledict.immutabledict‘ object has no attribute ‘setdefault‘_qingliu_D的博客-CSDN博客

但是，并不能直接运用2位前辈的解决方案，因为大家的运行环境并不完全一致，然而，大家的经历，倒是给到我一定的问题解决方向指引，感觉问题就是出在SQLAlchemy版本和PYTHON的运行环境可能不是特别适配，于是进行了调整的尝试，最终取用了SQLAlchemy的版本为1.3.24，替换了之前的1.4.27，从而越过了这个报错，继续了后续的项目练习。