diff artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java @ 275:e92d5944fe4b

Enabled the artifact database to retrieve requests to change the name of a specific collection. artifacts/trunk@2074 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Wed, 08 Jun 2011 07:36:43 +0000
parents 22a90706d32d
children 942a54670a72
line wrap: on
line diff
--- a/artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java	Tue Jun 07 17:09:25 2011 +0000
+++ b/artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java	Wed Jun 08 07:36:43 2011 +0000
@@ -129,6 +129,9 @@
     public static final String SQL_UPDATE_COLLECTION_TTL =
         SQL.get("collections.update.ttl");
 
+    public static final String SQL_UPDATE_COLLECTION_NAME =
+        SQL.get("collections.update.name");
+
     public static final String SQL_OUTDATE_ARTIFACTS_USER =
         SQL.get("outdate.artifacts.user");
 
@@ -1541,5 +1544,25 @@
             }
         }.runWrite();
     }
+
+
+    public boolean setCollectionName(final String uuid, final String name) {
+        if (!isValidIdentifier(uuid)) {
+            logger.debug("Invalid collection id: '" + uuid + "'");
+            return false;
+        }
+
+        return new SQLExecutor() {
+            public boolean doIt() throws SQLException {
+                prepareStatement(SQL_UPDATE_COLLECTION_NAME);
+                stmnt.setString(1, name);
+                stmnt.setString(2, uuid);
+                stmnt.execute();
+                conn.commit();
+
+                return true;
+            }
+        }.runWrite();
+    }
 }
 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

http://dive4elements.wald.intevation.org