コード例 #1
0
ファイル: LimsDAO.java プロジェクト: adwaitpatil/miso-lims
  @Test
  public void testPlatforms() {
    try {
      // get row count of experiments in the dataset
      int expected = getDataSet().getTable("Platform").getRowCount();

      // get number of experiments from the DAO
      int actual = getPlatformDAO().count();

      // test data contains 2 experiments, check size of returned list
      TestCase.assertEquals("Wrong number of Platform", expected, actual);
      System.out.println("Expected number of Platform: " + expected + ", actual: " + actual);

      for (Platform d : random(getPlatformDAO(), actual, 5)) {
        TestCase.assertNotNull(d);
        TestCase.assertNotNull(d.getPlatformId());
      }
    } catch (Exception e) {
      e.printStackTrace();
      TestCase.fail();
    }
  }
コード例 #2
0
ファイル: SQLPlatformDAO.java プロジェクト: TGAC/miso-lims
 public Platform mapRow(ResultSet rs, int rowNum) throws SQLException {
   Platform p = new PlatformImpl();
   p.setPlatformId(rs.getLong("platformId"));
   p.setPlatformType(PlatformType.get(rs.getString("name")));
   p.setDescription(rs.getString("description"));
   p.setInstrumentModel(rs.getString("instrumentModel"));
   p.setNumContainers(rs.getInt("numContainers"));
   return p;
 }
コード例 #3
0
ファイル: SQLPlatformDAO.java プロジェクト: TGAC/miso-lims
  public long save(Platform platform) throws IOException {
    // execute this procedure...
    MapSqlParameterSource params = new MapSqlParameterSource();
    params
        .addValue("name", platform.getPlatformType().getKey())
        .addValue("instrumentModel", platform.getInstrumentModel())
        .addValue("description", platform.getDescription())
        .addValue("numContainers", platform.getNumContainers());

    if (platform.getPlatformId() == null) {
      SimpleJdbcInsert insert =
          new SimpleJdbcInsert(template)
              .withTableName(TABLE_NAME)
              .usingGeneratedKeyColumns("platformId");
      Number newId = insert.executeAndReturnKey(params);
      platform.setPlatformId(newId.longValue());
    } else {
      params.addValue("platformId", platform.getPlatformId());
      NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
      namedTemplate.update(PLATFORM_UPDATE, params);
    }

    return platform.getPlatformId();
  }
コード例 #4
0
 @Transactional(readOnly = false)
 public long save(Platform platform) throws IOException {
   getHibernateTemplate().saveOrUpdate(platform);
   return platform.getPlatformId();
 }