You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by zh...@apache.org on 2021/05/11 10:13:02 UTC
[shardingsphere] branch master updated: Add tests for PostgreSQL
Proxy Query/Bind CommandExecutor (#10284)
This is an automated email from the ASF dual-hosted git repository.
zhangliang 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 b87b4e4 Add tests for PostgreSQL Proxy Query/Bind CommandExecutor (#10284)
b87b4e4 is described below
commit b87b4e43482e505ee56fa0ce45c5cb5e4709e26b
Author: 吴伟杰 <wu...@apache.org>
AuthorDate: Tue May 11 18:12:40 2021 +0800
Add tests for PostgreSQL Proxy Query/Bind CommandExecutor (#10284)
* Add test for PostgreSQLComBindExecutor
* Add test for PostgreSQLComQueryExecutor
---
.../binary/bind/PostgreSQLComBindExecutorTest.java | 165 +++++++++++++++++++++
.../query/text/PostgreSQLComQueryExecutorTest.java | 125 ++++++++++++++++
2 files changed, 290 insertions(+)
diff --git a/shardingsphere-proxy/shardingsphere-proxy-frontend/shardingsphere-proxy-frontend-postgresql/src/test/java/org/apache/shardingsphere/proxy/frontend/postgresql/command/query/binary/bind/PostgreSQLComBindExecutorTest.java b/shardingsphere-proxy/shardingsphere-proxy-frontend/shardingsphere-proxy-frontend-postgresql/src/test/java/org/apache/shardingsphere/proxy/frontend/postgresql/command/query/binary/bind/PostgreSQLComBindExecutorTest.java
new file mode 100644
index 0000000..b8af727
--- /dev/null
+++ b/shardingsphere-proxy/shardingsphere-proxy-frontend/shardingsphere-proxy-frontend-postgresql/src/test/java/org/apache/shardingsphere/proxy/frontend/postgresql/command/query/binary/bind/PostgreSQLComBindExecutorTest.java
@@ -0,0 +1,165 @@
+/*
+ * 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.proxy.frontend.postgresql.command.query.binary.bind;
+
+import lombok.SneakyThrows;
+import org.apache.shardingsphere.db.protocol.packet.DatabasePacket;
+import org.apache.shardingsphere.db.protocol.postgresql.packet.PostgreSQLPacket;
+import org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.PostgreSQLRowDescriptionPacket;
+import org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.bind.PostgreSQLBinaryResultSetRowPacket;
+import org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.bind.PostgreSQLBindCompletePacket;
+import org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.bind.PostgreSQLComBindPacket;
+import org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.text.PostgreSQLDataRowPacket;
+import org.apache.shardingsphere.db.protocol.postgresql.packet.generic.PostgreSQLCommandCompletePacket;
+import org.apache.shardingsphere.proxy.backend.communication.DatabaseCommunicationEngine;
+import org.apache.shardingsphere.proxy.backend.communication.jdbc.connection.BackendConnection;
+import org.apache.shardingsphere.proxy.backend.response.data.QueryResponseRow;
+import org.apache.shardingsphere.proxy.backend.response.header.query.QueryResponseHeader;
+import org.apache.shardingsphere.proxy.backend.response.header.query.impl.QueryHeader;
+import org.apache.shardingsphere.proxy.backend.response.header.update.UpdateResponseHeader;
+import org.apache.shardingsphere.proxy.frontend.command.executor.ResponseType;
+import org.junit.Test;
+import org.junit.runner.RunWith;
+import org.mockito.Mock;
+import org.mockito.junit.MockitoJUnitRunner;
+
+import java.lang.reflect.Field;
+import java.lang.reflect.Modifier;
+import java.sql.SQLException;
+import java.util.Collection;
+import java.util.Collections;
+import java.util.Iterator;
+
+import static org.hamcrest.CoreMatchers.instanceOf;
+import static org.hamcrest.CoreMatchers.is;
+import static org.junit.Assert.assertFalse;
+import static org.junit.Assert.assertNull;
+import static org.junit.Assert.assertThat;
+import static org.junit.Assert.assertTrue;
+import static org.mockito.Mockito.mock;
+import static org.mockito.Mockito.verify;
+import static org.mockito.Mockito.when;
+
+@RunWith(MockitoJUnitRunner.class)
+public final class PostgreSQLComBindExecutorTest {
+
+ @Mock
+ private PostgreSQLComBindPacket bindPacket;
+
+ @Mock
+ private BackendConnection backendConnection;
+
+ @Mock
+ private DatabaseCommunicationEngine databaseCommunicationEngine;
+
+ @Test
+ public void assertExecuteEmptyBindPacket() throws SQLException {
+ PostgreSQLComBindExecutor executor = new PostgreSQLComBindExecutor(bindPacket, backendConnection);
+ Collection<DatabasePacket<?>> actual = executor.execute();
+ assertThat(actual.size(), is(1));
+ assertThat(actual.iterator().next(), is(instanceOf(PostgreSQLBindCompletePacket.class)));
+ assertNull(executor.getResponseType());
+ assertFalse(executor.next());
+ }
+
+ @Test
+ public void assertExecuteBindPacketWithQuerySQLAndReturnEmptyResult() throws SQLException {
+ QueryResponseHeader queryResponseHeader = mock(QueryResponseHeader.class);
+ when(databaseCommunicationEngine.execute()).thenReturn(queryResponseHeader);
+ PostgreSQLComBindExecutor executor = new PostgreSQLComBindExecutor(bindPacket, backendConnection);
+ setMockFieldIntoExecutor(executor);
+ Collection<DatabasePacket<?>> actual = executor.execute();
+ assertThat(actual.size(), is(1));
+ assertThat(actual.iterator().next(), is(instanceOf(PostgreSQLBindCompletePacket.class)));
+ assertNull(executor.getResponseType());
+ verify(queryResponseHeader).getQueryHeaders();
+ }
+
+ @Test
+ public void assertExecuteBindPacketWithQuerySQL() throws SQLException {
+ QueryResponseHeader queryResponseHeader = mock(QueryResponseHeader.class);
+ when(queryResponseHeader.getQueryHeaders()).thenReturn(Collections.singletonList(new QueryHeader("schema", "table", "label", "column", 1, "type", 2, 3, true, true, true, true)));
+ when(databaseCommunicationEngine.execute()).thenReturn(queryResponseHeader);
+ PostgreSQLComBindExecutor executor = new PostgreSQLComBindExecutor(bindPacket, backendConnection);
+ setMockFieldIntoExecutor(executor);
+ Collection<DatabasePacket<?>> actual = executor.execute();
+ assertThat(actual.size(), is(2));
+ Iterator<DatabasePacket<?>> actualPackets = actual.iterator();
+ assertThat(actualPackets.next(), is(instanceOf(PostgreSQLBindCompletePacket.class)));
+ assertThat(actualPackets.next(), is(instanceOf(PostgreSQLRowDescriptionPacket.class)));
+ assertThat(executor.getResponseType(), is(ResponseType.QUERY));
+ }
+
+ @Test
+ public void assertNext() throws SQLException {
+ when(databaseCommunicationEngine.next()).thenReturn(true, false);
+ PostgreSQLComBindExecutor executor = new PostgreSQLComBindExecutor(bindPacket, backendConnection);
+ setMockFieldIntoExecutor(executor);
+ assertTrue(executor.next());
+ assertFalse(executor.next());
+ }
+
+ @Test
+ public void assertDataRowNotBinary() throws SQLException {
+ QueryResponseRow queryResponseRow = mock(QueryResponseRow.class);
+ when(databaseCommunicationEngine.getQueryResponseRow()).thenReturn(queryResponseRow);
+ PostgreSQLComBindExecutor executor = new PostgreSQLComBindExecutor(bindPacket, backendConnection);
+ setMockFieldIntoExecutor(executor);
+ PostgreSQLPacket actualQueryRowPacket = executor.getQueryRowPacket();
+ verify(queryResponseRow).getData();
+ assertThat(actualQueryRowPacket, is(instanceOf(PostgreSQLDataRowPacket.class)));
+ }
+
+ @Test
+ public void assertDataRowIsBinary() throws SQLException {
+ when(bindPacket.isBinaryRowData()).thenReturn(true);
+ QueryResponseRow queryResponseRow = mock(QueryResponseRow.class);
+ when(databaseCommunicationEngine.getQueryResponseRow()).thenReturn(queryResponseRow);
+ PostgreSQLComBindExecutor executor = new PostgreSQLComBindExecutor(bindPacket, backendConnection);
+ setMockFieldIntoExecutor(executor);
+ PostgreSQLPacket actualQueryRowPacket = executor.getQueryRowPacket();
+ verify(queryResponseRow).getCells();
+ assertThat(actualQueryRowPacket, is(instanceOf(PostgreSQLBinaryResultSetRowPacket.class)));
+ }
+
+ @Test
+ public void assertExecuteBindPacketWithUpdateSQL() throws SQLException {
+ UpdateResponseHeader updateResponseHeader = mock(UpdateResponseHeader.class);
+ when(databaseCommunicationEngine.execute()).thenReturn(updateResponseHeader);
+ PostgreSQLComBindExecutor executor = new PostgreSQLComBindExecutor(bindPacket, backendConnection);
+ setMockFieldIntoExecutor(executor);
+ Collection<DatabasePacket<?>> actual = executor.execute();
+ assertThat(actual.size(), is(2));
+ Iterator<DatabasePacket<?>> actualPackets = actual.iterator();
+ assertThat(actualPackets.next(), is(instanceOf(PostgreSQLBindCompletePacket.class)));
+ assertThat(actualPackets.next(), is(instanceOf(PostgreSQLCommandCompletePacket.class)));
+ assertThat(executor.getResponseType(), is(ResponseType.UPDATE));
+ verify(updateResponseHeader).getSqlStatement();
+ verify(updateResponseHeader).getUpdateCount();
+ }
+
+ @SneakyThrows
+ private void setMockFieldIntoExecutor(final PostgreSQLComBindExecutor executor) {
+ Field field = PostgreSQLComBindExecutor.class.getDeclaredField("databaseCommunicationEngine");
+ field.setAccessible(true);
+ Field modifiers = Field.class.getDeclaredField("modifiers");
+ modifiers.setAccessible(true);
+ modifiers.setInt(field, field.getModifiers() & ~Modifier.FINAL);
+ field.set(executor, databaseCommunicationEngine);
+ }
+}
diff --git a/shardingsphere-proxy/shardingsphere-proxy-frontend/shardingsphere-proxy-frontend-postgresql/src/test/java/org/apache/shardingsphere/proxy/frontend/postgresql/command/query/text/PostgreSQLComQueryExecutorTest.java b/shardingsphere-proxy/shardingsphere-proxy-frontend/shardingsphere-proxy-frontend-postgresql/src/test/java/org/apache/shardingsphere/proxy/frontend/postgresql/command/query/text/PostgreSQLComQueryExecutorTest.java
new file mode 100644
index 0000000..fa4a07a
--- /dev/null
+++ b/shardingsphere-proxy/shardingsphere-proxy-frontend/shardingsphere-proxy-frontend-postgresql/src/test/java/org/apache/shardingsphere/proxy/frontend/postgresql/command/query/text/PostgreSQLComQueryExecutorTest.java
@@ -0,0 +1,125 @@
+/*
+ * 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.proxy.frontend.postgresql.command.query.text;
+
+import lombok.SneakyThrows;
+import org.apache.shardingsphere.db.protocol.packet.DatabasePacket;
+import org.apache.shardingsphere.db.protocol.postgresql.packet.PostgreSQLPacket;
+import org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.PostgreSQLRowDescriptionPacket;
+import org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.text.PostgreSQLComQueryPacket;
+import org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.text.PostgreSQLDataRowPacket;
+import org.apache.shardingsphere.db.protocol.postgresql.packet.generic.PostgreSQLCommandCompletePacket;
+import org.apache.shardingsphere.proxy.backend.communication.jdbc.connection.BackendConnection;
+import org.apache.shardingsphere.proxy.backend.response.header.query.QueryResponseHeader;
+import org.apache.shardingsphere.proxy.backend.response.header.query.impl.QueryHeader;
+import org.apache.shardingsphere.proxy.backend.response.header.update.UpdateResponseHeader;
+import org.apache.shardingsphere.proxy.backend.text.TextProtocolBackendHandler;
+import org.apache.shardingsphere.proxy.frontend.command.executor.ResponseType;
+import org.junit.Before;
+import org.junit.Test;
+import org.junit.runner.RunWith;
+import org.mockito.Mock;
+import org.mockito.junit.MockitoJUnitRunner;
+
+import java.lang.reflect.Field;
+import java.lang.reflect.Modifier;
+import java.sql.SQLException;
+import java.util.Collection;
+import java.util.Collections;
+
+import static org.hamcrest.CoreMatchers.instanceOf;
+import static org.hamcrest.CoreMatchers.is;
+import static org.junit.Assert.assertFalse;
+import static org.junit.Assert.assertNull;
+import static org.junit.Assert.assertThat;
+import static org.junit.Assert.assertTrue;
+import static org.mockito.Mockito.mock;
+import static org.mockito.Mockito.verify;
+import static org.mockito.Mockito.when;
+
+@RunWith(MockitoJUnitRunner.class)
+public final class PostgreSQLComQueryExecutorTest {
+
+ @Mock
+ private TextProtocolBackendHandler textProtocolBackendHandler;
+
+ private PostgreSQLComQueryExecutor queryExecutor;
+
+ @Before
+ public void setUp() throws SQLException {
+ PostgreSQLComQueryPacket queryPacket = mock(PostgreSQLComQueryPacket.class);
+ BackendConnection backendConnection = mock(BackendConnection.class);
+ queryExecutor = new PostgreSQLComQueryExecutor(queryPacket, backendConnection);
+ setMockFieldIntoExecutor(queryExecutor);
+ }
+
+ @SneakyThrows
+ private void setMockFieldIntoExecutor(final PostgreSQLComQueryExecutor executor) {
+ Field field = PostgreSQLComQueryExecutor.class.getDeclaredField("textProtocolBackendHandler");
+ field.setAccessible(true);
+ Field modifiers = Field.class.getDeclaredField("modifiers");
+ modifiers.setAccessible(true);
+ modifiers.setInt(field, field.getModifiers() & ~Modifier.FINAL);
+ field.set(executor, textProtocolBackendHandler);
+ }
+
+ @Test
+ public void assertExecuteQueryAndReturnEmptyResult() throws SQLException {
+ QueryResponseHeader queryResponseHeader = mock(QueryResponseHeader.class);
+ when(textProtocolBackendHandler.execute()).thenReturn(queryResponseHeader);
+ Collection<DatabasePacket<?>> actual = queryExecutor.execute();
+ assertTrue(actual.isEmpty());
+ assertNull(queryExecutor.getResponseType());
+ verify(queryResponseHeader).getQueryHeaders();
+ }
+
+ @Test
+ public void assertExecuteQueryAndReturnResult() throws SQLException {
+ QueryResponseHeader queryResponseHeader = mock(QueryResponseHeader.class);
+ when(queryResponseHeader.getQueryHeaders()).thenReturn(Collections.singletonList(new QueryHeader("schema", "table", "label", "column", 1, "type", 2, 3, true, true, true, true)));
+ when(textProtocolBackendHandler.execute()).thenReturn(queryResponseHeader);
+ Collection<DatabasePacket<?>> actual = queryExecutor.execute();
+ assertThat(actual.size(), is(1));
+ assertThat(actual.iterator().next(), is(instanceOf(PostgreSQLRowDescriptionPacket.class)));
+ assertThat(queryExecutor.getResponseType(), is(ResponseType.QUERY));
+ verify(queryResponseHeader).getQueryHeaders();
+ }
+
+ @Test
+ public void assertExecuteUpdate() throws SQLException {
+ UpdateResponseHeader updateResponseHeader = mock(UpdateResponseHeader.class);
+ when(textProtocolBackendHandler.execute()).thenReturn(updateResponseHeader);
+ Collection<DatabasePacket<?>> actual = queryExecutor.execute();
+ assertThat(actual.size(), is(1));
+ assertThat(actual.iterator().next(), is(instanceOf(PostgreSQLCommandCompletePacket.class)));
+ assertThat(queryExecutor.getResponseType(), is(ResponseType.UPDATE));
+ }
+
+ @Test
+ public void assertNext() throws SQLException {
+ when(textProtocolBackendHandler.next()).thenReturn(true, false);
+ assertTrue(queryExecutor.next());
+ assertFalse(queryExecutor.next());
+ }
+
+ @Test
+ public void assertGetQueryRowPacket() throws SQLException {
+ PostgreSQLPacket actual = queryExecutor.getQueryRowPacket();
+ assertThat(actual, is(instanceOf(PostgreSQLDataRowPacket.class)));
+ }
+}