Changeset 27807 for main/trunk/greenstone3/src/java/org/greenstone/gsdl3/util/DerbyWrapper.java

Timestamp:

2013-07-11T15:36:55+12:00 (11 years ago)

Author:

sjm84

Message:

Added a function to empty the user database (useful for testing)

File:

• main/trunk/greenstone3/src/java/org/greenstone/gsdl3/util/DerbyWrapper.java (modified) (1 diff)

main/trunk/greenstone3/src/java/org/greenstone/gsdl3/util/DerbyWrapper.java

@@ -134 +134 @@
             System.err.println("Warning: Derby did not shut down normally");
         }
-
+    }
+
+    public void clearUserData()
+    {
+        try
+        {
+            conn.setAutoCommit(false);
+            state.execute("drop table data");
+            state.execute("create table data (username varchar(40) not null, name varchar(128) not null, value clob, primary key (username, name))");
+            conn.commit();
+        }
+        catch (SQLException e)
+        {
+            e.printStackTrace();
+        }
     }