/** * Read many beans using an iterator (except you need to close() the iterator when you have * finished). */ public <T> QueryIterator<T> findIterate(OrmQueryRequest<T> request) { CQuery<T> cquery = queryBuilder.buildQuery(request); request.setCancelableQuery(cquery); try { if (!cquery.prepareBindExecuteQuery()) { // query has been cancelled already logger.trace("Future fetch already cancelled"); return null; } if (request.isLogSql()) { logSql(cquery); } int iterateBufferSize = request.getSecondaryQueriesMinBatchSize(defaultSecondaryQueryBatchSize); QueryIterator<T> readIterate = cquery.readIterate(iterateBufferSize, request); if (request.isLogSummary()) { logFindManySummary(cquery); } return readIterate; } catch (SQLException e) { throw cquery.createPersistenceException(e); } }
/** Log the generated SQL to the transaction log. */ private void logSql(CQuery<?> query) { String sql = query.getGeneratedSql(); if (TransactionManager.SQL_LOGGER.isTraceEnabled()) { sql += "; --bind(" + query.getBindLog() + ")"; } query.getTransaction().logSql(sql); }
/** Build and execute the row count query. */ public <T> int findRowCount(OrmQueryRequest<T> request) { CQueryRowCount rcQuery = queryBuilder.buildRowCountQuery(request); try { int rowCount = rcQuery.findRowCount(); if (request.isLogSql()) { String logSql = rcQuery.getGeneratedSql(); if (TransactionManager.SQL_LOGGER.isTraceEnabled()) { logSql += "; --bind(" + rcQuery.getBindLog() + ")"; } request.logSql(logSql); } if (request.isLogSummary()) { request.getTransaction().logSummary(rcQuery.getSummary()); } if (request.getQuery().isFutureFetch()) { logger.debug("Future findRowCount completed!"); request.getTransaction().end(); } return rowCount; } catch (SQLException e) { throw CQuery.createPersistenceException( e, request.getTransaction(), rcQuery.getBindLog(), rcQuery.getGeneratedSql()); } }
/** Build and execute the find Id's query. */ public <T> BeanIdList findIds(OrmQueryRequest<T> request) { CQueryFetchIds rcQuery = queryBuilder.buildFetchIdsQuery(request); try { BeanIdList list = rcQuery.findIds(); if (request.isLogSql()) { String logSql = rcQuery.getGeneratedSql(); if (TransactionManager.SQL_LOGGER.isTraceEnabled()) { logSql += "; --bind(" + rcQuery.getBindLog() + ")"; } request.logSql(logSql); } if (request.isLogSummary()) { request.getTransaction().logSummary(rcQuery.getSummary()); } if (!list.isFetchingInBackground() && request.getQuery().isFutureFetch()) { // end the transaction for futureFindIds (it had it's own one) logger.debug("Future findIds completed!"); request.getTransaction().end(); } return list; } catch (SQLException e) { throw CQuery.createPersistenceException( e, request.getTransaction(), rcQuery.getBindLog(), rcQuery.getGeneratedSql()); } }
protected Map<String, Value<?>> copyKeysFormFilters() { final Map<String, Value<?>> orderedFiltersMap = new LinkedHashMap<>(); for (final CFilter<?> filter : cQuery.getFilters()) { final CColumn<?, ?> column = filter.getValue().getColumn(); orderedFiltersMap.put(column.getName(), Value.unbound(column)); } return orderedFiltersMap; }
/** Find and return a single bean using its unique id. */ public <T> T find(OrmQueryRequest<T> request) { T bean = null; CQuery<T> cquery = queryBuilder.buildQuery(request); try { cquery.prepareBindExecuteQuery(); if (request.isLogSql()) { logSql(cquery); } if (cquery.readBean()) { bean = cquery.getLoadedBean(); } if (request.isLogSummary()) { logFindBeanSummary(cquery); } request.executeSecondaryQueries(defaultSecondaryQueryBatchSize); return bean; } catch (SQLException e) { throw cquery.createPersistenceException(e); } finally { cquery.close(); } }
/** Log the FindMany to the transaction log. */ private void logFindManySummary(CQuery<?> q) { SpiQuery<?> query = q.getQueryRequest().getQuery(); String loadMode = query.getLoadMode(); String loadDesc = query.getLoadDescription(); String lazyLoadProp = query.getLazyLoadProperty(); ObjectGraphNode node = query.getParentNode(); String originKey; if (node == null || node.getOriginQueryPoint() == null) { originKey = null; } else { originKey = node.getOriginQueryPoint().getKey(); } StringBuilder msg = new StringBuilder(200); msg.append("FindMany "); if (loadMode != null) { msg.append("mode[").append(loadMode).append("] "); } msg.append("type[").append(q.getBeanName()).append("] "); if (query.isAutofetchTuned()) { msg.append("tuned[true] "); } if (originKey != null) { msg.append("origin[").append(originKey).append("] "); } if (lazyLoadProp != null) { msg.append("lazyLoadProp[").append(lazyLoadProp).append("] "); } if (loadDesc != null) { msg.append("load[").append(loadDesc).append("] "); } msg.append("exeMicros[").append(q.getQueryExecutionTimeMicros()); msg.append("] rows[").append(q.getLoadedRowDetail()); msg.append("] name[").append(q.getName()); msg.append("] predicates[").append(q.getLogWhereSql()); msg.append("] bind[").append(q.getBindLog()).append("]"); q.getTransaction().logSummary(msg.toString()); }
/** Find a list/map/set of beans. */ public <T> BeanCollection<T> findMany(OrmQueryRequest<T> request) { // flag indicating whether we need to close the resources... boolean useBackgroundToContinueFetch = false; CQuery<T> cquery = queryBuilder.buildQuery(request); request.setCancelableQuery(cquery); try { if (!cquery.prepareBindExecuteQuery()) { // query has been cancelled already logger.trace("Future fetch already cancelled"); return null; } if (request.isLogSql()) { logSql(cquery); } BeanCollection<T> beanCollection = cquery.readCollection(); BeanCollectionTouched collectionTouched = request.getQuery().getBeanCollectionTouched(); if (collectionTouched != null) { // register a listener that wants to be notified when the // bean collection is first used beanCollection.setBeanCollectionTouched(collectionTouched); } if (cquery.useBackgroundToContinueFetch()) { // stop the request from putting connection back into pool // before background fetching is finished. request.setBackgroundFetching(); useBackgroundToContinueFetch = true; BackgroundFetch fetch = new BackgroundFetch(cquery); FutureTask<Integer> future = new FutureTask<Integer>(fetch); beanCollection.setBackgroundFetch(future); backgroundExecutor.execute(future); } if (request.isLogSummary()) { logFindManySummary(cquery); } request.executeSecondaryQueries(defaultSecondaryQueryBatchSize); return beanCollection; } catch (SQLException e) { throw cquery.createPersistenceException(e); } finally { if (useBackgroundToContinueFetch) { // left closing resources to BackgroundFetch... } else { if (cquery != null) { cquery.close(); } if (request.getQuery().isFutureFetch()) { // end the transaction for futureFindIds // as it had it's own transaction logger.debug("Future fetch completed!"); request.getTransaction().end(); } } } }