Update of /cvsroot/squirrel-sql/sql12/test/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs
In directory fdv4jf1.ch3.sourceforge.com:/tmp/cvs-serv10469/test/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs
Modified Files:
AbstractSourceTabTest.java
AbstractBasePreparedStatementTabTest.java
AbstractStatementTabTest.java
Added Files:
AbstractBaseDataSetTabTest.java AbstractTabTest.java
Log Message:
Added base test class for tab test and added new tests.
Index: AbstractBasePreparedStatementTabTest.java
===================================================================
RCS file: /cvsroot/squirrel-sql/sql12/test/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AbstractBasePreparedStatementTabTest.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** AbstractBasePreparedStatementTabTest.java 29 Nov 2008 15:08:31 -0000 1.1
--- AbstractBasePreparedStatementTabTest.java 30 Nov 2008 22:22:27 -0000 1.2
***************
*** 33,132 ****
import org.junit.Test;
- import utils.EasyMockHelper;
- import net.sourceforge.squirrel_sql.BaseSQuirreLJUnit4TestCase;
- import net.sourceforge.squirrel_sql.client.IApplication;
- import net.sourceforge.squirrel_sql.client.session.ISession;
- import net.sourceforge.squirrel_sql.client.session.SessionManager;
import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BasePreparedStatementTab;
import net.sourceforge.squirrel_sql.client.session.properties.SessionProperties;
import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetListModel;
- import net.sourceforge.squirrel_sql.fw.id.IIdentifier;
import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
- import net.sourceforge.squirrel_sql.fw.sql.ISQLConnection;
- import net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData;
! public class AbstractBasePreparedStatementTabTest extends BaseSQuirreLJUnit4TestCase
{
- private static final String TEST_COLUMN_NAME = "aColumnName";
- protected static final String DATABASE_PRODUCT_VERSION = "1.0";
- protected EasyMockHelper mockHelper = new EasyMockHelper();
protected BasePreparedStatementTab classUnderTest = null;
! protected String databaseProductName = null;
! private static final String TEST_QUALIFIED_NAME = "testQualifiedName";
! private static final String TEST_SIMPLE_NAME = "testSimpleName";
! private static final String TEST_CATALOG_NAME = "testCatalogName";
! private static final String TEST_SCHEMA_NAME = "testSchemaName";
public static final String STMT_SEP = ";";
public static final String HINT = "aHint";
! public static final String METADATA_OUTPUT_CLASSNAME = "aMetaDataOutputClassName";
! protected ISession mockSession = mockHelper.createMock(ISession.class);
protected SessionProperties mockSessionProperties = mockHelper.createMock(SessionProperties.class);
! protected IApplication mockApplication = mockHelper.createMock(IApplication.class);
! protected IIdentifier mockSessionId = mockHelper.createMock(IIdentifier.class);
! protected SessionManager mockSessionManager = mockHelper.createMock(SessionManager.class);
protected IDatabaseObjectInfo mockDatabaseObjectInfo = mockHelper.createMock(IDatabaseObjectInfo.class);
! protected ISQLConnection mockSQLConnection = mockHelper.createMock(ISQLConnection.class);
protected PreparedStatement mockPreparedStatement = mockHelper.createMock(PreparedStatement.class);
protected ResultSet mockResultSet = mockHelper.createMock(ResultSet.class);
! protected ISQLDatabaseMetaData mockMetaData = mockHelper.createMock(ISQLDatabaseMetaData.class);
protected ResultSetMetaData mockResultSetMetaData = mockHelper.createMock(ResultSetMetaData.class);
! public AbstractBasePreparedStatementTabTest() {
super();
}
@After
! public void tearDown() throws Exception
! {
! classUnderTest = null;
! }
@Test
! public void testSelect() throws SQLException
! {
! expect(mockSession.getApplication()).andStubReturn(mockApplication);
! expect(mockSession.getIdentifier()).andStubReturn(mockSessionId);
! expect(mockSession.getProperties()).andStubReturn(mockSessionProperties);
! expect(mockSession.getMetaData()).andStubReturn(mockMetaData);
! 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.prepareStatement(isA(String.class))).andStubReturn(mockPreparedStatement);
! expect(mockMetaData.getDatabaseProductName()).andStubReturn(databaseProductName);
! expect(mockMetaData.getDatabaseProductVersion()).andStubReturn(DATABASE_PRODUCT_VERSION);
! mockPreparedStatement.setString(EasyMock.anyInt(), isA(String.class));
! expectLastCall().anyTimes();
! 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();
! mockPreparedStatement.close();
!
! mockHelper.replayAll();
! classUnderTest.setSession(mockSession);
! classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo);
! classUnderTest.getComponent();
! classUnderTest.select();
! mockHelper.verifyAll();
! }
}
\ No newline at end of file
--- 33,118 ----
import org.junit.Test;
import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BasePreparedStatementTab;
import net.sourceforge.squirrel_sql.client.session.properties.SessionProperties;
import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetListModel;
import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
! public class AbstractBasePreparedStatementTabTest extends AbstractTabTest
{
protected BasePreparedStatementTab classUnderTest = null;
!
public static final String STMT_SEP = ";";
+
public static final String HINT = "aHint";
!
protected SessionProperties mockSessionProperties = mockHelper.createMock(SessionProperties.class);
!
protected IDatabaseObjectInfo mockDatabaseObjectInfo = mockHelper.createMock(IDatabaseObjectInfo.class);
!
protected PreparedStatement mockPreparedStatement = mockHelper.createMock(PreparedStatement.class);
+
protected ResultSet mockResultSet = mockHelper.createMock(ResultSet.class);
!
protected ResultSetMetaData mockResultSetMetaData = mockHelper.createMock(ResultSetMetaData.class);
! public AbstractBasePreparedStatementTabTest()
! {
super();
}
@After
! public void tearDown() throws Exception
! {
! classUnderTest = null;
! }
@Test
! public void testSelect() throws SQLException
! {
! expect(mockSession.getApplication()).andStubReturn(mockApplication);
! expect(mockSession.getIdentifier()).andStubReturn(mockSessionId);
! expect(mockSession.getProperties()).andStubReturn(mockSessionProperties);
! expect(mockSession.getMetaData()).andStubReturn(mockMetaData);
! 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.prepareStatement(isA(String.class))).andStubReturn(mockPreparedStatement);
! expect(mockMetaData.getDatabaseProductName()).andStubReturn(databaseProductName);
! expect(mockMetaData.getDatabaseProductVersion()).andStubReturn(DATABASE_PRODUCT_VERSION);
! mockPreparedStatement.setString(EasyMock.anyInt(), isA(String.class));
! expectLastCall().anyTimes();
! 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();
! mockPreparedStatement.close();
!
! mockHelper.replayAll();
! classUnderTest.setSession(mockSession);
! classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo);
! classUnderTest.getComponent();
! classUnderTest.select();
! mockHelper.verifyAll();
! }
}
\ No newline at end of file
--- NEW FILE: AbstractBaseDataSetTabTest.java ---
/*
* Copyright (C) 2008 Rob Manning
* manningr@...
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
package net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs;
import static org.easymock.EasyMock.expect;
import static org.easymock.EasyMock.expectLastCall;
import static org.easymock.EasyMock.isA;
import java.util.Date;
import org.junit.After;
import org.junit.Assert;
import org.junit.Test;
public class AbstractBaseDataSetTabTest extends AbstractTabTest
{
protected BaseDataSetTab classUnderTest = null;
public AbstractBaseDataSetTabTest()
{
super();
}
public void setUp() throws Exception
{
expect(mockSession.getApplication()).andStubReturn(mockApplication);
expect(mockSession.getSQLConnection()).andStubReturn(mockSQLConnection);
expect(mockSession.getMetaData()).andStubReturn(mockMetaData);
expect(mockSession.getIdentifier()).andStubReturn(mockSessionId);
expect(mockApplication.getSessionManager()).andStubReturn(mockSessionManager);
expect(mockSessionManager.getSession(mockSessionId)).andStubReturn(mockSession);
expect(mockApplication.getThreadPool()).andStubReturn(mockThreadPool);
expect(mockSQLConnection.getSQLMetaData()).andStubReturn(mockSQLMetaData);
expect(mockSQLMetaData.getCatalogs()).andStubReturn(mockCatalogs);
expect(mockSQLConnection.getConnection()).andStubReturn(mockConnection);
expect(mockConnection.isClosed()).andStubReturn(false);
expect(mockConnection.isReadOnly()).andStubReturn(false);
expect(mockConnection.getCatalog()).andStubReturn(TEST_CATALOG_NAME);
expect(mockSQLConnection.getCatalog()).andStubReturn(TEST_CATALOG_NAME);
expect(mockSQLConnection.getAutoCommit()).andStubReturn(true);
expect(mockConnection.getTransactionIsolation()).andStubReturn(TRANSACTION_ISOLATION);
expect(mockSQLConnection.getTimeOpened()).andStubReturn(new Date());
mockThreadPool.addTask(isA(Runnable.class));
expectLastCall().anyTimes();
}
@After
public void tearDown() throws Exception
{
classUnderTest = null;
}
@Test
public void testRefreshComponent() throws Exception
{
mockHelper.replayAll();
classUnderTest.setSession(mockSession);
classUnderTest.refreshComponent();
mockHelper.verifyAll();
}
@Test
public void testGetHint()
{
mockHelper.replayAll();
classUnderTest.setSession(mockSession);
Assert.assertNotNull(classUnderTest.getHint());
mockHelper.verifyAll();
}
@Test
public void testGetTitle()
{
mockHelper.replayAll();
classUnderTest.setSession(mockSession);
Assert.assertNotNull(classUnderTest.getTitle());
mockHelper.verifyAll();
}
}
Index: AbstractStatementTabTest.java
===================================================================
RCS file: /cvsroot/squirrel-sql/sql12/test/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AbstractStatementTabTest.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** AbstractStatementTabTest.java 30 Nov 2008 21:24:02 -0000 1.1
--- AbstractStatementTabTest.java 30 Nov 2008 22:22:27 -0000 1.2
***************
*** 27,71 ****
import java.sql.Types;
- import net.sourceforge.squirrel_sql.BaseSQuirreLJUnit4TestCase;
- import net.sourceforge.squirrel_sql.client.IApplication;
- import net.sourceforge.squirrel_sql.client.session.ISession;
- import net.sourceforge.squirrel_sql.client.session.SessionManager;
import net.sourceforge.squirrel_sql.client.session.properties.SessionProperties;
import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetListModel;
- import net.sourceforge.squirrel_sql.fw.id.IIdentifier;
import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
- import net.sourceforge.squirrel_sql.fw.sql.ISQLConnection;
- import net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData;
import org.junit.After;
import org.junit.Test;
- import utils.EasyMockHelper;
! public class AbstractStatementTabTest extends BaseSQuirreLJUnit4TestCase
{
protected BaseObjectTab classUnderTest = null;
! protected EasyMockHelper mockHelper = new EasyMockHelper();
! private static final String TEST_COLUMN_NAME = "aColumnName";
! protected static final String DATABASE_PRODUCT_VERSION = "1.0";
! protected String databaseProductName = null;
! private static final String TEST_QUALIFIED_NAME = "testQualifiedName";
! private static final String TEST_SIMPLE_NAME = "testSimpleName";
! private static final String TEST_CATALOG_NAME = "testCatalogName";
! private static final String TEST_SCHEMA_NAME = "testSchemaName";
public static final String STMT_SEP = ";";
public static final String HINT = "aHint";
! public static final String METADATA_OUTPUT_CLASSNAME = "aMetaDataOutputClassName";
! protected ISession mockSession = mockHelper.createMock(ISession.class);
protected SessionProperties mockSessionProperties = mockHelper.createMock(SessionProperties.class);
! protected IApplication mockApplication = mockHelper.createMock(IApplication.class);
! protected IIdentifier mockSessionId = mockHelper.createMock(IIdentifier.class);
! protected SessionManager mockSessionManager = mockHelper.createMock(SessionManager.class);
protected IDatabaseObjectInfo mockDatabaseObjectInfo = mockHelper.createMock(IDatabaseObjectInfo.class);
! protected ISQLConnection mockSQLConnection = mockHelper.createMock(ISQLConnection.class);
protected Statement mockStatement = mockHelper.createMock(Statement.class);
protected ResultSet mockResultSet = mockHelper.createMock(ResultSet.class);
! protected ISQLDatabaseMetaData mockMetaData = mockHelper.createMock(ISQLDatabaseMetaData.class);
protected ResultSetMetaData mockResultSetMetaData = mockHelper.createMock(ResultSetMetaData.class);
--- 27,55 ----
import java.sql.Types;
import net.sourceforge.squirrel_sql.client.session.properties.SessionProperties;
import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetListModel;
import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
import org.junit.After;
import org.junit.Test;
! public class AbstractStatementTabTest extends AbstractTabTest
{
protected BaseObjectTab classUnderTest = null;
!
public static final String STMT_SEP = ";";
+
public static final String HINT = "aHint";
!
protected SessionProperties mockSessionProperties = mockHelper.createMock(SessionProperties.class);
!
protected IDatabaseObjectInfo mockDatabaseObjectInfo = mockHelper.createMock(IDatabaseObjectInfo.class);
!
protected Statement mockStatement = mockHelper.createMock(Statement.class);
+
protected ResultSet mockResultSet = mockHelper.createMock(ResultSet.class);
!
protected ResultSetMetaData mockResultSetMetaData = mockHelper.createMock(ResultSetMetaData.class);
***************
*** 84,93 ****
public void testSelect() throws Exception
{
!
expect(mockSession.getApplication()).andStubReturn(mockApplication);
expect(mockSession.getIdentifier()).andStubReturn(mockSessionId);
expect(mockSession.getProperties()).andStubReturn(mockSessionProperties);
expect(mockSession.getMetaData()).andStubReturn(mockMetaData);
! expect(mockSessionProperties.getMetaDataOutputClassName()).andStubReturn(DataSetListModel.class.getName());
expect(mockApplication.getSessionManager()).andStubReturn(mockSessionManager);
expect(mockSessionManager.getSession(mockSessionId)).andStubReturn(mockSession);
--- 68,78 ----
public void testSelect() throws Exception
{
!
expect(mockSession.getApplication()).andStubReturn(mockApplication);
expect(mockSession.getIdentifier()).andStubReturn(mockSessionId);
expect(mockSession.getProperties()).andStubReturn(mockSessionProperties);
expect(mockSession.getMetaData()).andStubReturn(mockMetaData);
! expect(mockSessionProperties.getMetaDataOutputClassName()).andStubReturn(
! DataSetListModel.class.getName());
expect(mockApplication.getSessionManager()).andStubReturn(mockSessionManager);
expect(mockSessionManager.getSession(mockSessionId)).andStubReturn(mockSession);
***************
*** 117,125 ****
mockResultSet.close();
mockStatement.close();
!
mockHelper.replayAll();
classUnderTest.setSession(mockSession);
! classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo);
! classUnderTest.getComponent();
classUnderTest.select();
mockHelper.verifyAll();
--- 102,110 ----
mockResultSet.close();
mockStatement.close();
!
mockHelper.replayAll();
classUnderTest.setSession(mockSession);
! classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo);
! classUnderTest.getComponent();
classUnderTest.select();
mockHelper.verifyAll();
Index: AbstractSourceTabTest.java
===================================================================
RCS file: /cvsroot/squirrel-sql/sql12/test/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AbstractSourceTabTest.java,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** AbstractSourceTabTest.java 29 Nov 2008 15:08:45 -0000 1.2
--- AbstractSourceTabTest.java 30 Nov 2008 22:22:27 -0000 1.3
***************
*** 26,36 ****
import java.sql.ResultSet;
- import net.sourceforge.squirrel_sql.BaseSQuirreLJUnit4TestCase;
- import net.sourceforge.squirrel_sql.client.IApplication;
- import net.sourceforge.squirrel_sql.client.session.ISession;
- import net.sourceforge.squirrel_sql.client.session.SessionManager;
- import net.sourceforge.squirrel_sql.fw.id.IIdentifier;
import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
- import net.sourceforge.squirrel_sql.fw.sql.ISQLConnection;
import org.easymock.EasyMock;
--- 26,30 ----
***************
*** 38,102 ****
import org.junit.Test;
! import utils.EasyMockHelper;
- public class AbstractSourceTabTest extends BaseSQuirreLJUnit4TestCase {
- private static final String TEST_QUALIFIED_NAME = "testQualifiedName";
- private static final String TEST_SIMPLE_NAME = "testSimpleName";
- private static final String TEST_CATALOG_NAME = "testCatalogName";
- private static final String TEST_SCHEMA_NAME = "testSchemaName";
- public static final String STMT_SEP = ";";
- public static final String HINT = "aHint";
protected BaseSourceTab classUnderTest = null;
! protected EasyMockHelper mockHelper = new EasyMockHelper();
! protected ISession mockSession = mockHelper.createMock(ISession.class);
! protected IApplication mockApplication = mockHelper.createMock(IApplication.class);
! protected IIdentifier mockSessionId = mockHelper.createMock(IIdentifier.class);
! protected SessionManager mockSessionManager = mockHelper.createMock(SessionManager.class);
protected IDatabaseObjectInfo mockDatabaseObjectInfo = mockHelper.createMock(IDatabaseObjectInfo.class);
! protected ISQLConnection mockSQLConnection = mockHelper.createMock(ISQLConnection.class);
protected PreparedStatement mockPreparedStatement = mockHelper.createMock(PreparedStatement.class);
protected ResultSet mockResultSet = mockHelper.createMock(ResultSet.class);
! public AbstractSourceTabTest() {
super();
}
@After
! public void tearDown() throws Exception {
! classUnderTest = null;
! }
/**
* Verifies that the select method properly closes the PreparedStatement and ResultSet.
* @throws Exception
*/
@Test
! public final void testSelect() throws Exception {
!
! expect(mockSession.getApplication()).andStubReturn(mockApplication);
! expect(mockSession.getIdentifier()).andStubReturn(mockSessionId);
! 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.prepareStatement(isA(String.class))).andStubReturn(mockPreparedStatement);
! mockPreparedStatement.setString(EasyMock.anyInt(), isA(String.class));
! expectLastCall().anyTimes();
! expect(mockPreparedStatement.executeQuery()).andReturn(mockResultSet);
! expect(mockResultSet.next()).andStubReturn(false);
! mockResultSet.close();
! mockPreparedStatement.close();
!
! mockHelper.replayAll();
! classUnderTest.getComponent();
! classUnderTest.setSession(mockSession);
! classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo);
! classUnderTest.select();
! mockHelper.verifyAll();
! }
}
\ No newline at end of file
--- 32,91 ----
import org.junit.Test;
! public class AbstractSourceTabTest extends AbstractTabTest
! {
protected BaseSourceTab classUnderTest = null;
!
protected IDatabaseObjectInfo mockDatabaseObjectInfo = mockHelper.createMock(IDatabaseObjectInfo.class);
!
protected PreparedStatement mockPreparedStatement = mockHelper.createMock(PreparedStatement.class);
+
protected ResultSet mockResultSet = mockHelper.createMock(ResultSet.class);
! public AbstractSourceTabTest()
! {
super();
}
@After
! public void tearDown() throws Exception
! {
! classUnderTest = null;
! }
/**
* Verifies that the select method properly closes the PreparedStatement and ResultSet.
+ *
* @throws Exception
*/
@Test
! public final void testSelect() throws Exception
! {
!
! expect(mockSession.getApplication()).andStubReturn(mockApplication);
! expect(mockSession.getIdentifier()).andStubReturn(mockSessionId);
! 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.prepareStatement(isA(String.class))).andStubReturn(mockPreparedStatement);
! mockPreparedStatement.setString(EasyMock.anyInt(), isA(String.class));
! expectLastCall().anyTimes();
! expect(mockPreparedStatement.executeQuery()).andReturn(mockResultSet);
! expect(mockResultSet.next()).andStubReturn(false);
! mockResultSet.close();
! mockPreparedStatement.close();
!
! mockHelper.replayAll();
! classUnderTest.getComponent();
! classUnderTest.setSession(mockSession);
! classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo);
! classUnderTest.select();
! mockHelper.verifyAll();
! }
}
\ No newline at end of file
--- NEW FILE: AbstractTabTest.java ---
/*
* Copyright (C) 2008 Rob Manning
* manningr@...
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
package net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs;
import java.sql.Connection;
import net.sourceforge.squirrel_sql.BaseSQuirreLJUnit4TestCase;
import net.sourceforge.squirrel_sql.client.IApplication;
import net.sourceforge.squirrel_sql.client.session.ISession;
import net.sourceforge.squirrel_sql.client.session.SessionManager;
import net.sourceforge.squirrel_sql.fw.id.IIdentifier;
import net.sourceforge.squirrel_sql.fw.sql.ISQLConnection;
import net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData;
import net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData;
import net.sourceforge.squirrel_sql.fw.util.TaskThreadPool;
public class AbstractTabTest extends BaseSQuirreLJUnit4TestCase
{
public static final String STMT_SEP = ";";
public static final String HINT = "aHint";
public static final int TRANSACTION_ISOLATION = Connection.TRANSACTION_READ_COMMITTED;
protected ISession mockSession = mockHelper.createMock(ISession.class);
protected ISQLConnection mockSQLConnection = mockHelper.createMock(ISQLConnection.class);
protected ISQLDatabaseMetaData mockMetaData = mockHelper.createMock(ISQLDatabaseMetaData.class);
protected IApplication mockApplication = mockHelper.createMock(IApplication.class);
protected IIdentifier mockSessionId = mockHelper.createMock(IIdentifier.class);
protected SessionManager mockSessionManager = mockHelper.createMock(SessionManager.class);
protected TaskThreadPool mockThreadPool = mockHelper.createMock(TaskThreadPool.class);
protected SQLDatabaseMetaData mockSQLMetaData = mockHelper.createMock(SQLDatabaseMetaData.class);
protected Connection mockConnection = mockHelper.createMock(Connection.class);
protected String databaseProductName = null;
public static final String TEST_QUALIFIED_NAME = "testQualifiedName";
public static final String TEST_SIMPLE_NAME = "testSimpleName";
public static final String TEST_CATALOG_NAME = "testCatalogName";
public static final String TEST_SCHEMA_NAME = "testSchemaName";
public static final String TEST_COLUMN_NAME = "aColumnName";
protected static final String DATABASE_PRODUCT_VERSION = "1.0";
public static final String[] mockCatalogs = new String[] { TEST_CATALOG_NAME, "testCatalogName2" };
public static final String METADATA_OUTPUT_CLASSNAME = "aMetaDataOutputClassName";
public AbstractTabTest()
{
super();
}
}
|