def test1(self):
request = rQ.Request(parameters={'firstName': 'Johansson', 'zero': ''})
request.put("firstName", "Johansson")
request.put("zero", "")
request.put("none", None)
self.assertEqual("Johansson", rQ.resolve_value(":firstName", request))
self.assertEqual("Johansson",
rQ.resolve_value(" :firstName ", request))
self.assertEqual("firstName", rQ.resolve_value("firstName", request))
self.assertEqual(":lastName", rQ.resolve_value("':lastName'", request))
#
self.assertEqual("", rQ.resolve_value(":zero", request))
self.assertEqual("", rQ.resolve_value(" :zero ", request))
self.assertEqual("zero", rQ.resolve_value("zero", request))
#
self.assertEqual("", rQ.resolve_value(":none", request))
self.assertEqual("", rQ.resolve_value(" :none ", request))
self.assertEqual("none", rQ.resolve_value("none", request))
#
self.assertEqual("'", rQ.resolve_value("'", request))
#
self.assertEqual("", rQ.resolve_value(None, request))
self.assertEqual("", rQ.resolve_value(":lastName", request))
#
self.assertEqual("A B", rQ.resolve_value(" 'A B' ", request))
self.assertEqual("A B", rQ.resolve_value("'A B'", request))
self.assertEqual("A B", rQ.resolve_value("A B", request))
self.assertEqual("A B", rQ.resolve_value(" A B ", request))
self.assertEqual(":firstName",
rQ.resolve_value("':firstName'", request))
def test_set(self):
serviceId = "Test.Command.set"
se = rQ.ServiceRepositoryHolder.get(serviceId)
self.assertIsNotNone(se)
request = rQ.Request().setServiceId(serviceId)
request.run()
self.assertTrue("hello", request.get("name"))
def test_command_if(self):
#
# COMMAND NODE
#
se = rQ.ServiceRepositoryHolder.get("Test.Command.if")
self.assertIsNotNone(se)
snActual = rQ.prepareCommandBlock(se)
snExpected = StatementNode("serviceRoot").append(StatementNode("parameters"),
StatementNode("if").append(
StatementNode("sql"), StatementNode("sql"), StatementNode("else"), StatementNode("sql"),
StatementNode("end")
))
rQ.assertStatementNodeEquals(snExpected, snActual)
#
# REQUEST RUN
#
request = rQ.Request().setServiceId("Test.Command.if").put("name", "hello")
r = request.run()
self.assertTrue(len(r) > 0)
m = r.toList()
self.assertEqual("true", m[0]["value"])
request.put("name", "blabla")
r = request.run()
self.assertTrue(len(r) > 0)
self.assertEqual("false", r.toList()[0]["value"]);
def test_set_array_parameters(self):
request = rQ.Request()
request.setServiceId('Test.Command.arrayParameter')
request.run()
self.assertEqual('New York,Paris,London,Peking', request.get('names'))
self.assertEqual('New York,Paris,London,Peking',
request.get('namesCopy'))
self.assertEqual('', request.get('namesCopy2'))
def test_array_parameters(self):
request = rQ.Request()
request.setServiceId('Address.selectWithNamesArray')
request.addRole('ADDRESS_READER')
request.put('names', 'Anna,Ralf,Sara')
result = request.run()
_list = result.toList()
self.assertEqual(3, len(_list))
def test_command_example(self):
serviceId = "Test.Command.example"
se = rQ.ServiceRepositoryHolder.get(serviceId)
self.assertIsNotNone(se)
request = rQ.Request().addRole("APP_ADMIN")
request.setServiceId(serviceId)
r = request.run()
self.assertEqual("world", r.table[0][0])
def test_command_backslash(self):
serviceId = "Test.Command.backslash"
se = rQ.ServiceRepositoryHolder.get(serviceId)
self.assertIsNotNone(se)
request = rQ.Request()
request.setServiceId(serviceId)
request.run()
self.assertEqual("ok", request.get("semicolon"))
def test_set2(self):
serviceId = "Test.Command.copy"
se = rQ.ServiceRepositoryHolder.get(serviceId)
self.assertIsNotNone(se)
request = rQ.Request().setServiceId(serviceId)
request.run()
self.assertEqual("hello", request.get("name"))
self.assertEqual("hello", request.get("name1"))
self.assertEqual("hello2", request.get("name2"))
def test_insert_html_text(self):
texttext = "<html>hallo</html>"
serviceId = "HtmlText.save"
se = rQ.ServiceRepositoryHolder.get(serviceId)
self.assertIsNotNone(se)
r = rQ.Request().setServiceId(serviceId).put(
"htmlTextId", "test_01").put("htmlText",
texttext).addRole("APP_USER").run()
self.assertEqual(1, r.rowsAffected)
def test_address_filter(self):
TestCentral.init()
request = rQ.Request(serviceId="Address.search",
roles=set(["ADDRESS_READER"]),
parameters={"nameFilter": "Jo%"})
result = request.run()
# convert to a POJO
_list = result.toList()
self.assertEqual(2, len(_list))
def test_command_if_empty(self):
#
# COMMAND NODE
#
se = rQ.ServiceRepositoryHolder.get("Test.Command.if-empty")
self.assertIsNotNone(se)
#
# REQUEST RUN
#
request = rQ.Request().setServiceId("Test.Command.if-empty").put("name", "does not exist")
request.run()
self.assertEqual("true", request.get('emptyVisited'));
self.assertEqual("false", request.get('else'));
def test_command_if_else_only(self):
serviceId = "Test.Command.if_elseOnly"
#
# COMMAND NODE
#
se = rQ.ServiceRepositoryHolder.get(serviceId)
self.assertIsNotNone(se)
cb = rQ.prepareCommandBlock(se)
cbExpected = StatementNode("serviceRoot").append(
#
StatementNode("put"),
StatementNode("if").append(
#
StatementNode("else"),
#
StatementNode("put"),
#
StatementNode("end")
#
))
rQ.assertStatementNodeEquals(cbExpected, cb)
#
# REQUEST RUN
#
request = rQ.Request().setServiceId(serviceId)
request.run()
self.assertEqual("true", request.get("elseValue"))
request.put("condition1", "hello")
request.run()
self.assertEqual("not reached else", request.get("elseValue"))
def test_command_while(self):
serviceId = "Test.Command.while"
#
# COMMAND NODE
#
se = rQ.ServiceRepositoryHolder.get(serviceId)
self.assertIsNotNone(se)
cb = rQ.prepareCommandBlock(se)
cbExpected = StatementNode("serviceRoot").append(
#
StatementNode("sql"),
#
StatementNode("sql"),
#
StatementNode("sql"),
#
StatementNode("set"),
#
StatementNode("while").append(
#
StatementNode("sql"),
#
StatementNode("parameters"),
#
StatementNode("end")),
#
StatementNode("sql"));
rQ.assertStatementNodeEquals(cbExpected, cb)
#
# REQUEST RUN
#
request = rQ.Request().setServiceId(serviceId)
r = request.run()
self.assertTrue(len(r) == 0)
def test_command_foreach(self):
serviceId = "Test.Command.foreach"
#
# COMMAND NODE
#
se = rQ.ServiceRepositoryHolder.get(serviceId)
self.assertIsNotNone(se)
cb = rQ.prepareCommandBlock(se)
cbExpected = StatementNode("serviceRoot").append(
#
StatementNode("parameters"),
#
StatementNode("foreach").append(
#
StatementNode("sql"),
#
StatementNode("end")),
#
StatementNode("sql"),
#
StatementNode("parameters"));
rQ.assertStatementNodeEquals(cbExpected, cb)
#
# REQUEST RUN
#
request = rQ.Request().setServiceId(serviceId)
request.run()
total1 = request.get("total1")
total2 = request.get("total2")
self.assertIsNotNone(total1)
self.assertIsNotNone(total2)
def test_python(self):
result = rQ.Request(serviceId="UUID.create",
roles=set(["SYSTEM"])).run()
self.assertEqual("1234", result.table[0][0])
