List of usage examples for org.springframework.jdbc.core JdbcTemplate queryForRowSet
@Override
public SqlRowSet queryForRowSet(String sql, @Nullable Object... args) throws DataAccessException
From source file:org.obiba.onyx.jade.instrument.topcon.EyeExtractor.java
public Map<String, Data> extractData(JdbcTemplate jdbc, String patientUUID) { log.info("Extracting Data"); Map<String, Data> data = new HashMap<String, Data>(); SqlRowSet mediaRowSet = jdbc.queryForRowSet(// "SELECT FileName, FileExt, StoragePathUid, CreateDate" + // " FROM dbo.Media" + // " WHERE PatientUid = ?" + // " AND EyeType = ? " + // " AND Status = 1 " + // " AND Display = 1 " + // " ORDER BY CreateDate ASC", new Object[] { patientUUID, getEyeTypeIntValue() }); if (mediaRowSet.last()) { String storagePathUid = mediaRowSet.getString("StoragePathUid"); String fileName = mediaRowSet.getString("FileName").trim(); String extension = mediaRowSet.getString("FileExt").trim(); String location = EyeExtractorQueryUtil.getLocation(jdbc, storagePathUid); byte[] imageByteArray = pathToByteArray(location, fileName, extension); data.put(EYE_PICT_VENDOR, new Data(DataType.DATA, imageByteArray)); data.put(EYE_SIDE_VENDOR, new Data(DataType.TEXT, getSideName())); } else {/* ww w .j a va2 s . co m*/ log.warn("Missing Picture"); } return data; }
From source file:com.emc.ecs.sync.service.SqliteDbServiceTest.java
private SqlRowSet getRowSet(String id) { JdbcTemplate jdbcTemplate = dbService.getJdbcTemplate(); SqlRowSet rowSet = jdbcTemplate .queryForRowSet("SELECT * FROM " + dbService.getObjectsTableName() + " WHERE source_id=?", id); rowSet.next();//from w ww . jav a 2 s.co m return rowSet; }
From source file:com.emc.ecs.sync.EndToEndTest.java
protected long verifyDbObjects(JdbcTemplate jdbcTemplate, List<TestSyncObject> objects) { Date now = new Date(); long count = 0; for (TestSyncObject object : objects) { count++;/*from w ww . j a v a 2s . c o m*/ SqlRowSet rowSet = jdbcTemplate.queryForRowSet( "SELECT * FROM " + DbService.DEFAULT_OBJECTS_TABLE_NAME + " WHERE target_id=?", object.getSourceIdentifier()); Assert.assertTrue(rowSet.next()); Assert.assertEquals(object.getSourceIdentifier(), rowSet.getString("target_id")); Assert.assertEquals(object.isDirectory(), rowSet.getBoolean("is_directory")); Assert.assertEquals(object.getMetadata().getContentLength(), rowSet.getLong("size")); // mtime in the DB is actually pulled from the target system, so we don't know what precision it will be in // or if the target system's clock is in sync, but let's assume it will always be within 5 minutes Assert.assertTrue( Math.abs(object.getMetadata().getModificationTime().getTime() - rowSet.getLong("mtime")) < 5 * 60 * 1000); Assert.assertEquals(ObjectStatus.Verified.getValue(), rowSet.getString("status")); Assert.assertTrue(now.getTime() - rowSet.getLong("transfer_start") < 10 * 60 * 1000); // less than 10 minutes ago Assert.assertTrue(now.getTime() - rowSet.getLong("transfer_complete") < 10 * 60 * 1000); // less than 10 minutes ago Assert.assertTrue(now.getTime() - rowSet.getLong("verify_start") < 10 * 60 * 1000); // less than 10 minutes ago Assert.assertTrue(now.getTime() - rowSet.getLong("verify_complete") < 10 * 60 * 1000); // less than 10 minutes ago Assert.assertEquals(object.getFailureCount(), rowSet.getInt("retry_count")); if (object.getFailureCount() > 0) { String error = rowSet.getString("error_message"); Assert.assertNotNull(error); log.warn("{} was retried {} time{}; error: {}", object.getRelativePath(), object.getFailureCount(), object.getFailureCount() > 1 ? "s" : "", error); } if (object.isDirectory()) count += verifyDbObjects(jdbcTemplate, object.getChildren()); } return count; }
From source file:db.postgres.V2_0_1__InitializeIdentityZones.java
private void removeDuplicateRows(final JdbcTemplate jdbcTemplate, final Long zone) { final List<SubjectEntity> subjects = jdbcTemplate .query("SELECT DISTINCT subject_identifier, attributes FROM subject", new SubjectRowMapper()); jdbcTemplate.update("DELETE FROM subject *"); for (SubjectEntity s : subjects) { jdbcTemplate.update(// www . j a v a 2s .c om "INSERT INTO subject (subject_identifier, attributes, " + " authorization_zone_id) VALUES (?,?,?)", s.getSubjectIdentifier(), s.getAttributesAsJson(), zone); } final List<ResourceEntity> resources = jdbcTemplate .query("SELECT DISTINCT resource_identifier, attributes FROM resource", new ResourceRowMapper()); jdbcTemplate.update("DELETE FROM resource *"); for (ResourceEntity r : resources) { jdbcTemplate.update( "INSERT INTO resource (resource_identifier, attributes, " + " authorization_zone_id) VALUES (?,?,?)", r.getResourceIdentifier(), r.getAttributesAsJson(), zone); } final List<PolicySetEntity> policysets = jdbcTemplate .query("SELECT DISTINCT policy_set_id, policy_set_json FROM policy_set", new PolicySetRowMapper()); jdbcTemplate.update("DELETE FROM policy_set *"); for (PolicySetEntity ps : policysets) { SqlRowSet row = jdbcTemplate.queryForRowSet("SELECT * FROM policy_set WHERE policy_set_id =?", ps.getPolicySetID()); if (row.next()) { jdbcTemplate.update("UPDATE policy_set SET policy_set_json = ? WHERE policy_set_id = ?", ps.getPolicySetJson(), ps.getPolicySetID()); } else { jdbcTemplate.update( "INSERT INTO policy_set (policy_set_id, policy_set_json, " + " authorization_zone_id) VALUES (?,?,?)", ps.getPolicySetID(), ps.getPolicySetJson(), zone); } } }
From source file:org.agnitas.dao.impl.RecipientDaoImpl.java
@Override public Set<String> loadBlackList(int companyID) throws Exception { JdbcTemplate jdbcTemplate = new JdbcTemplate((DataSource) applicationContext.getBean("dataSource")); SqlRowSet rset = null;/* ww w .j av a 2 s . c o m*/ Object[] params = new Object[] { new Integer(companyID) }; Set<String> blacklist = new HashSet<String>(); try { rset = jdbcTemplate.queryForRowSet("SELECT email FROM cust_ban_tbl WHERE company_id=? OR company_id=0", params); while (rset.next()) { blacklist.add(rset.getString(1).toLowerCase()); } } catch (Exception e) { logger.error("loadBlacklist (company ID: " + companyID + ")", e); throw e; } return blacklist; }
From source file:org.agnitas.web.ImportWizardForm.java
/** * Loads blacklist./*from w ww .jav a 2 s. c om*/ */ protected void loadBlacklist(int companyID, JdbcTemplate jdbc) throws Exception { SqlRowSet rset = null; String blackList = null; Object[] params = new Object[] { new Integer(companyID) }; this.blacklist = new HashSet(); try { blackList = "SELECT email FROM cust_ban_tbl WHERE company_id=? OR company_id=0"; rset = jdbc.queryForRowSet(blackList, params); while (rset.next()) { this.blacklist.add(rset.getString(1).toLowerCase()); } } catch (Exception e) { AgnUtils.logger().error("loadBlacklist: " + e); throw new Exception(e.getMessage()); } }