/* * Copyright 1999-2015 dangdang.com. *

* 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. *

*/ package com.dangdang.ddframe.rdb.common.sql; import com.dangdang.ddframe.rdb.common.jaxb.SqlShardingRule; import com.dangdang.ddframe.rdb.common.sql.base.AbstractSqlAssertTest; import com.dangdang.ddframe.rdb.common.sql.common.ShardingTestStrategy; import com.dangdang.ddframe.rdb.integrate.fixture.MultipleKeysModuloDatabaseShardingAlgorithm; import com.dangdang.ddframe.rdb.sharding.api.rule.BindingTableRule; import com.dangdang.ddframe.rdb.sharding.api.rule.DataSourceRule; import com.dangdang.ddframe.rdb.sharding.api.rule.ShardingRule; import com.dangdang.ddframe.rdb.sharding.api.rule.TableRule; import com.dangdang.ddframe.rdb.sharding.api.strategy.database.DatabaseShardingStrategy; import com.dangdang.ddframe.rdb.sharding.api.strategy.table.NoneTableShardingAlgorithm; import com.dangdang.ddframe.rdb.sharding.api.strategy.table.TableShardingStrategy; import com.dangdang.ddframe.rdb.sharding.constant.DatabaseType; import com.dangdang.ddframe.rdb.sharding.jdbc.core.datasource.ShardingDataSource; import com.dangdang.ddframe.rdb.sharding.keygen.fixture.IncrementKeyGenerator; import org.junit.AfterClass; import org.junit.Ignore; import org.junit.runner.RunWith; import org.junit.runners.Parameterized; import javax.sql.DataSource; import java.util.Arrays; import java.util.Collections; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.Set; @RunWith(Parameterized.class) @Ignore public class ShardingDatabaseOnlyTest extends AbstractSqlAssertTest { private static boolean isShutdown; private static Map shardingDataSources = new HashMap<>(); public ShardingDatabaseOnlyTest(final String testCaseName, final String sql, final Set types, final List sqlShardingRules) { super(testCaseName, sql, types, sqlShardingRules); } @Override protected ShardingTestStrategy getShardingStrategy() { return ShardingTestStrategy.db; } @Override protected List getDataSetFiles() { return Arrays.asList( "integrate/dataset/db/init/db_0.xml", "integrate/dataset/db/init/db_1.xml", "integrate/dataset/db/init/db_2.xml", "integrate/dataset/db/init/db_3.xml", "integrate/dataset/db/init/db_4.xml", "integrate/dataset/db/init/db_5.xml", "integrate/dataset/db/init/db_6.xml", "integrate/dataset/db/init/db_7.xml", "integrate/dataset/db/init/db_8.xml", "integrate/dataset/db/init/db_9.xml"); } @Override protected final Map getShardingDataSources() { if (!shardingDataSources.isEmpty() && !isShutdown) { return shardingDataSources; } isShutdown = false; Map> dataSourceMap = createDataSourceMap(); for (Map.Entry> each : dataSourceMap.entrySet()) { DataSourceRule dataSourceRule = new DataSourceRule(each.getValue()); TableRule orderTableRule = TableRule.builder("t_order").dataSourceRule(dataSourceRule).generateKeyColumn("order_id", IncrementKeyGenerator.class).build(); TableRule orderItemTableRule = TableRule.builder("t_order_item").dataSourceRule(dataSourceRule).build(); ShardingRule shardingRule = ShardingRule.builder().dataSourceRule(dataSourceRule).tableRules(Arrays.asList(orderTableRule, orderItemTableRule)) .bindingTableRules(Collections.singletonList(new BindingTableRule(Arrays.asList(orderTableRule, orderItemTableRule)))) .databaseShardingStrategy(new DatabaseShardingStrategy(Collections.singletonList("user_id"), new MultipleKeysModuloDatabaseShardingAlgorithm())) .tableShardingStrategy(new TableShardingStrategy(Collections.singletonList("order_id"), new NoneTableShardingAlgorithm())).build(); shardingDataSources.put(each.getKey(), new ShardingDataSource(shardingRule)); } return shardingDataSources; } @AfterClass public static void clear() { isShutdown = true; if (!shardingDataSources.isEmpty()) { for (ShardingDataSource each : shardingDataSources.values()) { each.close(); } } } }