comparison 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
comparison
equal deleted inserted replaced
274:92166f7c3842 275:e92d5944fe4b
126 public static final String SQL_OUTDATE_ARTIFACTS_COLLECTION = 126 public static final String SQL_OUTDATE_ARTIFACTS_COLLECTION =
127 SQL.get("outdate.artifacts.collection"); 127 SQL.get("outdate.artifacts.collection");
128 128
129 public static final String SQL_UPDATE_COLLECTION_TTL = 129 public static final String SQL_UPDATE_COLLECTION_TTL =
130 SQL.get("collections.update.ttl"); 130 SQL.get("collections.update.ttl");
131
132 public static final String SQL_UPDATE_COLLECTION_NAME =
133 SQL.get("collections.update.name");
131 134
132 public static final String SQL_OUTDATE_ARTIFACTS_USER = 135 public static final String SQL_OUTDATE_ARTIFACTS_USER =
133 SQL.get("outdate.artifacts.user"); 136 SQL.get("outdate.artifacts.user");
134 137
135 public static final String SQL_DELETE_USER_COLLECTION_ITEMS = 138 public static final String SQL_DELETE_USER_COLLECTION_ITEMS =
1539 1542
1540 return true; 1543 return true;
1541 } 1544 }
1542 }.runWrite(); 1545 }.runWrite();
1543 } 1546 }
1547
1548
1549 public boolean setCollectionName(final String uuid, final String name) {
1550 if (!isValidIdentifier(uuid)) {
1551 logger.debug("Invalid collection id: '" + uuid + "'");
1552 return false;
1553 }
1554
1555 return new SQLExecutor() {
1556 public boolean doIt() throws SQLException {
1557 prepareStatement(SQL_UPDATE_COLLECTION_NAME);
1558 stmnt.setString(1, name);
1559 stmnt.setString(2, uuid);
1560 stmnt.execute();
1561 conn.commit();
1562
1563 return true;
1564 }
1565 }.runWrite();
1566 }
1544 } 1567 }
1545 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : 1568 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

http://dive4elements.wald.intevation.org