Beispiel #1
0
    def setUpClass(self):
        self.dw = create_demo_dw(CONNECTION, None, False)
        self.store = SQLStore(engine=self.dw.engine,
                              metadata=self.dw.md)

        self.provider = TinyDemoModelProvider()

        naming = {
            "fact_prefix": "fact_",
            "dimension_prefix": "dim_"
        }
        naming = distill_naming(naming)

        self.cube = self.provider.cube("sales")

        (fact_name, mappings) = map_base_attributes(self.cube,
                                                    StarSchemaMapper,
                                                    naming=naming)

        joins = [to_join(join) for join in self.cube.joins]
        self.star = StarSchema(self.cube.name,
                               self.dw.md,
                               mappings=mappings,
                               fact=fact_name,
                               joins=joins)
Beispiel #2
0
    def setUp(self):
        super(MapperTestCase, self).setUp()

        self.provider = create_provider("mapper_test.json")

        self.cube = self.provider.cube("sales")
        naming = {"dimension_prefix": "dim_", "dimension_suffix": "_dim"}
        self.naming = distill_naming(naming)
        self.mapper = StarSchemaMapper(self.cube, self.naming)

        self.mapper.mappings = {
            "product.name": "product.product_name",
            "product.category": "product.category_id",
            "subcategory.name.en": "subcategory.subcategory_name_en",
            "subcategory.name.sk": "subcategory.subcategory_name_sk",
        }
Beispiel #3
0
    def setUp(self):
        super(MapperTestCase, self).setUp()

        self.provider = create_provider("mapper_test.json")

        self.cube = self.provider.cube("sales")
        naming = {"dimension_prefix": "dim_", "dimension_suffix": "_dim"}
        self.naming = distill_naming(naming)
        self.mapper = StarSchemaMapper(self.cube, self.naming)

        self.mapper.mappings = {
            "product.name": "product.product_name",
            "product.category": "product.category_id",
            "subcategory.name.en": "subcategory.subcategory_name_en",
            "subcategory.name.sk": "subcategory.subcategory_name_sk"
        }