def setUp(self): """ These tests use the following dataset configuration: l -> left r -> right j -> joined l1 r2 \ / j1 Dependencies flow from top to bottom. """ TestAbstractDatasetsUpdate.setUp(self) # create original datasets self.left_dataset_id = self._post_file() self.right_dataset_id = self._post_file('good_eats_aux.csv') # create joined dataset self.on = 'food_type' results = json.loads(self.controller.join( self.left_dataset_id, self.right_dataset_id, on=self.on)) self.joined_dataset_id = results[Dataset.ID]
def setUp(self): TestAbstractDatasetsUpdate.setUp(self) self._create_original_datasets() self._add_common_calculations() # create linked datasets aggregations = { "max(amount)": "max of amount", "mean(amount)": "mean of amount", "median(amount)": "median of amount", "min(amount)": "min of amount", "ratio(amount, gps_latitude)": "ratio of amount and gps_latitude", "sum(amount)": "sum of amount", } for aggregation, name in aggregations.items(): self.calculations.create(self.dataset2_id, aggregation, name) # and with group for aggregation, name in aggregations.items(): self.calculations.create(self.dataset2_id, aggregation, name, group="food_type") result = json.loads(self.controller.aggregations(self.dataset2_id)) self.linked_dataset1_id = result[""] # create merged datasets result = json.loads(self.controller.merge(datasets=json.dumps([self.dataset1_id, self.dataset2_id]))) self.merged_dataset1_id = result[Dataset.ID] result = json.loads( self.controller.merge(datasets=json.dumps([self.merged_dataset1_id, self.linked_dataset1_id])) ) self.merged_dataset2_id = result[Dataset.ID]
def setUp(self): TestAbstractDatasetsUpdate.setUp(self) self._create_original_datasets() self._add_common_calculations() # create linked datasets self.calculations.create( self.dataset2_id, 'sum(amount)', 'sum of amount') result = json.loads( self.controller.aggregations(self.dataset2_id)) self.linked_dataset1_id = result[''] # create merged datasets result = json.loads(self.controller.merge(dataset_ids=json.dumps( [self.dataset1_id, self.dataset2_id]))) self.merged_dataset1_id = result[Dataset.ID] result = json.loads(self.controller.merge(dataset_ids=json.dumps( [self.merged_dataset1_id, self.linked_dataset1_id]))) self.merged_dataset2_id = result[Dataset.ID]
def setUp(self): TestAbstractDatasetsUpdate.setUp(self) self._create_original_datasets() # create aggregated datasets self.calculations = Calculations() self.name1 = "sum of amount" self.formula1 = "sum(amount)" self.calculations.create(self.dataset2_id, self.formula1, self.name1) result = json.loads(self.controller.aggregations(self.dataset2_id)) self.aggregated_dataset1_id = result[""] # create merged datasets result = json.loads(self.controller.merge(dataset_ids=json.dumps([self.dataset1_id, self.dataset2_id]))) self.merged_dataset1_id = result[Dataset.ID] result = json.loads( self.controller.merge(dataset_ids=json.dumps([self.merged_dataset1_id, self.aggregated_dataset1_id])) ) self.merged_dataset2_id = result[Dataset.ID]
def setUp(self): TestAbstractDatasetsUpdate.setUp(self) self._create_original_datasets() # create aggregated datasets self.calculations = Calculations() self.name1 = 'sum of amount' self.formula1 = 'sum(amount)' self.calculations.create(self.dataset2_id, self.formula1, self.name1) result = json.loads( self.controller.aggregations(self.dataset2_id)) self.aggregated_dataset1_id = result[''] # create merged datasets result = json.loads(self.controller.merge(dataset_ids=json.dumps( [self.dataset1_id, self.dataset2_id]))) self.merged_dataset1_id = result[Dataset.ID] result = json.loads(self.controller.merge(dataset_ids=json.dumps( [self.merged_dataset1_id, self.aggregated_dataset1_id]))) self.merged_dataset2_id = result[Dataset.ID]
def setUp(self): TestAbstractDatasetsUpdate.setUp(self) self._create_original_datasets() self._add_common_calculations() # create linked datasets aggregations = { 'max(amount)': 'max of amount', 'mean(amount)': 'mean of amount', 'median(amount)': 'median of amount', 'min(amount)': 'min of amount', 'ratio(amount, gps_latitude)': 'ratio of amount and gps_latitude', 'sum(amount)': 'sum of amount', } for aggregation, name in aggregations.items(): self.calculations.create(self.dataset2_id, aggregation, name) # and with group for aggregation, name in aggregations.items(): self.calculations.create(self.dataset2_id, aggregation, name, group='food_type') result = json.loads(self.controller.aggregations(self.dataset2_id)) self.linked_dataset1_id = result[''] # create merged datasets result = json.loads( self.controller.merge( dataset_ids=json.dumps([self.dataset1_id, self.dataset2_id]))) self.merged_dataset1_id = result[Dataset.ID] result = json.loads( self.controller.merge(dataset_ids=json.dumps( [self.merged_dataset1_id, self.linked_dataset1_id]))) self.merged_dataset2_id = result[Dataset.ID]