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

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

59
60
61
62
63
64
65
66
67
    verifyParameters(sql,"userId","username","password","age","sex");
    verifyColumns(sql,"user_id","username","password","BIRTH_DATE","age","sex");
  }
 
  public void test_聚合函数() throws SQLException, Exception {
    Sql sql = parser.parseSql("select DISTINCT(count(*)) DISTINCT_count,count(username) cnt_username,sum(age) sum_age,avg(sex) avg_sex from user_info where user_id = ? and age = ? and password = ? and username like ? or (sex >= ?)");
    verifyParameters(sql,"userId","username","password","age","sex");
    verifyColumns(sql,"DISTINCT_count","cnt_username","sum_age","avg_sex");
  }
View Full Code Here
65
66
67
68
69
70
71
72
73
    verifyParameters(sql,"userId","username","password","age","sex");
    verifyColumns(sql,"DISTINCT_count","cnt_username","sum_age","avg_sex");
  }

  public void test_聚合函数2() throws SQLException, Exception {
    Sql sql = parser.parseSql("select DISTINCT username from user_info where user_id = ? and age = ? and password = ? and username like ? or (sex >= ?)");
    verifyParameters(sql,"userId","username","password","age","sex");
    verifyColumns(sql,"username");
  }
View Full Code Here
71
72
73
74
75
76
77
78
79
    verifyParameters(sql,"userId","username","password","age","sex");
    verifyColumns(sql,"username");
  }

  public void test_group_by() throws SQLException, Exception {
    Sql sql = parser.parseSql("select DISTINCT username from user_info where user_id = ? and age = ? and password = ? and username like ? or (sex >= ?) group by username");
    verifyParameters(sql,"userId","username","password","age","sex");
    verifyColumns(sql,"username");
  }
View Full Code Here
77
78
79
80
81
82
83
84
85
    verifyParameters(sql,"userId","username","password","age","sex");
    verifyColumns(sql,"username");
  }

  public void test_join() throws SQLException, Exception {
    Sql sql = parser.parseSql("select DISTINCT t1.username from user_info t1 inner join user_info t2 on t1.user_id=t2.user_id where t1.user_id = ? and t1.age = ? and t1.password = ? and t1.username like ? or (t1.sex >= ?) group by t1.username");
    verifyParameters(sql,"userId","username","password","age","sex");
    verifyColumns(sql,"username");
  }
View Full Code Here
83
84
85
86
87
88
89
90
91
    verifyParameters(sql,"userId","username","password","age","sex");
    verifyColumns(sql,"username");
  }

  public void test_select_with_table_alias() throws SQLException, Exception {
    Sql sql = parser.parseSql("select * from user_info t where t.user_id = ? and t.age = ? and t.password = ? and t.username like ? or (t.sex >= ?)");
    verifyParameters(sql,"userId","username","password","age","sex");
    verifyColumns(sql,"userId","username","password","BIRTH_DATE","age","sex");
  }
View Full Code Here
89
90
91
92
93
94
95
96
97
    verifyParameters(sql,"userId","username","password","age","sex");
    verifyColumns(sql,"userId","username","password","BIRTH_DATE","age","sex");
  }
 
  public void test_group_by_having() throws SQLException, Exception {
    Sql sql = parser.parseSql("select sum(age) sum_age from user_info where user_id = ? and age = ? and password = ? and username like ? or (sex >= ?) group by username having sum(age) = :havingUsername");
    verifyParameters(sql,"userId","username","password","age","sex","havingUsername");
    verifyColumns(sql,"sum_age");
  }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
    verifyParameters(sql,"userId","username","password","age","sex","havingUsername");
    verifyColumns(sql,"sum_age");
  }

    public void test_select_for_mybatis_foreach() throws SQLException, Exception {
        Sql sql = parser.parseSql("select * from user_info where user_id = ? and username = #{usernamesByIndex[index]}");
        verifyParameters(sql,"userId","usernamesByIndex");
       
        sql = parser.parseSql("select * from user_info where user_id = ? and username = #{usernamesByIndex[${index}]}");
        verifyParameters(sql,"userId","usernamesByIndex");
       
View Full Code Here
106
107
108
109
110
111
112
113
        sql = parser.parseSql("select * from user_info where user_id = ? and username = #{item}");
        verifyParameters(sql,"userId","item");
    }

   public void test_select_for_ibatis_foreach() throws SQLException, Exception {
       Sql sql = parser.parseSql("select * from user_info where user_id = ? and username = #usernamesByIndex[]#");
       verifyParameters(sql,"userId","usernamesByIndex");
   }
View Full Code Here
111
112
113
114
115
116
117
118
119
120
       Sql sql = parser.parseSql("select * from user_info where user_id = ? and username = #usernamesByIndex[]#");
       verifyParameters(sql,"userId","usernamesByIndex");
   }
  
  public void test_select_willcard() throws SQLException, Exception {
    Sql sql = parser.parseSql("select * from user_info where user_id = ? and username = :username");
    verifyParameters(sql,"userId","username");
    String expected = "select USER_ID,USERNAME,PASSWORD,BIRTH_DATE,SEX,AGE from user_info where user_id = #userId# and username = :username";
    assertStringEquals(expected,sql.getIbatisSql());
  }
View Full Code Here
118
119
120
121
122
123
124
125
126
127
128
    String expected = "select USER_ID,USERNAME,PASSWORD,BIRTH_DATE,SEX,AGE from user_info where user_id = #userId# and username = :username";
    assertStringEquals(expected,sql.getIbatisSql());
  }

  public void test_select_willcard_multi_table() throws SQLException, Exception {
    Sql sql = parser.parseSql("select t1.*,t2.* from user_info t1 inner join role t2 on t1.username=t2.role_name where t1.user_id = ? and t2.role_name = :role_name");
    verifyParameters(sql,"userId","role_name");
    String expected = "select t1.USER_ID,t1.USERNAME,t1.PASSWORD,t1.BIRTH_DATE,t1.SEX,t1.AGE,t2.USER_ID,t2.USERNAME,t2.PASSWORD,t2.BIRTH_DATE,t2.SEX,t2.AGE from user_info where user_id = #userId# and username = :username";
//    assertStringEquals(expected,sql.getSql());
    //FIXME select t1.* t2.* 应该返回不同的表前缀
  }
 
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.