[Squirrel-sql-commits] SF.net SVN: squirrel-sql:[6382] trunk/sql12/ squirrelsql-integration-environment/src/test/java

[<man...@us...>]

Revision: 6382
          http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6382&view=rev
Author:   manningr
Date:     2011-08-30 10:30:05 +0000 (Tue, 30 Aug 2011)
Log Message:
-----------
External tests for BaseSourceTab implementations.  This requires aliases defined in local SQuirreL config that have the same name as those found in the AliasNames constants.

Added Paths:
-----------
    trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/client/session/mainpanel/
    trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/
    trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/
    trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AbstractBaseSourceTabExternalTest.java
    trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AliasNames.java
    trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/
    trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/tab/
    trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/tab/ProcedureSourceTabExternalTest.java
    trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/tab/TriggerSourceTabExternalTest.java
    trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/tab/ViewSourceTabExternalTest.java
    trunk/sql12/squirrelsql-integration-environment/src/test/java/org/
    trunk/sql12/squirrelsql-integration-environment/src/test/java/org/firebirdsql/
    trunk/sql12/squirrelsql-integration-environment/src/test/java/org/firebirdsql/squirrel/
    trunk/sql12/squirrelsql-integration-environment/src/test/java/org/firebirdsql/squirrel/tab/
    trunk/sql12/squirrelsql-integration-environment/src/test/java/org/firebirdsql/squirrel/tab/ViewSourceTabTest.java

Added: trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AbstractBaseSourceTabExternalTest.java
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AbstractBaseSourceTabExternalTest.java	                        (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AbstractBaseSourceTabExternalTest.java	2011-08-30 10:30:05 UTC (rev 6382)
@@ -0,0 +1,58 @@
+package net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs;
+
+import java.lang.reflect.Method;
+import java.sql.PreparedStatement;
+
+import net.sourceforge.squirrel_sql.client.session.ISession;
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseSourceTab;
+import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
+import net.sourceforge.squirrel_sql.plugins.dbcopy.cli.SessionUtil;
+
+import org.junit.Before;
+import org.junit.Test;
+import org.mockito.Mockito;
+
+public abstract class AbstractBaseSourceTabExternalTest
+{
+	
+	protected BaseSourceTab classUnderTest = null;
+	protected SessionUtil sessionUtil = new SessionUtil();
+	protected IDatabaseObjectInfo dboi = null;
+
+	protected abstract String getSimpleName();
+	
+	protected abstract BaseSourceTab getTabToTest();
+	
+	protected abstract String getAlias();
+	
+	protected String getSchemaName() {
+		return null;
+	}
+
+	@Before
+	public void setup() throws Exception
+	{
+		classUnderTest = getTabToTest();
+		ISession session = sessionUtil.getSessionForAlias(getAlias());
+		if (dboi == null) {
+			dboi = Mockito.mock(IDatabaseObjectInfo.class);
+			Mockito.when(dboi.getSchemaName()).thenReturn(getSchemaName());
+			Mockito.when(dboi.getSimpleName()).thenReturn(getSimpleName());
+		}
+		classUnderTest.setSession(session);
+		classUnderTest.setDatabaseObjectInfo(dboi);
+	}
+
+	@Test
+	public void testCreateStatement() throws Exception
+	{
+		Method m = classUnderTest.getClass().getDeclaredMethod("createStatement", (Class<?>[])null);
+		m.setAccessible(true);
+		Object result = m.invoke(classUnderTest, (Object[])null);
+	   PreparedStatement stmt = (PreparedStatement)result;
+		stmt.executeQuery();
+	}
+	
+	
+
+}

Added: trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AliasNames.java
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AliasNames.java	                        (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/AliasNames.java	2011-08-30 10:30:05 UTC (rev 6382)
@@ -0,0 +1,45 @@
+package net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs;
+
+public interface AliasNames
+{
+	String DB2_DEST_ALIAS_NAME = "DB2 (DBCPDST)";
+
+	String DB2_SOURCE_ALIAS_NAME = "DB2 (DBCPSRC)";
+
+	String DERBY_DEST_ALIAS_NAME = "Derby (dbcopydest)";
+
+	String DERBY_SOURCE_ALIAS_NAME = "Derby (dbcopysrc)";
+
+	String FIREBIRD_DEST_ALIAS_NAME = "Firebird (dbcopydest)";
+
+	String FRONTBASE_DEST_ALIAS_NAME = "Frontbase (dbcopydest)";
+
+	String H2_SOURCE_ALIAS_NAME = "H2 (dbcopysrc)";
+
+	String H2_DEST_ALIAS_NAME = "H2 (dbcopydest)";
+
+	String INFORMIX_DEST_ALIAS_NAME = "Informix (demo_on)";
+
+	String HSQLDB_SOURCE_ALIAS_NAME = "HSQLDB (dbcopysrc)";
+	
+	String HSQLDB_DEST_ALIAS_NAME = "HSQLDB (dbcopydest)";
+
+	String MYSQL4_DEST_ALIAS_NAME = "MySQL 4 (dbcopydest)";
+
+	String MYSQL4_SOURCE_ALIAS_NAME = "MySQL 4 (dbcopysrc)";
+
+	String MYSQL5_DEST_ALIAS_NAME = "MySQL 5 (dbcopydest)";
+
+	String MYSQL5_SOURCE_ALIAS_NAME = "MySQL 5 (dbcopysrc)";
+
+	String ORACLE_SOURCE_ALIAS_NAME = "Oracle (dbcopysrc)";
+
+	String ORACLE_DEST_ALIAS_NAME = "Oracle (dbcopydest)";
+
+	String POINTBASE_SOURCE_ALIAS_NAME = "Pointbase (dbcopysrc)";
+	
+	String POINTBASE_DEST_ALIAS_NAME = "Pointbase (dbcopydest)";
+	
+	String POSTGRES_DEST_ALIAS_NAME = "PostgreSQL";
+
+}

Added: trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/tab/ProcedureSourceTabExternalTest.java
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/tab/ProcedureSourceTabExternalTest.java	                        (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/tab/ProcedureSourceTabExternalTest.java	2011-08-30 10:30:05 UTC (rev 6382)
@@ -0,0 +1,38 @@
+package net.sourceforge.squirrel_sql.plugins.derby.tab;
+
+import java.sql.PreparedStatement;
+import java.sql.SQLException;
+
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.AbstractBaseSourceTabExternalTest;
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.AliasNames;
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseSourceTab;
+
+public class ProcedureSourceTabExternalTest extends AbstractBaseSourceTabExternalTest
+{
+	
+	protected String getSimpleName() {
+		return "testView";
+	}
+	
+	protected BaseSourceTab getTabToTest() {
+		return new MyStatementCreator();
+	}
+	
+	protected String getAlias() {
+		return AliasNames.DERBY_DEST_ALIAS_NAME;
+	}
+
+	private class MyStatementCreator extends ProcedureSourceTab {
+		public MyStatementCreator()
+		{
+			super("","");
+		}
+
+		@Override
+		public PreparedStatement createStatement() throws SQLException
+		{
+			return super.createStatement();
+		}
+		
+	}
+}

Added: trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/tab/TriggerSourceTabExternalTest.java
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/tab/TriggerSourceTabExternalTest.java	                        (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/tab/TriggerSourceTabExternalTest.java	2011-08-30 10:30:05 UTC (rev 6382)
@@ -0,0 +1,23 @@
+package net.sourceforge.squirrel_sql.plugins.derby.tab;
+
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.AbstractBaseSourceTabExternalTest;
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.AliasNames;
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseSourceTab;
+
+
+public class TriggerSourceTabExternalTest extends AbstractBaseSourceTabExternalTest
+{
+
+	protected String getSimpleName() {
+		return "testTrigger";
+	}
+		
+	protected BaseSourceTab getTabToTest() {
+		return new TriggerSourceTab("a hint");
+	}
+	
+	protected String getAlias() {
+		return AliasNames.DERBY_DEST_ALIAS_NAME;
+	}
+	
+}

Added: trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/tab/ViewSourceTabExternalTest.java
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/tab/ViewSourceTabExternalTest.java	                        (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/java/net/sourceforge/squirrel_sql/plugins/derby/tab/ViewSourceTabExternalTest.java	2011-08-30 10:30:05 UTC (rev 6382)
@@ -0,0 +1,22 @@
+package net.sourceforge.squirrel_sql.plugins.derby.tab;
+
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.AbstractBaseSourceTabExternalTest;
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.AliasNames;
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseSourceTab;
+
+public class ViewSourceTabExternalTest extends AbstractBaseSourceTabExternalTest
+{
+	
+	protected String getSimpleName() {
+		return "testView";
+	}
+	
+	protected BaseSourceTab getTabToTest() {
+		return new ViewSourceTab("a hint");
+	}
+	
+	protected String getAlias() {
+		return AliasNames.DERBY_DEST_ALIAS_NAME;
+	}
+
+}

Added: trunk/sql12/squirrelsql-integration-environment/src/test/java/org/firebirdsql/squirrel/tab/ViewSourceTabTest.java
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/java/org/firebirdsql/squirrel/tab/ViewSourceTabTest.java	                        (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/java/org/firebirdsql/squirrel/tab/ViewSourceTabTest.java	2011-08-30 10:30:05 UTC (rev 6382)
@@ -0,0 +1,38 @@
+package org.firebirdsql.squirrel.tab;
+
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.AbstractBaseSourceTabExternalTest;
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.AliasNames;
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseSourceTab;
+
+public class ViewSourceTabTest extends AbstractBaseSourceTabExternalTest
+{
+
+	@Override
+	protected String getSimpleName()
+	{
+		return "TestView";
+	}
+
+	@Override
+	protected BaseSourceTab getTabToTest()
+	{
+		return new ViewSourceTab("");
+	}
+
+	@Override
+	protected String getAlias()
+	{
+		return AliasNames.FIREBIRD_DEST_ALIAS_NAME;
+	}
+
+	/**
+	 * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.AbstractBaseSourceTabExternalTest#getSchemaName()
+	 */
+	@Override
+	protected String getSchemaName()
+	{
+		return "";
+	}
+
+
+}

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.