def setUp(self): self.model = cubes.Model('test') self.date_levels = [{ "name": "year", "key": "year" }, { "name": "month", "key": "month" }] self.date_levels2 = [{ "name": "year", "key": "year" }, { "name": "month", "key": "month" }, { "name": "day", "key": "day" }] self.date_hiers = [{"name": "ym", "levels": ["year", "month"]}] self.date_hiers2 = [{ "name": "ym", "levels": ["year", "month"] }, { "name": "ymd", "levels": ["year", "month", "day"] }] self.date_desc = { "name": "date", "levels": self.date_levels, "hierarchies": self.date_hiers }
def setUp(self): engine = create_engine('sqlite://') self.connection = engine.connect() self.metadata = MetaData() self.metadata.bind = engine self.table_name = "test" # Prepare table table = sqlalchemy.Table(self.table_name, self.metadata) table.append_column(Column("id", String)) table.append_column(Column("color", String)) table.append_column(Column("tone", String)) table.append_column(Column("size", String)) table.append_column(Column("temperature", String)) table.create(self.connection) self.table = table # Prepare model self.model = cubes.Model() self.cube = cubes.Cube("test") self.model.add_cube(self.cube) desc = {"name": "color", "levels": ["color", "tone"]} dimension = cubes.create_dimension(desc) self.cube.add_dimension(dimension) dimension = cubes.create_dimension("size") self.cube.add_dimension(dimension)
def setUp(self): a = [DIM_DATE_DESC, DIM_PRODUCT_DESC, DIM_FLAG_DESC] self.measures = cubes.attribute_list(["amount", "discount"]) self.dimensions = [cubes.create_dimension(desc) for desc in a] self.cube = cubes.Cube("contracts", dimensions=self.dimensions, measures=self.measures) self.model = cubes.Model(cubes=[self.cube], dimensions=self.dimensions) self.model_path = os.path.join(DATA_PATH, 'model.json')
def setUp(self): date_desc = { "name": "date", "levels": { "year": { "key": "year", "attributes": [{ "name": "year", "order": "ascending" }] }, "month": { "key": "month", "attributes": [{ "name": "month", "order": "ascending" }, { "name": "month_name" }] } }, "default_hierarchy": "ym", "hierarchies": { "ym": { "levels": ["year", "month"] } } } class_desc = { "name": "cls", "levels": { "group": { "key": "group_id", "attributes": ["group_id", "group_desc"] }, "class": { "key": "class_id", "attributes": ["class_id", "class_desc"] } }, "default_hierarchy": "default", "hierarchies": { "default": { "levels": ["group", "class"] } } } cube = { "name": "testcube", } self.date_dim = cubes.create_dimension(date_desc) self.class_dim = cubes.create_dimension(class_desc) dims = [self.date_dim, self.class_dim] self.model = cubes.Model('test', dimensions=dims) self.cube = cubes.Cube("testcube", dimensions=dims) self.model.add_cube(self.cube) self.cube.measures = [cubes.Attribute("amount")] self.cube.mappings = { "amount": "ft_contracts.amount", "date.year": "dm_date.year", "date.month": "dm_date.month", "date.month_name": "dm_date.month_name", "cls.group_id": "dm_cls.group_id", "cls.class_id": "dm_cls.class_id", "cls.group_desc": "dm_cls.group_desc", "cls.class_desc": "dm_cls.class_desc", "cls.id": "dm_cls.id", "date.id": "dm_date.id", "fact.date_id": "ft_contracts.date_id", "fact.cls_id": "ft_contracts.cls_id" } self.cube.fact = "ft_contracts" self.mappings2 = {"amount": "ft_contracts.amount"} self.cube.joins = [{ "master": "fact.date_id", "detail": "date.id" }, { "master": "fact.cls_id", "detail": "cls.id" }] self.prepare_data()