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)