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

Examples of cn.org.rapid_framework.generator.provider.db.sql.SqlFactory$SelectColumnsParser

25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
    sql.setSourceSql("delete from user_info");
    assertEquals("FindPageParameter",sql.getParameterClassName());
  }
 
  public void test_getOperationResultClass() throws SQLException {
    Sql sql = new SqlFactory().parseSql("select username from user_info");
    assertEquals("String",sql.getResultClass());
   
    sql = new SqlFactory().parseSql("select username,password from user_info");
    assertEquals("UserInfo",sql.getResultClass());
   
    sql = new SqlFactory().parseSql("select username as user,password as pwd from user_info");
    sql.setOperation("findUsername");
    assertEquals("FindUsernameResult",sql.getResultClass());
   
    sql = new SqlFactory().parseSql("select username as user,count(password) as pwd from user_info group by username");
    sql.setOperation("findUsername");
    assertEquals("FindUsernameResult",sql.getResultClass());
   
    sql = new SqlFactory().parseSql("select count(username) cnt_username,count(password) cnt_pwd from user_info");
    sql.setOperation("op1");
    assertEquals("Op1Result",sql.getResultClass());
   
    sql.setResultClass("test_by_set_result");
    assertEquals("test_by_set_result",sql.getResultClass());
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
    sql.setResultClass("test_by_set_result");
    assertEquals("test_by_set_result",sql.getResultClass());
  }
 
  public void test_getOperationParameterClass() {
    sql = new SqlFactory().parseSql("select count(username) cnt_username,count(password) cnt_pwd from user_info");
    sql.setOperation("findPage");
    assertEquals("FindPageQuery",sql.getParameterClass());
   
    sql = new SqlFactory().parseSql("insert into user_info(user_id,username) values (:userId,:username)");
    sql.setOperation("insertUsername");
    assertEquals("InsertUsernameParameter",sql.getParameterClass());
   
    sql.setParameterClass("set_by_user");
    assertEquals("set_by_user",sql.getParameterClass());
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
//   
//    assertEquals("T1AbcBlog123",sql.getTableClassName());
//  }
 
  public void test_isColumnsInSameTable() {
    sql = new SqlFactory().parseSql("select username from user_info");
    assertTrue(sql.isColumnsInSameTable());
   
    sql = new SqlFactory().parseSql("select username,password from user_info");
    assertTrue(sql.isColumnsInSameTable());
   
    //FIXME 应该为true,是同一张表
    sql = new SqlFactory().parseSql("select username user,password pwd from user_info");
    assertFalse(sql.isColumnsInSameTable());
   
    sql = new SqlFactory().parseSql("select count(username) cnt_username,count(password) cnt_pwd from user_info");
    assertFalse(sql.isColumnsInSameTable());
   
    sql = new SqlFactory().parseSql("insert into user_info(username,user_id) values (:username,?)");
    assertFalse(sql.isColumnsInSameTable());
  }
View Full Code Here
93
94
95
96
97
98
99
100
    sql = new SqlFactory().parseSql("insert into user_info(username,user_id) values (:username,?)");
    assertFalse(sql.isColumnsInSameTable());
  }
 
  public void test_get_result_class() {
    Sql sql = new SqlFactory().parseSql("select * from user_info /* inner join from blogjava */ ");
    assertEquals("UserInfo",sql.getResultClass());
  }
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
    assertEquals("UserInfo",sql.getResultClass());
  }
 
  /** 测试聚集函数colum名称自动转换,示例转换 count(*) => count, max(age) => max_age, sum(income) => sum_income */
  public void test_intergate_function_name_convert() {
      sql = new SqlFactory().parseSql("select count(*) cnt, count(username) count_username,max(password) max_password,min(password) min_password,avg(sex) avg_sex from user_info");
        String msg = sql.getColumns().toString();
    assertNotNull(msg,sql.getColumnByName("Cnt"));
        assertNotNull(msg,sql.getColumnByName("count_username"));
        assertNotNull(msg,sql.getColumnByName("max_password"));
        assertNotNull(msg,sql.getColumnByName("min_password"));
        assertNotNull(msg,sql.getColumnByName("avg_sex"));
       
        //FIXME 试聚集函数colum名称自动转换,示例转换 count(*) => count, max(age) => max_age, sum(income) => sum_income
        sql = new SqlFactory().parseSql("select count(*) cnt, count(username),max(password),min(password),avg(sex) from user_info");
        msg = sql.getColumns().toString();
    assertNotNull(msg,sql.getColumnByName("Cnt"));
//        assertNotNull(msg,sql.getColumnByName("C2"));
//        assertNotNull(msg,sql.getColumnByName("C3"));
//        assertNotNull(msg,sql.getColumnByName("C4"));
View Full Code Here
196
197
198
199
200
201
202
203
204
205
206
        assertEquals(segment.getParamNames().get(0),"username");
        assertEquals(segment.getParamNames().get(1),"password");
        assertEquals(segment.getParamNames().get(2),"age");
        assertEquals(segment.getClassName(),"UserInfoWhere");
       
        Sql sql = new SqlFactory().parseSql(parser.resultSql);
        assertEquals(get(segment.getParams(sql),0).getParamName(),"username");
        assertEquals(get(segment.getParams(sql),1).getParamName(),"password");
        assertEquals(get(segment.getParams(sql),2).getParamName(),"age");
       
        assertEquals(get(segment.getParams(sql),0).getParameterClass(),"String");
View Full Code Here
214
215
216
217
218
219
220
221
222
223
224
      parser.parse("select * from user_info where <include refid='user-Info.where'/>",hashMap);
     
      GeneratorFacade gf = new GeneratorFacade();
      gf.getGenerator().setTemplateRootDir("classpath:for_test_sql_segment");
      for(SqlSegment segment : parser.usedIncludedSqls.values()) {
        segment.setParams(segment.getParams(new SqlFactory().parseSql(parser.resultSql)));
        Map map = new HashMap();
        map.put("sqlSegment", segment);
        map.putAll(BeanHelper.describe(segment));
        System.out.println(map);
        String str = GeneratorTestHelper.generateByMap(gf, map);
View Full Code Here
238
239
240
241
242
243
244
245
246
247
248
        assertEquals(segment.getParamNames().get(0),"username");
        assertEquals(segment.getParamNames().get(1),"password");
//        assertEquals(segment.getParamNames().get(2),"age"); // TODO 现在不支持 age = ?
        assertEquals(segment.getClassName(),"UserInfoWhere");
       
        Sql sql = new SqlFactory().parseSql(parser.resultSql);
        assertEquals(get(segment.getParams(sql),0).getParamName(),"username");
        assertEquals(get(segment.getParams(sql),1).getParamName(),"password");
//        assertEquals(get(segment.getParams(sql),2).getParamName(),"age");
       
        assertEquals(get(segment.getParams(sql),0).getParameterClass(),"String");
View Full Code Here
19
20
21
22
23
24
25
26
27
    g.setTemplateRootDir(FileHelper.getFileByClassLoader("for_test_select_sql"));
    g.setOutRootDir("./target/temp/sql");
  }

  public void test_select_with_between() throws Exception {
    Sql selectSql  = new SqlFactory().parseSql("select * from user_info where birth_date between #minBirthDate# and #maxBirthDate# and username = :specialUsername and sex <= :specialSex and age >= ${specialAge} and password <> #{password}");
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
View Full Code Here
25
26
27
28
29
30
31
32
33
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
 
  public void test_select_with_no_parameers() throws Exception {
    Sql selectSql  = new SqlFactory().parseSql("select * from user_info");
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
View Full Code Here
TOP

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

  • cn.org.rapid_framework.generator.demo.GenerateBySqlDemoTest
  • cn.org.rapid_framework.generator.ext.tableconfig.IbatisSqlMapConfigParserTest
  • cn.org.rapid_framework.generator.ext.tableconfig.model.TableConfig$Convert2SqlsProecssor
  • cn.org.rapid_framework.generator.provider.db.sql.model.Sql
  • cn.org.rapid_framework.generator.provider.db.sql.model.SqlParameter
  • cn.org.rapid_framework.generator.provider.db.sql.model.SqlTest
  • 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.Table
  • cn.org.rapid_framework.generator.util.sqlerrorcode.SQLErrorCodeSQLExceptionTranslator
    • 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.