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=TableConverter(self.differences) self.converter.convert() rescolnames=['name', 'architecture', 'version', 'subversion', 'lilr601', 'lilr642', 'lilr602'] colnames=self.converter.columnnames self.assertEquals(colnames, rescolnames) def testconvert(self): self.converter=TableConverter(self.differences) self.converter.convert() rows=self.converter.getvalue() #print self.converter.columnnames #print ",\n".join(map(str, rows)) result=[['GFS-kernel-debuginfo', 'x86_64', '2.6.9', '72.2.0.2', 'installed', 'not installed', 'not installed'], ['GFS-kernel-debuginfo', 'x86_64', '2.6.9', '80.9.el4_7.5.hotfix.1', 'not installed', 'not installed', 'installed'], ['GFS-kernel-largesmp', 'x86_64', '2.6.9', '80.9.el4_7.1', 'not installed', 'installed', 'not installed'], ['GFS-kernel-largesmp', 'x86_64', '2.6.9', '80.9.el4_7.5.hotfix.1', 'installed', 'not installed', 'installed']] self.assertEquals(rows, result)
def testconvert(self): self.converter=TableConverter(self.differences) self.converter.convert() rows=self.converter.getvalue() #print self.converter.columnnames #print ",\n".join(map(str, rows)) result=[['GFS-kernel-debuginfo', 'x86_64', '2.6.9', '72.2.0.2', 'installed', 'not installed', 'not installed'], ['GFS-kernel-debuginfo', 'x86_64', '2.6.9', '80.9.el4_7.5.hotfix.1', 'not installed', 'not installed', 'installed'], ['GFS-kernel-largesmp', 'x86_64', '2.6.9', '80.9.el4_7.1', 'not installed', 'installed', 'not installed'], ['GFS-kernel-largesmp', 'x86_64', '2.6.9', '80.9.el4_7.5.hotfix.1', 'installed', 'not installed', 'installed']] self.assertEquals(rows, result)
def testconvertcolnames(self): self.converter=TableConverter(self.differences) self.converter.convert() rescolnames=['name', 'architecture', 'version', 'subversion', 'lilr601', 'lilr642', 'lilr602'] colnames=self.converter.columnnames self.assertEquals(colnames, rescolnames)