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

Timestamp:

2013-07-19T16:48:54+12:00 (11 years ago)

Author:

sjm84

Message:

Added a way to clear the data saved by the depositor

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

@@ -688 +688 @@
         }
     }
+
+    public void clearUserDataWithPrefix(String username, String prefix)
+    {
+        try
+        {
+            conn.setAutoCommit(false);
+            state.execute("DELETE FROM data WHERE username = '" + username + "' AND SUBSTR(name, 1, " + prefix.length() + ") = '" + prefix + "'");
+            conn.commit();
+        }
+        catch (Exception ex)
+        {
+            ex.printStackTrace();
+        }
+    }
 }