def test_resemble_mdx_with_member(self):
mdx = """
WITH MEMBER [dim3].[e3] AS 1
SELECT {[dim3].[e2], [dim3].[e3]} ON COLUMNS FROM [cube]
"""
self.assertTrue(resembles_mdx(mdx))
def test_resemble_mdx_with_line_breaks(self):
mdx = """
SELECT
{[dim3].[e2]} ON
COLUMNS,
{[dim4].[e5]}
ON ROWS FROM
[cube]
"""
self.assertTrue(resembles_mdx(mdx))
def test_resemble_mdx_no_rows(self):
mdx = """
SELECT {[dim3].[e2]} ON COLUMNS FROM [cube]
"""
self.assertTrue(resembles_mdx(mdx))
def test_resemble_mdx_lower_case(self):
mdx = """
SELECT {[dim3].[e2]} ON COLUMNS, {[dim4].[e5]} ON ROWS FROM [cube]
""".lower()
self.assertTrue(resembles_mdx(mdx))
def test_resemble_mdx_happy_case_false(self):
mdx = """
not mdx
"""
self.assertFalse(resembles_mdx(mdx))
def test_resemble_mdx_happy_case_true(self):
mdx = """
SELECT {[dim3].[e2]} ON COLUMNS, {[dim4].[e5]} ON ROWS FROM [cube]
"""
self.assertTrue(resembles_mdx(mdx))
