def setUp(self):
super(self.__class__, self).setUp()
self.script_kwargs = {
'inType': SCALAR,
'inArgs': [('a', VARCHAR(1024))],
'outType': RETURNS,
'outArgs': VARCHAR(1024),
}
self.port = 5000
if 'SGE_NODES' in os.environ:
self.port = portreg.client.get_port()
def setUp(self):
super(self.__class__, self).setUp()
self.script_kwargs = {
'inType': SCALAR,
'inArgs': [('a', VARCHAR(1024))],
'outType': RETURNS,
'outArgs': VARCHAR(1024),
}
self.port = 5000
if 'SGE_NODES' in os.environ:
self.port = portreg.client.get_port()
self.exatoolbox = exasol.__file__
self.interpreter = sys.executable
def test_createScript_local_argorder_args(self):
with exasol.connect(useCSV=True, **self.odbc_kwargs) as ecn:
ecn.execute('OPEN SCHEMA foo')
@ecn.createScript(
inArgs=[
('c', DOUBLE),
('a', DOUBLE),
('d', VARCHAR(20)),
('b', VARCHAR(20)),
],
outType=RETURNS,
outArgs=VARCHAR(40),
)
def foo(ctx):
return 'a=' + str(ctx.a) + '; b=' + str(ctx.b) + '; c=' + str(ctx.c) + '; d=' + str(ctx.d)
result = foo(4.5, 1.3, "'foo'", "'bar'", table='dual')
self.assertEqual('a=1.3; b=bar; c=4.5; d=foo', result[0][0])
def test_createScript_with_varchar(self):
self.create_script(VARCHAR(20))
self.check_type('VARCHAR(20) UTF8')