You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2024/11/03 06:21:17 UTC
(shardingsphere) branch master updated: Refactor BroadcastSQLRouter (#33507)
This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new f04777b6ece Refactor BroadcastSQLRouter (#33507)
f04777b6ece is described below
commit f04777b6ece52dda92c38341a10b331026acd042
Author: Liang Zhang <zh...@apache.org>
AuthorDate: Sun Nov 3 14:21:10 2024 +0800
Refactor BroadcastSQLRouter (#33507)
* Add more test cases on BroadcastSQLRouter
* Refactor BroadcastSQLRouter
---
.../broadcast/route/BroadcastSQLRouter.java | 39 ++---
.../BroadcastDatabaseBroadcastRouteEngine.java | 4 +-
.../BroadcastInstanceBroadcastRouteEngine.java | 4 +-
.../type/ignore/BroadcastIgnoreRouteEngine.java | 2 +-
.../type/unicast/BroadcastUnicastRouteEngine.java | 4 +-
.../broadcast/route/BroadcastSQLRouterTest.java | 117 ++++++++++++++
.../broadcast/route/BroadcastSqlRouterTest.java | 177 ---------------------
7 files changed, 144 insertions(+), 203 deletions(-)
diff --git a/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/BroadcastSQLRouter.java b/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/BroadcastSQLRouter.java
index e2034a285a5..3922375cda0 100644
--- a/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/BroadcastSQLRouter.java
+++ b/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/BroadcastSQLRouter.java
@@ -77,24 +77,25 @@ public final class BroadcastSQLRouter implements EntranceSQLRouter<BroadcastRule
SQLStatementContext sqlStatementContext = queryContext.getSqlStatementContext();
SQLStatement sqlStatement = sqlStatementContext.getSqlStatement();
if (sqlStatement instanceof TCLStatement) {
- routeToAllDatabase(routeContext, rule);
- }
- if (sqlStatement instanceof DDLStatement) {
+ decorateRouteContextWhenTCLStatement(routeContext, rule);
+ } else if (sqlStatement instanceof DDLStatement) {
decorateRouteContextWhenDDLStatement(routeContext, queryContext, database, rule);
- }
- if (sqlStatement instanceof DALStatement && isResourceGroupStatement(sqlStatement)) {
- routeToAllDatabaseInstance(routeContext, database, rule);
- }
- if (sqlStatement instanceof DCLStatement && !isDCLForSingleTable(queryContext.getSqlStatementContext())) {
- routeToAllDatabaseInstance(routeContext, database, rule);
+ } else if (sqlStatement instanceof DALStatement && isResourceGroupStatement(sqlStatement)) {
+ routeToAllDatabaseInstances(routeContext, database, rule);
+ } else if (sqlStatement instanceof DCLStatement && !isDCLForSingleTable(queryContext.getSqlStatementContext())) {
+ routeToAllDatabaseInstances(routeContext, database, rule);
}
}
+ private void decorateRouteContextWhenTCLStatement(final RouteContext routeContext, final BroadcastRule rule) {
+ routeToAllDatabases(routeContext, rule);
+ }
+
private void decorateRouteContextWhenDDLStatement(final RouteContext routeContext, final QueryContext queryContext, final ShardingSphereDatabase database, final BroadcastRule rule) {
SQLStatementContext sqlStatementContext = queryContext.getSqlStatementContext();
if (sqlStatementContext instanceof CursorAvailable) {
if (sqlStatementContext instanceof CloseStatementContext && ((CloseStatementContext) sqlStatementContext).getSqlStatement().isCloseAll()) {
- routeToAllDatabase(routeContext, rule);
+ routeToAllDatabases(routeContext, rule);
}
return;
}
@@ -105,17 +106,17 @@ public final class BroadcastSQLRouter implements EntranceSQLRouter<BroadcastRule
boolean functionStatement = sqlStatement instanceof CreateFunctionStatement || sqlStatement instanceof AlterFunctionStatement || sqlStatement instanceof DropFunctionStatement;
boolean procedureStatement = sqlStatement instanceof CreateProcedureStatement || sqlStatement instanceof AlterProcedureStatement || sqlStatement instanceof DropProcedureStatement;
if (functionStatement || procedureStatement) {
- routeToAllDatabase(routeContext, rule);
+ routeToAllDatabases(routeContext, rule);
return;
}
// TODO BEGIN extract db route logic to common database router, eg: DCL in instance route @duanzhengqiang
if (sqlStatement instanceof CreateTablespaceStatement || sqlStatement instanceof AlterTablespaceStatement || sqlStatement instanceof DropTablespaceStatement) {
- routeToAllDatabaseInstance(routeContext, database, rule);
+ routeToAllDatabaseInstances(routeContext, database, rule);
}
// TODO END extract db route logic to common database router, eg: DCL in instance route
Collection<String> tableNames = sqlStatementContext instanceof TableAvailable ? getTableNames((TableAvailable) sqlStatementContext) : Collections.emptyList();
if (rule.isAllBroadcastTables(tableNames)) {
- routeToAllDatabaseInstance(routeContext, database, rule);
+ routeToAllDatabaseInstances(routeContext, database, rule);
}
}
@@ -151,19 +152,19 @@ public final class BroadcastSQLRouter implements EntranceSQLRouter<BroadcastRule
return false;
}
- private void routeToAllDatabaseInstance(final RouteContext routeContext, final ShardingSphereDatabase database, final BroadcastRule rule) {
+ private void routeToAllDatabases(final RouteContext routeContext, final BroadcastRule rule) {
routeContext.getRouteUnits().clear();
for (String each : rule.getDataSourceNames()) {
- if (database.getResourceMetaData().getAllInstanceDataSourceNames().contains(each)) {
- routeContext.getRouteUnits().add(new RouteUnit(new RouteMapper(each, each), Collections.emptyList()));
- }
+ routeContext.getRouteUnits().add(new RouteUnit(new RouteMapper(each, each), Collections.emptyList()));
}
}
- private void routeToAllDatabase(final RouteContext routeContext, final BroadcastRule rule) {
+ private void routeToAllDatabaseInstances(final RouteContext routeContext, final ShardingSphereDatabase database, final BroadcastRule rule) {
routeContext.getRouteUnits().clear();
for (String each : rule.getDataSourceNames()) {
- routeContext.getRouteUnits().add(new RouteUnit(new RouteMapper(each, each), Collections.emptyList()));
+ if (database.getResourceMetaData().getAllInstanceDataSourceNames().contains(each)) {
+ routeContext.getRouteUnits().add(new RouteUnit(new RouteMapper(each, each), Collections.emptyList()));
+ }
}
}
diff --git a/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/broadcast/BroadcastDatabaseBroadcastRouteEngine.java b/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/broadcast/BroadcastDatabaseBroadcastRouteEngine.java
index 8fe9a82bd5f..9269f64e419 100644
--- a/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/broadcast/BroadcastDatabaseBroadcastRouteEngine.java
+++ b/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/broadcast/BroadcastDatabaseBroadcastRouteEngine.java
@@ -33,8 +33,8 @@ import java.util.Collections;
public final class BroadcastDatabaseBroadcastRouteEngine implements BroadcastRouteEngine {
@Override
- public RouteContext route(final RouteContext routeContext, final BroadcastRule broadcastRule) {
- for (String each : broadcastRule.getDataSourceNames()) {
+ public RouteContext route(final RouteContext routeContext, final BroadcastRule rule) {
+ for (String each : rule.getDataSourceNames()) {
routeContext.getRouteUnits().add(new RouteUnit(new RouteMapper(each, each), Collections.emptyList()));
}
return routeContext;
diff --git a/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/broadcast/BroadcastInstanceBroadcastRouteEngine.java b/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/broadcast/BroadcastInstanceBroadcastRouteEngine.java
index 3587545e58a..3cb9ae7af77 100644
--- a/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/broadcast/BroadcastInstanceBroadcastRouteEngine.java
+++ b/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/broadcast/BroadcastInstanceBroadcastRouteEngine.java
@@ -38,9 +38,9 @@ public final class BroadcastInstanceBroadcastRouteEngine implements BroadcastRou
private final ResourceMetaData resourceMetaData;
@Override
- public RouteContext route(final RouteContext routeContext, final BroadcastRule broadcastRule) {
+ public RouteContext route(final RouteContext routeContext, final BroadcastRule rule) {
RouteContext result = new RouteContext();
- for (String each : broadcastRule.getDataSourceNames()) {
+ for (String each : rule.getDataSourceNames()) {
if (resourceMetaData.getAllInstanceDataSourceNames().contains(each)) {
result.getRouteUnits().add(new RouteUnit(new RouteMapper(each, each), Collections.emptyList()));
}
diff --git a/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/ignore/BroadcastIgnoreRouteEngine.java b/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/ignore/BroadcastIgnoreRouteEngine.java
index 66bd7365b32..4dc1a749507 100644
--- a/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/ignore/BroadcastIgnoreRouteEngine.java
+++ b/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/ignore/BroadcastIgnoreRouteEngine.java
@@ -27,7 +27,7 @@ import org.apache.shardingsphere.infra.route.context.RouteContext;
public final class BroadcastIgnoreRouteEngine implements BroadcastRouteEngine {
@Override
- public RouteContext route(final RouteContext routeContext, final BroadcastRule broadcastRule) {
+ public RouteContext route(final RouteContext routeContext, final BroadcastRule rule) {
return routeContext;
}
}
diff --git a/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/unicast/BroadcastUnicastRouteEngine.java b/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/unicast/BroadcastUnicastRouteEngine.java
index 8bffcfe41e9..444116de5a0 100644
--- a/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/unicast/BroadcastUnicastRouteEngine.java
+++ b/features/broadcast/core/src/main/java/org/apache/shardingsphere/broadcast/route/engine/type/unicast/BroadcastUnicastRouteEngine.java
@@ -49,8 +49,8 @@ public final class BroadcastUnicastRouteEngine implements BroadcastRouteEngine {
private final ConnectionContext connectionContext;
@Override
- public RouteContext route(final RouteContext routeContext, final BroadcastRule broadcastRule) {
- RouteMapper dataSourceMapper = getDataSourceRouteMapper(broadcastRule.getDataSourceNames());
+ public RouteContext route(final RouteContext routeContext, final BroadcastRule rule) {
+ RouteMapper dataSourceMapper = getDataSourceRouteMapper(rule.getDataSourceNames());
routeContext.getRouteUnits().add(new RouteUnit(dataSourceMapper, createTableRouteMappers()));
return routeContext;
}
diff --git a/features/broadcast/core/src/test/java/org/apache/shardingsphere/broadcast/route/BroadcastSQLRouterTest.java b/features/broadcast/core/src/test/java/org/apache/shardingsphere/broadcast/route/BroadcastSQLRouterTest.java
new file mode 100644
index 00000000000..5caad2ffe31
--- /dev/null
+++ b/features/broadcast/core/src/test/java/org/apache/shardingsphere/broadcast/route/BroadcastSQLRouterTest.java
@@ -0,0 +1,117 @@
+/*
+ * 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.broadcast.route;
+
+import com.google.common.collect.Lists;
+import org.apache.shardingsphere.broadcast.config.BroadcastRuleConfiguration;
+import org.apache.shardingsphere.broadcast.route.engine.BroadcastRouteEngineFactory;
+import org.apache.shardingsphere.broadcast.route.engine.type.BroadcastRouteEngine;
+import org.apache.shardingsphere.broadcast.rule.BroadcastRule;
+import org.apache.shardingsphere.infra.binder.context.statement.ddl.CreateTableStatementContext;
+import org.apache.shardingsphere.infra.config.props.ConfigurationProperties;
+import org.apache.shardingsphere.infra.database.core.DefaultDatabase;
+import org.apache.shardingsphere.infra.hint.HintValueContext;
+import org.apache.shardingsphere.infra.metadata.ShardingSphereMetaData;
+import org.apache.shardingsphere.infra.metadata.database.ShardingSphereDatabase;
+import org.apache.shardingsphere.infra.metadata.database.resource.unit.StorageUnit;
+import org.apache.shardingsphere.infra.metadata.database.rule.RuleMetaData;
+import org.apache.shardingsphere.infra.route.SQLRouter;
+import org.apache.shardingsphere.infra.route.context.RouteContext;
+import org.apache.shardingsphere.infra.route.context.RouteMapper;
+import org.apache.shardingsphere.infra.route.context.RouteUnit;
+import org.apache.shardingsphere.infra.session.connection.ConnectionContext;
+import org.apache.shardingsphere.infra.session.query.QueryContext;
+import org.apache.shardingsphere.infra.spi.type.ordered.OrderedSPILoader;
+import org.apache.shardingsphere.sql.parser.statement.core.segment.generic.table.SimpleTableSegment;
+import org.apache.shardingsphere.sql.parser.statement.core.segment.generic.table.TableNameSegment;
+import org.apache.shardingsphere.sql.parser.statement.core.statement.ddl.CreateTableStatement;
+import org.apache.shardingsphere.sql.parser.statement.core.value.identifier.IdentifierValue;
+import org.apache.shardingsphere.sql.parser.statement.mysql.ddl.MySQLCreateTableStatement;
+import org.apache.shardingsphere.test.fixture.jdbc.MockedDataSource;
+import org.apache.shardingsphere.test.mock.AutoMockExtension;
+import org.apache.shardingsphere.test.mock.StaticMockSettings;
+import org.junit.jupiter.api.Test;
+import org.junit.jupiter.api.extension.ExtendWith;
+
+import java.util.Collections;
+import java.util.Iterator;
+import java.util.LinkedList;
+import java.util.Optional;
+import java.util.Properties;
+
+import static org.hamcrest.CoreMatchers.is;
+import static org.hamcrest.MatcherAssert.assertThat;
+import static org.mockito.ArgumentMatchers.any;
+import static org.mockito.ArgumentMatchers.eq;
+import static org.mockito.Mockito.RETURNS_DEEP_STUBS;
+import static org.mockito.Mockito.mock;
+import static org.mockito.Mockito.verify;
+import static org.mockito.Mockito.when;
+
+@ExtendWith(AutoMockExtension.class)
+@StaticMockSettings(BroadcastRouteEngineFactory.class)
+class BroadcastSQLRouterTest {
+
+ @Test
+ void assertCreateRouteContext() {
+ QueryContext queryContext = mock(QueryContext.class);
+ BroadcastRule rule = mock(BroadcastRule.class);
+ ShardingSphereDatabase database = mock(ShardingSphereDatabase.class);
+ BroadcastRouteEngine routeEngine = mock(BroadcastRouteEngine.class);
+ when(BroadcastRouteEngineFactory.newInstance(rule, database, queryContext)).thenReturn(routeEngine);
+ getSQLRouter(rule).createRouteContext(queryContext, mock(RuleMetaData.class), database, rule, new ConfigurationProperties(new Properties()));
+ verify(routeEngine).route(any(), eq(rule));
+ }
+
+ @Test
+ void assertDecorateBroadcastRouteContextWithSingleDataSource() {
+ BroadcastRuleConfiguration currentConfig = mock(BroadcastRuleConfiguration.class);
+ when(currentConfig.getTables()).thenReturn(Collections.singleton("t_order"));
+ BroadcastRule rule = new BroadcastRule(currentConfig, Collections.singletonMap("foo_ds", new MockedDataSource()), Collections.emptyList());
+ RouteContext routeContext = new RouteContext();
+ routeContext.getRouteUnits().add(new RouteUnit(new RouteMapper("foo_ds", "foo_ds"), Lists.newArrayList()));
+ BroadcastSQLRouter sqlRouter = getSQLRouter(rule);
+ sqlRouter.decorateRouteContext(routeContext, createQueryContext(), mockSingleDatabase(), rule, new ConfigurationProperties(new Properties()));
+ Iterator<String> routedDataSourceNames = routeContext.getActualDataSourceNames().iterator();
+ assertThat(routedDataSourceNames.next(), is("foo_ds"));
+ }
+
+ private BroadcastSQLRouter getSQLRouter(final BroadcastRule rule) {
+ return (BroadcastSQLRouter) OrderedSPILoader.getServices(SQLRouter.class, Collections.singleton(rule)).get(rule);
+ }
+
+ private ShardingSphereDatabase mockSingleDatabase() {
+ ShardingSphereDatabase result = mock(ShardingSphereDatabase.class, RETURNS_DEEP_STUBS);
+ when(result.getResourceMetaData().getStorageUnits()).thenReturn(Collections.singletonMap("foo_ds", mock(StorageUnit.class)));
+ when(result.getResourceMetaData().getAllInstanceDataSourceNames()).thenReturn(Collections.singletonList("foo_ds"));
+ return result;
+ }
+
+ private QueryContext createQueryContext() {
+ CreateTableStatement createTableStatement = new MySQLCreateTableStatement(false);
+ createTableStatement.setTable(new SimpleTableSegment(new TableNameSegment(1, 2, new IdentifierValue("t_order"))));
+ return new QueryContext(new CreateTableStatementContext(createTableStatement, DefaultDatabase.LOGIC_NAME), "CREATE TABLE", new LinkedList<>(), new HintValueContext(),
+ mockConnectionContext(), mock(ShardingSphereMetaData.class));
+ }
+
+ private ConnectionContext mockConnectionContext() {
+ ConnectionContext result = mock(ConnectionContext.class);
+ when(result.getCurrentDatabaseName()).thenReturn(Optional.of(DefaultDatabase.LOGIC_NAME));
+ return result;
+ }
+}
diff --git a/features/broadcast/core/src/test/java/org/apache/shardingsphere/broadcast/route/BroadcastSqlRouterTest.java b/features/broadcast/core/src/test/java/org/apache/shardingsphere/broadcast/route/BroadcastSqlRouterTest.java
deleted file mode 100644
index 7361bf4a4d5..00000000000
--- a/features/broadcast/core/src/test/java/org/apache/shardingsphere/broadcast/route/BroadcastSqlRouterTest.java
+++ /dev/null
@@ -1,177 +0,0 @@
-/*
- * 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.broadcast.route;
-
-import com.google.common.collect.Lists;
-import org.apache.groovy.util.Maps;
-import org.apache.shardingsphere.broadcast.config.BroadcastRuleConfiguration;
-import org.apache.shardingsphere.broadcast.rule.BroadcastRule;
-import org.apache.shardingsphere.infra.binder.context.statement.ddl.CreateTableStatementContext;
-import org.apache.shardingsphere.infra.config.props.ConfigurationProperties;
-import org.apache.shardingsphere.infra.database.core.DefaultDatabase;
-import org.apache.shardingsphere.infra.datanode.DataNode;
-import org.apache.shardingsphere.infra.datasource.pool.props.domain.DataSourcePoolProperties;
-import org.apache.shardingsphere.infra.hint.HintValueContext;
-import org.apache.shardingsphere.infra.metadata.ShardingSphereMetaData;
-import org.apache.shardingsphere.infra.metadata.database.ShardingSphereDatabase;
-import org.apache.shardingsphere.infra.metadata.database.resource.node.StorageNode;
-import org.apache.shardingsphere.infra.metadata.database.resource.unit.StorageUnit;
-import org.apache.shardingsphere.infra.metadata.database.rule.RuleMetaData;
-import org.apache.shardingsphere.infra.metadata.database.schema.model.ShardingSphereSchema;
-import org.apache.shardingsphere.infra.route.SQLRouter;
-import org.apache.shardingsphere.infra.route.context.RouteContext;
-import org.apache.shardingsphere.infra.route.context.RouteMapper;
-import org.apache.shardingsphere.infra.route.context.RouteUnit;
-import org.apache.shardingsphere.infra.rule.attribute.datanode.DataNodeRuleAttribute;
-import org.apache.shardingsphere.infra.session.connection.ConnectionContext;
-import org.apache.shardingsphere.infra.session.query.QueryContext;
-import org.apache.shardingsphere.infra.spi.type.ordered.OrderedSPILoader;
-import org.apache.shardingsphere.sql.parser.statement.core.segment.generic.table.SimpleTableSegment;
-import org.apache.shardingsphere.sql.parser.statement.core.segment.generic.table.TableNameSegment;
-import org.apache.shardingsphere.sql.parser.statement.core.statement.ddl.CreateTableStatement;
-import org.apache.shardingsphere.sql.parser.statement.core.value.identifier.IdentifierValue;
-import org.apache.shardingsphere.sql.parser.statement.mysql.ddl.MySQLCreateTableStatement;
-import org.apache.shardingsphere.test.fixture.jdbc.MockedDataSource;
-import org.junit.jupiter.api.Test;
-
-import javax.sql.DataSource;
-import java.sql.Connection;
-import java.sql.SQLException;
-import java.util.ArrayList;
-import java.util.Collections;
-import java.util.HashMap;
-import java.util.Iterator;
-import java.util.LinkedList;
-import java.util.List;
-import java.util.Map;
-import java.util.Optional;
-import java.util.Properties;
-
-import static org.hamcrest.CoreMatchers.is;
-import static org.hamcrest.MatcherAssert.assertThat;
-import static org.junit.jupiter.api.Assertions.assertFalse;
-import static org.mockito.ArgumentMatchers.any;
-import static org.mockito.Mockito.RETURNS_DEEP_STUBS;
-import static org.mockito.Mockito.mock;
-import static org.mockito.Mockito.when;
-
-class BroadcastSqlRouterTest {
-
- @Test
- void assertCreateBroadcastRouteContextWithMultiDataSource() throws SQLException {
- BroadcastRuleConfiguration currentConfig = mock(BroadcastRuleConfiguration.class);
- when(currentConfig.getTables()).thenReturn(Collections.singleton("t_order"));
- BroadcastRule broadcastRule = new BroadcastRule(currentConfig, createMultiDataSourceMap(), Collections.emptyList());
- RouteContext routeContext = new BroadcastSQLRouter().createRouteContext(createQueryContext(), mock(RuleMetaData.class), mockDatabaseWithMultipleResources(), broadcastRule,
- new ConfigurationProperties(new Properties()));
- List<RouteUnit> routeUnits = new ArrayList<>(routeContext.getRouteUnits());
- assertThat(routeContext.getRouteUnits().size(), is(2));
- assertThat(routeUnits.get(0).getDataSourceMapper().getLogicName(), is(routeUnits.get(0).getDataSourceMapper().getActualName()));
- assertThat(routeUnits.get(0).getTableMappers().size(), is(1));
- RouteMapper tableMapper = routeUnits.get(0).getTableMappers().iterator().next();
- assertThat(tableMapper.getActualName(), is("t_order"));
- assertThat(tableMapper.getLogicName(), is("t_order"));
- }
-
- @Test
- void assertCreateBroadcastRouteContextWithSingleDataSource() throws SQLException {
- BroadcastRuleConfiguration currentConfig = mock(BroadcastRuleConfiguration.class);
- when(currentConfig.getTables()).thenReturn(Collections.singleton("t_order"));
- BroadcastRule broadcastRule = new BroadcastRule(currentConfig, Collections.singletonMap("tmp_ds", new MockedDataSource(mockConnection())), Collections.emptyList());
- broadcastRule.getAttributes().getAttribute(DataNodeRuleAttribute.class).getAllDataNodes().put("t_order", Collections.singletonList(createDataNode("tmp_ds")));
- ShardingSphereDatabase database = mockSingleDatabase();
- RouteContext routeContext = new BroadcastSQLRouter().createRouteContext(
- createQueryContext(), mock(RuleMetaData.class), database, broadcastRule, new ConfigurationProperties(new Properties()));
- assertThat(routeContext.getRouteUnits().size(), is(1));
- RouteUnit routeUnit = routeContext.getRouteUnits().iterator().next();
- assertThat(routeUnit.getDataSourceMapper().getLogicName(), is("tmp_ds"));
- assertThat(routeUnit.getDataSourceMapper().getActualName(), is("tmp_ds"));
- assertFalse(routeUnit.getTableMappers().isEmpty());
- }
-
- @Test
- void assertDecorateBroadcastRouteContextWithSingleDataSource() {
- BroadcastRuleConfiguration currentConfig = mock(BroadcastRuleConfiguration.class);
- when(currentConfig.getTables()).thenReturn(Collections.singleton("t_order"));
- BroadcastRule broadcastRule = new BroadcastRule(currentConfig, Collections.singletonMap("foo_ds", new MockedDataSource()), Collections.emptyList());
- RouteContext routeContext = new RouteContext();
- routeContext.getRouteUnits().add(new RouteUnit(new RouteMapper("foo_ds", "foo_ds"), Lists.newArrayList()));
- BroadcastSQLRouter sqlRouter = (BroadcastSQLRouter) OrderedSPILoader.getServices(SQLRouter.class, Collections.singleton(broadcastRule)).get(broadcastRule);
- sqlRouter.decorateRouteContext(routeContext, createQueryContext(),
- mockSingleDatabase(), broadcastRule, new ConfigurationProperties(new Properties()));
- Iterator<String> routedDataSourceNames = routeContext.getActualDataSourceNames().iterator();
- assertThat(routedDataSourceNames.next(), is("foo_ds"));
- }
-
- private Connection mockConnection() throws SQLException {
- Connection result = mock(Connection.class, RETURNS_DEEP_STUBS);
- when(result.getMetaData().getURL()).thenReturn("jdbc:h2:mem:db");
- return result;
- }
-
- private ShardingSphereDatabase mockSingleDatabase() {
- ShardingSphereDatabase result = mock(ShardingSphereDatabase.class, RETURNS_DEEP_STUBS);
- when(result.getResourceMetaData().getStorageUnits()).thenReturn(Collections.singletonMap("foo_ds", mock(StorageUnit.class)));
- when(result.getResourceMetaData().getAllInstanceDataSourceNames()).thenReturn(Collections.singletonList("foo_ds"));
- return result;
- }
-
- private QueryContext createQueryContext() {
- CreateTableStatement createTableStatement = new MySQLCreateTableStatement(false);
- createTableStatement.setTable(new SimpleTableSegment(new TableNameSegment(1, 2, new IdentifierValue("t_order"))));
- return new QueryContext(new CreateTableStatementContext(createTableStatement, DefaultDatabase.LOGIC_NAME), "CREATE TABLE", new LinkedList<>(), new HintValueContext(),
- mockConnectionContext(), mock(ShardingSphereMetaData.class));
- }
-
- private ConnectionContext mockConnectionContext() {
- ConnectionContext result = mock(ConnectionContext.class);
- when(result.getCurrentDatabaseName()).thenReturn(Optional.of(DefaultDatabase.LOGIC_NAME));
- return result;
- }
-
- private Map<String, DataSource> createMultiDataSourceMap() throws SQLException {
- Map<String, DataSource> result = new HashMap<>(2, 1F);
- Connection connection = mockConnection();
- result.put("ds_0", new MockedDataSource(connection));
- result.put("ds_1", new MockedDataSource(connection));
- return result;
- }
-
- private DataNode createDataNode(final String dataSourceName) {
- DataNode result = new DataNode(dataSourceName, "t_order");
- result.setSchemaName(DefaultDatabase.LOGIC_NAME);
- return result;
- }
-
- private ShardingSphereDatabase mockDatabaseWithMultipleResources() {
- Map<String, StorageUnit> storageUnits = new HashMap<>(2, 1F);
- DataSourcePoolProperties dataSourcePoolProps0 = mock(DataSourcePoolProperties.class, RETURNS_DEEP_STUBS);
- when(dataSourcePoolProps0.getConnectionPropertySynonyms().getStandardProperties()).thenReturn(Maps.of("url", "jdbc:mock://127.0.0.1/ds_0", "username", "test"));
- storageUnits.put("ds_0", new StorageUnit(mock(StorageNode.class), dataSourcePoolProps0, new MockedDataSource()));
- DataSourcePoolProperties dataSourcePoolProps1 = mock(DataSourcePoolProperties.class, RETURNS_DEEP_STUBS);
- when(dataSourcePoolProps1.getConnectionPropertySynonyms().getStandardProperties()).thenReturn(Maps.of("url", "jdbc:mock://127.0.0.1/ds_1", "username", "test"));
- storageUnits.put("ds_1", new StorageUnit(mock(StorageNode.class), dataSourcePoolProps1, new MockedDataSource()));
- ShardingSphereDatabase result = mock(ShardingSphereDatabase.class, RETURNS_DEEP_STUBS);
- when(result.getResourceMetaData().getStorageUnits()).thenReturn(storageUnits);
- when(result.getName()).thenReturn(DefaultDatabase.LOGIC_NAME);
- ShardingSphereSchema schema = mock(ShardingSphereSchema.class);
- when(schema.containsTable("t_order")).thenReturn(true);
- when(result.getSchema(any())).thenReturn(schema);
- return result;
- }
-}