/*
* Copyright 1999-2015 dangdang.com.
* <p>
* Licensed 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.
* </p>
*/
package com.dangdang.ddframe.rdb.sharding.router;
import com.dangdang.ddframe.rdb.sharding.api.HintManager;
import com.dangdang.ddframe.rdb.sharding.exception.SQLParserException;
import com.dangdang.ddframe.rdb.sharding.parser.result.router.Condition;
import java.util.Collection;
import java.util.Collections;
import java.util.List;
public abstract class AbstractDynamicRouteSqlTest extends AbstractBaseRouteSqlTest {
protected void assertSingleTarget(final List<ShardingValuePair> shardingValuePairs, final String originSql, final String targetDataSource, final String targetSQL) throws SQLParserException {
assertSingleTarget(shardingValuePairs, originSql, Collections.emptyList(), targetDataSource, targetSQL);
}
protected void assertSingleTarget(final List<ShardingValuePair> shardingValuePairs, final String originSql, final List<Object> parameters, final String targetDataSource, final String targetSQL)
throws SQLParserException {
assertMultipleTargets(shardingValuePairs, originSql, parameters, 1, Collections.singletonList(targetDataSource), Collections.singletonList(targetSQL));
}
protected void assertMultipleTargets(final List<ShardingValuePair> shardingValuePairs, final String originSql, final int expectedSize,
final Collection<String> targetDataSources, final Collection<String> targetSQLs) throws SQLParserException {
assertMultipleTargets(shardingValuePairs, originSql, Collections.emptyList(), expectedSize, targetDataSources, targetSQLs);
}
private void assertMultipleTargets(final List<ShardingValuePair> shardingValuePairs, final String originSql, final List<Object> parameters, final int expectedSize,
final Collection<String> targetDataSources, final Collection<String> targetSQLs) throws SQLParserException {
try (HintManager hintManager = HintManager.getInstance()) {
for (ShardingValuePair each : shardingValuePairs) {
hintManager.addDatabaseShardingValue(each.logicTable, "order_id", each.binaryOperator, each.shardingValue);
hintManager.addTableShardingValue(each.logicTable, "order_id", each.binaryOperator, each.shardingValue);
}
assertMultipleTargets(originSql, parameters, expectedSize, targetDataSources, targetSQLs);
}
}
protected static class ShardingValuePair {
private final String logicTable;
private final Condition.BinaryOperator binaryOperator;
private final Integer[] shardingValue;
protected ShardingValuePair(final String logicTable, final Integer... shardingValue) {
this(logicTable, Condition.BinaryOperator.EQUAL, shardingValue);
}
protected ShardingValuePair(final String logicTable, final Condition.BinaryOperator binaryOperator, final Integer... shardingValue) {
this.logicTable = logicTable;
this.binaryOperator = binaryOperator;
this.shardingValue = shardingValue;
}
}
}