Examples of Sql

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

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

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

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

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

31
32
33
34
35
36
37
38
39
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }

  public void test_select_with_2_parameers() throws Exception {
    Sql selectSql  = new SqlFactory().parseSql("select * from user_info where username = :username and password =:password ");
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
View Full Code Here

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

37
38
39
40
41
42
43
44
45
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }

  public void test_select_with_in_parameers() throws Exception {
    Sql selectSql  = new SqlFactory().parseSql("select * from user_info where username = :username and password =:password and age in (:age)");
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
View Full Code Here

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

43
44
45
46
47
48
49
50
51
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
 
  public void test_select_with_many_parameers() throws Exception {
    Sql selectSql  = new SqlFactory().parseSql("select * from user_info where username = :username and password =:password and age = :age and sex = :sex and birth_date > :birth_date and birth_date < :birth_date2");
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
View Full Code Here

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

49
50
51
52
53
54
55
56
57
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
 
  public void test_select_with_cannot_guess_column_type() throws Exception {
    Sql selectSql  = new SqlFactory().parseSql("select * from user_info where username = :username and password =:password and age = :age and sex = :sex and birth_date > :birth_date and birth_date < :birth_date2");
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
View Full Code Here

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

55
56
57
58
59
60
61
62
63
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
 
  public void test_select_same_params() throws Exception {
    Sql selectSql  = new SqlFactory().parseSql("select * from user_info where username = :username and username like :username and birth_date between :birthDate and :birthDate");
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
View Full Code Here

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

61
62
63
64
65
66
67
68
69
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }

  public void test_select_with_two_columns() throws Exception {
    Sql selectSql  = new SqlFactory().parseSql("select sum(age) sum_age,count(username) cnt from user_info ");
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
View Full Code Here

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

67
68
69
70
71
72
73
74
75
76
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
 
  public void test_select_count_and_multi_policy_one() throws Exception {
    Sql selectSql  = new SqlFactory().parseSql("select count(username) cnt from user_info where username = :username and password =:password and age = :age and sex = :sex and birth_date > :birth_date and birth_date < :birth_date2");
    selectSql.setMultiplicity(Sql.MULTIPLICITY_ONE);
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
View Full Code Here

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

74
75
76
77
78
79
80
81
82
83
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
 
  public void test_select_string_and_multi_policy_one() throws Exception {
    Sql selectSql  = new SqlFactory().parseSql("select username from user_info where username = :username and password =:password and age = :age and sex = :sex and birth_date > :birth_date and birth_date < :birth_date2");
    selectSql.setMultiplicity(Sql.MULTIPLICITY_ONE);
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.