def __load_definition(self): """Load definition of an existing dataset.""" response = datasets.dataset_definition(connection=self._connection, dataset_id=self._dataset_id) self._definition = response.json() self._name = self._definition['name']
def __multitable_definition(self): """Return all tables names and columns as a dictionary""" if not self._table_definition: try: res_tables = datasets.dataset_definition( connection=self._connection, dataset_id=self._cube_id, fields=['tables', 'columns']) _ds_definition = res_tables.json() for table in _ds_definition['result']['definition'][ 'availableObjects']['tables']: column_list = [ column['columnName'] for column in _ds_definition['result']['definition'] ['availableObjects']['columns'] if table['name'] == column['tableName'] ] self._table_definition[table['name']] = column_list except: helper.exception_handler( "Some functionality is not available with this type of cube at the moment.", throw_error=False, exception_type=Warning, stack_lvl=3) return self._table_definition
def __multitable_definition(self): """Return all tables names and columns as a dictionary""" res_tables = datasets.dataset_definition(connection=self._connection, dataset_id=self._cube_id, fields=['tables', 'columns']) _ds_definition = res_tables.json() for table in _ds_definition['result']['definition']['availableObjects']['tables']: column_list = [column['columnName'] for column in _ds_definition['result']['definition']['availableObjects']['columns'] if table['name'] == column['tableName']] self._table_definition[table['name']] = column_list
def __load_definition(self): """Load definition of an existing dataset.""" response = datasets.dataset_definition(connection=self._connection, dataset_id=self._dataset_id) if not response.ok: self.__response_handler( response=response, msg="Error loading dataset '{}'. Check dataset ID.".format( self._dataset_id)) else: self._definition = response.json() self._name = self._definition['name'] self._dataset_id = self._definition['id']
def __multitable_definition(self): """Return all tables names and columns as a dictionary.""" if not self._table_definition: res_tables = datasets.dataset_definition(connection=self._connection, id=self._id, fields=['tables', 'columns'], whitelist=[('ERR001', 500)]) if res_tables.ok: ds_definition = res_tables.json() for table in ds_definition['result']['definition']['availableObjects']['tables']: column_list = [ column['columnName'] for column in ds_definition['result']['definition'] ['availableObjects']['columns'] if table['name'] == column['tableName'] ] self._table_definition[table['name']] = column_list return self._table_definition
def multitable_definition(self): """ Return all tables names and collumns as a dictionary """ res_tables = datasets.dataset_definition(connection=self._connection, dataset_id=self._cube_id, fields=['tables', 'columns']) _ds_definition = res_tables.json() _columns_tables = {} for table in _ds_definition['result']['definition'][ 'availableObjects']['tables']: _column_list = [] for column in _ds_definition['result']['definition'][ 'availableObjects']['columns']: if (table['name'] == column['tableName']): _column_list.append(column['columnName']) _columns_tables[table['name']] = _column_list return _columns_tables
def generate_dataset_definition(self): res = datasets.dataset_definition(self.connection, dataset_id=self.dataset_id, fields=['tables', 'columns']) return res.json()