2. Summary
  3. Files
  4. Support
  5. Report Spam
  6. Create account
  7. Log in

Changeset 4723

Show
Ignore:
Timestamp:
11/30/08 22:22:27 (4 years ago)
Author:
manningr
Message:

Added base test class for tab test and added new tests.

Location:
trunk/sql12/test/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs
Files:
5 added
3 modified

Legend:

Unmodified
Added
Removed

  • trunk/sql12/test/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AbstractBasePreparedStatementTabTest.java

    r4713 r4723  
    3333import org.junit.Test; 
    3434 
    35 import utils.EasyMockHelper; 
    36 import net.sourceforge.squirrel_sql.BaseSQuirreLJUnit4TestCase; 
    37 import net.sourceforge.squirrel_sql.client.IApplication; 
    38 import net.sourceforge.squirrel_sql.client.session.ISession; 
    39 import net.sourceforge.squirrel_sql.client.session.SessionManager; 
    4035import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BasePreparedStatementTab; 
    4136import net.sourceforge.squirrel_sql.client.session.properties.SessionProperties; 
    4237import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetListModel; 
    43 import net.sourceforge.squirrel_sql.fw.id.IIdentifier; 
    4438import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo; 
    45 import net.sourceforge.squirrel_sql.fw.sql.ISQLConnection; 
    46 import net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData; 
    4739 
    48 public class AbstractBasePreparedStatementTabTest extends BaseSQuirreLJUnit4TestCase 
     40public class AbstractBasePreparedStatementTabTest extends AbstractTabTest 
    4941{ 
    5042 
    51         private static final String TEST_COLUMN_NAME = "aColumnName"; 
    52         protected static final String DATABASE_PRODUCT_VERSION = "1.0"; 
    53         protected EasyMockHelper mockHelper = new EasyMockHelper(); 
    5443        protected BasePreparedStatementTab classUnderTest = null; 
    55         protected String databaseProductName = null; 
    56         private static final String TEST_QUALIFIED_NAME = "testQualifiedName"; 
    57         private static final String TEST_SIMPLE_NAME = "testSimpleName"; 
    58         private static final String TEST_CATALOG_NAME = "testCatalogName"; 
    59         private static final String TEST_SCHEMA_NAME = "testSchemaName"; 
     44 
    6045        public static final String STMT_SEP = ";"; 
     46 
    6147        public static final String HINT = "aHint"; 
    62         public static final String METADATA_OUTPUT_CLASSNAME = "aMetaDataOutputClassName"; 
    63         protected ISession mockSession = mockHelper.createMock(ISession.class); 
     48 
    6449        protected SessionProperties mockSessionProperties = mockHelper.createMock(SessionProperties.class); 
    65         protected IApplication mockApplication = mockHelper.createMock(IApplication.class); 
    66         protected IIdentifier mockSessionId = mockHelper.createMock(IIdentifier.class); 
    67         protected SessionManager mockSessionManager = mockHelper.createMock(SessionManager.class); 
     50 
    6851        protected IDatabaseObjectInfo mockDatabaseObjectInfo = mockHelper.createMock(IDatabaseObjectInfo.class); 
    69         protected ISQLConnection mockSQLConnection = mockHelper.createMock(ISQLConnection.class); 
     52 
    7053        protected PreparedStatement mockPreparedStatement = mockHelper.createMock(PreparedStatement.class); 
     54 
    7155        protected ResultSet mockResultSet = mockHelper.createMock(ResultSet.class); 
    72         protected ISQLDatabaseMetaData mockMetaData = mockHelper.createMock(ISQLDatabaseMetaData.class); 
     56 
    7357        protected ResultSetMetaData mockResultSetMetaData = mockHelper.createMock(ResultSetMetaData.class); 
    7458 
    75         public AbstractBasePreparedStatementTabTest() { 
     59        public AbstractBasePreparedStatementTabTest() 
     60        { 
    7661                super(); 
    7762        } 
    7863 
    7964        @After 
    80    public void tearDown() throws Exception 
    81    { 
    82         classUnderTest = null; 
    83    } 
     65        public void tearDown() throws Exception 
     66        { 
     67                classUnderTest = null; 
     68        } 
    8469 
    8570        @Test 
    86    public void testSelect() throws SQLException 
    87    { 
    88         expect(mockSession.getApplication()).andStubReturn(mockApplication); 
    89         expect(mockSession.getIdentifier()).andStubReturn(mockSessionId); 
    90         expect(mockSession.getProperties()).andStubReturn(mockSessionProperties); 
    91         expect(mockSession.getMetaData()).andStubReturn(mockMetaData); 
    92         expect(mockSessionProperties.getMetaDataOutputClassName()).andStubReturn(DataSetListModel.class.getName()); 
    93         expect(mockApplication.getSessionManager()).andStubReturn(mockSessionManager); 
    94         expect(mockSessionManager.getSession(mockSessionId)).andStubReturn(mockSession); 
    95         expect(mockDatabaseObjectInfo.getSchemaName()).andStubReturn(TEST_SCHEMA_NAME); 
    96         expect(mockDatabaseObjectInfo.getCatalogName()).andStubReturn(TEST_CATALOG_NAME); 
    97         expect(mockDatabaseObjectInfo.getSimpleName()).andStubReturn(TEST_SIMPLE_NAME); 
    98         expect(mockDatabaseObjectInfo.getQualifiedName()).andStubReturn(TEST_QUALIFIED_NAME); 
    99         expect(mockSession.getSQLConnection()).andStubReturn(mockSQLConnection); 
    100         expect(mockSQLConnection.prepareStatement(isA(String.class))).andStubReturn(mockPreparedStatement); 
    101         expect(mockMetaData.getDatabaseProductName()).andStubReturn(databaseProductName); 
    102         expect(mockMetaData.getDatabaseProductVersion()).andStubReturn(DATABASE_PRODUCT_VERSION); 
    103         mockPreparedStatement.setString(EasyMock.anyInt(), isA(String.class)); 
    104         expectLastCall().anyTimes(); 
    105         expect(mockPreparedStatement.executeQuery()).andStubReturn(mockResultSet); 
    106         expect(mockResultSet.next()).andStubReturn(false); 
    107         expect(mockResultSet.getMetaData()).andStubReturn(mockResultSetMetaData); 
    108         expect(mockResultSetMetaData.getColumnCount()).andStubReturn(1); 
    109         expect(mockResultSetMetaData.isNullable(1)).andStubReturn(ResultSetMetaData.columnNoNulls); 
    110         expect(mockResultSetMetaData.getPrecision(1)).andStubReturn(10); 
    111         expect(mockResultSetMetaData.isSigned(1)).andReturn(true); 
    112         expect(mockResultSetMetaData.isCurrency(1)).andReturn(true); 
    113         expect(mockResultSetMetaData.isAutoIncrement(1)).andReturn(true); 
    114         expect(mockResultSetMetaData.getColumnName(1)).andReturn(TEST_COLUMN_NAME); 
    115         expect(mockResultSetMetaData.getColumnTypeName(1)).andReturn("VARCHAR"); 
    116         expect(mockResultSetMetaData.getColumnType(1)).andReturn(Types.VARCHAR); 
    117         expect(mockResultSetMetaData.getColumnDisplaySize(1)).andStubReturn(10); 
    118         expect(mockResultSetMetaData.getColumnLabel(1)).andStubReturn(TEST_COLUMN_NAME); 
    119         expect(mockResultSetMetaData.getScale(1)).andStubReturn(3); 
    120          
    121         mockResultSet.close(); 
    122         mockPreparedStatement.close(); 
    123          
    124         mockHelper.replayAll(); 
    125         classUnderTest.setSession(mockSession); 
    126         classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo);            
    127         classUnderTest.getComponent(); 
    128         classUnderTest.select(); 
    129         mockHelper.verifyAll(); 
    130    } 
     71        public void testSelect() throws SQLException 
     72        { 
     73                expect(mockSession.getApplication()).andStubReturn(mockApplication); 
     74                expect(mockSession.getIdentifier()).andStubReturn(mockSessionId); 
     75                expect(mockSession.getProperties()).andStubReturn(mockSessionProperties); 
     76                expect(mockSession.getMetaData()).andStubReturn(mockMetaData); 
     77                expect(mockSessionProperties.getMetaDataOutputClassName()).andStubReturn( 
     78                        DataSetListModel.class.getName()); 
     79                expect(mockApplication.getSessionManager()).andStubReturn(mockSessionManager); 
     80                expect(mockSessionManager.getSession(mockSessionId)).andStubReturn(mockSession); 
     81                expect(mockDatabaseObjectInfo.getSchemaName()).andStubReturn(TEST_SCHEMA_NAME); 
     82                expect(mockDatabaseObjectInfo.getCatalogName()).andStubReturn(TEST_CATALOG_NAME); 
     83                expect(mockDatabaseObjectInfo.getSimpleName()).andStubReturn(TEST_SIMPLE_NAME); 
     84                expect(mockDatabaseObjectInfo.getQualifiedName()).andStubReturn(TEST_QUALIFIED_NAME); 
     85                expect(mockSession.getSQLConnection()).andStubReturn(mockSQLConnection); 
     86                expect(mockSQLConnection.prepareStatement(isA(String.class))).andStubReturn(mockPreparedStatement); 
     87                expect(mockMetaData.getDatabaseProductName()).andStubReturn(databaseProductName); 
     88                expect(mockMetaData.getDatabaseProductVersion()).andStubReturn(DATABASE_PRODUCT_VERSION); 
     89                mockPreparedStatement.setString(EasyMock.anyInt(), isA(String.class)); 
     90                expectLastCall().anyTimes(); 
     91                expect(mockPreparedStatement.executeQuery()).andStubReturn(mockResultSet); 
     92                expect(mockResultSet.next()).andStubReturn(false); 
     93                expect(mockResultSet.getMetaData()).andStubReturn(mockResultSetMetaData); 
     94                expect(mockResultSetMetaData.getColumnCount()).andStubReturn(1); 
     95                expect(mockResultSetMetaData.isNullable(1)).andStubReturn(ResultSetMetaData.columnNoNulls); 
     96                expect(mockResultSetMetaData.getPrecision(1)).andStubReturn(10); 
     97                expect(mockResultSetMetaData.isSigned(1)).andReturn(true); 
     98                expect(mockResultSetMetaData.isCurrency(1)).andReturn(true); 
     99                expect(mockResultSetMetaData.isAutoIncrement(1)).andReturn(true); 
     100                expect(mockResultSetMetaData.getColumnName(1)).andReturn(TEST_COLUMN_NAME); 
     101                expect(mockResultSetMetaData.getColumnTypeName(1)).andReturn("VARCHAR"); 
     102                expect(mockResultSetMetaData.getColumnType(1)).andReturn(Types.VARCHAR); 
     103                expect(mockResultSetMetaData.getColumnDisplaySize(1)).andStubReturn(10); 
     104                expect(mockResultSetMetaData.getColumnLabel(1)).andStubReturn(TEST_COLUMN_NAME); 
     105                expect(mockResultSetMetaData.getScale(1)).andStubReturn(3); 
     106 
     107                mockResultSet.close(); 
     108                mockPreparedStatement.close(); 
     109 
     110                mockHelper.replayAll(); 
     111                classUnderTest.setSession(mockSession); 
     112                classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo); 
     113                classUnderTest.getComponent(); 
     114                classUnderTest.select(); 
     115                mockHelper.verifyAll(); 
     116        } 
    131117 
    132118} 

  • trunk/sql12/test/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AbstractSourceTabTest.java

    r4714 r4723  
    2626import java.sql.ResultSet; 
    2727 
    28 import net.sourceforge.squirrel_sql.BaseSQuirreLJUnit4TestCase; 
    29 import net.sourceforge.squirrel_sql.client.IApplication; 
    30 import net.sourceforge.squirrel_sql.client.session.ISession; 
    31 import net.sourceforge.squirrel_sql.client.session.SessionManager; 
    32 import net.sourceforge.squirrel_sql.fw.id.IIdentifier; 
    3328import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo; 
    34 import net.sourceforge.squirrel_sql.fw.sql.ISQLConnection; 
    3529 
    3630import org.easymock.EasyMock; 
    … …  
    3832import org.junit.Test; 
    3933 
    40 import utils.EasyMockHelper; 
     34public class AbstractSourceTabTest extends AbstractTabTest 
     35{ 
    4136 
    42 public class AbstractSourceTabTest extends BaseSQuirreLJUnit4TestCase { 
    4337 
    44         private static final String TEST_QUALIFIED_NAME = "testQualifiedName"; 
    45         private static final String TEST_SIMPLE_NAME = "testSimpleName"; 
    46         private static final String TEST_CATALOG_NAME = "testCatalogName"; 
    47         private static final String TEST_SCHEMA_NAME = "testSchemaName"; 
    48         public static final String STMT_SEP = ";"; 
    49         public static final String HINT = "aHint"; 
    5038        protected BaseSourceTab classUnderTest = null; 
    51         protected EasyMockHelper mockHelper = new EasyMockHelper(); 
    52         protected ISession mockSession = mockHelper.createMock(ISession.class); 
    53         protected IApplication mockApplication = mockHelper.createMock(IApplication.class); 
    54         protected IIdentifier mockSessionId = mockHelper.createMock(IIdentifier.class); 
    55         protected SessionManager mockSessionManager = mockHelper.createMock(SessionManager.class); 
     39 
    5640        protected IDatabaseObjectInfo mockDatabaseObjectInfo = mockHelper.createMock(IDatabaseObjectInfo.class); 
    57         protected ISQLConnection mockSQLConnection = mockHelper.createMock(ISQLConnection.class); 
     41 
    5842        protected PreparedStatement mockPreparedStatement = mockHelper.createMock(PreparedStatement.class); 
     43 
    5944        protected ResultSet mockResultSet = mockHelper.createMock(ResultSet.class); 
    6045 
    61         public AbstractSourceTabTest() { 
     46        public AbstractSourceTabTest() 
     47        { 
    6248                super(); 
    6349        } 
    6450 
    6551        @After 
    66    public void tearDown() throws Exception { 
    67         classUnderTest = null; 
    68    } 
     52        public void tearDown() throws Exception 
     53        { 
     54                classUnderTest = null; 
     55        } 
    6956 
    7057        /** 
    7158         * Verifies that the select method properly closes the PreparedStatement and ResultSet. 
     59         *  
    7260         * @throws Exception 
    7361         */ 
    7462        @Test 
    75    public final void testSelect() throws Exception { 
    76          
    77         expect(mockSession.getApplication()).andStubReturn(mockApplication); 
    78         expect(mockSession.getIdentifier()).andStubReturn(mockSessionId); 
    79         expect(mockApplication.getSessionManager()).andStubReturn(mockSessionManager); 
    80         expect(mockSessionManager.getSession(mockSessionId)).andStubReturn(mockSession); 
    81         expect(mockDatabaseObjectInfo.getSchemaName()).andStubReturn(TEST_SCHEMA_NAME); 
    82         expect(mockDatabaseObjectInfo.getCatalogName()).andStubReturn(TEST_CATALOG_NAME); 
    83         expect(mockDatabaseObjectInfo.getSimpleName()).andStubReturn(TEST_SIMPLE_NAME); 
    84         expect(mockDatabaseObjectInfo.getQualifiedName()).andStubReturn(TEST_QUALIFIED_NAME); 
    85         expect(mockSession.getSQLConnection()).andStubReturn(mockSQLConnection); 
    86         expect(mockSQLConnection.prepareStatement(isA(String.class))).andStubReturn(mockPreparedStatement); 
    87         mockPreparedStatement.setString(EasyMock.anyInt(), isA(String.class)); 
    88         expectLastCall().anyTimes(); 
    89         expect(mockPreparedStatement.executeQuery()).andReturn(mockResultSet); 
    90         expect(mockResultSet.next()).andStubReturn(false); 
    91         mockResultSet.close(); 
    92         mockPreparedStatement.close(); 
    93          
    94         mockHelper.replayAll(); 
    95         classUnderTest.getComponent(); 
    96         classUnderTest.setSession(mockSession); 
    97         classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo); 
    98         classUnderTest.select(); 
    99         mockHelper.verifyAll(); 
    100    } 
     63        public final void testSelect() throws Exception 
     64        { 
     65 
     66                expect(mockSession.getApplication()).andStubReturn(mockApplication); 
     67                expect(mockSession.getIdentifier()).andStubReturn(mockSessionId); 
     68                expect(mockApplication.getSessionManager()).andStubReturn(mockSessionManager); 
     69                expect(mockSessionManager.getSession(mockSessionId)).andStubReturn(mockSession); 
     70                expect(mockDatabaseObjectInfo.getSchemaName()).andStubReturn(TEST_SCHEMA_NAME); 
     71                expect(mockDatabaseObjectInfo.getCatalogName()).andStubReturn(TEST_CATALOG_NAME); 
     72                expect(mockDatabaseObjectInfo.getSimpleName()).andStubReturn(TEST_SIMPLE_NAME); 
     73                expect(mockDatabaseObjectInfo.getQualifiedName()).andStubReturn(TEST_QUALIFIED_NAME); 
     74                expect(mockSession.getSQLConnection()).andStubReturn(mockSQLConnection); 
     75                expect(mockSQLConnection.prepareStatement(isA(String.class))).andStubReturn(mockPreparedStatement); 
     76                mockPreparedStatement.setString(EasyMock.anyInt(), isA(String.class)); 
     77                expectLastCall().anyTimes(); 
     78                expect(mockPreparedStatement.executeQuery()).andReturn(mockResultSet); 
     79                expect(mockResultSet.next()).andStubReturn(false); 
     80                mockResultSet.close(); 
     81                mockPreparedStatement.close(); 
     82 
     83                mockHelper.replayAll(); 
     84                classUnderTest.getComponent(); 
     85                classUnderTest.setSession(mockSession); 
     86                classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo); 
     87                classUnderTest.select(); 
     88                mockHelper.verifyAll(); 
     89        } 
    10190 
    10291} 

  • trunk/sql12/test/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AbstractStatementTabTest.java

    r4722 r4723  
    2727import java.sql.Types; 
    2828 
    29 import net.sourceforge.squirrel_sql.BaseSQuirreLJUnit4TestCase; 
    30 import net.sourceforge.squirrel_sql.client.IApplication; 
    31 import net.sourceforge.squirrel_sql.client.session.ISession; 
    32 import net.sourceforge.squirrel_sql.client.session.SessionManager; 
    3329import net.sourceforge.squirrel_sql.client.session.properties.SessionProperties; 
    3430import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetListModel; 
    35 import net.sourceforge.squirrel_sql.fw.id.IIdentifier; 
    3631import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo; 
    37 import net.sourceforge.squirrel_sql.fw.sql.ISQLConnection; 
    38 import net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData; 
    3932 
    4033import org.junit.After; 
    4134import org.junit.Test; 
    4235 
    43 import utils.EasyMockHelper; 
    4436 
    45 public class AbstractStatementTabTest extends BaseSQuirreLJUnit4TestCase 
     37public class AbstractStatementTabTest extends AbstractTabTest 
    4638{ 
    4739 
    4840        protected BaseObjectTab classUnderTest = null; 
    49         protected EasyMockHelper mockHelper = new EasyMockHelper(); 
    50         private static final String TEST_COLUMN_NAME = "aColumnName"; 
    51         protected static final String DATABASE_PRODUCT_VERSION = "1.0"; 
    52         protected String databaseProductName = null; 
    53         private static final String TEST_QUALIFIED_NAME = "testQualifiedName"; 
    54         private static final String TEST_SIMPLE_NAME = "testSimpleName"; 
    55         private static final String TEST_CATALOG_NAME = "testCatalogName"; 
    56         private static final String TEST_SCHEMA_NAME = "testSchemaName"; 
     41 
    5742        public static final String STMT_SEP = ";"; 
     43 
    5844        public static final String HINT = "aHint"; 
    59         public static final String METADATA_OUTPUT_CLASSNAME = "aMetaDataOutputClassName"; 
    60         protected ISession mockSession = mockHelper.createMock(ISession.class); 
     45 
    6146        protected SessionProperties mockSessionProperties = mockHelper.createMock(SessionProperties.class); 
    62         protected IApplication mockApplication = mockHelper.createMock(IApplication.class); 
    63         protected IIdentifier mockSessionId = mockHelper.createMock(IIdentifier.class); 
    64         protected SessionManager mockSessionManager = mockHelper.createMock(SessionManager.class); 
     47 
    6548        protected IDatabaseObjectInfo mockDatabaseObjectInfo = mockHelper.createMock(IDatabaseObjectInfo.class); 
    66         protected ISQLConnection mockSQLConnection = mockHelper.createMock(ISQLConnection.class); 
     49 
    6750        protected Statement mockStatement = mockHelper.createMock(Statement.class); 
     51 
    6852        protected ResultSet mockResultSet = mockHelper.createMock(ResultSet.class); 
    69         protected ISQLDatabaseMetaData mockMetaData = mockHelper.createMock(ISQLDatabaseMetaData.class); 
     53 
    7054        protected ResultSetMetaData mockResultSetMetaData = mockHelper.createMock(ResultSetMetaData.class); 
    7155 
    … …  
    8468        public void testSelect() throws Exception 
    8569        { 
    86                  
     70 
    8771                expect(mockSession.getApplication()).andStubReturn(mockApplication); 
    8872                expect(mockSession.getIdentifier()).andStubReturn(mockSessionId); 
    8973                expect(mockSession.getProperties()).andStubReturn(mockSessionProperties); 
    9074                expect(mockSession.getMetaData()).andStubReturn(mockMetaData); 
    91                 expect(mockSessionProperties.getMetaDataOutputClassName()).andStubReturn(DataSetListModel.class.getName()); 
     75                expect(mockSessionProperties.getMetaDataOutputClassName()).andStubReturn( 
     76                        DataSetListModel.class.getName()); 
    9277                expect(mockApplication.getSessionManager()).andStubReturn(mockSessionManager); 
    9378                expect(mockSessionManager.getSession(mockSessionId)).andStubReturn(mockSession); 
    … …  
    117102                mockResultSet.close(); 
    118103                mockStatement.close(); 
    119                  
     104 
    120105                mockHelper.replayAll(); 
    121106                classUnderTest.setSession(mockSession); 
    122                 classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo);            
    123                 classUnderTest.getComponent();           
     107                classUnderTest.setDatabaseObjectInfo(mockDatabaseObjectInfo); 
     108                classUnderTest.getComponent(); 
    124109                classUnderTest.select(); 
    125110                mockHelper.verifyAll(); 

© 2013 SourceForge. All Rights Reserved. SourceForge is a Dice Holdings, Inc. company   Terms of Use - Privacy Policy - Cookies/Opt Out