@Override public String toSql(boolean includeSchemaInColumnPaths) { final String sameQueryAlias = _selectItem.getSameQueryAlias(includeSchemaInColumnPaths); return sameQueryAlias; }
@Override public String toSql(boolean includeSchemaInColumnPaths) { final String sameQueryAlias = _selectItem.getSameQueryAlias(includeSchemaInColumnPaths); return sameQueryAlias; }
public String getSameQueryAlias() { return getSameQueryAlias(false); }
public String getSameQueryAlias() { return getSameQueryAlias(false); }
@Override public String toSql(boolean includeSchemaInColumnPaths) { StringBuilder sb = new StringBuilder(); sb.append(_selectItem.getSameQueryAlias(includeSchemaInColumnPaths) + ' '); sb.append(_direction); return sb.toString(); }
@Override public String toSql(boolean includeSchemaInColumnPaths) { StringBuilder sb = new StringBuilder(); sb.append(_selectItem.getSameQueryAlias(includeSchemaInColumnPaths) + ' '); sb.append(_direction); return sb.toString(); }
/** * Rewrites a (non-compound) {@link FilterItem} when it's operand has already been rewritten into a SQL literal. * * @param item * @param operandLiteral * @return */ protected String rewriteFilterItemWithOperandLiteral(FilterItem item, String operandLiteral) { final OperatorType operator = item.getOperator(); final SelectItem selectItem = item.getSelectItem(); final StringBuilder sb = new StringBuilder(); sb.append(selectItem.getSameQueryAlias(false)); FilterItem.appendOperator(sb, item.getOperand(), operator); sb.append(operandLiteral); return sb.toString(); }
/** * Rewrites a (non-compound) {@link FilterItem} when it's operand has already been rewritten into a SQL literal. * * @param item * @param operandLiteral * @return */ protected String rewriteFilterItemWithOperandLiteral(FilterItem item, String operandLiteral) { final OperatorType operator = item.getOperator(); final SelectItem selectItem = item.getSelectItem(); final StringBuilder sb = new StringBuilder(); sb.append(selectItem.getSameQueryAlias(false)); FilterItem.appendOperator(sb, item.getOperand(), operator); sb.append(operandLiteral); return sb.toString(); }
sb.append(_selectItem.getSameQueryAlias(includeSchemaInColumnPaths)); .getSameQueryAlias(includeSchemaInColumnPaths); sb.append(selectItemString); } else {
sb.append(_selectItem.getSameQueryAlias(includeSchemaInColumnPaths)); .getSameQueryAlias(includeSchemaInColumnPaths); sb.append(selectItemString); } else {
@Override public String rewriteFilterItem(FilterItem item) { final SelectItem selectItem = item.getSelectItem(); final Object itemOperand = item.getOperand(); final OperatorType operator = item.getOperator(); if (null != selectItem && itemOperand != null) { ColumnType columnType = selectItem.getExpectedColumnType(); if (columnType != null) { if (columnType.isTimeBased()) { // special logic for DB2 based time operands. StringBuilder sb = new StringBuilder(); sb.append(selectItem.getSameQueryAlias(true)); final Object operand = FilterItem.appendOperator(sb, itemOperand, operator); if (operand instanceof SelectItem) { final String selectItemString = ((SelectItem) operand).getSameQueryAlias(true); sb.append(selectItemString); } else { Date date = TimeComparator.toDate(itemOperand); if (date == null) { throw new IllegalStateException("Could not convert " + itemOperand + " to date"); } final String sqlValue = FormatHelper.formatSqlTime(columnType, date, true, "('", "')"); sb.append(sqlValue); } return sb.toString(); } } } return super.rewriteFilterItem(item); }
@Override public String rewriteFilterItem(FilterItem item) { final SelectItem selectItem = item.getSelectItem(); final Object itemOperand = item.getOperand(); final OperatorType operator = item.getOperator(); if (null != selectItem && itemOperand != null) { ColumnType columnType = selectItem.getExpectedColumnType(); if (columnType != null) { if (columnType.isTimeBased()) { // special logic for DB2 based time operands. StringBuilder sb = new StringBuilder(); sb.append(selectItem.getSameQueryAlias(true)); final Object operand = FilterItem.appendOperator(sb, itemOperand, operator); if (operand instanceof SelectItem) { final String selectItemString = ((SelectItem) operand).getSameQueryAlias(true); sb.append(selectItemString); } else { Date date = TimeComparator.toDate(itemOperand); if (date == null) { throw new IllegalStateException("Could not convert " + itemOperand + " to date"); } final String sqlValue = FormatHelper.formatSqlTime(columnType, date, true, "('", "')"); sb.append(sqlValue); } return sb.toString(); } } } return super.rewriteFilterItem(item); }
if ("TIMESTAMP".equalsIgnoreCase(nativeType) || "DATETIME".equalsIgnoreCase(nativeType)) { final StringBuilder sb = new StringBuilder(); sb.append(selectItem.getSameQueryAlias(true));
if ("TIMESTAMP".equalsIgnoreCase(nativeType) || "DATETIME".equalsIgnoreCase(nativeType)) { final StringBuilder sb = new StringBuilder(); sb.append(selectItem.getSameQueryAlias(true));