Examples of cn.org.rapid_framework.generator.provider.db.sql.SqlFactory.SqlParametersParser

public class SqlFactoryTest extends GeneratorTestCase {
  SqlFactory parser = new SqlFactory();


  public void test_isMatchListParam() {
      String sql = "length(#username#) and in \n (#pwd#) and not \n in \n (#user#) and blog = #blog[]# and sex = #sex[].value#";
        assertFalse(new SqlParametersParser().isMatchListParam(sql, "username"));
        assertFalse(new SqlParametersParser().isMatchListParam(sql, "notexist"));
        assertFalse(new SqlParametersParser().isMatchListParam(sql, "in"));
        assertFalse(new SqlParametersParser().isMatchListParam(sql, "not in"));
        assertTrue(new SqlParametersParser().isMatchListParam(sql, "pwd"));
        assertTrue(new SqlParametersParser().isMatchListParam(sql, "user"));
        assertTrue(new SqlParametersParser().isMatchListParam(sql, "blog"));
        assertTrue(new SqlParametersParser().isMatchListParam(sql, "sex"));
  }

      assertTrue(true);
    }
  }
  
  public void test_isMatchListParam() {
    SqlParametersParser sqlParametersParser = new SqlFactory.SqlParametersParser();
        assertFalse(sqlParametersParser.isMatchListParam("  \n (:username) ", "username"));
        assertFalse(sqlParametersParser.isMatchListParam("  (&username) ", "username"));
        assertFalse(sqlParametersParser.isMatchListParam("  (#username#) ", "username"));
        assertFalse(sqlParametersParser.isMatchListParam("  (#{username}) ", "username"));
        assertFalse(sqlParametersParser.isMatchListParam("  ($username$) ", "username"));
        assertFalse(sqlParametersParser.isMatchListParam("  (${username}) ", "username"));
        
        assertTrue(sqlParametersParser.isMatchListParam("  ${username[index]} ", "username"));
        assertTrue(sqlParametersParser.isMatchListParam("  #{username[index]} ", "username"));
        assertTrue(sqlParametersParser.isMatchListParam("  #{username[a124]} ", "username"));
        assertTrue(sqlParametersParser.isMatchListParam("  ${username[${index}]} ", "username"));
        assertTrue(sqlParametersParser.isMatchListParam("  #{username[${index}]} ", "username"));
        assertTrue(sqlParametersParser.isMatchListParam("  #{username[${a124}]} ", "username"));
        
        assertTrue(sqlParametersParser.isMatchListParam(" in \n (:username) ", "username"));
        assertTrue(sqlParametersParser.isMatchListParam(" not in (&username) ", "username"));
        assertTrue(sqlParametersParser.isMatchListParam(" not in (#username#) ", "username"));
        assertTrue(sqlParametersParser.isMatchListParam(" in \n (#{username}) ", "username"));
        assertTrue(sqlParametersParser.isMatchListParam("  not \n in ($username$) ", "username"));
        assertTrue(sqlParametersParser.isMatchListParam(" not \n in \n (${username}) ", "username"));
        
    assertTrue(sqlParametersParser.isMatchListParam("  #username[]# ", "username"));
    assertTrue(sqlParametersParser.isMatchListParam("  $username[]$ ", "username"));
    assertTrue(sqlParametersParser.isMatchListParam("  #user[].age# ", "user"));
    
    assertFalse(sqlParametersParser.isMatchListParam("  $username[] $ ", "username"));
    assertFalse(sqlParametersParser.isMatchListParam("  #user[].age # ", "user"));
  }

Examples of cn.org.rapid_framework.generator.provider.db.sql.SqlFactory.SqlParametersParser

Related Classes of cn.org.rapid_framework.generator.provider.db.sql.SqlFactory.SqlParametersParser