def post_query(self, table, start_time=None, end_time=None, select_fields=None, where_clause=None, sort_fields=None, sort=None, limit=None, filter=None, sync=True,dir=None): res = None try: flows_url = OpServerUtils.opserver_query_url( self._ip, str(self._port)) print flows_url query_dict = OpServerUtils.get_query_dict( table, start_time, end_time, select_fields, where_clause, sort_fields, sort, limit, filter, dir) print json.dumps(query_dict) res = [] resp = OpServerUtils.post_url_http( flows_url, json.dumps(query_dict), sync) if sync: if resp is not None: res = json.loads(resp) res = res['value'] else: if resp is not None: resp = json.loads(resp) qid = resp['href'].rsplit('/', 1)[1] result = OpServerUtils.get_query_result( self._ip, str(self._port), qid, 30) for item in result: res.append(item) except Exception as e: print str(e) finally: return res
def post_query(self, table, start_time=None, end_time=None, select_fields=None, where_clause='', sort_fields=None, sort=None, limit=None, filter=None, sync=True,dir=None, session_type=None, is_service_instance=None): res = None try: flows_url = OpServerUtils.opserver_query_url( self._ip, str(self._port)) print(flows_url) query_dict = OpServerUtils.get_query_dict( table, start_time=start_time, end_time=end_time, select_fields=select_fields, where_clause=where_clause, sort_fields=sort_fields, sort=sort, limit=limit, filter=filter, dir=dir, is_service_instance=is_service_instance, session_type=session_type) print(json.dumps(query_dict)) res = [] resp = OpServerUtils.post_url_http( flows_url, json.dumps(query_dict), self._user, self._password, sync, headers=self._headers) if sync: if resp is not None: res = json.loads(resp) res = res['value'] else: if resp is not None: resp = json.loads(resp) qid = resp['href'].rsplit('/', 1)[1] result = OpServerUtils.get_query_result( self._ip, str(self._port), qid, self._user, self._password, 30, headers=self._headers) for item in result: res.append(item) except Exception as e: print(str(e)) finally: return res
def query(self,schema): query_url = OpServerUtils.opserver_query_url( self._args.opserver_ip, self._args.opserver_port) query_dict = OpServerUtils.get_query_dict( "StatTable." + self._args.table, str(self._start_time), str(self._end_time), select_fields = self._args.select, where_clause = "AND".join(self._args.where), sort_fields = self._args.sort) print json.dumps(query_dict) resp = OpServerUtils.post_url_http( query_url, json.dumps(query_dict), sync = True) res = None if resp is not None: res = json.loads(resp) res = res['value'] return res
def query(self, schema): query_url = OpServerUtils.opserver_query_url(self._args.opserver_ip, self._args.opserver_port) query_dict = OpServerUtils.get_query_dict( "StatTable." + self._args.table, str(self._start_time), str(self._end_time), select_fields=self._args.select, where_clause="AND".join(self._args.where), sort_fields=self._args.sort) print json.dumps(query_dict) resp = OpServerUtils.post_url_http(query_url, json.dumps(query_dict), sync=True) res = None if resp is not None: res = json.loads(resp) res = res['value'] return res