def getColnamesForDiffCategory(self, category, Installed=False, colnames=COMPARE_2_SOFTWARE): source=Source(dbhandle=self.db) sourcenames=source.getSourcesForCategory(category) colnames_ret=list() colnames_ret.append(colnames[0]) for sourcename in sourcenames: for colname in colnames[1:]: colnames_ret.append(colname+"_"+self.escapeSQL(sourcename)) if Installed: colnames_ret.append(SoftwareCMDB.DIFFS_COLNAME) return colnames_ret
def getDiffsFromCategory(self, category, colnames=None, limitup=0, limitdown=0, where=None, orderby=None, Diffs=True, NotInstalled=True, Installed=False): """ Returns a resultset of differences of the given categories. Parameter are the sourcesnames to compare """ sources=list() source=Source(dbhandle=self.db) snames=source.getSourcesForCategory(category) if len(snames) == 0: return None else: snames=self.escapeSQL(snames) return self.getDiffsFromSources(snames, colnames, limitup, limitdown, where, orderby, Diffs, NotInstalled, Installed)
def getColnamesForDiffCategory(self, category, Installed=False, colnames=COMPARE_2_SOFTWARE): source = Source(dbhandle=self.db) sourcenames = source.getSourcesForCategory(category) colnames_ret = list() colnames_ret.append(colnames[0]) for sourcename in sourcenames: for colname in colnames[1:]: colnames_ret.append(colname + "_" + self.escapeSQL(sourcename)) if Installed: colnames_ret.append(SoftwareCMDB.DIFFS_COLNAME) return colnames_ret
def getDiffsFromCategory(self, category, colnames=None, limitup=0, limitdown=0, where=None, orderby=None, Diffs=True, NotInstalled=True, Installed=False): """ Returns a resultset of differences of the given categories. Parameter are the sourcesnames to compare """ sources = list() source = Source(dbhandle=self.db) snames = source.getSourcesForCategory(category) if len(snames) == 0: return None else: snames = self.escapeSQL(snames) return self.getDiffsFromSources(snames, colnames, limitup, limitdown, where, orderby, Diffs, NotInstalled, Installed)