Java Code Examples for org.apache.ibatis.scripting.xmltags.DynamicSqlSource#getBoundSql()
The following examples show how to use
org.apache.ibatis.scripting.xmltags.DynamicSqlSource#getBoundSql() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: DynamicSqlSourceTest.java From mybatis with Apache License 2.0 | 6 votes |
@Test public void shouldPerformStrictMatchOnForEachVariableSubstitution() throws Exception { final Map<String, Object> param = new HashMap<String, Object>(); final Map<String, String> uuu = new HashMap<String, String>(); uuu.put("u", "xyz"); List<Bean> uuuu = new ArrayList<Bean>(); uuuu.add(new Bean("bean id")); param.put("uuu", uuu); param.put("uuuu", uuuu); DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("INSERT INTO BLOG (ID, NAME, NOTE, COMMENT) VALUES"), new ForEachSqlNode(new Configuration(),mixedContents( new TextSqlNode("#{uuu.u}, #{u.id}, #{ u,typeHandler=org.apache.ibatis.type.StringTypeHandler}," + " #{u:VARCHAR,typeHandler=org.apache.ibatis.type.StringTypeHandler}")), "uuuu", "uu", "u", "(", ")", ",")); BoundSql boundSql = source.getBoundSql(param); assertEquals(4, boundSql.getParameterMappings().size()); assertEquals("uuu.u", boundSql.getParameterMappings().get(0).getProperty()); assertEquals("__frch_u_0.id", boundSql.getParameterMappings().get(1).getProperty()); assertEquals("__frch_u_0", boundSql.getParameterMappings().get(2).getProperty()); assertEquals("__frch_u_0", boundSql.getParameterMappings().get(3).getProperty()); }
Example 2
Source File: DynamicSqlSourceTest.java From mybatis with Apache License 2.0 | 6 votes |
@Test public void shouldIterateOnceForEachItemInCollection() throws Exception { final HashMap<String, String[]> parameterObject = new HashMap<String, String[]>() {{ put("array", new String[]{"one", "two", "three"}); }}; final String expected = "SELECT * FROM BLOG WHERE ID in ( one = ? AND two = ? AND three = ? )"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG WHERE ID in"), new ForEachSqlNode(new Configuration(),mixedContents(new TextSqlNode("${item} = #{item}")), "array", "index", "item", "(", ")", "AND")); BoundSql boundSql = source.getBoundSql(parameterObject); assertEquals(expected, boundSql.getSql()); assertEquals(3, boundSql.getParameterMappings().size()); assertEquals("__frch_item_0", boundSql.getParameterMappings().get(0).getProperty()); assertEquals("__frch_item_1", boundSql.getParameterMappings().get(1).getProperty()); assertEquals("__frch_item_2", boundSql.getParameterMappings().get(2).getProperty()); }
Example 3
Source File: DynamicSqlSourceTest.java From mybaties with Apache License 2.0 | 5 votes |
@Test public void shouldTrimWHEREANDWithTABForFirstCondition() throws Exception { final String expected = "SELECT * FROM BLOG WHERE \t ID = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new WhereSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" and\t ID = ? ")), "true" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 4
Source File: DynamicSqlSourceTest.java From mybatis with Apache License 2.0 | 5 votes |
@Test public void shouldTrimWHEREORWithCRLFForFirstCondition() throws Exception { final String expected = "SELECT * FROM BLOG WHERE \r\n ID = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new WhereSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" or\r\n ID = ? ")), "true" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 5
Source File: DynamicSqlSourceTest.java From mybatis with Apache License 2.0 | 5 votes |
@Test public void shouldConditionallyChooseFirst() throws Exception { final String expected = "SELECT * FROM BLOG WHERE CATEGORY = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new ChooseSqlNode(new ArrayList<SqlNode>() {{ add(new IfSqlNode(mixedContents(new TextSqlNode("WHERE CATEGORY = ?")), "true" )); add(new IfSqlNode(mixedContents(new TextSqlNode("WHERE CATEGORY = 'NONE'")), "false" )); }}, mixedContents(new TextSqlNode("WHERE CATEGORY = 'DEFAULT'")))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 6
Source File: DynamicSqlSourceTest.java From mybaties with Apache License 2.0 | 5 votes |
@Test public void shouldTrimSETInsteadOfCOMMAForBothConditions() throws Exception { final String expected = "UPDATE BLOG SET ID = ?, NAME = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("UPDATE BLOG"), new SetSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" ID = ?, ")), "true" ), new IfSqlNode(mixedContents(new TextSqlNode(" NAME = ?, ")), "true" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 7
Source File: DynamicSqlSourceTest.java From mybaties with Apache License 2.0 | 5 votes |
@Test public void shouldTrimNoWhereClause() throws Exception { final String expected = "SELECT * FROM BLOG"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new WhereSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" and ID = ? ")), "false" ), new IfSqlNode(mixedContents(new TextSqlNode("OR NAME = ? ")), "false" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 8
Source File: DynamicSqlSourceTest.java From mybaties with Apache License 2.0 | 5 votes |
@Test public void shouldTrimWHEREInsteadOfANDForBothConditions() throws Exception { final String expected = "SELECT * FROM BLOG WHERE ID = ? OR NAME = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new WhereSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" and ID = ? ")), "true" ), new IfSqlNode(mixedContents(new TextSqlNode("OR NAME = ? ")), "true" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 9
Source File: DynamicSqlSourceTest.java From mybatis with Apache License 2.0 | 5 votes |
@Test public void shouldConditionallyExcludeWhere() throws Exception { final String expected = "SELECT * FROM BLOG"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new IfSqlNode(mixedContents(new TextSqlNode("WHERE ID = ?")), "false" )); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 10
Source File: DynamicSqlSourceTest.java From mybaties with Apache License 2.0 | 5 votes |
@Test public void shouldTrimWHEREORWithTABForFirstCondition() throws Exception { final String expected = "SELECT * FROM BLOG WHERE \t ID = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new WhereSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" or\t ID = ? ")), "true" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 11
Source File: DynamicSqlSourceTest.java From mybatis with Apache License 2.0 | 5 votes |
@Test public void shouldTrimNoSetClause() throws Exception { final String expected = "UPDATE BLOG"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("UPDATE BLOG"), new SetSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" , ID = ? ")), "false" ), new IfSqlNode(mixedContents(new TextSqlNode(", NAME = ? ")), "false" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 12
Source File: DynamicSqlSourceTest.java From mybaties with Apache License 2.0 | 5 votes |
@Test public void shouldTrimWHEREORWithLFForFirstCondition() throws Exception { final String expected = "SELECT * FROM BLOG WHERE \n ID = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new WhereSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" or\n ID = ? ")), "true" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 13
Source File: DynamicSqlSourceTest.java From mybatis with Apache License 2.0 | 5 votes |
@Test public void shouldTrimWHEREANDWithTABForFirstCondition() throws Exception { final String expected = "SELECT * FROM BLOG WHERE \t ID = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new WhereSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" and\t ID = ? ")), "true" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 14
Source File: DynamicSqlSourceTest.java From mybaties with Apache License 2.0 | 5 votes |
@Test public void shouldTrimWHEREANDWithCRLFForFirstCondition() throws Exception { final String expected = "SELECT * FROM BLOG WHERE \r\n ID = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new WhereSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" and\r\n ID = ? ")), "true" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 15
Source File: DynamicSqlSourceTest.java From mybaties with Apache License 2.0 | 5 votes |
@Test public void shouldTrimWHEREANDWithLFForFirstCondition() throws Exception { final String expected = "SELECT * FROM BLOG WHERE \n ID = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new WhereSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" and\n ID = ? ")), "true" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 16
Source File: DynamicSqlSourceTest.java From mybaties with Apache License 2.0 | 5 votes |
@Test public void shouldTrimWHEREInsteadOfANDForFirstCondition() throws Exception { final String expected = "SELECT * FROM BLOG WHERE ID = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new WhereSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" and ID = ? ")), "true" ), new IfSqlNode(mixedContents(new TextSqlNode(" or NAME = ? ")), "false" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 17
Source File: DynamicSqlSourceTest.java From mybaties with Apache License 2.0 | 5 votes |
@Test public void shouldConditionallyChooseFirst() throws Exception { final String expected = "SELECT * FROM BLOG WHERE CATEGORY = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new ChooseSqlNode(new ArrayList<SqlNode>() {{ add(new IfSqlNode(mixedContents(new TextSqlNode("WHERE CATEGORY = ?")), "true" )); add(new IfSqlNode(mixedContents(new TextSqlNode("WHERE CATEGORY = 'NONE'")), "false" )); }}, mixedContents(new TextSqlNode("WHERE CATEGORY = 'DEFAULT'")))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 18
Source File: DynamicSqlSourceTest.java From mybatis with Apache License 2.0 | 5 votes |
@Test public void shouldConditionallyChooseSecond() throws Exception { final String expected = "SELECT * FROM BLOG WHERE CATEGORY = 'NONE'"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new ChooseSqlNode(new ArrayList<SqlNode>() {{ add(new IfSqlNode(mixedContents(new TextSqlNode("WHERE CATEGORY = ?")), "false" )); add(new IfSqlNode(mixedContents(new TextSqlNode("WHERE CATEGORY = 'NONE'")), "true" )); }}, mixedContents(new TextSqlNode("WHERE CATEGORY = 'DEFAULT'")))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 19
Source File: DynamicSqlSourceTest.java From mybatis with Apache License 2.0 | 5 votes |
@Test public void shouldTrimWHEREInsteadOfORForSecondCondition() throws Exception { final String expected = "SELECT * FROM BLOG WHERE NAME = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new WhereSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" and ID = ? ")), "false" ), new IfSqlNode(mixedContents(new TextSqlNode(" or NAME = ? ")), "true" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }
Example 20
Source File: DynamicSqlSourceTest.java From mybatis with Apache License 2.0 | 5 votes |
@Test public void shouldTrimWHEREORWithLFForFirstCondition() throws Exception { final String expected = "SELECT * FROM BLOG WHERE \n ID = ?"; DynamicSqlSource source = createDynamicSqlSource( new TextSqlNode("SELECT * FROM BLOG"), new WhereSqlNode(new Configuration(),mixedContents( new IfSqlNode(mixedContents(new TextSqlNode(" or\n ID = ? ")), "true" ) ))); BoundSql boundSql = source.getBoundSql(null); assertEquals(expected, boundSql.getSql()); }