Package org.opentides.bean

Examples of org.opentides.bean.SystemCodes

34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
 
  // fails due to findByExample bug where the column name generated for SystemCodes.key is KEY
  // which should be KEY_ and also as a note KEY is a reserved word in MySQL
    @Test
  public void testFindBykey(){   
    SystemCodes sc = new SystemCodes();
    sc.setDisableProtection(true);
    sc.setCategory("COUNTRY");
    sc.setKey("PH");
    sc.setValue("Philippines");
   
    SystemCodes actual = systemCodesService.findByKey(sc);
   
    assertEquals(sc.getKey(), actual.getKey());
    assertEquals(sc.getCategory(), actual.getCategory());
    assertEquals(sc.getValue(), actual.getValue());
  }
View Full Code Here
15
16
17
18
19
20
21
22
23
24
25
    this.systemCodesService = systemCodesService;
  }
 
  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
45
46
47
48
49
50
51
52
53
54
55
56
57
    assertEquals(scs1.size(), scs2.size());
    Assert.assertArrayEquals(scs1.toArray(), scs2.toArray());
  }
 
  public void testFindByExample(){
    SystemCodes example = new SystemCodes();
    example.setDisableProtection(true);
    example.setCategory("COUNTRY");
   
    List<SystemCodes> expected = jdbcTemplate.query("SELECT * FROM SYSTEM_CODES WHERE CATEGORY_='COUNTRY'", new SystemCodesMapper());
    List<SystemCodes> actual = systemCodesService.findByExample(example);
    assertEquals(expected.size(), actual.size());
    Assert.assertArrayEquals(expected.toArray(), actual.toArray());
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
67
68
    assertEquals(expected.size(), actual.size());
    Assert.assertArrayEquals(expected.toArray(), actual.toArray());
  }
 
  public void testFindByExamplePaging(){
    SystemCodes example = new SystemCodes();
    example.setDisableProtection(true);
    example.setCategory("COUNTRY");
   
    List<SystemCodes> expected = jdbcTemplate.query("SELECT * FROM SYSTEM_CODES WHERE CATEGORY_ LIKE '%COUNTRY%' limit 4,7", new SystemCodesMapper());
    List<SystemCodes> actual = systemCodesService.findByExample(example, 4, 5);
    _log.debug("Size not exact match: "+expected.size());
    assertEquals(expected.size(), actual.size());
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
79
80
    assertEquals(expected.size(), actual.size());
    Assert.assertArrayEquals(expected.toArray(), actual.toArray());
  }
 
  public void testFindByExampleExactMatch(){
    SystemCodes example = new SystemCodes();
    example.setDisableProtection(true);
    example.setCategory("COUNTRY");
   
    List<SystemCodes> expected = jdbcTemplate.query("SELECT * FROM SYSTEM_CODES WHERE CATEGORY_='COUNTRY'", new SystemCodesMapper());
    List<SystemCodes> actual = systemCodesService.findByExample(example,true);
    _log.debug("Size exact match: "+expected.size());
    assertEquals(expected.size(), actual.size());
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
91
92
    assertEquals(expected.size(), actual.size());
    Assert.assertArrayEquals(expected.toArray(), actual.toArray());
  }
 
  public void testFindByExampleExactMatchPaging(){
    SystemCodes example = new SystemCodes();
    example.setDisableProtection(true);
    example.setCategory("OFFICE");
   
    List<SystemCodes> expected = jdbcTemplate.query("SELECT * FROM SYSTEM_CODES WHERE CATEGORY_='OFFICE' limit 4,5", new SystemCodesMapper());
    List<SystemCodes> actual = systemCodesService.findByExample(example,true,4,5);
    _log.debug("Size exact match: "+expected.size());
    assertEquals(expected.size(), actual.size());
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
114
115
    long currCount = systemCodesService.countAll(); 
    assertEquals(prevCount+1, currCount);
  }
 
  public void testCountAllByExample(){
    SystemCodes example = new SystemCodes();
    example.setDisableProtection(true);
    example.setCategory("COUNTRY");
   
    long expected = jdbcTemplate.queryForLong("SELECT count(*) FROM SYSTEM_CODES WHERE CATEGORY_ LIKE '%COUNTRY%'");
    long actual = systemCodesService.countByExample(example);
    assertEquals(expected, actual);
   
View Full Code Here
118
119
120
121
122
123
124
125
126
127
128
129
130
    long currCount = systemCodesService.countAll(); 
    assertEquals(prevCount+1, currCount);
  }
 
  public void testCountAllByExampleExactMatch(){
    SystemCodes example = new SystemCodes();
    example.setDisableProtection(true);
    example.setCategory("O");
   
    long expected = jdbcTemplate.queryForLong("SELECT count(*) FROM SYSTEM_CODES WHERE CATEGORY_ = 'O'");
    long actual = systemCodesService.countByExample(example,true);
    _log.debug("Count exact match: "+expected);
    assertEquals(expected, actual);
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
  public void testLoad(){
    assertNotNull(systemCodesService.load(9001L));
  }
 
  public void testSave(){
    SystemCodes sc = new SystemCodes();
    sc.setDisableProtection(true);
    sc.setCategory("OFFICE");
    sc.setKey("ED");
    sc.setValue("Events Department");
   
    long prevCount = jdbcTemplate.queryForLong("SELECT count(*) FROM SYSTEM_CODES");
    systemCodesService.save(sc);
    long currCount = jdbcTemplate.queryForLong("SELECT count(*) FROM SYSTEM_CODES");
    assertEquals(prevCount+1, currCount);
View Full Code Here
14
15
16
17
18
19
20
21
22
23
24
  private SystemCodesService systemCodesService;
  private static final Logger _log = Logger.getLogger(BaseCrudServiceTest.class);
 
  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
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.