def testconvert2(self):
self.converter=DictConverterColAdd(self.differences)
self.converter.convert(idcolname="idx", idcolvalues=["installed", 'notinstalled'])
rows=self.converter.getvalue()
print ",\n".join(map(str, rows))
result=[{'lilr601': 'installed', 'lilr602': 'not installed', 'name': 'GFS-kernel-debuginfo', 'idx': 'installed', 'subversion': '72.2.0.2', 'version': '2.6.9', 'architecture': 'x86_64', 'lilr642': 'not installed'},
{'lilr601': 'not installed', 'lilr602': 'installed', 'name': 'GFS-kernel-debuginfo', 'idx': 'notinstalled', 'subversion': '80.9.el4_7.5.hotfix.1', 'version': '2.6.9', 'architecture': 'x86_64', 'lilr642': 'not installed'},
{'lilr601': 'not installed', 'lilr602': 'not installed', 'name': 'GFS-kernel-largesmp', 'idx': 'installed', 'subversion': '80.9.el4_7.1', 'version': '2.6.9', 'architecture': 'x86_64', 'lilr642': 'installed'},
{'lilr601': 'installed', 'lilr602': 'installed', 'name': 'GFS-kernel-largesmp', 'idx': 'notinstalled', 'subversion': '80.9.el4_7.5.hotfix.1', 'version': '2.6.9', 'architecture': 'x86_64', 'lilr642': 'not installed'}
]
self.assertEquals(rows, result)
class Test(unittest.TestCase):
def setUp(self):
self.software_cmdb=SoftwareCMDB(hostname="axqad107-1", user="******", password="******", database="software_cmdb", table="software_cmdb")
self.packages=self.software_cmdb.getPackages(["lilr642", "lilr602"], "lilr601", None, 0, 0, ['name LIKE "%GFS-kernel%"'])
self.differences=self.packages.differences()
def tearDown(self):
pass
def testconvertcolnames(self):
self.converter=DictConverterColAdd(self.differences)
self.converter.convert()
rescolnames=['name', 'architecture', 'version', 'subversion', 'lilr601', 'lilr642', 'lilr602', "id"]
colnames=self.converter.columnnames
self.assertEquals(colnames, rescolnames)
def testconvert(self):
self.converter=DictConverterColAdd(self.differences)
self.converter.convert()
rows=self.converter.getvalue()
print ",\n".join(map(str, rows))
result=[
{'lilr601': 'installed', 'lilr602': 'not installed', 'name': 'GFS-kernel-debuginfo', 'subversion': '72.2.0.2', 'version': '2.6.9', 'architecture': 'x86_64', 'id': 'id1', 'lilr642': 'not installed'},
{'lilr601': 'not installed', 'lilr602': 'installed', 'name': 'GFS-kernel-debuginfo', 'subversion': '80.9.el4_7.5.hotfix.1', 'version': '2.6.9', 'architecture': 'x86_64', 'id': 'id2', 'lilr642': 'not installed'},
{'lilr601': 'not installed', 'lilr602': 'not installed', 'name': 'GFS-kernel-largesmp', 'subversion': '80.9.el4_7.1', 'version': '2.6.9', 'architecture': 'x86_64', 'id': 'id1', 'lilr642': 'installed'},
{'lilr601': 'installed', 'lilr602': 'installed', 'name': 'GFS-kernel-largesmp', 'subversion': '80.9.el4_7.5.hotfix.1', 'version': '2.6.9', 'architecture': 'x86_64', 'id': 'id2', 'lilr642': 'not installed'}
]
self.assertEquals(rows, result)
def testconvert2(self):
self.converter=DictConverterColAdd(self.differences)
self.converter.convert(idcolname="idx", idcolvalues=["installed", 'notinstalled'])
rows=self.converter.getvalue()
print ",\n".join(map(str, rows))
result=[{'lilr601': 'installed', 'lilr602': 'not installed', 'name': 'GFS-kernel-debuginfo', 'idx': 'installed', 'subversion': '72.2.0.2', 'version': '2.6.9', 'architecture': 'x86_64', 'lilr642': 'not installed'},
{'lilr601': 'not installed', 'lilr602': 'installed', 'name': 'GFS-kernel-debuginfo', 'idx': 'notinstalled', 'subversion': '80.9.el4_7.5.hotfix.1', 'version': '2.6.9', 'architecture': 'x86_64', 'lilr642': 'not installed'},
{'lilr601': 'not installed', 'lilr602': 'not installed', 'name': 'GFS-kernel-largesmp', 'idx': 'installed', 'subversion': '80.9.el4_7.1', 'version': '2.6.9', 'architecture': 'x86_64', 'lilr642': 'installed'},
{'lilr601': 'installed', 'lilr602': 'installed', 'name': 'GFS-kernel-largesmp', 'idx': 'notinstalled', 'subversion': '80.9.el4_7.5.hotfix.1', 'version': '2.6.9', 'architecture': 'x86_64', 'lilr642': 'not installed'}
]
self.assertEquals(rows, result)
def testconvertcolnames(self):
self.converter=DictConverterColAdd(self.differences)
self.converter.convert()
rescolnames=['name', 'architecture', 'version', 'subversion', 'lilr601', 'lilr642', 'lilr602', "id"]
colnames=self.converter.columnnames
self.assertEquals(colnames, rescolnames)
