今天在练习Flask项目时,Python 版本为3.8.3,Flask的版本为1.0.2,Flask-SQLAlchemy的版本为2.4.0。SQLAlchemy的版本为1.4.27。
>>> from flasker import db
D:\python\env\flasker\lib\site-packages\flask_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 "<stdin>", line 1, in <module>
File "D:\python\env\flasker\lib\site-packages\flask_sqlalchemy\__init__.py", line 1033, in create_all
self._execute_for_all_tables(app, bind, 'create_all')
File "D:\python\env\flasker\lib\site-packages\flask_sqlalchemy\__init__.py", line 1025, in _execute_for_all_tables
op(bind=self.get_engine(app, bind), **extra)
File "D:\python\env\flasker\lib\site-packages\flask_sqlalchemy\__init__.py", line 956, in get_engine
return connector.get_engine()
File "D:\python\env\flasker\lib\site-packages\flask_sqlalchemy\__init__.py", line 560, in get_engine
options = self.get_options(sa_url, echo)
File "D:\python\env\flasker\lib\site-packages\flask_sqlalchemy\__init__.py", line 575, in get_options
self._sa.apply_driver_hacks(self._app, sa_url, options)
File "D:\python\env\flasker\lib\site-packages\flask_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'的报错,参考了其他同学的踩坑博文,在此,谢谢前辈的问题记录。
参考的博文链接:
但是,并不能直接运用2位前辈的解决方案,因为大家的运行环境并不完全一致,然而,大家的经历,倒是给到我一定的问题解决方向指引,感觉问题就是出在SQLAlchemy版本和PYTHON的运行环境可能不是特别适配,于是进行了调整的尝试,最终取用了SQLAlchemy的版本为1.3.24,替换了之前的1.4.27,从而越过了这个报错,继续了后续的项目练习。