/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You under the Apache License, Version 2.0
 * (the "License"); you may not use this file except in compliance with
 * the License.  You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.apache.shardingsphere.core.rewrite.token.generator;

import com.google.common.base.Optional;
import org.apache.shardingsphere.core.optimize.statement.OptimizedStatement;
import org.apache.shardingsphere.core.parse.sql.statement.dml.SelectStatement;
import org.apache.shardingsphere.core.rewrite.builder.ParameterBuilder;
import org.apache.shardingsphere.core.rewrite.token.pojo.OrderByToken;
import org.apache.shardingsphere.core.rule.ShardingRule;

/**
 * Order by token generator.
 *
 * @author zhangliang
 */
public final class OrderByTokenGenerator implements OptionalSQLTokenGenerator<ShardingRule> {
    
    @Override
    public Optional<OrderByToken> generateSQLToken(final OptimizedStatement optimizedStatement, final ParameterBuilder parameterBuilder, final ShardingRule shardingRule) {
        if (!(optimizedStatement.getSQLStatement() instanceof SelectStatement)) {
            return Optional.absent();
        }
        if (((SelectStatement) optimizedStatement.getSQLStatement()).isToAppendOrderByItems()) {
            return Optional.of(new OrderByToken(((SelectStatement) optimizedStatement.getSQLStatement()).getGroupByLastIndex() + 1));
        }
        return Optional.absent();
    }
}

@@ -970,32 +970,218 @@
 mizedStatement;%0A
+import org.apache.shardingsphere.core.parse.sql.segment.dml.order.item.OrderByItemSegment;%0Aimport org.apache.shardingsphere.core.parse.sql.segment.dml.order.item.TextOrderByItemSegment;%0A
 import org.apach
@@ -1597,16 +1597,38 @@
 ingRule%3E
+, IgnoreForSingleRoute
  %7B%0A    %0A
@@ -2075,153 +2075,810 @@
 .of(
-new OrderByToken(((SelectStatement) optimizedStatement.getSQLStatement()).getGroupByLastIndex() + 1));%0A        %7D%0A        return Optional.absent()
+createOrderByToken(optimizedStatement));%0A        %7D%0A        return Optional.absent();%0A    %7D%0A    %0A    private OrderByToken createOrderByToken(final OptimizedStatement optimizedStatement) %7B%0A        OrderByToken result = new OrderByToken(((SelectStatement) optimizedStatement.getSQLStatement()).getGroupByLastIndex() + 1);%0A        SelectStatement selectStatement = (SelectStatement) optimizedStatement.getSQLStatement();%0A        for (OrderByItemSegment each : selectStatement.getOrderByItems()) %7B%0A            String columnLabel = each instanceof TextOrderByItemSegment ? ((TextOrderByItemSegment) each).getText() : String.valueOf(each.getIndex());%0A            result.getColumnLabels().add(columnLabel);%0A            result.getOrderDirections().add(each.getOrderDirection()); %0A        %7D%0A        return result
 ;%0A  

add createOrderByToken()