def get_data(self, **params):
data = {}
hostname = params.get('hostname')
hostuiname = ''
order_by = params.get('order_by', '1')
limit = params.get('limit', '50')
from_date = params.get('from_date',
datetime.datetime.now().strftime('%Y-%m-%d'))
to_date = params.get('to_date',
(datetime.datetime.now() +
datetime.timedelta(1)).strftime('%Y-%m-%d'))
no_copy_ddl = params.get('no_copy_ddl', True)
min_calls = params.get('min_calls', '3')
if 'show' in params and hostname:
data = reportdata.getStatStatements(hostname, from_date, to_date,
order_by, limit, no_copy_ddl,
min_calls)
hostuiname = hosts.getHostUIShortnameByHostname(hostname)
for d in data:
d['query_short'] = d['query'][:60].replace('\n', ' ').replace(
'\t', ' ') + ('...' if len(d['query']) > 60 else '')
host_names = sorted(hosts.hosts.items(),
key=lambda h: h[1]['host_name'])
return hostname, host_names, hostuiname, data, from_date, to_date, order_by, limit, no_copy_ddl, min_calls
def get_data(self, **params):
data = []
uishortname = params.get('uishortname', '')
order_by = params.get('order_by', '1')
limit = params.get('limit', '50')
from_date = params.get('from_date', datetime.datetime.now().strftime('%Y-%m-%d'))
to_date = params.get('to_date', (datetime.datetime.now() + datetime.timedelta(1)).strftime('%Y-%m-%d'))
no_copy_ddl = params.get('no_copy_ddl', True)
min_calls = params.get('min_calls', '3')
if 'show' in params and uishortname:
data = reportdata.getStatStatements(uishortname, from_date, to_date, order_by, limit, no_copy_ddl, min_calls)
for d in data:
d['query_short'] = d['query'][:60].replace('\n',' ').replace('\t',' ') + ('...' if len(d['query']) > 60 else '')
uishortnames = hosts.getHostsWithFeatureAsShortnames('statStatementsGatherInterval')
return uishortname, uishortnames, data, from_date, to_date, order_by, limit, no_copy_ddl, min_calls
def get_data(self, **params):
data = {}
hostname = params.get('hostname')
hostuiname = ''
order_by = params.get('order_by', '1')
limit = params.get('limit', '50')
from_date = params.get('from_date', datetime.datetime.now().strftime('%Y-%m-%d'))
to_date = params.get('to_date', (datetime.datetime.now() + datetime.timedelta(1)).strftime('%Y-%m-%d'))
if 'show' in params and hostname:
data = reportdata.getStatStatements(hostname, from_date, to_date, order_by, limit)
hostuiname = hosts.getHostUIShortnameByHostname(hostname)
for d in data:
d['query_short'] = d['query'][:60].replace('\n',' ').replace('\t',' ') + ('...' if len(d['query']) > 60 else '')
host_names=sorted(hosts.hosts.items(), key = lambda h : h[1]['host_name'])
return hostname, host_names, hostuiname, data, from_date, to_date, order_by, limit
def get_data(self, **params):
data = []
uishortname = params.get('uishortname', '')
order_by = params.get('order_by', '1')
limit = params.get('limit', '50')
from_date = params.get('from_date',
datetime.datetime.now().strftime('%Y-%m-%d'))
to_date = params.get('to_date',
(datetime.datetime.now() +
datetime.timedelta(1)).strftime('%Y-%m-%d'))
no_copy_ddl = params.get('no_copy_ddl', True)
min_calls = params.get('min_calls', '3')
if 'show' in params and uishortname:
data = reportdata.getStatStatements(uishortname, from_date,
to_date, order_by, limit,
no_copy_ddl, min_calls)
for d in data:
d['query_short'] = d['query'][:60].replace('\n', ' ').replace(
'\t', ' ') + ('...' if len(d['query']) > 60 else '')
uishortnames = hosts.getHostsWithFeatureAsShortnames(
'statStatementsGatherInterval')
return uishortname, uishortnames, data, from_date, to_date, order_by, limit, no_copy_ddl, min_calls
