@Override public int getTrackedEntityInstanceCount( TrackedEntityInstanceQueryParams params ) { SqlHelper hlp = new SqlHelper(); // --------------------------------------------------------------------- // Select clause // --------------------------------------------------------------------- String sql = "select count(tei.uid) as " + TRACKED_ENTITY_INSTANCE_ID + " "; // --------------------------------------------------------------------- // From and where clause // --------------------------------------------------------------------- sql += getFromWhereClause( params, hlp ); // --------------------------------------------------------------------- // Query // --------------------------------------------------------------------- Integer count = jdbcTemplate.queryForObject( sql, Integer.class ); log.debug( "Tracked entity instance count SQL: " + sql ); return count; }
@Override public String getCriteriaSqlClause(Map<String, String> criteria, SqlHelper sqlHelper ) { String sql = StringUtils.EMPTY; if ( criteria != null && !criteria.isEmpty() ) { sqlHelper = ObjectUtils.firstNonNull( sqlHelper, new SqlHelper() ); for ( String filter : criteria.keySet() ) { sql += sqlHelper.whereAnd() + " " + statementBuilder.columnQuote( filter ) + "='" + criteria.get( filter ) + "' "; } } return sql; }
/** * Returns a having clause restricting the result based on the measure criteria. */ private String getMeasureCriteriaSql( DataQueryParams params ) { SqlHelper sqlHelper = new SqlHelper(); String sql = " "; for ( MeasureFilter filter : params.getMeasureCriteria().keySet() ) { Double criterion = params.getMeasureCriteria().get( filter ); sql += sqlHelper.havingAnd() + " " + getNumericValueColumn( params ) + " " + OPERATOR_SQL_MAP.get( filter ) + " " + criterion + " "; } return sql; }
/** * Generates a sub query which provides a filtered view of the data according * to the criteria. If not, returns the full view of the partition. */ private String getPreMeasureCriteriaSubquerySql( DataQueryParams params ) { SqlHelper sqlHelper = new SqlHelper(); String fromSourceClause = getFromSourceClause( params ) + " as " + ANALYTICS_TBL_ALIAS; String sql = "(select * from " + fromSourceClause + " "; for ( MeasureFilter filter : params.getPreAggregateMeasureCriteria().keySet() ) { Double criterion = params.getPreAggregateMeasureCriteria().get( filter ); sql += sqlHelper.whereAnd() + " value " + OPERATOR_SQL_MAP.get( filter ) + " " + criterion + " "; } sql += ")"; return sql; }
@Override public Map<String, Set<String>> getOrganisationUnitDataSetAssocationMap( Collection<OrganisationUnit> organisationUnits, Collection<DataSet> dataSets ) SqlHelper hlp = new SqlHelper();
private String getSqlForView( Grid grid, SqlView sqlView, Map<String, String> criteria, List<String> filters, List<String> fields ) { String sql = "select " + QueryUtils.parseSelectFields( fields ) + " from " + statementBuilder.columnQuote( sqlView.getViewName() ) + " "; boolean hasCriteria = criteria != null && !criteria.isEmpty(); boolean hasFilter = filters != null && !filters.isEmpty(); if ( hasCriteria || hasFilter ) { SqlHelper sqlHelper = new SqlHelper(); if ( hasCriteria ) { sql += getCriteriaSqlClause( criteria, sqlHelper ); } if ( hasFilter ) { sql += parseFilters( filters, sqlHelper ); } } return sql; }
private String getSqlForQuery( Grid grid, SqlView sqlView, Map<String, String> criteria, Map<String, String> variables, List<String> filters, List<String> fields ) { boolean hasCriteria = criteria != null && !criteria.isEmpty(); boolean hasFilter = filters != null && !filters.isEmpty(); String sql = SqlViewUtils.substituteSqlVariables( sqlView.getSqlQuery(), variables ); if ( hasCriteria || hasFilter ) { sql = SqlViewUtils.removeQuerySeparator( sql ); String outerSql = "select " + QueryUtils.parseSelectFields( fields ) + " from " + "(" + sql + ") as qry "; SqlHelper sqlHelper = new SqlHelper(); if ( hasCriteria ) { outerSql += getCriteriaSqlClause( criteria, sqlHelper ); } if ( hasFilter ) { outerSql += parseFilters( filters, sqlHelper ); } sql = outerSql; } return sql; }
@Override public List<Map<String, String>> getTrackedEntityInstancesGrid( TrackedEntityInstanceQueryParams params ) SqlHelper hlp = new SqlHelper();
.collect( Collectors.toList() ); SqlHelper sqlHelper = new SqlHelper();
private String buildGridSql( EventSearchParams params, List<OrganisationUnit> organisationUnits ) SqlHelper hlp = new SqlHelper();
@Override public List<DeflatedDataValue> getDeflatedDataValues( DataExportParams params ) SqlHelper sqlHelper = new SqlHelper( true );
@Override public List<DataApprovalAudit> getDataApprovalAudits( DataApprovalAuditQueryParams params ) SqlHelper hlp = new SqlHelper();
private Query<ProgramMessage> getHqlQuery( ProgramMessageQueryParams params ) SqlHelper helper = new SqlHelper( true );
public List<OrganisationUnit> getOrganisationUnits( OrganisationUnitQueryParams params ) SqlHelper hlp = new SqlHelper();
SqlHelper sqlHelper = new SqlHelper();
SqlHelper sqlHelper = new SqlHelper();
SqlHelper sqlHelper = new SqlHelper();
SqlHelper orHlp = new SqlHelper( true );