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)
