def test_get_dimensions_from_where_clause_happy_case(self): mdx = """ SELECT {[dim3].[e2]} ON COLUMNS, {[dim4].[e5]} ON ROWS FROM [cube] WHERE ([dim2].[e1], [dim1].[e4]) """ dimensions = get_dimensions_from_where_clause(mdx) self.assertEqual(["DIM2", "DIM1"], dimensions)
def test_get_dimensions_from_where_clause_no_where(self): mdx = """ SELECT {[dim3].[e2]} ON COLUMNS, {[dim4].[e5]} ON ROWS FROM [cube] """ dimensions = get_dimensions_from_where_clause(mdx) self.assertEqual([], dimensions)
def test_get_dimensions_from_where_clause_spacing(self): mdx = """ SELECT {[dim3].[e2]} ON COLUMNS, {[dim4].[e5]} ON ROWS FROM [cube] WHERE([dim5]. [e4] ) """ dimensions = get_dimensions_from_where_clause(mdx) self.assertEqual(["DIM5"], dimensions)