@Test public void testSQLStatementsWithFileResource() { String sql1 = "select ORDERTYPE, STATUS from orders where ID=5;"; String sql2 = "select NAME, HEIGHT\nfrom customers\nwhere ID=1;"; reset(jdbcTemplate); Map<String, Object> resultMap1 = new HashMap<String, Object>(); resultMap1.put("ORDERTYPE", "small"); resultMap1.put("STATUS", "in_progress"); expect(jdbcTemplate.queryForList(sql1)).andReturn(Collections.singletonList(resultMap1)); Map<String, Object> resultMap2 = new HashMap<String, Object>(); resultMap2.put("NAME", "Mickey Mouse"); resultMap2.put("HEIGHT", "0,3"); expect(jdbcTemplate.queryForList(sql2)).andReturn(Collections.singletonList(resultMap2)); replay(jdbcTemplate); executeSQLQueryAction.setSqlResource( new ClassPathResource("test-sql-query-statements.sql", ExecuteSQLQueryActionTest.class)); executeSQLQueryAction.execute(context); Assert.assertNotNull(context.getVariable("${ORDERTYPE}")); Assert.assertEquals(context.getVariable("${ORDERTYPE}"), "small"); Assert.assertNotNull(context.getVariable("${STATUS}")); Assert.assertEquals(context.getVariable("${STATUS}"), "in_progress"); Assert.assertNotNull(context.getVariable("${NAME}")); Assert.assertEquals(context.getVariable("${NAME}"), "Mickey Mouse"); Assert.assertNotNull(context.getVariable("${HEIGHT}")); Assert.assertEquals(context.getVariable("${HEIGHT}"), "0,3"); }
@Test public void testSQLResource() { Resource sqlResource = new ClassPathResource("test-query.sql", ExecuteSQLQueryActionTest.class); String sql1 = "SELECT ORDERTYPE, STATUS FROM orders WHERE ID=5;"; String sql2 = "SELECT NAME, HEIGHT FROM customers WHERE ID=1;"; reset(jdbcTemplate); Map<String, Object> resultMap1 = new HashMap<String, Object>(); resultMap1.put("ORDERTYPE", "small"); resultMap1.put("STATUS", "in_progress"); expect(jdbcTemplate.queryForList(sql1)).andReturn(Collections.singletonList(resultMap1)); Map<String, Object> resultMap2 = new HashMap<String, Object>(); resultMap2.put("NAME", "Mickey Mouse"); resultMap2.put("HEIGHT", "0,3"); expect(jdbcTemplate.queryForList(sql2)).andReturn(Collections.singletonList(resultMap2)); replay(jdbcTemplate); executeSQLQueryAction.setSqlResource(sqlResource); executeSQLQueryAction.execute(context); Assert.assertNotNull(context.getVariable("${ORDERTYPE}")); Assert.assertEquals(context.getVariable("${ORDERTYPE}"), "small"); Assert.assertNotNull(context.getVariable("${STATUS}")); Assert.assertEquals(context.getVariable("${STATUS}"), "in_progress"); Assert.assertNotNull(context.getVariable("${NAME}")); Assert.assertEquals(context.getVariable("${NAME}"), "Mickey Mouse"); Assert.assertNotNull(context.getVariable("${HEIGHT}")); Assert.assertEquals(context.getVariable("${HEIGHT}"), "0,3"); }