def test_query_byCondition(self):
"""
测试根据查询条件组合查询
"""
dictionary = self.__prepareData()
dictionary.save()
conditionDict = {}
conditionDict['id'] = CMDB_Dictionary.objects.all()[0].id
result = DictionaryManager().getDictionaryInfoByCondition(conditionDict)
self.assertEqual(conditionDict['id'],result[0].id)
conditionDict['key'] = 'amd 2'
result = DictionaryManager().getDictionaryInfoByCondition(conditionDict)
self.assertEqual('AMD 2',result[0].key)
conditionDict.clear()
conditionDict['key_type'] = 'CPU_TYPE'
result = DictionaryManager().getDictionaryInfoByCondition(conditionDict)
self.assertEqual(result[0].key_type, conditionDict['key_type'])
conditionDict['value'] = 'amd 2'
result = DictionaryManager().getDictionaryInfoByCondition(conditionDict)
self.assertEqual(result[0].value,'AMD 2 CPU')
self.__deleteData(dictionary)
def test_delete_fail(self):
"""
测试‘删除’数据失败，表中不存在对应key的数据
"""
dictionary = self.__prepareData()
DictionaryManager().deleteDictionaryInfo(dictionary.id)
self.assertRaises( ObjectDoesNotExist, CMDB_Dictionary.objects.get, key = dictionary.key)
def test_insert_success_new(self):
"""
测试插入数据成功，表中不存在相同key的数据
"""
dictionary = self.__prepareData()
DictionaryManager().insertDictionaryInfo(dictionary)
query = CMDB_Dictionary.objects.get(key = dictionary.key,flag = True)
self.assertEqual(dictionary.value, query.value)
self.__deleteData(dictionary)
def test_update_fail(self):
"""
测试修改数据失败，表中不存在对应key的数据
"""
dictionary = self.__prepareData()
dictionary.key = 'INTEL 2'
DictionaryManager().updateDictionaryInfo(dictionary)
#self.assertRaises( ObjectDoesNotExist, DictionaryManager().updateDictionaryInfo, dictionary)
query = CMDB_Dictionary.objects.filter(key = dictionary.key,flag = True)
self.assertEqual(len(query), 0)
def test_insert_fail_unique(self):
"""
测试插入数据失败，表中存在相同key且flag为True的数据
"""
dictionary = self.__prepareData()
dictionary.save()
dictionary2 = self.__prepareData()
DictionaryManager().insertDictionaryInfo(dictionary2)
query = CMDB_Dictionary.objects.filter(key = dictionary2.key,flag = True)
self.assertEqual(len(query), 1)
self.__deleteData(dictionary)
def test_delete_success(self):
"""
测试‘删除’数据成功，表中存在对应key且flag为True的数据
"""
dictionary = self.__prepareData()
dictionary.save()
DictionaryManager().deleteDictionaryInfo(dictionary.id)
result = CMDB_Dictionary.objects.get(id = dictionary.id)
self.assertEqual(result.flag, False)
self.__deleteData(dictionary)
def test_update_fail_flagFalse(self):
"""
测试修改数据失败，表中存在对应key的数据且flag为False的数据
"""
dictionary = self.__prepareData()
dictionary.flag = False
dictionary.save()
dictionary.key = 'INTEL 2'
DictionaryManager().updateDictionaryInfo(dictionary)
self.assertRaises( ObjectDoesNotExist, CMDB_Dictionary.objects.get, key = dictionary.key)
self.__deleteData(dictionary)
def test_update_success(self):
"""
测试修改数据成功，表中存在对应key且flag为True的数据
"""
dictionary = self.__prepareData()
dictionary.save()
dictionary.key = 'INTEL 2'
DictionaryManager().updateDictionaryInfo(dictionary)
query = CMDB_Dictionary.objects.get(key = dictionary.key,flag = True)
self.assertEqual(query.key, dictionary.key)
self.__deleteData(dictionary)
def test_delete_fail_flagFalse(self):
"""
测试‘删除’数据失败，表中存在对应key且flag为false的数据
"""
dictionary = self.__prepareData()
dictionary.flag = False
dictionary.save()
firstModifyTime = CMDB_Dictionary.objects.get(id = dictionary.id).gmtModified
DictionaryManager().deleteDictionaryInfo(dictionary.id)
result = CMDB_Dictionary.objects.get(id = dictionary.id)
self.assertEqual(firstModifyTime,result.gmtModified)
def test_insert_sucess_flagFalse(self):
"""
测试插入数据成功，表中存在相同key且flag为False的数据
"""
dictionary = self.__prepareData()
dictionary.save()
dictionary.flag = False
dictionary.save()
dictionary2 = self.__prepareData()
DictionaryManager().insertDictionaryInfo(dictionary2)
query = CMDB_Dictionary.objects.filter(key = dictionary.key)
self.assertEqual(len(query), 2)
self.__deleteData(dictionary)
def __initDictionary(self):
DictionaryList = (
['CPU_TYPE',['AMD','INTEL']],
['IP_TYPE',['VIP','IP']],
['RAID',['SSD','SATA']],
['PATITION_TYPE',['SYSTEM','USER']],
['ENV',['PRD','PAT','TESTA','TESTB','TESTC','DEV']],
['APP',['HADES','AEGIS','DUBBO','NAPOLI']],
['APP_TYPE',['APACHE','TOMCAT','DATABASE']],
)
for keyType in DictionaryList:
for key in keyType[1]:
dictionary = CMDB_Dictionary()
dictionary.key_type = keyType[0]
dictionary.key = key
DictionaryManager().insertDictionaryInfo(dictionary)