def index(self, **params):
data = []
#data.append({'host_name':'Host1','schema_name':'schema1','table_name':'table1','day':'2013-08-20'})
#print(tplE.env.globals['hosts'])
if 'show' in params:
data = reportdata.getTablePerformanceIssues(
params['hostname'], params['from'], params['to'])
interval = {}
if 'from' in params and 'to' in params:
interval['from'] = params['from']
interval['to'] = params['to']
interval['hostname'] = params['hostname']
else:
interval['from'] = (
datetime.datetime.now() -
datetime.timedelta(days=3)).strftime('%Y-%m-%d')
interval['to'] = (datetime.datetime.now()).strftime('%Y-%m-%d')
interval['hostname'] = 'all'
table = tplE.env.get_template('perf_tables.html')
host_names = sorted(hosts.hosts.items(),
key=lambda h: h[1]['host_name'])
return table.render(data=data,
interval=interval,
host_names=host_names)
def get_data(self, **params):
data = []
if 'show' in params:
data = reportdata.getTablePerformanceIssues(params['hostname'], params['from'], params['to'])
for d in data:
d['hostuiname'] = hosts.hostIdToUiShortname(d['host_id'])
interval = {}
if 'from' in params and 'to' in params:
interval['from'] = params['from']
interval['to'] = params['to']
interval['hostname'] = params['hostname']
else:
interval['from'] = (datetime.datetime.now() - datetime.timedelta(days=3)).strftime('%Y-%m-%d')
interval['to'] = (datetime.datetime.now()).strftime('%Y-%m-%d')
interval['hostname'] = 'all'
host_names = sorted(hosts.hosts.items(), key = lambda h : h[1]['host_name'])
return data, interval, host_names
def get_data(self, **params):
data = []
if 'show' in params:
data = reportdata.getTablePerformanceIssues(params['hostname'], params['from'], params['to'])
for d in data:
d['hostuiname'] = hosts.hostIdToUiShortname(d['host_id'])
interval = {}
if 'from' in params and 'to' in params:
interval['from'] = params['from']
interval['to'] = params['to']
interval['hostname'] = params['hostname']
else:
interval['from'] = (datetime.datetime.now() - datetime.timedelta(days=3)).strftime('%Y-%m-%d')
interval['to'] = (datetime.datetime.now()).strftime('%Y-%m-%d')
interval['hostname'] = 'all'
host_names = sorted(hosts.hosts.items(), key = lambda h : h[1]['host_name'])
return data, interval, host_names
def get_data(self, **params):
data = []
if 'show' in params:
uishortname = params.get('uishortname')
if uishortname == 'all':
uishortname = None
data = reportdata.getTablePerformanceIssues(uishortname, params['from'], params['to'])
interval = {}
if 'from' in params and 'to' in params:
interval['from'] = params['from']
interval['to'] = params['to']
interval['uishortname'] = params['uishortname']
else:
interval['from'] = (datetime.datetime.now() - datetime.timedelta(days=3)).strftime('%Y-%m-%d')
interval['to'] = (datetime.datetime.now()).strftime('%Y-%m-%d')
interval['uishortname'] = 'all'
return data, interval, hosts.getAllHostUinamesSorted()
def index(self,**params):
data = []
#data.append({'host_name':'Host1','schema_name':'schema1','table_name':'table1','day':'2013-08-20'})
#print(tplE.env.globals['hosts'])
if 'show' in params:
data = reportdata.getTablePerformanceIssues(params['hostname'], params['from'], params['to'])
interval = {}
if 'from' in params and 'to' in params:
interval['from'] = params['from']
interval['to'] = params['to']
interval['hostname'] = params['hostname']
else:
interval['from'] = (datetime.datetime.now() - datetime.timedelta(days=3)).strftime('%Y-%m-%d')
interval['to'] = (datetime.datetime.now()).strftime('%Y-%m-%d')
interval['hostname'] = 'all'
table = tplE.env.get_template('perf_tables.html')
host_names = sorted(hosts.hosts.items(), key = lambda h : h[1]['host_name'])
return table.render(data=data, interval=interval, host_names=host_names)
def get_data(self, **params):
data = []
if 'show' in params:
uishortname = params.get('uishortname')
if uishortname == 'all':
uishortname = None
data = reportdata.getTablePerformanceIssues(
uishortname, params['from'], params['to'])
interval = {}
if 'from' in params and 'to' in params:
interval['from'] = params['from']
interval['to'] = params['to']
interval['uishortname'] = params['uishortname']
else:
interval['from'] = (
datetime.datetime.now() -
datetime.timedelta(days=3)).strftime('%Y-%m-%d')
interval['to'] = (datetime.datetime.now()).strftime('%Y-%m-%d')
interval['uishortname'] = 'all'
return data, interval, hosts.getAllHostUinamesSorted()