AttributeError: ‘sqlalchemy.cimmutabledict.immutabledict‘ object has no attribute ‘setdefault‘

最新推荐文章于 2023-12-20 14:17:23 发布
最新推荐文章于 2023-12-20 14:17:23 发布
阅读量3.3k 收藏
点赞数 2
CC 4.0 BY-SA版权
分类专栏： 笔记 文章标签： python flask
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/qingliu_D/article/details/115221617
在使用Python Flask进行项目实践时遇到数据库查询错误。问题出现在Windows环境下，Python 3.8版本的Flask应用中。为了解决这个问题，通过升级SQLAlchemy库可以修复，只需在命令行执行`pip install --upgrade sqlalchemy`即可更新到最新版本，从而避免查询错误。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

背景

  • 系统：windows
  • python：3.8

描述

在flask项目练习过程中，程序运行后查询数据库发现报错
在这里插入图片描述

解决方案

升级sqlalchemy,命令行执行下列操作

pip install --upgrade sqlalchemy
Flask_SQLAlchemy安装失败，提示AttributeError: 'list' object has no attribute 'read'
dailinqing1984的博客
05-26 4369
安装时提示： File "d:\python\python37\lib\shlex.py", line 136, in read_token nextchar = self.instream.read(1) AttributeError: 'list' object has no attribute 'read' -------------------...
AttributeError: ‘sqlalchemy.cimmutabledict.immutabledict‘ object has no attribute ‘setdefault‘报错解决记录
AlickLbc的博客
11-15 3154
今天在练习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 IFICATI
AttributeError: 'sqlalchemy.cimmutabledict.immutabledict' object has no attribute 'setdefault'
05-23
这个错误通常是因为你在使用 `setdefault()` 方法时，将一个不可变的字典对象传递给了它...这样就能避免 `AttributeError: 'sqlalchemy.cimmutabledict.immutabledict' object has no attribute 'setdefault'` 错误了。
AttributeError: module 'sqlalchemy.util' has no attribute 'py2k'
08-19
- *1* *2* [AttributeError: ‘sqlalchemy.cimmutabledict.immutabledict‘ object has no attribute ‘setdefault](https://blog.csdn.net/qq_39813400/article/details/127971727)[target="_blank" data-report-...
raise AttributeError("'{}' object has no attribute '{}'".format( AttributeError: 'Model' object has no attribute 'get'
08-15
- *1* *2* *3* [AttributeError: ‘sqlalchemy.cimmutabledict.immutabledict‘ object has no attribute ‘setdefault...](https://blog.csdn.net/AlickLbc/article/details/121325018)[target="_blank" data-...
raise AttributeError("'{}' object has no attribute '{}'".format( AttributeError: 'Tudui' object has no attribute 'linear1
09-19
对于引用中的问题，即"AttributeError: ‘sqlalchemy.cimmutabledict.immutabledict‘ object has no attribute ‘setdefault‘_qingliu_D的博客-优快云博客"，可以尝试检查导入的模块和对象是否正确，确保正确使用了...
python flask运行后报错[2025-03-18 08:41:05,126] ERROR in app: Exception on /user/login [POST] Traceback (most recent call last): File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\sqlalchemy\util\_collections.py", line 1008, in __call__ return self.registry[key] KeyError: <greenlet.greenlet object at 0x000001E008975640 (otid=0x000001E008910DE0) current active started main> During handling of the above exception, another exception occurred: Traceback (most recent call last): File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\flask\app.py", line 2447, in wsgi_app response = self.full_dispatch_request() File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\flask\app.py", line 1952, in full_dispatch_request rv = self.handle_user_exception(e) File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\flask\app.py", line 1821, in handle_user_exception reraise(exc_type, exc_value, tb) File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\flask\_compat.py", line 39, in reraise raise value File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\flask\app.py", line 1950, in full_dispatch_request rv = self.dispatch_request() File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\flask\app.py", line 1936, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "E:\PythonFlask项目实战\95944qjw\blueprints\user.py", line 95, in login user = UserModel.query.filter_by(username=username).first() File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\flask_sqlalchemy\__init__.py", line 514, in __get__ return type.query_class(mapper, session=self.sa.session()) File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\sqlalchemy\orm\scoping.py", line 47, in __call__ sess = self.registry() File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\sqlalchemy\util\_collections.py", line 1010, in __call__ return self.registry.setdefault(key, self.createfunc()) File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\sqlalchemy\orm\session.py", line 4225, in __call__ return self.class_(**local_kw) File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\flask_sqlalchemy\__init__.py", line 138, in __init__ bind = options.pop('bind', None) or db.engine File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\flask_sqlalchemy\__init__.py", line 943, in engine return self.get_engine() File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\flask_sqlalchemy\__init__.py", line 962, in get_engine return connector.get_engine() File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\flask_sqlalchemy\__init__.py", line 555, in get_engine options = self.get_options(sa_url, echo) File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\flask_sqlalchemy\__init__.py", line 570, in get_options self._sa.apply_driver_hacks(self._app, sa_url, options) File "E:\PythonFlask项目实战\95944qjw\.venv\lib\site-packages\flask_sqlalchemy\__init__.py", line 884, in apply_driver_hacks sa_url.query.setdefault('charset', 'utf8') AttributeError: 'sqlalchemy.cimmutabledict.immutabledict' object has no attribute 'setdefault' 127.0.0.1 - - [18/Mar/2025 08:41:05] "POST /user/login HTTP/1.1" 500 - 127.0.0.1 - - [18/Mar/2025 08:41:05] "GET /static/front/js/html5shiv.min.js HTTP/1.1" 404 - 127.0.0.1 - - [18/Mar/2025 08:41:05] "GET /static/front/js/respond.min.js HTTP/1.1" 404 - 127.0.0.1 - - [18/Mar/2025 08:41:05] "GET /static/front/js/skin/layer.css HTTP/1.1" 404 -
最新发布
03-19
AttributeError: 'sqlalchemy.cimmutabledict.immutabledict' object has no attribute 'setdefault' ``` 这个错误发生在SQLAlchemy 1.4+版本与旧版Flask-SQLAlchemy的兼容性问题中，新版SQLAlchemy将`sa_url.query`...
in __getattr__ if name in mod.__all__: AttributeError: module ‘sqlalchemy‘ has no attribute ‘__all__
xinzhengLUCK的博客
12-20 1380
他说版本小于2.0大于等于1.3.2，我去sqlalchemy官网看了看pip inst。虽然运行了，但还是漏洞摆出呀，这大畸形怪，先就将就着吧0 0.，那就按个1.4看看能不能解决报错吧。
Sqlalchemy 报错【sqlalchemy.cimmutabledict.immutabledict is not a sequence】
lulu_930的博客
08-15 1233
【代码】Sqlalchemy 报错【sqlalchemy.cimmutabledict.immutabledict is not a sequence】
AttributeError: module ‘sqlalchemy‘ has no attribute ‘NullType‘
weixin_44936542的博客
03-11 4252
flask框架在执行数据库迁移命令migrate之后upgrade，报这个错，将 这个表删掉再从头开始迁移数据库即可，先删掉migrations目录，再依次init, migrate,upgrade
关于AttributeError: type object ‘SQLAlchemy‘ has no attribute ‘Model‘的排障
coastline_s的博客
06-10 3771
AttributeError: type object 'SQLAlchemy' has no attribute 'Model'
python TypeError: dict is not a sequence
以后的今天的博客
12-18 5257
报错1: TypeError: dict is not a sequence 报错2：unsupported format character 'Y' (0x59) at index 79
1.python执行创建数据库迁移flask db init报“AttributeError: ‘SQLAlchemy‘ object has no attribute ‘after_request‘
LOVE_XUAN521的专栏
07-14 1017
报错原因是app->init.py 中代码段CORS(db)写错了，改为CORS（app）即可 重新执行创建数据库迁移命令flask db init成功 记录下来，方便以后查看，也为广大阅读者提供方便。贵在坚持！
Python 使用Poetry安装sqlalchemy报错AttributeError解决方法
weixin_42098295的博客
10-10 370
本文主要介绍Python中，执行 pip install sqlalchemy没问题，但执行poetry安装报错： AttributeError 'EmptyConstraint' object has no attribute 'allows'的解决方法。 原文地址：Python 使用Poetry安装sqlalchemy报错AttributeError解决方法 ...
sqlalchemy AttributeError: module ‘time‘ has no attribute ‘clock‘
qingliu_D的博客
03-26 1530
背景 系统：Windows python：3.8 描述 flask程序运行过程中查询数据库，报错 经查询，time模块中clock在Python3.8中被移除，无法调用 解决方案 单独出错可将出错文件中time.clock 替换为 time.perf_counter() 但是在Windows中运行使用上方更改后，可能会产生新错误 TypeError: 'float' object is not callable 所以可以考虑将源代码中检测windows程序注释 ...
SQLAlchemy 初始化数据库报错
weixin_44824389的博客
01-08 400
连接数据库出现： **问题：**使用sqlalchemy初始化数据库报错 ModuleNotFoundError: No module named ‘mysql’ 解决方案： pip install mysql-connector 即可
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值