geronimo-scm mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dwo...@apache.org
Subject svn commit: r701520 - in /geronimo/server/trunk/testsuite/console-testsuite/advanced/src/test/java/org/apache/geronimo/testsuite/console: DBManagerTest.java DatabasePoolTest.java
Date Fri, 03 Oct 2008 20:24:33 GMT
Author: dwoods
Date: Fri Oct  3 13:24:33 2008
New Revision: 701520

URL: http://svn.apache.org/viewvc?rev=701520&view=rev
Log:
GERONIMO-4225 add additional testcases for datasource vs. database focused Run SQL portlet
instances

Modified:
    geronimo/server/trunk/testsuite/console-testsuite/advanced/src/test/java/org/apache/geronimo/testsuite/console/DBManagerTest.java
    geronimo/server/trunk/testsuite/console-testsuite/advanced/src/test/java/org/apache/geronimo/testsuite/console/DatabasePoolTest.java

Modified: geronimo/server/trunk/testsuite/console-testsuite/advanced/src/test/java/org/apache/geronimo/testsuite/console/DBManagerTest.java
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/testsuite/console-testsuite/advanced/src/test/java/org/apache/geronimo/testsuite/console/DBManagerTest.java?rev=701520&r1=701519&r2=701520&view=diff
==============================================================================
--- geronimo/server/trunk/testsuite/console-testsuite/advanced/src/test/java/org/apache/geronimo/testsuite/console/DBManagerTest.java
(original)
+++ geronimo/server/trunk/testsuite/console-testsuite/advanced/src/test/java/org/apache/geronimo/testsuite/console/DBManagerTest.java
Fri Oct  3 13:24:33 2008
@@ -33,16 +33,14 @@
         selenium.click("//input[@value = 'Create']");
         waitForPageLoad();
         assertTrue(selenium.isTextPresent("MyUniqueDB"));
-        selenium.type("sqlStmts", "create table myTable ( id int primary key );");
-        selenium.select("useDB", "label=SystemDatabase");
         selenium.select("useDB", "label=MyUniqueDB");
+        selenium.type("sqlStmts", "create table myTable ( id int primary key );");
         selenium.click("//input[@value = 'Run SQL']");
         waitForPageLoad();
         //selenium.click("link=Application");
         selenium.click("//a[contains(@href, 'db=MyUniqueDB')]");
         waitForPageLoad();
         assertTrue(selenium.isTextPresent("MYTABLE"));
-        selenium.select("deleteDB", "label=SystemDatabase");
         selenium.select("deleteDB", "label=MyUniqueDB");
         selenium.click("//input[@value = 'Delete']");
         waitForPageLoad();
@@ -50,4 +48,15 @@
         waitForPageLoad();
         assertTrue(selenium.isTextPresent("Database deleted: MyUniqueDB"));
     }
+    
+    @Test
+    public void testRunSQL() throws Exception {
+        selenium.click("link=DB Manager");
+        waitForPageLoad();
+        selenium.select("useDB", "label=SystemDatabase");
+        selenium.type("sqlStmts", "select * from SYS.SYSDEPENDS;");
+        selenium.click("//input[@value = 'Run SQL']");
+        waitForPageLoad();
+        assertTrue(selenium.isTextPresent("SQL command/s successful"));
+    }
 }

Modified: geronimo/server/trunk/testsuite/console-testsuite/advanced/src/test/java/org/apache/geronimo/testsuite/console/DatabasePoolTest.java
URL: http://svn.apache.org/viewvc/geronimo/server/trunk/testsuite/console-testsuite/advanced/src/test/java/org/apache/geronimo/testsuite/console/DatabasePoolTest.java?rev=701520&r1=701519&r2=701520&view=diff
==============================================================================
--- geronimo/server/trunk/testsuite/console-testsuite/advanced/src/test/java/org/apache/geronimo/testsuite/console/DatabasePoolTest.java
(original)
+++ geronimo/server/trunk/testsuite/console-testsuite/advanced/src/test/java/org/apache/geronimo/testsuite/console/DatabasePoolTest.java
Fri Oct  3 13:24:33 2008
@@ -47,7 +47,18 @@
         waitForPageLoad();
         assertFalse(selenium.isTextPresent("UniquePool"));
     }
-    
+
+    @Test
+    public void testRunSQLDS() throws Exception {
+        selenium.click("link=Database Pools");
+        waitForPageLoad();
+        selenium.select("useDB", "label=SystemDatasource");
+        selenium.type("sqlStmts", "select * from SYS.SYSDEPENDS;");
+        selenium.click("//input[@value = 'Run SQL']");
+        waitForPageLoad();
+        assertTrue(selenium.isTextPresent("SQL command/s successful"));
+    }
+
     /*
     // cannot test yet. jetty is having problems rending the page
     



Mime
View raw message