def test_destinationcountry_country_country(self): level_fullname = "[Destination Country].[Country].[Country]" result = query(CUBE, MEASURES_SUM, level_fullname) # Check sum for measure "FOB US" measure_sum = sum(item["FOB US"] for item in result) self.assertEqual(measure_sum, 414316305677.0713)
def test_geography_region(self): level_fullname = "[Geography].[Region]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of records" measure_sum = sum(item["Number of records"] for item in result) self.assertEqual(measure_sum, 3171731.0)
def test_year_year(self): level_fullname = "[Year].[Year]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of records" measure_sum = sum(item["Number of records"] for item in result) self.assertEqual(measure_sum, 3209428.0)
def test_isiccaenes_isiccaenes(self): level_fullname = "[ISIC CAENES].[ISIC CAENES]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of records" measure_sum = sum(item["Number of records"] for item in result) self.assertEqual(measure_sum, 2645603.0)
def test_sex_sex(self): level_fullname = "[Sex].[Sex]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of records" measure_sum = sum(item["Number of records"] for item in result) self.assertEqual(measure_sum, 10030835.0)
def test_geography_region(self): level_fullname = "[Geography].[Region]" result = query(CUBE, MEASURES_AVG, level_fullname) # Check values for measure "Primary Healthcare AVG" average_sum = 15839270.433333334 average_count = 15 retrieved_values = [item["Primary Healthcare AVG"] or 0 for item in result] self.assertEqual(average_sum, sum(retrieved_values)) self.assertEqual(average_count, len(retrieved_values)) # Check values for measure "Specialized Healthcare AVG" average_sum = 7168714.966666666 average_count = 15 retrieved_values = [item["Specialized Healthcare AVG"] or 0 for item in result] self.assertEqual(average_sum, sum(retrieved_values)) self.assertEqual(average_count, len(retrieved_values)) # Check values for measure "Urgency Healthcare AVG" average_sum = 19107283.183333334 average_count = 15 retrieved_values = [item["Urgency Healthcare AVG"] or 0 for item in result] self.assertEqual(average_sum, sum(retrieved_values)) self.assertEqual(average_count, len(retrieved_values)) # Check values for measure "Dental Discharges Per 100 inhabitants AVG" average_sum = 120.67514924208322 average_count = 15 retrieved_values = [item["Dental Discharges Per 100 inhabitants AVG"] or 0 for item in result] self.assertEqual(average_sum, sum(retrieved_values)) self.assertEqual(average_count, len(retrieved_values))
def test_generaleconomiccondition_generaleconomiccondition(self): level_fullname = "[General Economic Condition].[General Economic Condition]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of records" measure_sum = sum(item["Number of records"] for item in result) self.assertEqual(measure_sum, 10030835.0)
def test_sex_sex(self): level_fullname = "[Sex].[Sex]" result = query(CUBE, MEASURES_SUM, level_fullname) # Check sum for measure "Population" measure_sum = sum(item["Population"] for item in result) self.assertEqual(measure_sum, 279246382.0)
def test_date_month(self): level_fullname = "[Date].[Month]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of records" measure_sum = sum(item["Number of records"] for item in result) self.assertEqual(measure_sum, 527089.0)
def test_agerange_agerange(self): level_fullname = "[Age Range].[Age Range]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of records" measure_sum = sum(item["Number of records"] for item in result) self.assertEqual(measure_sum, 188224.0)
def test_geography_region(self): level_fullname = "[Geography].[Region]" result = query(CUBE, MEASURES_SUM, level_fullname) # Check sum for measure "Population" measure_sum = sum(item["Population"] for item in result) self.assertEqual(measure_sum, 279246382.0)
def test_geography_region(self): level_fullname = "[Geography].[Region]" result = query(CUBE, MEASURES_SUM, level_fullname) # Check sum for measure "FOB US" measure_sum = sum(item["FOB US"] for item in result) self.assertEqual(measure_sum, 414313367696.0)
def test_geography_comuna(self): level_fullname = "[Geography].[Comuna]" result = query(CUBE, MEASURES_SUM, level_fullname) # Check sum for measure "FOB US" measure_sum = sum(item["FOB US"] for item in result) self.assertEqual(measure_sum, 414314489632.53516)
def test_exporths_hs_hs4(self): level_fullname = "[Export HS].[HS].[HS4]" result = query(CUBE, MEASURES_SUM, level_fullname) # Check sum for measure "FOB US" measure_sum = sum(item["FOB US"] for item in result) self.assertEqual(measure_sum, 414317607608.5573)
def test_visatype_visatype(self): level_fullname = "[Visa Type].[Visa Type]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of visas" measure_sum = sum(item["Number of visas"] for item in result) self.assertEqual(measure_sum, 1494873.0)
def test_storecreditcard_binarysurveyresponse_binarysurveyresponse(self): level_fullname = "[Store Credit Card].[Binary Survey Response].[Binary Survey Response]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of records" measure_sum = sum(item["Number of records"] for item in result) self.assertEqual(measure_sum, 527089.0)
def test_date_year(self): level_fullname = "[Date].[Year]" result = query(CUBE, MEASURES_AVG, level_fullname) # Check values for measure "Primary Healthcare AVG" average_sum = 5129687.411111111 average_count = 5 retrieved_values = [item["Primary Healthcare AVG"] or 0 for item in result] self.assertEqual(average_sum, sum(retrieved_values)) self.assertEqual(average_count, len(retrieved_values)) # Check values for measure "Specialized Healthcare AVG" average_sum = 2327705.588888889 average_count = 5 retrieved_values = [item["Specialized Healthcare AVG"] or 0 for item in result] self.assertEqual(average_sum, sum(retrieved_values)) self.assertEqual(average_count, len(retrieved_values)) # Check values for measure "Urgency Healthcare AVG" average_sum = 6200857.08888889 average_count = 5 retrieved_values = [item["Urgency Healthcare AVG"] or 0 for item in result] self.assertEqual(average_sum, sum(retrieved_values)) self.assertEqual(average_count, len(retrieved_values)) # Check values for measure "Dental Discharges Per 100 inhabitants AVG" average_sum = 39.81082196765476 average_count = 5 retrieved_values = [item["Dental Discharges Per 100 inhabitants AVG"] or 0 for item in result] self.assertEqual(average_sum, sum(retrieved_values)) self.assertEqual(average_count, len(retrieved_values))
def test_activity_activity(self): level_fullname = "[Activity].[Activity]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of visas" measure_sum = sum(item["Number of visas"] for item in result) self.assertEqual(measure_sum, 1556618.0)
def test_date_movingquarter(self): level_fullname = "[Date].[Moving Quarter]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of records" measure_sum = sum(item["Number of records"] for item in result) self.assertEqual(measure_sum, 10030835.0)
def test_calculatedagerange_agerange(self): level_fullname = "[Calculated Age Range].[Age Range]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of visas" measure_sum = sum(item["Number of visas"] for item in result) self.assertEqual(measure_sum, 1494873.0)
def test_isco_isco(self): level_fullname = "[ISCO].[ISCO]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of records" measure_sum = sum(item["Number of records"] for item in result) self.assertEqual(measure_sum, 4353563.0)
def test_date_year(self): level_fullname = "[Date].[Year]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of visas" measure_sum = sum(item["Number of visas"] for item in result) self.assertEqual(measure_sum, 1494873.0)
def test_occupationalsituation_occupationalsituation(self): level_fullname = "[Occupational Situation].[Occupational Situation]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of records" measure_sum = sum(item["Number of records"] for item in result) self.assertEqual(measure_sum, 10030835.0)
def test_education_education(self): level_fullname = "[Education].[Education]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of visas" measure_sum = sum(item["Number of visas"] for item in result) self.assertEqual(measure_sum, 1494873.0)
def test_administration_administration(self): level_fullname = "[Administration].[Administration]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of records" measure_sum = sum(item["Number of records"] for item in result) self.assertEqual(measure_sum, 3209428.0)
def test_geography_comuna(self): level_fullname = "[Geography].[Comuna]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of visas" measure_sum = sum(item["Number of visas"] for item in result) self.assertEqual(measure_sum, 1494873.0)
def test_institution_institution(self): level_fullname = "[Institution].[Institution]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of records" measure_sum = sum(item["Number of records"] for item in result) self.assertEqual(measure_sum, 3152985.0)
def test_origincountry_country_country(self): level_fullname = "[Origin Country].[Country].[Country]" result = query(CUBE, MEASURES_COUNT, level_fullname) # Check sum for measure "Number of visas" measure_sum = sum(item["Number of visas"] for item in result) self.assertEqual(measure_sum, 1494873.0)
def test_higherinstitutions_higherinstitutionsubgroup(self): level_fullname = "[Higher Institutions].[Higher Institution Subgroup]" result = query(CUBE, MEASURES_SUM, level_fullname) # Check sum for measure "Sum anual payment 2016" measure_sum = sum(item["Sum anual payment 2016"] for item in result) self.assertEqual(measure_sum, 3784407743.0)
def test_date_year(self): level_fullname = "[Date].[Year]" result = query(CUBE, MEASURES_SUM, level_fullname) # Check sum for measure "FOB US" measure_sum = sum(item["FOB US"] for item in result) self.assertEqual(measure_sum, 414308814848.0)