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)
