在TypeError: argument of type 'WindowsPath' is not iterable报错后,
下面Traceback显示了我们程序运行出错的先后顺序,
我们按照调用逻辑推理一下看看哪里出了问题
Traceback (most recent call last):
File "manage.py", line 22, in <module>
main()
File "manage.py", line 18, in main
execute_from_command_line(sys.argv)
File "D:\pyenv_location\Lib\site-packages\django\core\management\__init__.py", line 381, in execute_from_command_line
utility.execute()
self.fetch_command(subcommand).run_from_argv(self.argv)
File "D:\pyenv_location\Lib\site-packages\django\core\management\base.py", line 336, in run_from_argv
connections.close_all()
File "D:\pyenv_location\Lib\site-packages\django\db\utils.py", line 224, in close_all
connection.close()
File "D:\python_envv\py368\Lib\site-packages\django\db\backends\sqlite3\base.py", line 248, in close
if not self.is_in_memory_db():
File "D:\pyenv_location\Lib\site-packages\django\db\backends\sqlite3\base.py", line 367, in is_in_memory_db
return self.creation.is_in_memory_db(self.settings_dict['NAME'])
File "D:\pyenv_location\Lib\site-packages\django\db\backends\sqlite3\creation.py", line 12, in is_in_memory_db
return database_name == ':memory:' or 'mode=memory' in database_name
TypeError: argument of type 'WindowsPath' is not iterable
可以看到最终失败是在creation.py中如下位置,database_name不被识别为windows路径:
is_in_memory_db(database.name)函数中,出错就是因为参数类型错误。
上一步,可以看到base.py中is_in_memory_db(self)传入的参数
这里可以看出,settings_dict就是settings.py,
其中key值"NAME",value和路径相关的,看起来就是DATABASES里面的NAME了
当创建Django项目时,会默认生成settings.py文件,其中包含了数据库的相关配置信息。Django默认数据库相关的配置使用SQLite,并会自动在根目录下创建db.sqlite3文件作为数据库文件。
这里的NAME对应的value其实就是db.sqlite3所在路径,期望的是一个字符串
两种方式:
1. os.path.join(BASE_DIR, 'db.sqlite3')
2. str(BASE_DIR / 'db.sqlite3')
两种方式均可解决