def test_schema_included_in_function_sql(self): a = Schema('a') func = fn.Function('my_proc', 1, 2, 3, schema=a) self.assertEqual('"a".my_proc(1,2,3)', func.get_sql(quote_char='"'))
def test_dialect_propagation(self): func = fn.Function('func', ['a'], ['b']) self.assertEqual("func(ARRAY['a'],ARRAY['b'])", func.get_sql(dialect=Dialects.POSTGRESQL))
def test_schema_no_schema_in_sql_when_none_set(self): func = fn.Function('my_proc', 1, 2, 3) self.assertEqual('my_proc(1,2,3)', func.get_sql(quote_char='"'))
def test__subquery_in_params_functions(self): subquery = Query.from_('table').select('id') func = fn.Function('func', 'id', subquery) self.assertEqual("func('id',(SELECT id FROM table))", func.get_sql())