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

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

126
127
128
129
130
131
132
133
134
135
//    assertStringEquals(expected,sql.getSql());
    //FIXME select t1.* t2.* 应该返回不同的表前缀
  }
 
  public void test_escaped() throws SQLException, Exception {
    Sql sql = parser.parseSql("select * from user_info where user_id > ? and username < :username");
    verifyParameters(sql,"userId","username");
    assertStringEquals("select USER_ID,USERNAME,PASSWORD,BIRTH_DATE,SEX,AGE from user_info where user_id > #userId# and username < :username",sql.getIbatisSql());
    assertStringEquals("select USER_ID,USERNAME,PASSWORD,BIRTH_DATE,SEX,AGE from user_info where user_id > #{userId} and username < :username",sql.getMybatisSql());
  }
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
    assertStringEquals("select USER_ID,USERNAME,PASSWORD,BIRTH_DATE,SEX,AGE from user_info where user_id > #userId# and username < :username",sql.getIbatisSql());
    assertStringEquals("select USER_ID,USERNAME,PASSWORD,BIRTH_DATE,SEX,AGE from user_info where user_id > #{userId} and username < :username",sql.getMybatisSql());
  }

  public void test_sql_function() throws SQLException, Exception {
    Sql sql = parser.parseSql("select * from user_info where username = lower(#userId#) and username != :username");
    verifyParameters(sql,"userId","username");
   
    sql = parser.parseSql("select * from user_info where username = lower(?) and username != :username");
    verifyNoParameters(sql,"userId");
    verifyParameters(sql,"username");
View Full Code Here
142
143
144
145
146
147
148
149
    verifyNoParameters(sql,"userId");
    verifyParameters(sql,"username");
  }
 
  public void test_insert() throws SQLException, Exception {
    Sql sql = parser.parseSql("insert into user_info(user_id,username,password) values (?,?,?)");
    verifyParameters(sql,"userId","username","password");
  }
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
    verifyParameters(sql,"userId","username","password");
  }
 
  public void test_insert_with_userId_not_null() throws SQLException, Exception {
    try {
    Sql sql = parser.parseSql("insert into user_info(username,password) values (?,?)");
    fail("user_id must be not null");
    }catch(Exception e) {
      assertTrue(true);
    }
  }
View Full Code Here
156
157
158
159
160
161
162
163
164
165
166
167
      assertTrue(true);
    }
  }
 
  public void test_delete() throws SQLException, Exception {
    Sql sql = parser.parseSql("delete from user_info where username = ? and password = ? and age = ? or (sex >= ?)");
    verifyParameters(sql,"username","password","age","sex");
    assertEquals("delete from user_info where username = #username# and password = #password# and age = #age# or (sex >= #sex#)",sql.getIbatisSql());
    assertEquals("delete from user_info where username = #{username} and password = #{password} and age = #{age} or (sex >= #{sex})",sql.getMybatisSql());
    assertEquals("delete from user_info where username = :username and password = :password and age = :age or (sex >= :sex)",sql.getSpringJdbcSql());
    assertEquals("delete from user_info where username = :username and password = :password and age = :age or (sex >= :sex)",sql.getHql());
  }
View Full Code Here
164
165
166
167
168
169
170
171
172
    assertEquals("delete from user_info where username = #{username} and password = #{password} and age = #{age} or (sex >= #{sex})",sql.getMybatisSql());
    assertEquals("delete from user_info where username = :username and password = :password and age = :age or (sex >= :sex)",sql.getSpringJdbcSql());
    assertEquals("delete from user_info where username = :username and password = :password and age = :age or (sex >= :sex)",sql.getHql());
  }
  public void test_update() throws SQLException, Exception {
    Sql sql = parser.parseSql("update user_info set username = ? , password = ? , age = ? , sex = ?");
    verifyParameters(sql,"username","password","age","sex");
    assertEquals("update user_info set username = #username# , password = #password# , age = #age# , sex = #sex#",sql.getIbatisSql());
  }
View Full Code Here
171
172
173
174
175
176
177
178
179
    assertEquals("update user_info set username = #username# , password = #password# , age = #age# , sex = #sex#",sql.getIbatisSql());
  }

   public void test_select_as_alias_h2() {
       
        Sql sql = parser.parseSql("SELECT username user,password pwd from user_info");
        System.out.println("columns:"+sql.getColumns());
        verifyColumns(sql, "user","pwd");
    }
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
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
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.