public List<SelectItem> getEvaluatedSelectItems() { final List<SelectItem> result = new ArrayList<SelectItem>(); final List<OrderByItem> items = getItems(); for (OrderByItem item : items) { result.add(item.getSelectItem()); } return result; }
@Override public boolean isFirstRowSupported(final Query query) { return isSupportedVersion(_databaseProductName, _databaseSupportedVersion) && !query.getOrderByClause() .isEmpty(); }
public Query orderBy(OrderByItem... items) { _orderByClause.addItems(items); return this; }
protected String rewriteOrderByClause(Query query, OrderByClause orderByClause) { StringBuilder sb = new StringBuilder(); if (orderByClause.getItemCount() > 0) { sb.append(AbstractQueryClause.PREFIX_ORDER_BY); List<OrderByItem> items = orderByClause.getItems(); for (int i = 0; i < items.size(); i++) { OrderByItem item = items.get(i); if (i != 0) { sb.append(AbstractQueryClause.DELIM_COMMA); } sb.append(rewriteOrderByItem(query, item)); } } return sb.toString(); }
countQuery.setFirstRow(null); countQuery.getSelectClause().removeItems(); countQuery.getOrderByClause().removeItems(); countQuery.selectCount(); countQuery.getSelectClause().getItem(0).setFunctionApproximationAllowed(true);
final List<SelectItem> groupBySelectItems = query.getGroupByClause().getEvaluatedSelectItems(); final List<SelectItem> havingSelectItems = query.getHavingClause().getEvaluatedSelectItems(); final List<SelectItem> orderBySelectItems = query.getOrderByClause().getEvaluatedSelectItems(); final List<OrderByItem> orderByItems = query.getOrderByClause().getItems();
public static boolean isSplittable(Query q) { if (q.getOrderByClause().getItemCount() != 0) { return false; } return true; }
public Query() { _selectClause = new SelectClause(this); _fromClause = new FromClause(this); _whereClause = new FilterClause(this, AbstractQueryClause.PREFIX_WHERE); _groupByClause = new GroupByClause(this); _havingClause = new FilterClause(this, AbstractQueryClause.PREFIX_HAVING); _orderByClause = new OrderByClause(this); }
protected String toSql(boolean includeSchemaInColumnPaths) { final StringBuilder sb = new StringBuilder(); sb.append(_selectClause.toSql(includeSchemaInColumnPaths)); sb.append(_fromClause.toSql(includeSchemaInColumnPaths)); sb.append(_whereClause.toSql(includeSchemaInColumnPaths)); sb.append(_groupByClause.toSql(includeSchemaInColumnPaths)); sb.append(_havingClause.toSql(includeSchemaInColumnPaths)); sb.append(_orderByClause.toSql(includeSchemaInColumnPaths)); return sb.toString(); }
if (!getScalarFunctionSelectItems(query.getOrderByClause().getEvaluatedSelectItems()).isEmpty()) { return true;
countQuery.setFirstRow(null); countQuery.getSelectClause().removeItems(); countQuery.getOrderByClause().removeItems(); countQuery.selectCount(); countQuery.getSelectClause().getItem(0).setFunctionApproximationAllowed(true);
protected String rewriteOrderByClause(Query query, OrderByClause orderByClause) { StringBuilder sb = new StringBuilder(); if (orderByClause.getItemCount() > 0) { sb.append(AbstractQueryClause.PREFIX_ORDER_BY); List<OrderByItem> items = orderByClause.getItems(); for (int i = 0; i < items.size(); i++) { OrderByItem item = items.get(i); if (i != 0) { sb.append(AbstractQueryClause.DELIM_COMMA); } sb.append(rewriteOrderByItem(query, item)); } } return sb.toString(); }
final List<SelectItem> groupBySelectItems = query.getGroupByClause().getEvaluatedSelectItems(); final List<SelectItem> havingSelectItems = query.getHavingClause().getEvaluatedSelectItems(); final List<SelectItem> orderBySelectItems = query.getOrderByClause().getEvaluatedSelectItems(); final List<OrderByItem> orderByItems = query.getOrderByClause().getItems();
public static boolean isSplittable(Query q) { if (q.getOrderByClause().getItemCount() != 0) { return false; } return true; }
public Query() { _selectClause = new SelectClause(this); _fromClause = new FromClause(this); _whereClause = new FilterClause(this, AbstractQueryClause.PREFIX_WHERE); _groupByClause = new GroupByClause(this); _havingClause = new FilterClause(this, AbstractQueryClause.PREFIX_HAVING); _orderByClause = new OrderByClause(this); }
protected String toSql(boolean includeSchemaInColumnPaths) { final StringBuilder sb = new StringBuilder(); sb.append(_selectClause.toSql(includeSchemaInColumnPaths)); sb.append(_fromClause.toSql(includeSchemaInColumnPaths)); sb.append(_whereClause.toSql(includeSchemaInColumnPaths)); sb.append(_groupByClause.toSql(includeSchemaInColumnPaths)); sb.append(_havingClause.toSql(includeSchemaInColumnPaths)); sb.append(_orderByClause.toSql(includeSchemaInColumnPaths)); return sb.toString(); }
if (!getScalarFunctionSelectItems(query.getOrderByClause().getEvaluatedSelectItems()).isEmpty()) { return true;
@Override public boolean isFirstRowSupported(final Query query) { return isSupportedVersion(_databaseProductName, _databaseSupportedVersion) && !query.getOrderByClause() .isEmpty(); }
public List<SelectItem> getEvaluatedSelectItems() { final List<SelectItem> result = new ArrayList<SelectItem>(); final List<OrderByItem> items = getItems(); for (OrderByItem item : items) { result.add(item.getSelectItem()); } return result; }
final String rowOver = "ROW_NUMBER() " + "OVER(" + rewrittenOrderByClause + ")"; innerQuery.select(new SelectItem(rowOver, "metamodel_row_number")); innerQuery.getOrderByClause().removeItems();