public boolean next() throws Exception { return sqlRowSet.next(); }
@Override public boolean isLockOwner(Object entityId, Principal principal) { if (principal == null) { throw new SecurityException("no principal"); } String sql = "SELECT entity_id from locks where entity_id = ? and lock_owner = ?"; SqlRowSet rs = template.queryForRowSet(sql, entityId.toString(), principal.getName()); return rs.next(); } }
public Map<String, Object> next() { if (hasNext) { Map<String, Object> result = new HashMap<String, Object>(); for (String columnName : columnNames) { result.put(columnName, sqlRowSet.getObject(columnName)); } hasNext = sqlRowSet.next(); return result; } else { throw new NoSuchElementException(); } }
@Override public String validState() { boolean hasData = jdbcTemplate.queryForRowSet( "select validationresultid from validationresult limit 1" ).next(); if ( !hasData ) { return "No validation results exist, not updating validation result analytics tables"; } return null; }
@Override public String validState() { boolean hasData = jdbcTemplate.queryForRowSet( "select dataelementid from trackedentitydatavalue limit 1" ).next(); if ( !hasData ) { return "No events exist, not updating event analytics tables"; } return null; } }
@Override public String validState() { boolean hasData = jdbcTemplate.queryForRowSet( "select datasetid from completedatasetregistration limit 1" ).next(); if ( !hasData ) { return "No complete registrations exist, not updating completeness analytics tables"; } return null; }
/** * Indicates whether the given table exists and has at least one row. * * @param tableName the table name. */ protected boolean hasRows( String tableName ) { final String sql = "select * from " + tableName + " limit 1"; try { return jdbcTemplate.queryForRowSet( sql ).next(); } catch ( BadSqlGrammarException ex ) { return false; } }
@Override public boolean isObjectRelation(int templateId, Integer objectId) { logger.debug("IsObjectRelation for templateId: {}, objectId: {}", Arrays.asList(templateId, objectId)); try { SqlRowSet rowSet = this.getJdbcTemplate().queryForRowSet("select * from pn_regex_object where regex_id = ? AND object_id = ?", templateId, objectId); logger.debug("Relation between templateId: {} and objectId: {}, found.", Arrays.asList(templateId, objectId)); return rowSet.next(); } catch (EmptyResultDataAccessException ex) { //This exception signals empty row logger.debug("Relation between templateId: {}, and objectId: {}, not found", Arrays.asList(templateId, objectId)); return false; } }
/** * @see org.kuali.kfs.module.endow.batch.dataaccess.GLInterfaceBatchProcessDao#findDocumentTypes() */ public Collection<String> findDocumentTypes() { LOG.info("findDocumentTypes() started"); Collection<String> documentTypes = new ArrayList<String>(); SqlRowSet documentTypesRowSet = getJdbcTemplate().queryForRowSet("SELECT DISTINCT(DOC_TYP_NM) DOC_TYP_NM FROM END_TRAN_ARCHV_T ORDER BY DOC_TYP_NM"); while (documentTypesRowSet.next()) { documentTypes.add(documentTypesRowSet.getString(EndowPropertyConstants.ColumnNames.GlInterfaceBatchProcessLine.TRANSACTION_ARCHIVE_DOC_TYP_NM)); } LOG.info("findDocumentTypes() exited"); return documentTypes; }
public int account(String sql) throws SQLException { int ret = 0; SqlRowSet sqlRowset = jdbcTemplate.queryForRowSet(sql); if (sqlRowset.next()) { ret = sqlRowset.getInt(1); } return ret; }
public SqlIterator(SqlRowSet sqlRowSet) { this.sqlRowSet = sqlRowSet; this.columnNames = sqlRowSet.getMetaData().getColumnNames(); this.hasNext = sqlRowSet.next(); }
/** * 使用SQL初始化代码对照表 * * @param colName * @param sql * @param config * @throws InterceptException */ private void initCodeSql(String colName, String sql, ExcelImportConfig config) throws InterceptException { SqlRowSet rs = jdbcTemplate.queryForRowSet(sql); Map<String, String> codeMap = new HashMap<String, String>(); while (rs.next()) { String itemName = rs.getString(1); String itemNo = rs.getString(2); codeMap.put(itemName,itemNo); } if (codeMap.size() > 0) { codeConvert.put(colName, codeMap); } }
private void removeOldPoolMessages(long olderThan) { Set<Integer> proccessedIds = new HashSet<Integer>(); long actualTimeInMillis = new DateTime().getMillis(); SqlRowSet srs = this.getJdbcTemplate().queryForRowSet("SELECT id,created FROM pn_pool_message"); while (srs.next()) { Timestamp timeStamp = srs.getTimestamp("created"); if (timeStamp.getTime() + olderThan < actualTimeInMillis) { proccessedIds.add(srs.getInt("id")); } } removeAllPoolMessages(proccessedIds); } }
@Override public String validState() { boolean hasData = jdbcTemplate.queryForRowSet( "select dataelementid from datavalue dv where dv.deleted is false limit 1" ).next(); if ( !hasData ) { return "No data values exist, not updating aggregate analytics tables"; } int orgUnitLevels = organisationUnitService.getNumberOfOrganisationalLevels(); if ( orgUnitLevels == 0 ) { return "No organisation unit levels exist, not updating aggregate analytics tables"; } return null; }
public int account(String sql) throws TinyDbException { try { int ret = 0; SqlRowSet sqlRowset = jdbcTemplate.queryForRowSet(sql); if (sqlRowset.next()) { ret = sqlRowset.getInt(1); } return ret; } catch (DataAccessException e) { throw new TinyDbException(e); } }
@Override public Grid addRows( SqlRowSet rs, int maxLimit ) { int cols = rs.getMetaData().getColumnCount(); while ( rs.next() ) { addRow(); for ( int i = 1; i <= cols; i++ ) { addValue( rs.getObject( i ) ); if ( maxLimit > 0 && i > maxLimit ) { throw new IllegalStateException( "Number of rows produced by query is larger than the max limit: " + maxLimit ); } } } return this; }
/** * Writes all rows in the SqlRowSet to the given Grid. */ public static void addRows( Grid grid, SqlRowSet rs ) { int cols = rs.getMetaData().getColumnCount(); while ( rs.next() ) { grid.addRow(); for ( int i = 1; i <= cols; i++ ) { grid.addValue( rs.getObject( i ) ); } } }
@Override public Rectangle getRectangle( EventQueryParams params ) { String clusterField = params.getCoordinateField(); String quotedClusterField = quoteAlias( clusterField ); String sql = "select count(psi) as " + COL_COUNT + ", ST_Extent(" + quotedClusterField + ") as " + COL_EXTENT + " "; sql += getFromClause( params ); sql += getWhereClause( params ); log.debug( String.format( "Analytics event count and extent SQL: %s", sql ) ); Rectangle rectangle = new Rectangle(); SqlRowSet rowSet = jdbcTemplate.queryForRowSet( sql ); if ( rowSet.next() ) { Object extent = rowSet.getObject( COL_EXTENT ); rectangle.setCount( rowSet.getLong( COL_COUNT ) ); rectangle.setExtent( extent != null ? String.valueOf( rowSet.getObject( COL_EXTENT ) ) : null ); } return rectangle; }
private SqlRowSet getRowSet(String id) { JdbcTemplate jdbcTemplate = dbService.getJdbcTemplate(); SqlRowSet rowSet = jdbcTemplate.queryForRowSet("SELECT * FROM " + dbService.getObjectsTableName() + " WHERE source_id=?", id); rowSet.next(); return rowSet; }
private void verifyDb(TestStorage storage) { JdbcTemplate jdbcTemplate = dbService.getJdbcTemplate(); long totalCount = verifyDbObjects(jdbcTemplate, storage, storage.getRootObjects()); SqlRowSet rowSet = jdbcTemplate.queryForRowSet("SELECT count(target_id) FROM " + AbstractDbService.DEFAULT_OBJECTS_TABLE_NAME + " WHERE target_id != ''"); Assert.assertTrue(rowSet.next()); Assert.assertEquals(totalCount, rowSet.getLong(1)); jdbcTemplate.update("DELETE FROM " + AbstractDbService.DEFAULT_OBJECTS_TABLE_NAME); }