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())
