def doMain(self): hellodb = sdb.getDBStats() main = {} for i in ('items', 'size','itemsize','ndomains'): main[i] = hellodb[i] dkeys = hellodb['domainstats'].keys() dkeys.sort() dmain = [] for d in dkeys: dinfo = hellodb['domainstats'][d] row = [] row.append(d) for i in ('items', 'size','itemsize','attrnames','attrvalues'): row.append(dinfo[i]) dmain.append(row) main['header'] = ['Jobs', 'Items (M)', 'MB', 'bytes/item', 'Attribute names (M)','Values (M)']; main['info'] = dmain self.publish(main)
def doMain(self): dbstats = sdb.getDBStats() main = {} for i in ('items', 'size', 'itemsize', 'ndomains'): main[i] = dbstats[i] dkeys = dbstats['domainstats'].keys() dkeys.sort() dmain = [] for d in dkeys: dinfo = dbstats['domainstats'][d] row = [] row.append(d) for i in ('items', 'size', 'itemsize', 'attrnames', 'attrvalues'): row.append(dinfo[i]) dmain.append(row) main['header'] = [ 'Jobs', 'Items (M)', 'MB', 'bytes/item', 'Attribute names (M)', 'Values (M)' ] main['info'] = dmain self.publish(main)
def doQuery(self): """ Process the query request This is the redundant method. It was left here for the sake of the backward compatibiity """ title = 'Database status' nav = 'Archival job database in use is %s' % pmstate().jobarchive maintxt = '' dbstats = sdb.getDBStats() maintxt += "<p>Total size: %s MB" % dbstats['size'] maintxt += "<p>Total items: %s M" % int(dbstats['items'] / 1000000) maintxt += "<p>Average item size: %s bytes" % dbstats['itemsize'] maintxt += "<p>Number of domains: %s" % dbstats['ndomains'] maintxt += "<p>Domain info:" dkeys = dbstats['domainstats'].keys() dkeys.sort() for d in dkeys: dinfo = dbstats['domainstats'][d] maintxt += "<br> %s: %2.1f M items %s MB %s bytes/item Attribute names: %s values: %s M" % \ ( d, dinfo['items']/1000000., dinfo['size'], dinfo['itemsize'], dinfo['attrnames'], int(dinfo['attrvalues']/1000000) ) self.publishPage(title, nav, maintxt)
def doQuery(self): """ Process the query request This is the redundant method. It was left here for the sake of the backward compatibiity """ title = 'Database status' nav = 'Archival job database in use is %s' % pmstate().jobarchive maintxt = '' dbstats = sdb.getDBStats() maintxt += "<p>Total size: %s MB" % dbstats['size'] maintxt += "<p>Total items: %s M" % int(dbstats['items']/1000000) maintxt += "<p>Average item size: %s bytes" % dbstats['itemsize'] maintxt += "<p>Number of domains: %s" % dbstats['ndomains'] maintxt += "<p>Domain info:" dkeys = dbstats['domainstats'].keys() dkeys.sort() for d in dkeys: dinfo = dbstats['domainstats'][d] maintxt += "<br> %s: %2.1f M items %s MB %s bytes/item Attribute names: %s values: %s M" % \ ( d, dinfo['items']/1000000., dinfo['size'], dinfo['itemsize'], dinfo['attrnames'], int(dinfo['attrvalues']/1000000) ) self.publishPage(title,nav,maintxt)