public void testSelect() throws SQLException { expect(mockSession.getApplication()).andStubReturn(mockApplication); expect(mockSession.getIdentifier()).andStubReturn(mockSessionId); expect(mockSession.getProperties()).andStubReturn(mockSessionProperties); expect(mockSession.getMetaData()).andStubReturn(mockSQLMetaData); expect(mockSessionProperties.getMetaDataOutputClassName()).andStubReturn( DataSetListModel.class.getName()); expect(mockApplication.getSessionManager()).andStubReturn(mockSessionManager); expect(mockSessionManager.getSession(mockSessionId)).andStubReturn(mockSession); expect(mockSession.getSQLConnection()).andStubReturn(mockSQLConnection); expect(mockSQLConnection.prepareStatement(isA(String.class))).andStubReturn(mockPreparedStatement); expect(mockSQLMetaData.getDatabaseProductName()).andStubReturn(databaseProductName); expect(mockSQLMetaData.getDatabaseProductVersion()).andStubReturn(DATABASE_PRODUCT_VERSION); mockPreparedStatement.setString(anyInt(), isA(String.class)); expectLastCall().anyTimes(); mockPreparedStatement.setLong(anyInt(), anyLong()); expectLastCall().anyTimes(); setupMockDatabaseObjectInfo(); expect(mockPreparedStatement.executeQuery()).andStubReturn(mockResultSet); expect(mockResultSet.next()).andStubReturn(false); expect(mockResultSet.getMetaData()).andStubReturn(mockResultSetMetaData); expect(mockResultSetMetaData.getColumnCount()).andStubReturn(1); expect(mockResultSetMetaData.isNullable(1)).andStubReturn(ResultSetMetaData.columnNoNulls); expect(mockResultSetMetaData.getPrecision(1)).andStubReturn(10); expect(mockResultSetMetaData.isSigned(1)).andReturn(true); expect(mockResultSetMetaData.isCurrency(1)).andReturn(true); expect(mockResultSetMetaData.isAutoIncrement(1)).andReturn(true); expect(mockResultSetMetaData.getColumnName(1)).andReturn(TEST_COLUMN_NAME); expect(mockResultSetMetaData.getColumnTypeName(1)).andReturn("VARCHAR"); expect(mockResultSetMetaData.getColumnType(1)).andReturn(Types.VARCHAR); expect(mockResultSetMetaData.getColumnDisplaySize(1)).andStubReturn(10); expect(mockResultSetMetaData.getColumnLabel(1)).andStubReturn(TEST_COLUMN_NAME); expect(mockResultSetMetaData.getScale(1)).andStubReturn(3); mockResultSet.close(); expect(mockResultSet.getStatement()).andStubReturn(mockPreparedStatement); mockPreparedStatement.close(); mockHelper.replayAll(); classUnderTest.setSession(mockSession); classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo); classUnderTest.getComponent(); classUnderTest.select(); mockHelper.verifyAll();
public void testSelect() throws Exception { expect(mockSession.getApplication()).andStubReturn(mockApplication); expect(mockSession.getIdentifier()).andStubReturn(mockSessionId); expect(mockSession.getProperties()).andStubReturn(mockSessionProperties); expect(mockSession.getMetaData()).andStubReturn(mockSQLMetaData); expect(mockSessionProperties.getMetaDataOutputClassName()).andStubReturn( DataSetListModel.class.getName()); expect(mockApplication.getSessionManager()).andStubReturn(mockSessionManager); expect(mockSessionManager.getSession(mockSessionId)).andStubReturn(mockSession); expect(mockDatabaseObjectInfo.getSchemaName()).andStubReturn(TEST_SCHEMA_NAME); expect(mockDatabaseObjectInfo.getCatalogName()).andStubReturn(TEST_CATALOG_NAME); expect(mockDatabaseObjectInfo.getSimpleName()).andStubReturn(TEST_SIMPLE_NAME); expect(mockDatabaseObjectInfo.getQualifiedName()).andStubReturn(TEST_QUALIFIED_NAME); expect(mockSession.getSQLConnection()).andStubReturn(mockSQLConnection); expect(mockSQLConnection.createStatement()).andStubReturn(mockStatement); expect(mockSQLMetaData.getDatabaseProductName()).andStubReturn(databaseProductName); expect(mockSQLMetaData.getDatabaseProductVersion()).andStubReturn(DATABASE_PRODUCT_VERSION); expect(mockStatement.executeQuery(isA(String.class))).andStubReturn(mockResultSet); expect(mockResultSet.next()).andStubReturn(false); expect(mockResultSet.getMetaData()).andStubReturn(mockResultSetMetaData); expect(mockResultSetMetaData.getColumnCount()).andStubReturn(1); expect(mockResultSetMetaData.isNullable(1)).andStubReturn(ResultSetMetaData.columnNoNulls); expect(mockResultSetMetaData.getPrecision(1)).andStubReturn(10); expect(mockResultSetMetaData.isSigned(1)).andReturn(true); expect(mockResultSetMetaData.isCurrency(1)).andReturn(true); expect(mockResultSetMetaData.isAutoIncrement(1)).andReturn(true); expect(mockResultSetMetaData.getColumnName(1)).andReturn(TEST_COLUMN_NAME); expect(mockResultSetMetaData.getColumnTypeName(1)).andReturn("VARCHAR"); expect(mockResultSetMetaData.getColumnType(1)).andReturn(Types.VARCHAR); expect(mockResultSetMetaData.getColumnDisplaySize(1)).andStubReturn(10); expect(mockResultSetMetaData.getColumnLabel(1)).andStubReturn(TEST_COLUMN_NAME); expect(mockResultSetMetaData.getScale(1)).andStubReturn(3); mockResultSet.close(); mockStatement.close(); mockHelper.replayAll(); classUnderTest.setSession(mockSession); classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo); classUnderTest.getComponent(); classUnderTest.select(); mockHelper.verifyAll();
Clone fragments detected by clone detection tool
File path: /sql12/test/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AbstractBasePreparedStatementTabTest.java File path: /sql12/test/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AbstractStatementTabTest.java
Method name: Method name:
Number of AST nodes: 0 Number of AST nodes: 0
1
public void testSelect() throws SQLException
1
public void testSelect() throws Exception
2
	{
2
	{
3
		expect(mockSession.getApplication()).andStubReturn(mockApplication);
3
		expect(mockSession.getApplication()).andStubReturn(mockApplication);
4
		expect(mockSession.getIdentifier()).andStubReturn(mockSessionId);
4
		expect(mockSession.getIdentifier()).andStubReturn(mockSessionId);
5
		expect(mockSession.getProperties()).andStubReturn(mockSessionProperties);
5
		expect(mockSession.getProperties()).andStubReturn(mockSessionProperties);
6
		expect(mockSession.getMetaData()).andStubReturn(mockSQLMetaData);
6
		expect(mockSession.getMetaData()).andStubReturn(mockSQLMetaData);
7
		expect(mockSessionProperties.getMetaDataOutputClassName()).andStubReturn(
7
		expect(mockSessionProperties.getMetaDataOutputClassName()).andStubReturn(
8
			DataSetListModel.class.getName());
8
			DataSetListModel.class.getName());
9
		expect(mockApplication.getSessionManager()).andStubReturn(mockSessionManager);
9
		expect(mockApplication.getSessionManager()).andStubReturn(mockSessionManager);
10
		expect(mockSessionManager.getSession(mockSessionId)).andStubReturn(mockSession);
10
		expect(mockSessionManager.getSession(mockSessionId)).andStubReturn(mockSession);
11
		
11
		expect(mockDatabaseObjectInfo.getSchemaName()).andStubReturn(TEST_SCHEMA_NAME);
12
		expect(mockDatabaseObjectInfo.getCatalogName()).andStubReturn(TEST_CATALOG_NAME);
13
		expect(mockDatabaseObjectInfo.getSimpleName()).andStubReturn(TEST_SIMPLE_NAME);
14
		expect(mockDatabaseObjectInfo.getQualifiedName()).andStubReturn(TEST_QUALIFIED_NAME);
12
expect(mockSession.getSQLConnection()).andStubReturn(mockSQLConnection);
15
		expect(mockSession.getSQLConnection()).andStubReturn(mockSQLConnection);
13
		expect(mockSQLConnection.prepareStatement(isA(String.class))).andStubReturn(mockPreparedStatement);
16
		expect(mockSQLConnection.createStatement()).andStubReturn(mockStatement);
14
		expect(mockSQLMetaData.getDatabaseProductName()).andStubReturn(databaseProductName);
17
		expect(mockSQLMetaData.getDatabaseProductName()).andStubReturn(databaseProductName);
15
		expect(mockSQLMetaData.getDatabaseProductVersion()).andStubReturn(DATABASE_PRODUCT_VERSION);
18
		expect(mockSQLMetaData.getDatabaseProductVersion()).andStubReturn(DATABASE_PRODUCT_VERSION);
16
		mockPreparedStatement.setString(anyInt(), isA(String.class));
19
		
17
		expectLastCall().anyTimes();
18
		mockPreparedStatement.setLong(anyInt(), anyLong());
19
		expectLastCall().anyTimes();
20
		setupMockDatabaseObjectInfo();
21
		expect(mockPreparedStatement.executeQuery()).andStubReturn(mockResultSet);
20
expect(mockStatement.executeQuery(isA(String.class))).andStubReturn(mockResultSet);
22
		expect(mockResultSet.next()).andStubReturn(false);
21
		expect(mockResultSet.next()).andStubReturn(false);
23
		expect(mockResultSet.getMetaData()).andStubReturn(mockResultSetMetaData);
22
		expect(mockResultSet.getMetaData()).andStubReturn(mockResultSetMetaData);
24
		expect(mockResultSetMetaData.getColumnCount()).andStubReturn(1);
23
		expect(mockResultSetMetaData.getColumnCount()).andStubReturn(1);
25
		expect(mockResultSetMetaData.isNullable(1)).andStubReturn(ResultSetMetaData.columnNoNulls);
24
		expect(mockResultSetMetaData.isNullable(1)).andStubReturn(ResultSetMetaData.columnNoNulls);
26
		expect(mockResultSetMetaData.getPrecision(1)).andStubReturn(10);
25
		expect(mockResultSetMetaData.getPrecision(1)).andStubReturn(10);
27
		expect(mockResultSetMetaData.isSigned(1)).andReturn(true);
26
		expect(mockResultSetMetaData.isSigned(1)).andReturn(true);
28
		expect(mockResultSetMetaData.isCurrency(1)).andReturn(true);
27
		expect(mockResultSetMetaData.isCurrency(1)).andReturn(true);
29
		expect(mockResultSetMetaData.isAutoIncrement(1)).andReturn(true);
28
		expect(mockResultSetMetaData.isAutoIncrement(1)).andReturn(true);
30
		expect(mockResultSetMetaData.getColumnName(1)).andReturn(TEST_COLUMN_NAME);
29
		expect(mockResultSetMetaData.getColumnName(1)).andReturn(TEST_COLUMN_NAME);
31
		expect(mockResultSetMetaData.getColumnTypeName(1)).andReturn("VARCHAR");
30
		expect(mockResultSetMetaData.getColumnTypeName(1)).andReturn("VARCHAR");
32
		expect(mockResultSetMetaData.getColumnType(1)).andReturn(Types.VARCHAR);
31
		expect(mockResultSetMetaData.getColumnType(1)).andReturn(Types.VARCHAR);
33
		expect(mockResultSetMetaData.getColumnDisplaySize(1)).andStubReturn(10);
32
		expect(mockResultSetMetaData.getColumnDisplaySize(1)).andStubReturn(10);
34
		expect(mockResultSetMetaData.getColumnLabel(1)).andStubReturn(TEST_COLUMN_NAME);
33
		expect(mockResultSetMetaData.getColumnLabel(1)).andStubReturn(TEST_COLUMN_NAME);
35
		expect(mockResultSetMetaData.getScale(1)).andStubReturn(3);
34
		expect(mockResultSetMetaData.getScale(1)).andStubReturn(3);
36
		mockResultSet.close();
35
		mockResultSet.close();
37
		expect(mockResultSet.getStatement()).andStubReturn(mockPreparedStatement);
36
		
38
		mockPreparedStatement.close();
37
mockStatement.close();
39
		mockHelper.replayAll();
38
		mockHelper.replayAll();
40
		classUnderTest.setSession(mockSession);
39
		classUnderTest.setSession(mockSession);
41
		classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo);
40
		classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo);
42
		classUnderTest.getComponent();
41
		classUnderTest.getComponent();
43
		classUnderTest.select();
42
		classUnderTest.select();
44
		mockHelper.verifyAll();
43
		mockHelper.verifyAll();
45
	
44
	
Summary
Number of common nesting structure subtrees0
Number of refactorable cases0
Number of non-refactorable cases0
Time elapsed for finding largest common nesting structure subtrees (ms)0.0
Clones location
Number of node comparisons0