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=getConverter("coladdmasterdiffs/dict")(self.differences, "lilr601") self.converter.convert() rescolnames=['source: name', 'name', 'architecture', 'master: version', 'master: subversion', 'source: version', 'source: subversion', "id"] colnames=self.converter.columnnames self.assertEquals(colnames, rescolnames) def testconvert(self): self.converter=getConverter("coladdmasterdiffs/dict")(self.differences, "lilr601") self.converter.convert() rows=self.converter.getvalue() print ",\n".join(map(str, rows)) result=[{'master: subversion': '72.2.0.2', 'name': 'GFS-kernel-debuginfo', 'source: subversion': 'not installed', 'source: name': 'lilr642', 'architecture': 'x86_64', 'source: version': 'not installed', 'id': 'id1', 'master: version': '2.6.9'}, {'master: subversion': '72.2.0.2', 'name': 'GFS-kernel-debuginfo', 'source: subversion': 'not installed', 'source: name': 'lilr602', 'architecture': 'x86_64', 'source: version': 'not installed', 'id': 'id2', 'master: version': '2.6.9'}, {'master: subversion': 'not installed', 'name': 'GFS-kernel-debuginfo', 'architecture': 'x86_64', 'source: name': 'lilr602', 'source: subversion': '80.9.el4_7.5.hotfix.1', 'source: version': '2.6.9', 'id': 'id1', 'master: version': 'not installed'}, {'master: subversion': 'not installed', 'name': 'GFS-kernel-largesmp', 'architecture': 'x86_64', 'source: name': 'lilr642', 'source: subversion': '80.9.el4_7.1', 'source: version': '2.6.9', 'id': 'id2', 'master: version': 'not installed'}, {'master: subversion': '80.9.el4_7.5.hotfix.1', 'name': 'GFS-kernel-largesmp', 'source: subversion': 'not installed', 'source: name': 'lilr642', 'architecture': 'x86_64', 'source: version': 'not installed', 'id': 'id1', 'master: version': '2.6.9'} ] 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() self.masterreport=MasterReportPackages(self.differences, "lilr601") def tearDown(self): pass def testMasterReport(self): buffer=cStringIO.StringIO() #self.masterreport.report() self.masterreport.report(outputchannel=buffer) print buffer.getvalue() expectedstring=""" source: name name architecture master: version master: subversion source: version source: subversion ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ lilr642 GFS-kernel-debuginfo x86_64 2.6.9 72.2.0.2 not installed not installed lilr602 GFS-kernel-debuginfo x86_64 2.6.9 72.2.0.2 not installed not installed lilr602 GFS-kernel-debuginfo x86_64 not installed not installed 2.6.9 80.9.el4_7.5.hotfix.1 lilr642 GFS-kernel-largesmp x86_64 not installed not installed 2.6.9 80.9.el4_7.1 lilr642 GFS-kernel-largesmp x86_64 2.6.9 80.9.el4_7.5.hotfix.1 not installed not installed ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ """ self.assertEquals(buffer.getvalue(), expectedstring)
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 createConverter(source=None, master=None, category=None, where=None, convertertype="coladddiffs/dict"): cmdb=SoftwareCMDB(hostname=ComoonicsGlobals.mysqlserver, user=ComoonicsGlobals.mysqluser, password=ComoonicsGlobals.mysqlpassword, database=ComoonicsGlobals.mysqldatabase) ComoonicsGlobals.mylog.debug("searching for master %s with source %s" %(master, source)) if category: dbsource=Source(dbhandle=cmdb.db) source=dbsource.getSourcesForCategory(category) ComoonicsGlobals.mylog.debug("got %u sources for category %s" %(len(source), category)) if isinstance(source, basestring): source=[source] packages=cmdb.getPackages(source, master, None, 0, 0, where) differences=packages.differences() ComoonicsGlobals.mylog.debug("Searching for converter: %s" %convertertype) converter=getConverter(convertertype)(differences) ComoonicsGlobals.mylog.debug("Got converter: %s" %converter) return converter
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() self.report=CSVReportPackages(self.differences) def tearDown(self): pass def testReport(self): buffer=cStringIO.StringIO() self.report.report(outputchannel=buffer) print buffer.getvalue() expectedstring=""""name","architecture","version","subversion","lilr601","lilr642","lilr602" "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(buffer.getvalue(), expectedstring)
class Test(unittest.TestCase): def setUp(self): self.software_cmdb = SoftwareCMDB( hostname="axqad107-1", user="******", password="******", database="software_cmdb", table="software_cmdb" ) def testgetPackages(self): result = self.software_cmdb.getPackages( ["lilr642", "lilr602"], "lilr601", None, 0, 0, ['name LIKE "%GFS-kernel%"'] ) expectedresult = Packages( Package( name="GFS-kernel-largesmp", architecture="x86_64", version="2.6.9", subversion="80.9.el4_7.1", sources=["lilr642"], allsources=["lilr601", "lilr642", "lilr602"], hashlevel=4, ), Package( name="GFS-kernel-debuginfo", architecture="x86_64", version="2.6.9", subversion="80.9.el4_7.5.hotfix.1", sources=["lilr602"], allsources=["lilr601", "lilr642", "lilr602"], hashlevel=4, ), Package( name="GFS-kernel-largesmp", architecture="x86_64", version="2.6.9", subversion="80.9.el4_7.20", sources=["lilr601", "lilr642", "lilr602"], allsources=["lilr601", "lilr642", "lilr602"], hashlevel=4, ), Package( name="GFS-kernel-debuginfo", architecture="x86_64", version="2.6.9", subversion="72.2.0.2", sources=["lilr601"], allsources=["lilr601", "lilr642", "lilr602"], hashlevel=4, ), Package( name="GFS-kernel-largesmp", architecture="x86_64", version="2.6.9", subversion="80.9.el4_7.5.hotfix.1", sources=["lilr601", "lilr602"], allsources=["lilr601", "lilr642", "lilr602"], hashlevel=4, ), ) print repr(result) self.assertEquals(result, expectedresult) def testgetDifferencesMaster(self): expectedresult = Packages( Package( name="GFS-kernel-largesmp", architecture="x86_64", version="2.6.9", subversion="80.9.el4_7.1", sources=["lilr642"], allsources=["lilr601", "lilr642", "lilr602"], hashlevel=4, ), Package( name="GFS-kernel-debuginfo", architecture="x86_64", version="2.6.9", subversion="80.9.el4_7.5.hotfix.1", sources=["lilr602"], allsources=["lilr601", "lilr642", "lilr602"], hashlevel=4, ), Package( name="GFS-kernel-debuginfo", architecture="x86_64", version="2.6.9", subversion="72.2.0.2", sources=["lilr601"], allsources=["lilr601", "lilr642", "lilr602"], hashlevel=4, ), Package( name="GFS-kernel-largesmp", architecture="x86_64", version="2.6.9", subversion="80.9.el4_7.5.hotfix.1", sources=["lilr601", "lilr602"], allsources=["lilr601", "lilr642", "lilr602"], hashlevel=4, ), ) result = self.software_cmdb.getPackages( ["lilr642", "lilr602"], "lilr601", None, 0, 0, ['name LIKE "%GFS-kernel%"'] ) result = result.differences() print repr(result) self.assertEquals(result, expectedresult)