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, selected_hostname=None, **params): hostnames = hosts.getAllHostNames() bloat_type = params.get('bloat_type', 'table') order_by = params.get('order_by', 'wasted_bytes') limit = params.get('limit', '50') data = [] hostuiname = None if selected_hostname: if bloat_type == 'table': msg, data = reportdata.getBloatedTablesForHostname(selected_hostname, order_by, limit) else: msg, data = reportdata.getBloatedIndexesForHostname(selected_hostname, order_by, limit) if msg: raise Exception('Failed to get data: ' + msg) hostuiname = hosts.getHostUIShortnameByHostname(selected_hostname) return data, hostnames, bloat_type, order_by, limit, hostuiname
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, selected_hostname=None, **params): hostnames = hosts.getAllHostNames() bloat_type = params.get('bloat_type', 'table') order_by = params.get('order_by', 'wasted_bytes') limit = params.get('limit', '50') data = [] hostuiname = None if selected_hostname: if bloat_type == 'table': msg, data = reportdata.getBloatedTablesForHostname(selected_hostname, order_by, limit) else: msg, data = reportdata.getBloatedIndexesForHostname(selected_hostname, order_by, limit) if msg: raise Exception('Failed to get data: ' + msg) hostuiname = hosts.getHostUIShortnameByHostname(selected_hostname) return data, hostnames, bloat_type, order_by, limit, hostuiname