public SQLOrderBy(SQLExpr expr){ SQLSelectOrderByItem item = new SQLSelectOrderByItem(expr); addItem(item); }
public void addItem(SQLExpr expr, SQLOrderingSpecification type) { SQLSelectOrderByItem item = createItem(); item.setExpr(expr); item.setType(type); addItem(item); }
@Override public SQLSelectBuilderImpl orderBy(String... columns) { SQLSelect select = this.getSQLSelect(); SQLOrderBy orderBy = select.getOrderBy(); if (orderBy == null) { orderBy = createOrderBy(); select.setOrderBy(orderBy); } for (String column : columns) { SQLSelectOrderByItem orderByItem = SQLUtils.toOrderByItem(column, dbType); orderBy.addItem(orderByItem); } return this; }
public SQLOrderBy(SQLExpr expr){ SQLSelectOrderByItem item = new SQLSelectOrderByItem(expr); addItem(item); }
public void addItem(SQLExpr expr, SQLOrderingSpecification type) { SQLSelectOrderByItem item = createItem(); item.setExpr(expr); item.setType(type); addItem(item); }
@Override public SQLSelectBuilderImpl orderBy(String... columns) { SQLSelect select = this.getSQLSelect(); SQLOrderBy orderBy = select.getOrderBy(); if (orderBy == null) { orderBy = createOrderBy(); select.setOrderBy(orderBy); } for (String column : columns) { SQLSelectOrderByItem orderByItem = SQLUtils.toOrderByItem(column, dbType); orderBy.addItem(orderByItem); } return this; }
@Override public SQLExpr toExpression() { SQLAggregateExpr aggregate = new SQLAggregateExpr(funcName()); if (hasWithDistinct()) { aggregate.setOption(SQLAggregateOption.DISTINCT); } if (orders != null) { SQLOrderBy orderBy = new SQLOrderBy(); for (Order order : orders) { SQLSelectOrderByItem orderItem = new SQLSelectOrderByItem(order.getItem().toExpression()); orderItem.setType(order.getSortOrder()); orderBy.addItem(orderItem); } aggregate.putAttribute(ItemFuncKeyWord.ORDER_BY, orderBy); } for (Item arg : args) { aggregate.addArgument(arg.toExpression()); } if (seperator != null) { SQLCharExpr sep = new SQLCharExpr(seperator); aggregate.putAttribute(ItemFuncKeyWord.SEPARATOR, sep); } return aggregate; }