Package org.opentides.bean

Examples of org.opentides.bean.SystemCodes

80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
  public void testSaveEntityModelUpdateObject() {
    int count = jdbcTemplate.queryForInt("select count(*) from SYSTEM_CODES where KEY_='TK' and CATEGORY_='COUNTRY'");
    assertEquals(0, count);
    count = jdbcTemplate.queryForInt("select count(*) from SYSTEM_CODES where KEY_='PH' and CATEGORY_='COUNTRY'");
    assertEquals(1, count);
    SystemCodes sc1 = dao.loadEntityModel(9001l);
    sc1.setKey("TK");
    sc1.setCategory("COUNTRY");
    sc1.setValue("Thailand");
    dao.saveEntityModel(sc1);
    count = jdbcTemplate.queryForInt("select count(*) from SYSTEM_CODES where KEY_='TK' and CATEGORY_='COUNTRY'");
    assertEquals(1, count);
    count = jdbcTemplate.queryForInt("select count(*) from SYSTEM_CODES where KEY_='PH' and CATEGORY_='COUNTRY'");
    assertEquals(0, count);
    SystemCodes sc2 = dao.loadEntityModel(9001l);
    assertEquals(sc1, sc2);
  }
View Full Code Here
102
103
104
105
106
107
108
109
110
111
    count = jdbcTemplate.queryForInt("select count(*) from SYSTEM_CODES where KEY_='US'");
    assertEquals(0, count);   

    count = jdbcTemplate.queryForInt("select count(*) from SYSTEM_CODES where KEY_='PH'");
    assertEquals(1, count); 
    SystemCodes sc1 = dao.loadEntityModel(9001l);
    dao.deleteEntityModel(sc1);
    count = jdbcTemplate.queryForInt("select count(*) from SYSTEM_CODES where KEY_='PH'");
    assertEquals(0, count); 
  }
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
155
  }
 
  // TODO: Test ByExample with various datatypes (e.g. String, Long, Boolean, etc.)
  public void testCountByExampleString() {
    SystemCodes example = new SystemCodes();
    example.setDisableProtection(true);
    example.setCategory("OFFICE");
    long count = dao.countByExample(example);
    long target = jdbcTemplate.queryForInt("select count(*) from SYSTEM_CODES where CATEGORY_='OFFICE'");
    assertEquals(target, count);   
  }
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
166
167
  }
 
  // TODO: Test ByExample with various parameters (e.g. exact match or not)
  @SuppressWarnings("unchecked")
  public void testFindByExample() {
    SystemCodes example = new SystemCodes();
    example.setDisableProtection(true);
    example.setCategory("OFFICE");
    List<SystemCodes> codes = dao.findByExample(example);
    List<SystemCodes> targets = jdbcTemplate.query(
        "select * from SYSTEM_CODES where CATEGORY_='OFFICE'", 
        new SystemCodesMapper());
    Assert.assertArrayEquals(targets.toArray(), codes.toArray());
View Full Code Here
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
    Assert.assertArrayEquals(targets.toArray(), codes.toArray());
  }
 
  @SuppressWarnings("unchecked")
  public void testFindByExampleSorting() {
    SystemCodes example = new SystemCodes();
    example.setDisableProtection(true);
    example.setOrderOption("key");
    example.setOrderFlow("desc");
    example.setCategory("COUNTRY");
    List<SystemCodes> codes = dao.findByExample(example);
    List<SystemCodes> targets = jdbcTemplate.query(
        "select * from SYSTEM_CODES where CATEGORY_='COUNTRY' order by KEY_ desc", 
        new SystemCodesMapper());
    Assert.assertArrayEquals(targets.toArray(), codes.toArray());
View Full Code Here
181
182
183
184
185
186
187
188
189
190
191
192
193
    Assert.assertArrayEquals(targets.toArray(), codes.toArray());
  }
 
  @SuppressWarnings("unchecked")
  public void testFindByExamplePaging() {
    SystemCodes example = new SystemCodes();
    example.setDisableProtection(true);
    example.setCategory("COUNTRY");
    List<SystemCodes> codes = dao.findByExample(example,0,2);
    List<SystemCodes> targets = this.jdbcTemplate.query(
          "select * from SYSTEM_CODES where CATEGORY_='COUNTRY' limit 0,2",
          new SystemCodesMapper());
    Assert.assertArrayEquals(targets.toArray(), codes.toArray());
View Full Code Here
221
222
223
224
225
226
227
228
229
  }
 
  public void testfindSingleResultByNamedQuery() {
    Map<String, Object> params = new HashMap<String, Object>();
    params.put("keyName", "CN");
    SystemCodes object = dao.findSingleResultByNamedQuery("jpql.systemcodes.findByKey", params);
    List<SystemCodes> target = this.jdbcTemplate.query("select * from SYSTEM_CODES where key_='CN'", new SystemCodesMapper());
    assertEquals(target.get(0), object);   
  }
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
    datasetName = "test/xml/SystemCodesDAOTest.xml";
  }

  private static final class SystemCodesMapper implements RowMapper {
      public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
          SystemCodes sc = new SystemCodes();
          sc.setCategory(rs.getString("category_"));
          sc.setKey(rs.getString("key_"));
          sc.setValue(rs.getString("value_"));
          return sc;
      }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
  }
 
  @Override
  public String getAsText() {
    if (getValue() != null) {
      SystemCodes editor = (SystemCodes) getValue();
      return editor.getId().toString();
    }
    return "";
  }
View Full Code Here
46
47
48
49
50
51
52
53
54
55
  }

  @Override
  public void setAsText(String text) throws IllegalArgumentException {
    if (!StringUtil.isEmpty(text)) {
      SystemCodes systemCode = systemCodesService.load(text);
      setValue(systemCode);
    } else
      setValue(null);
  }
View Full Code Here
TOP

Related Classes of org.opentides.bean.SystemCodes

  • org.opentides.editor.SystemCodeEditor
  • org.opentides.persistence.AuditLogDAOTest
  • org.opentides.persistence.AuditLogDAOTest$SystemCodesExtractor
  • org.opentides.persistence.BaseEntityDAOTest
  • org.opentides.persistence.BaseEntityDAOTest$SystemCodesMapper
  • org.opentides.persistence.evolve.DBEvolveManager
  • org.opentides.persistence.impl.SystemCodesDAOJpaImpl
  • org.opentides.persistence.SystemCodesDAOTest
  • org.opentides.persistence.SystemCodesDAOTest$SystemCodesExtractor
  • org.opentides.persistence.SystemCodesDAOTest$SystemCodesMapper
    • 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.