def test_transform_order(): r = transform(t, sin_amount=sin(t.amount), cos_id=cos(t.id)) result = compute(r, s) expected = """SELECT accounts.name, accounts.amount, accounts.id, cos(accounts.id) as cos_id, sin(accounts.amount) as sin_amount FROM accounts """ assert normalize(str(result)) == normalize(expected)
def test_unary_ops(): t = TableSymbol('t', '{name: string, amount: int}') expr = cos(exp(t['amount'])) assert 'cos' in str(expr) assert '~' in str(~(t.amount > 0))
def test_unary_ops(): t = symbol('t', 'var * {name: string, amount: int}') expr = cos(exp(t['amount'])) assert 'cos' in str(expr) assert '~' in str(~(t.amount > 0))
def test_unary_ops(): t = TableSymbol("t", "{name: string, amount: int}") expr = cos(exp(t["amount"])) assert "cos" in str(expr) assert "~" in str(~(t.amount > 0))