在settings.py中指定Django测试数据库名称 [英] Specify Django Test Database names in settings.py
问题描述
DATABASES = {
'default':{
'ENGINE':'mysql',
'NAME':'testsqldb',
'USER':'< username>',
'PASSWORD'密码>',
},
'dynamic_data':{
'ENGINE':'sqlite3',
'NAME':'',
'USER' '',
'PASSWORD':''
},
}
如何指定测试数据库的名称?我一直试图在settings.py文件中使用 TEST_NAME ='auto_tests'
。但是,当我运行 python manage.py tests< app_name>
我收到以下消息:
创建测试数据库'default'...
创建测试数据库时出错:(1007,无法创建数据库test_testsqldb;数据库存在)
类型'yes'如果你想尝试删除测试数据库'test_testsqldb'或'否'取消:
我期待系统在运行我的测试时创建一个单独的数据库,大概叫做auto_tests_testsqldb;然而,它仍然在问我关于test_testsqldb。
任何建议不胜感激!
在Django 1.6及更低版本, TEST_NAME
应该是您的一个数据库字典的键。但是在Django 1.7及以上版本中,您可以使用 TEST
键,该键是测试数据库的设置字典。
您可能想要:
DATABASES = {
'default':{
'ENGINE':'mysql ',
'NAME':'testsqldb',
'USER':'< username>',
'PASSWORD':'< password>',
'TEST ':{
'NAME':'auto_tests',
}
},
'dynamic_data':{
'ENGINE':'sqlite3',
'NAME':'',
'USER':'',
'PASSWORD':''
},
}
或者,您是否想使用不同的引擎进行测试?在这种情况下,我想您只需要创建一个单独的设置文件进行测试。它可以从您的标准设置模块导入并覆盖 DATABASES
。
I'm specifying the databases using a python object:
DATABASES = {
'default':{
'ENGINE':'mysql',
'NAME':'testsqldb',
'USER':'<username>',
'PASSWORD':'<password>',
},
'dynamic_data':{
'ENGINE': 'sqlite3',
'NAME':'',
'USER':'',
'PASSWORD':''
},
}
How can I specify the name of my test database? I've been trying to use TEST_NAME = 'auto_tests'
in the settings.py file. However, when I run python manage.py tests <app_name>
I get the following message:
Creating test database 'default'...
Got an error creating the test database: (1007, "Can't create database 'test_testsqldb'; database exists")
Type 'yes' if you would like to try deleting the test database 'test_testsqldb', or 'no' to cancel:
I'm expecting the system to create a separate database when running my tests, presumably called 'auto_tests_testsqldb'; however, it's still asking me about test_testsqldb.
Any advice is appreciated!
In Django 1.6 and below, TEST_NAME
should be a key of one of your database dictionaries. But in Django 1.7 and above, you use a TEST
key which is a dictionary of settings for test databases.
You probably want:
DATABASES = {
'default':{
'ENGINE':'mysql',
'NAME':'testsqldb',
'USER':'<username>',
'PASSWORD':'<password>',
'TEST': {
'NAME': 'auto_tests',
}
},
'dynamic_data':{
'ENGINE': 'sqlite3',
'NAME':'',
'USER':'',
'PASSWORD':''
},
}
Alternatively, perhaps you are wanting to use a different engine for your tests? In that case, I think you'll just have to create a separate settings file for testing. It can import from your standard settings module and override DATABASES
.
这篇关于在settings.py中指定Django测试数据库名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!