Package cn.org.rapid_framework.generator.provider.db.sql.model

Examples of cn.org.rapid_framework.generator.provider.db.sql.model.Sql

28
29
30
31
32
33
34
35
36
      assertTrue(newSql("UPDATE user_info SET username = #username#,password = #password# WHERE username = #username#").isUpdateSql());
      assertTrue(newSql("update user_info set username = #username#,password = #password#").isUpdateSql());
  }
 
  public void test_setSqlMap_and_replase_cdata() {
      Sql s = new Sql();
      s.setSqlmap("${cdata-start} 123 ${cdata-end}");
      assertEquals(s.getSqlmap(),"<![CDATA[ 123 ]]>");
  }
View Full Code Here
46
47
48
49
50
51
52
53
54
//    sql.setTableSqlName("diy_user");
//    assertEquals("DiyUser",sql.getTableClassName());
//  }

  private Sql newSql(String string) {
    Sql sql = new Sql();
    sql.setSourceSql(string);
    return sql;
  }
View Full Code Here
13
14
15
16
17
18
19
20
21
import cn.org.rapid_framework.generator.util.StringHelper;

public class Helper {
 
  public static Map getMapBySql(TableConfig t, String operation) {
    Sql sql = getSql(t,operation);
      Map map = newMapFromSql(sql,t);
    return map;
  }
View Full Code Here
48
49
50
51
52
53
54
55
56
57
    public void testListner() throws SQLException, Exception {
//      sql = newSql(newOperation("queryUserInfo","select * from user_info"),null);
//   
//    assertEquals(sql.getResultClass(),"UserInfo");
   
      Sql sql = newSql(newOperation("queryUserInfo","select * from user_info"),"CustomUserInfo");
   
    assertEquals(sql.getResultClass(),"CustomUserInfo");
   
    }
View Full Code Here
71
72
73
74
75
76
77
78
      tc.setClassName(customClassName);
    tc.setOperations(Arrays.asList(operation));
    set.addTableConfig(tc);
   
    List<Sql> sqls = tc.getSqls();
    Sql sql = sqls.get(0);
    return sql;
  }
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
  }
 
  public void test_union() throws SQLException, Exception {
    String query = "select * from user_info where user_id = ? and age = ? and password = ? and username like ? or (sex >= ?) ";
    String orderByQuery = "select * from user_info where user_id = ? and age = ? and password = ? and username like ? or (sex >= ?) order by :orderby ";
    Sql sql = parser.parseSql(query+" union " + query);
    verifyParameters(sql,"userId","username","password","age","sex");
   
    sql = parser.parseSql(orderByQuery+" union " + orderByQuery);
    verifyParameters(sql,"userId","username","password","age","sex");
  }
View Full Code Here
33
34
35
36
37
38
39
40
    sql = parser.parseSql(orderByQuery+" union " + orderByQuery);
    verifyParameters(sql,"userId","username","password","age","sex");
  }
 
  public void test_order_by() throws SQLException, Exception {
    Sql sql = parser.parseSql("select * from user_info where user_id = ? and age = ? and password = ? and username like ? or (sex >= ?) order by :orderby :asc_desc");
    verifyParameters(sql,"userId","username","password","age","sex");
  }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
    Sql sql = parser.parseSql("select * from user_info where user_id = ? and age = ? and password = ? and username like ? or (sex >= ?) order by :orderby :asc_desc");
    verifyParameters(sql,"userId","username","password","age","sex");
  }
  public void test_unscaped_xml() throws SQLException, Exception {
    try {
      Sql sql = parser.parseSql("select * from user_info where user_id &lt; :user_id");
      fail();
    }catch(RuntimeException e) {
    }
  }
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
    }catch(RuntimeException e) {
    }
  }

  public void test_ListParam() throws SQLException, Exception {
    Sql sql = parser.parseSql("select * from user_info where user_id = #nameList[]# and password = #{pwdList[index]} and age = ${ageList[${index}]} ");
    verifyParameters(sql,"nameList","pwdList","ageList");
    assertTrue(sql.getParam("nameList").isListParam());
    assertTrue(sql.getParam("pwdList").isListParam());
    assertTrue(sql.getParam("ageList").isListParam());
  }
View Full Code Here
53
54
55
56
57
58
59
60
61
    assertTrue(sql.getParam("pwdList").isListParam());
    assertTrue(sql.getParam("ageList").isListParam());
  }
 
  public void test_select() throws SQLException, Exception {
    Sql sql = parser.parseSql("select * from user_info where user_id = ? and age = ? and password = ? and username like ? or (sex >= ?)");
    verifyParameters(sql,"userId","username","password","age","sex");
    verifyColumns(sql,"user_id","username","password","BIRTH_DATE","age","sex");
  }
View Full Code Here
TOP

Related Classes of cn.org.rapid_framework.generator.provider.db.sql.model.Sql

  • cn.org.rapid_framework.generator.demo.GenerateBySqlDemoTest
  • cn.org.rapid_framework.generator.ext.tableconfig.IbatisSqlMapConfigParserTest
  • cn.org.rapid_framework.generator.ext.tableconfig.model.Helper
  • cn.org.rapid_framework.generator.ext.tableconfig.model.TableConfig$Convert2SqlsProecssor
  • cn.org.rapid_framework.generator.ext.tableconfig.model.TableConfigSetTest
  • cn.org.rapid_framework.generator.provider.db.sql.SqlFactory
  • cn.org.rapid_framework.generator.provider.db.sql.SqlFactoryTest
  • cn.org.rapid_framework.generator.provider.db.SqlQueryFactoryTest
  • cn.org.rapid_framework.generator.provider.db.table.model.Column
  • cn.org.rapid_framework.generator.provider.db.table.model.ColumnSet
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.