| /* |
| * 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.skywalking.apm.plugin.jdbc; |
| |
| import com.mysql.cj.api.jdbc.JdbcConnection; |
| import java.sql.PreparedStatement; |
| import java.sql.SQLException; |
| import java.sql.Savepoint; |
| import java.util.HashMap; |
| import java.util.List; |
| import java.util.Properties; |
| import java.util.concurrent.Executor; |
| import org.apache.skywalking.apm.agent.test.tools.SegmentStorage; |
| import org.junit.Before; |
| import org.junit.Rule; |
| import org.junit.Test; |
| import org.junit.runner.RunWith; |
| import org.mockito.Mock; |
| import org.powermock.modules.junit4.PowerMockRunner; |
| import org.powermock.modules.junit4.PowerMockRunnerDelegate; |
| import org.apache.skywalking.apm.agent.core.context.trace.AbstractTracingSpan; |
| import org.apache.skywalking.apm.agent.core.context.trace.TraceSegment; |
| import org.apache.skywalking.apm.agent.test.helper.SegmentHelper; |
| import org.apache.skywalking.apm.agent.test.helper.SpanHelper; |
| import org.apache.skywalking.apm.agent.test.tools.AgentServiceRule; |
| import org.apache.skywalking.apm.agent.test.tools.SegmentStoragePoint; |
| import org.apache.skywalking.apm.agent.test.tools.TracingSegmentRunner; |
| |
| import static org.hamcrest.CoreMatchers.is; |
| import static org.junit.Assert.assertThat; |
| import static org.mockito.Matchers.any; |
| import static org.mockito.Matchers.anyBoolean; |
| import static org.mockito.Matchers.anyInt; |
| import static org.mockito.Matchers.anyString; |
| import static org.mockito.Mockito.doThrow; |
| import static org.mockito.Mockito.verify; |
| import static org.mockito.Mockito.when; |
| |
| @RunWith(PowerMockRunner.class) |
| @PowerMockRunnerDelegate(TracingSegmentRunner.class) |
| public class SWConnectionTest extends AbstractStatementTest { |
| |
| @SegmentStoragePoint |
| private SegmentStorage segmentStorage; |
| |
| @Rule |
| public AgentServiceRule serviceRule = new AgentServiceRule(); |
| |
| @Mock |
| private com.mysql.cj.jdbc.PreparedStatement mysqlPreparedStatement; |
| @Mock |
| private JdbcConnection jdbcConnection; |
| @Mock |
| private Executor executor; |
| @Mock |
| private Savepoint savepoint; |
| private SWConnection swConnection; |
| private SWConnection multiHostConnection; |
| |
| @Before |
| public void setUp() throws Exception { |
| swConnection = new SWConnection("jdbc:mysql://127.0.0.1:3306/test", new Properties(), jdbcConnection); |
| multiHostConnection = new SWConnection("jdbc:mysql://127.0.0.1:3306,127.0.0.1:3309/test", new Properties(), jdbcConnection); |
| when(jdbcConnection.prepareStatement(anyString())).thenReturn(mysqlPreparedStatement); |
| } |
| |
| @Test |
| public void testCommit() throws SQLException { |
| PreparedStatement preparedStatement = swConnection.prepareStatement("SELECT * FROM test"); |
| |
| swConnection.commit(); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/commit"); |
| } |
| |
| @Test |
| public void testMultiHostCommit() throws SQLException { |
| PreparedStatement preparedStatement = swConnection.prepareStatement("SELECT * FROM test", new String[] {"1"}); |
| multiHostConnection.commit(); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/commit"); |
| } |
| |
| @Test(expected = SQLException.class) |
| public void testCommitWithException() throws SQLException { |
| PreparedStatement preparedStatement = swConnection.prepareStatement("SELECT * FROM test", new int[] {1}); |
| doThrow(new SQLException()).when(jdbcConnection).commit(); |
| try { |
| swConnection.commit(); |
| } finally { |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/commit"); |
| assertThat(SpanHelper.getLogs(spans.get(0)).size(), is(1)); |
| assertDBSpanLog(SpanHelper.getLogs(spans.get(0)).get(0)); |
| } |
| } |
| |
| @Test |
| public void testRollBack() throws SQLException { |
| PreparedStatement preparedStatement = swConnection.prepareStatement("SELECT * FROM test", 1, 1); |
| swConnection.rollback(); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/rollback"); |
| } |
| |
| @Test |
| public void testMultiHostRollBack() throws SQLException { |
| PreparedStatement preparedStatement = swConnection.prepareStatement("SELECT * FROM test", 1, 1, 1); |
| multiHostConnection.rollback(); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/rollback"); |
| } |
| |
| @Test(expected = SQLException.class) |
| public void testRollBackWithException() throws SQLException { |
| doThrow(new SQLException()).when(jdbcConnection).rollback(); |
| |
| swConnection.rollback(); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/rollback"); |
| } |
| |
| @Test |
| public void testRollBackWithSavePoint() throws SQLException { |
| swConnection.rollback(savepoint); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/rollback to savepoint"); |
| |
| } |
| |
| @Test |
| public void testMultiHostRollBackWithSavePoint() throws SQLException { |
| multiHostConnection.rollback(savepoint); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/rollback to savepoint"); |
| |
| } |
| |
| @Test(expected = SQLException.class) |
| public void testRollBackWithSavePointWithException() throws SQLException { |
| doThrow(new SQLException()).when(jdbcConnection).rollback(any(Savepoint.class)); |
| |
| swConnection.rollback(savepoint); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/rollback to savepoint"); |
| assertDBSpanLog(SpanHelper.getLogs(spans.get(0)).get(0)); |
| |
| } |
| |
| @Test |
| public void testClose() throws SQLException { |
| swConnection.close(); |
| swConnection.clearWarnings(); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/close"); |
| |
| } |
| |
| @Test |
| public void testMultiHostClose() throws SQLException { |
| multiHostConnection.close(); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/close"); |
| |
| } |
| |
| @Test(expected = SQLException.class) |
| public void testCloseWithException() throws SQLException { |
| doThrow(new SQLException()).when(jdbcConnection).close(); |
| |
| swConnection.close(); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/close"); |
| assertDBSpanLog(SpanHelper.getLogs(spans.get(0)).get(0)); |
| } |
| |
| @Test |
| public void testReleaseSavePoint() throws SQLException { |
| swConnection.releaseSavepoint(savepoint); |
| swConnection.clearWarnings(); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/releaseSavepoint savepoint"); |
| |
| } |
| |
| @Test |
| public void testMultiHostReleaseSavePoint() throws SQLException { |
| multiHostConnection.releaseSavepoint(savepoint); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/releaseSavepoint savepoint"); |
| } |
| |
| @Test(expected = SQLException.class) |
| public void testReleaseSavePointWithException() throws SQLException { |
| doThrow(new SQLException()).when(jdbcConnection).releaseSavepoint(any(Savepoint.class)); |
| |
| swConnection.releaseSavepoint(savepoint); |
| |
| assertThat(segmentStorage.getTraceSegments().size(), is(1)); |
| TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0); |
| |
| List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment); |
| assertThat(spans.size(), is(1)); |
| assertDBSpan(spans.get(0), "Mysql/JDBI/Connection/releaseSavepoint savepoint"); |
| assertDBSpanLog(SpanHelper.getLogs(spans.get(0)).get(0)); |
| } |
| |
| @Test |
| public void testSetConfig() throws SQLException { |
| swConnection.createArrayOf("1", new Object[0]); |
| swConnection.createBlob(); |
| swConnection.createClob(); |
| swConnection.createNClob(); |
| swConnection.createSQLXML(); |
| swConnection.nativeSQL("SELECT IT"); |
| swConnection.setAutoCommit(true); |
| swConnection.getAutoCommit(); |
| swConnection.setCatalog("test"); |
| swConnection.getCatalog(); |
| swConnection.setClientInfo(new Properties()); |
| swConnection.getClientInfo(); |
| swConnection.setHoldability(1); |
| swConnection.getHoldability(); |
| swConnection.setReadOnly(false); |
| swConnection.setClientInfo("test-discovery", "test-discovery"); |
| swConnection.getClientInfo("test"); |
| swConnection.setSavepoint(); |
| swConnection.getMetaData(); |
| swConnection.getTransactionIsolation(); |
| swConnection.getTypeMap(); |
| swConnection.getWarnings(); |
| swConnection.isClosed(); |
| swConnection.isReadOnly(); |
| swConnection.isValid(10); |
| swConnection.setSavepoint("test"); |
| swConnection.setTransactionIsolation(1); |
| swConnection.setTypeMap(new HashMap<String, Class<?>>()); |
| |
| verify(jdbcConnection).createBlob(); |
| verify(jdbcConnection).createClob(); |
| verify(jdbcConnection).createNClob(); |
| verify(jdbcConnection).createSQLXML(); |
| verify(jdbcConnection).nativeSQL(anyString()); |
| verify(jdbcConnection).setAutoCommit(anyBoolean()); |
| verify(jdbcConnection).getAutoCommit(); |
| verify(jdbcConnection).setCatalog(anyString()); |
| verify(jdbcConnection).getCatalog(); |
| verify(jdbcConnection).setClientInfo(anyString(), anyString()); |
| verify(jdbcConnection).setHoldability(anyInt()); |
| verify(jdbcConnection).getHoldability(); |
| verify(jdbcConnection).setReadOnly(anyBoolean()); |
| verify(jdbcConnection).getClientInfo(); |
| verify(jdbcConnection).getClientInfo(anyString()); |
| verify(jdbcConnection).setSavepoint(anyString()); |
| verify(jdbcConnection).setSavepoint(); |
| verify(jdbcConnection).getMetaData(); |
| verify(jdbcConnection).getTransactionIsolation(); |
| verify(jdbcConnection).getTypeMap(); |
| verify(jdbcConnection).getWarnings(); |
| verify(jdbcConnection).setTransactionIsolation(anyInt()); |
| verify(jdbcConnection).getTransactionIsolation(); |
| verify(jdbcConnection).isClosed(); |
| verify(jdbcConnection).isReadOnly(); |
| verify(jdbcConnection).isValid(anyInt()); |
| verify(jdbcConnection).setTypeMap(any(HashMap.class)); |
| |
| } |
| } |