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()