def test_measure_4():
context = Context(["table_a", "table_b"], ["field_x", "field_y"])
test = "SUM(table_a:field_a)+COUNT(table_b:field_b);"
correct = """
CREATE MATERIALIZED VIEW table_a_c AS
SELECT
SUM(field_a) AS SUM_table_a_field_a
FROM
table_a
GROUP BY
field_x,field_y;
CREATE MATERIALIZED VIEW table_b_c AS
SELECT
COUNT(field_b) AS COUNT_table_b_field_b
FROM
table_b
GROUP BY
field_x,field_y;
CREATE VIEW base AS
SELECT
SUM_table_a_field_a+COUNT_table_b_field_b
FROM
table_a_c
LEFT JOIN table_b_c ON table_b_c.field_x = table_a_c.field_x,table_b_c.field_y = table_a_c.field_y;
"""
assert _r(correct) == _r(parse(test, context))
def test_measure_2():
context = Context(["table_a", "table_b"], ["field_x", "field_y"])
test = "SUM(table_a:field_a)+1;"
correct = """
CREATE MATERIALIZED VIEW table_a_c AS
SELECT
SUM(field_a) AS SUM_table_a_field_a
FROM
table_a
GROUP BY
field_x,field_y;
CREATE VIEW base AS
SELECT
SUM_table_a_field_a+1
FROM
table_a_c;
"""
assert _r(correct) == _r(parse(test, context))