def do_query(self, select_statement): """ performs a query using sql query statement """ result_json = OperationHelper.request_select_statement( self.server_url, select_statement) result = pd.read_json(result_json.text) print(result.to_string())
def __init__(self, data_type, tmp_files, _uuid, server_url): cmd.Cmd.__init__(self) if not data_type in DATA_TYPE_MAPPING.keys(): print("data_type must be in {0}".format( list(DATA_TYPE_MAPPING.keys()))) return None self.class_id = data_type self.data_type = DATA_TYPE_MAPPING[data_type] self._uuid = _uuid self.server_url = server_url request_json_result = OperationHelper.request_select_statement( self.server_url, self.QUERY_TEMPLATE.format(data_type, self._uuid)) request_json_result = json.loads(request_json_result.text) df_request_result = pd.DataFrame(request_json_result) if df_request_result.shape[0] != 1: print("number of rows : {0} for uuid {1}".format( df_request_result.shape[0], _uuid)) self.past_data_element = df_request_result.iloc[0].to_dict() self.current_data_element = self.past_data_element.copy() self.tmp_files = tmp_files