private List<AnalyticsTableColumn> getValueColumns() { final String dbl = statementBuilder.getDoubleColumnType(); return Lists.newArrayList( new AnalyticsTableColumn( quote( "value" ), dbl, "value" ) ); }
private List<AnalyticsTableColumn> getValueColumns() { final String dbl = statementBuilder.getDoubleColumnType(); return Lists.newArrayList( new AnalyticsTableColumn( quote( "value" ), dbl, "value" ) ); }
@Override protected void populateTable( AnalyticsTableUpdateParams params, AnalyticsTablePartition partition ) { final String dbl = statementBuilder.getDoubleColumnType(); final boolean skipDataTypeValidation = (Boolean) systemSettingManager.getSystemSetting( SettingKey.SKIP_DATA_TYPE_VALIDATION_IN_ANALYTICS_TABLE_EXPORT ); final String approvalClause = getApprovalJoinClause( partition.getYear() ); final String numericClause = skipDataTypeValidation ? "" : ( "and dv.value " + statementBuilder.getRegexpMatch() + " '" + MathUtils.NUMERIC_LENIENT_REGEXP + "' " ); String intClause = "( dv.value != '0' or de.aggregationtype in ('" + AggregationType.AVERAGE + ',' + AggregationType.AVERAGE_SUM_ORG_UNIT + "') or de.zeroissignificant = true ) " + numericClause; populateTable( params, partition, "cast(dv.value as " + dbl + ")", "null", ValueType.NUMERIC_TYPES, intClause, approvalClause ); populateTable( params, partition, "1", "null", Sets.newHashSet( ValueType.BOOLEAN, ValueType.TRUE_ONLY ), "dv.value = 'true'", approvalClause ); populateTable( params, partition, "0", "null", Sets.newHashSet( ValueType.BOOLEAN ), "dv.value = 'false'", approvalClause ); populateTable( params, partition, "null", "dv.value", Sets.union( ValueType.TEXT_TYPES, ValueType.DATE_TYPES ), null, approvalClause ); }
"and ( cast( dv.value as " + statementBuilder.getDoubleColumnType() + " ) < " + lowerBoundMap.get( orgUnitUid ) + " " + "or cast( dv.value as " + statementBuilder.getDoubleColumnType() + " ) > " + upperBoundMap.get( orgUnitUid ) + " ) ) or ";
"and dv.periodid in (" + periodIds + ") " + "and ( " + "cast( dv.value as " + statementBuilder.getDoubleColumnType() + " ) < mm.minimumvalue " + "or cast( dv.value as " + statementBuilder.getDoubleColumnType() + " ) > mm.maximumvalue ) " + "and (";
Date endDate ) final String dbl = statementBuilder.getDoubleColumnType();
private List<AnalyticsTableColumn> getValueColumns() { final String dbl = statementBuilder.getDoubleColumnType(); return Lists.newArrayList( new AnalyticsTableColumn( quote( "daysxvalue" ), dbl, "daysxvalue" ), new AnalyticsTableColumn( quote( "daysno" ), "integer not null", "daysno" ), new AnalyticsTableColumn( quote( "value" ), dbl, "value" ), new AnalyticsTableColumn( quote( "textvalue" ), "text", "textvalue" ) ); }
"avg( cast( dv.value as " + statementBuilder.getDoubleColumnType() + " ) ) as average, " + "stddev_pop( cast( dv.value as " + statementBuilder.getDoubleColumnType() + " ) ) as standarddeviation " + "from datavalue dv " +
return statementBuilder.getDoubleColumnType();
return "cast(value as " + statementBuilder.getDoubleColumnType() + ")";
private List<AnalyticsTableColumn> getDimensionColumns( Program program ) final String dbl = statementBuilder.getDoubleColumnType(); final String numericClause = " and value " + statementBuilder.getRegexpMatch() + " '" + NUMERIC_LENIENT_REGEXP + "'"; final String dateClause = " and value " + statementBuilder.getRegexpMatch() + " '" + DATE_REGEXP + "'";
private List<AnalyticsTableColumn> getDimensionColumns( Program program ) final String dbl = statementBuilder.getDoubleColumnType(); final String numericClause = " and value " + statementBuilder.getRegexpMatch() + " '" + NUMERIC_LENIENT_REGEXP + "'"; final String dateClause = " and value " + statementBuilder.getRegexpMatch() + " '" + DATE_REGEXP + "'";