dive4elements/framework: artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java annotate

annotate artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java @ 273:22a90706d32d

Enables the artifact server to set the TTL of a specific collection via REST call. artifacts/trunk@2070 c6561f87-3c4e-4783-a992-168aeb5c3f6f

author	Ingo Weinzierl <ingo.weinzierl@intevation.de>
date	Tue, 07 Jun 2011 16:27:47 +0000
parents	a2df2b48d2aa
children	e92d5944fe4b

rev	line source
100 933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	1 /*
182 7eebe707a034 Added helper to be return in Backend.listCollectionArtifacts() Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 180 diff changeset	2 * Copyright (c) 2010, 2011 by Intevation GmbH
100 933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	3 *
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	4 * This program is free software under the LGPL (>=v2.1)
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	5 * Read the file LGPL.txt coming with the software for details
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	6 * or visit http://www.gnu.org/licenses/ if it does not exist.
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	7 */
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	8 package de.intevation.artifactdatabase;
0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	9
158 d718a4d55662 Implemented the createCollection() method in the artifact database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 157 diff changeset	10 import de.intevation.artifacts.Artifact;
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	11 import de.intevation.artifacts.ArtifactCollection;
158 d718a4d55662 Implemented the createCollection() method in the artifact database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 157 diff changeset	12 import de.intevation.artifacts.ArtifactCollectionFactory;
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	13 import de.intevation.artifacts.ArtifactFactory;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	14 import de.intevation.artifacts.ArtifactSerializer;
186 15c7638511dc Added an interface for CollectionItems and renamed the CollectionItem class from the artifact-database package to DefaultCollectionItem - because this is the default implementation of the interface. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 184 diff changeset	15 import de.intevation.artifacts.CollectionItem;
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	16 import de.intevation.artifacts.User;
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	17 import de.intevation.artifacts.UserFactory;
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	18
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	19 import de.intevation.artifacts.common.utils.XMLUtils;
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	20
93 e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 90 diff changeset	21 import java.sql.SQLException;
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	22 import java.sql.Timestamp;
93 e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 90 diff changeset	23 import java.sql.Types;
e27cf9c84eb8 Unified imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 90 diff changeset	24
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	25 import java.util.ArrayList;
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	26 import java.util.Date;
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	27 import java.util.HashMap;
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	28
17 5a6b6a3debc7 Integrated logging into artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 15 diff changeset	29 import org.apache.log4j.Logger;
5a6b6a3debc7 Integrated logging into artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 15 diff changeset	30
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	31 import org.w3c.dom.Document;
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	32
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	33 /**
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	34 * The backend implements the low level layer used to store artifacts
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	35 * in a SQL database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	36 *
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	37 * @author <a href="mailto:sascha.teichmann@intevation.de">Sascha L. Teichmann</a>
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	38 */
0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	39 public class Backend
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	40 implements DatabaseCleaner.ArtifactReviver
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	41 {
17 5a6b6a3debc7 Integrated logging into artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 15 diff changeset	42 private static Logger logger = Logger.getLogger(Backend.class);
5a6b6a3debc7 Integrated logging into artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 15 diff changeset	43
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	44 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	45 * The SQL statement to create new artifact id inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	46 */
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	47 public static final String SQL_NEXT_ID =
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	48 SQL.get("artifacts.id.nextval");
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	49
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	50 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	51 * The SQL statement to insert an artifact into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	52 */
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	53 public static final String SQL_INSERT =
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	54 SQL.get("artifacts.insert");
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	55
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	56 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	57 * The SQL statement to update some columns of an existing
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	58 * artifact in the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	59 */
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	60 public static final String SQL_UPDATE =
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	61 SQL.get("artifacts.update");
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	62
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	63 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	64 * The SQL statement to touch the access time of an
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	65 * artifact inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	66 */
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	67 public static final String SQL_TOUCH =
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	68 SQL.get("artifacts.touch");
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	69
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	70 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	71 * The SQL statement to load an artifact by a given
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	72 * identifier from the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	73 */
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	74 public static final String SQL_LOAD_BY_GID =
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	75 SQL.get("artifacts.select.gid");
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	76
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	77 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	78 * The SQL statement to get the database id of an artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	79 * identified by the identifier.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	80 */
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	81 public static final String SQL_GET_ID =
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	82 SQL.get("artifacts.get.id");
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	83
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	84 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	85 * The SQL statement to replace the content of an
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	86 * existing artifact inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	87 */
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	88 public static final String SQL_REPLACE =
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	89 SQL.get("artifacts.replace");
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	90
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	91 // USER SQL
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	92
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	93 public static final String SQL_USERS_NEXT_ID =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	94 SQL.get("users.id.nextval");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	95
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	96 public static final String SQL_USERS_INSERT =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	97 SQL.get("users.insert");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	98
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	99 public static final String SQL_USERS_SELECT_ID_BY_GID =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	100 SQL.get("users.select.id.by.gid");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	101
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	102 public static final String SQL_USERS_SELECT_GID =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	103 SQL.get("users.select.gid");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	104
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	105 public static final String SQL_USERS_DELETE_ID =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	106 SQL.get("users.delete.id");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	107
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	108 public static final String SQL_USERS_DELETE_COLLECTIONS =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	109 SQL.get("users.delete.collections");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	110
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	111 public static final String SQL_USERS_SELECT_ALL =
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	112 SQL.get("users.select.all");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	113
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	114 public static final String SQL_USERS_COLLECTIONS =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	115 SQL.get("users.collections");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	116
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	117 public static final String SQL_USERS_COLLECTION_IDS =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	118 SQL.get("users.collection.ids");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	119
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	120 public static final String SQL_USERS_DELETE_ALL_COLLECTIONS =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	121 SQL.get("users.delete.all.collections");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	122
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	123 public static final String SQL_ARTIFACTS_IN_ONLY_COLLECTION_ONLY =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	124 SQL.get("artifacts.in.one.collection.only");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	125
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	126 public static final String SQL_OUTDATE_ARTIFACTS_COLLECTION =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	127 SQL.get("outdate.artifacts.collection");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	128
273 22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	129 public static final String SQL_UPDATE_COLLECTION_TTL =
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	130 SQL.get("collections.update.ttl");
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	131
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	132 public static final String SQL_OUTDATE_ARTIFACTS_USER =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	133 SQL.get("outdate.artifacts.user");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	134
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	135 public static final String SQL_DELETE_USER_COLLECTION_ITEMS =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	136 SQL.get("delete.user.collection.items");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	137
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	138 public static final String SQL_COLLECTIONS_NEXT_ID =
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	139 SQL.get("collections.id.nextval");
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	140
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	141 public static final String SQL_COLLECTIONS_INSERT =
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	142 SQL.get("collections.insert");
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	143
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	144 public static final String SQL_COLLECTIONS_SELECT_USER =
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	145 SQL.get("collections.select.user");
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	146
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	147 public static final String SQL_COLLECTIONS_SELECT_ALL =
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	148 SQL.get("collections.select.all");
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	149
217 87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	150 public static final String SQL_COLLECTIONS_SELECT_GID =
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	151 SQL.get("collections.select.by.gid");
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	152
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	153 public static final String SQL_COLLECTIONS_CREATION_TIME =
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	154 SQL.get("collection.creation.time");
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	155
175 16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	156 public static final String SQL_COLLECTIONS_ID_BY_GID =
187 a85d889a1b0d Fixed some backend specific stuff (sql statements, schema). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 186 diff changeset	157 SQL.get("collections.id.by.gid");
175 16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	158
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	159 public static final String SQL_DELETE_COLLECTION_ITEMS =
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	160 SQL.get("delete.collection.items");
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	161
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	162 public static final String SQL_DELETE_COLLECTION =
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	163 SQL.get("delete.collection");
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	164
176 a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	165 public static final String SQL_COLLECTION_CHECK_ARTIFACT =
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	166 SQL.get("collection.check.artifact");
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	167
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	168 public static final String SQL_COLLECTION_ITEMS_ID_NEXTVAL =
187 a85d889a1b0d Fixed some backend specific stuff (sql statements, schema). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 186 diff changeset	169 SQL.get("collection.items.id.nextval");
176 a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	170
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	171 public static final String SQL_COLLECTION_ITEMS_INSERT =
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	172 SQL.get("collection.items.insert");
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	173
253 a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	174 public static final String SQL_COLLECTION_GET_ATTRIBUTE =
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	175 SQL.get("collection.get.attribute");
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	176
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	177 public static final String SQL_COLLECTION_SET_ATTRIBUTE =
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	178 SQL.get("collection.set.attribute");
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	179
178 535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	180 public static final String SQL_COLLECTION_ITEM_GET_ATTRIBUTE =
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	181 SQL.get("collection.item.get.attribute");
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	182
179 644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	183 public static final String SQL_COLLECTION_ITEM_SET_ATTRIBUTE =
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	184 SQL.get("collection.item.set.attribute");
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	185
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	186 public static final String SQL_COLLECTIONS_TOUCH_BY_GID =
180 38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	187 SQL.get("collections.touch.by.gid");
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	188
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	189 public static final String SQL_COLLECTION_ITEM_ID_CID_AID =
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	190 SQL.get("collection.item.id.cid.aid");
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	191
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	192 public static final String SQL_COLLECTION_ITEM_OUTDATE_ARTIFACT =
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	193 SQL.get("collection.item.outdate.artifact");
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	194
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	195 public static final String SQL_COLLECTION_ITEM_DELETE =
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	196 SQL.get("collection.item.delete");
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	197
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	198 public static final String SQL_COLLECTIONS_TOUCH_BY_ID =
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	199 SQL.get("collections.touch.by.id");
179 644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	200
184 a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	201 public static final String SQL_COLLECTION_ITEMS_LIST_GID =
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	202 SQL.get("collection.items.list.gid");
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	203
128 bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	204 /** The singleton.*/
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	205 protected static Backend instance;
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	206
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	207 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	208 * The database cleaner. Reference is stored here because
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	209 * the cleaner is woken up if the backend finds an outdated
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	210 * artifact. This artifact should be removed as soon as
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	211 * possible.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	212 */
30 88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	213 protected DatabaseCleaner cleaner;
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	214
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	215 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	216 * To revive an artifact from the bytes coming from the database
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	217 * we need the artifact factory which references the artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	218 * serializer which is able to do the reviving job.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	219 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	220 protected FactoryLookup factoryLookup;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	221
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	222 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	223 * Little helper interface to decouple the ArtifactDatabase
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	224 * from the Backend. A ArtifactDatabase should depend on a
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	225 * Backend but a Backend not from an ArtifactDatabase.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	226 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	227 public interface FactoryLookup {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	228
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	229 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	230 * Returns an ArtifactFactory which is bound to a given name.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	231 * @param factoryName The name of the artifact factory.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	232 * @return The ArtifactFactory bound to the factory name or
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	233 * null if not matching factory is found.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	234 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	235 ArtifactFactory getArtifactFactory(String factoryName);
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	236
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	237 } // interface FactoryLookup
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	238
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	239 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	240 * Inner class that brigdes between the persisten form of the
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	241 * artifact and the living one inside the artifact database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	242 * After the describe(), feed(), advance() and out() operations
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	243 * of the artifact it must be possible to write to modified artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	244 * back into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	245 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	246 public final class PersistentArtifact
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	247 {
230 fbd57d2eeaef Changed semantics of locked artifact ids. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 217 diff changeset	248 private int id;
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	249 private Artifact artifact;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	250 private ArtifactSerializer serializer;
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	251 private Long ttl;
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	252
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	253 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	254 * Cronstructor to create a persistent artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	255 * @param artifact The living artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	256 * @param serializer The serializer to store the artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	257 * after the operations.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	258 * @param ttl The time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	259 * @param id The database id of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	260 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	261 public PersistentArtifact(
47 4ae4dc99127d Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 46 diff changeset	262 Artifact artifact,
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	263 ArtifactSerializer serializer,
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	264 Long ttl,
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	265 int id
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	266 ) {
230 fbd57d2eeaef Changed semantics of locked artifact ids. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 217 diff changeset	267 this.id = id;
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	268 this.artifact = artifact;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	269 this.serializer = serializer;
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	270 this.ttl = ttl;
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	271 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	272
230 fbd57d2eeaef Changed semantics of locked artifact ids. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 217 diff changeset	273 public int getId() {
fbd57d2eeaef Changed semantics of locked artifact ids. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 217 diff changeset	274 return id;
fbd57d2eeaef Changed semantics of locked artifact ids. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 217 diff changeset	275 }
fbd57d2eeaef Changed semantics of locked artifact ids. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 217 diff changeset	276
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	277 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	278 * Returns the wrapped living artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	279 * @return the living artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	280 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	281 public Artifact getArtifact() {
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	282 return artifact;
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	283 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	284
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	285 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	286 * Returns the serialized which is able to write a
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	287 * modified artifact back into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	288 * @return The serializer.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	289 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	290 public ArtifactSerializer getSerializer() {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	291 return serializer;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	292 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	293
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	294 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	295 * The time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	296 * @return The time to live.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	297 */
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	298 public Long getTTL() {
72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	299 return ttl;
72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	300 }
72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	301
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	302 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	303 * Stores the living artifact back into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	304 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	305 public void store() {
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	306 if (logger.isDebugEnabled()) {
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	307 logger.debug("storing artifact id = " + getId());
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	308 }
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	309 Backend.this.store(this);
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	310 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	311
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	312 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	313 * Only touches the access time of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	314 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	315 public void touch() {
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	316 if (logger.isDebugEnabled()) {
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	317 logger.debug("touching artifact id = " + getId());
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	318 }
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	319 Backend.this.touch(this);
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	320 }
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	321 } // class ArtifactWithId
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	322
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	323 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	324 * Default constructor
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	325 */
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	326 public Backend() {
0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	327 }
0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	328
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	329 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	330 * Constructor to create a backend with a link to the database cleaner.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	331 * @param cleaner The clean which periodically removes outdated
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	332 * artifacts from the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	333 */
30 88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	334 public Backend(DatabaseCleaner cleaner) {
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	335 this.cleaner = cleaner;
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	336 }
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	337
128 bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	338
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	339 /**
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	340 * Returns the singleton of this Backend.
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	341 *
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	342 * @return the backend.
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	343 */
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	344 public static synchronized Backend getInstance() {
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	345 if (instance == null) {
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	346 instance = new Backend();
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	347 }
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	348
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	349 return instance;
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	350 }
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	351
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	352 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	353 * Sets the factory lookup mechanism to decouple ArtifactDatabase
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	354 * and Backend.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	355 * @param factoryLookup
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	356 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	357 public void setFactoryLookup(FactoryLookup factoryLookup) {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	358 this.factoryLookup = factoryLookup;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	359 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	360
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	361 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	362 * Sets the database cleaner explicitly.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	363 * @param cleaner The database cleaner
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	364 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	365 public void setCleaner(DatabaseCleaner cleaner) {
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	366 this.cleaner = cleaner;
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	367 }
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	368
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	369 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	370 * Returns a new unique identifier to external identify
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	371 * the artifact across the system. This implementation
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	372 * uses random UUIDs v4 to achieve this target.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	373 * @return the new identifier
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	374 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	375 public String newIdentifier() {
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	376 // TODO: check database for collisions.
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	377 return StringUtils.newUUID();
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	378 }
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	379
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	380 public boolean isValidIdentifier(String identifier) {
77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	381 return StringUtils.checkUUID(identifier);
77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	382 }
77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	383
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	384 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	385 * Stores a new artifact into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	386 * @param artifact The artifact to be stored
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	387 * @param factory The factory which build the artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	388 * @param ttl The initial time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	389 * @return A persistent wrapper around the living
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	390 * artifact to be able to write modification later.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	391 * @throws Exception Thrown if something went wrong with the
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	392 * storage process.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	393 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	394 public PersistentArtifact storeInitially(
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	395 Artifact artifact,
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	396 ArtifactFactory factory,
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	397 Long ttl
47 4ae4dc99127d Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 46 diff changeset	398 )
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	399 throws Exception
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	400 {
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	401 return new PersistentArtifact(
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	402 artifact,
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	403 factory.getSerializer(),
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	404 ttl,
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	405 insertDatabase(artifact, factory, ttl));
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	406 }
47 4ae4dc99127d Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 46 diff changeset	407
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	408 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	409 * Stores an artifact into database if it does not exist there.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	410 * If it exists there it is only updated.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	411 * @param artifact The artifact to store/update.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	412 * @param factory The factory which created the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	413 * @param ttl The initial time to live of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	414 * @return A persistent version of the artifact to be able
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	415 * to store a modification later.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	416 * @throws Exception Thrown if something went wrong during
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	417 * storing/updating.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	418 */
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	419 public PersistentArtifact storeOrReplace(
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	420 Artifact artifact,
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	421 ArtifactFactory factory,
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	422 Long ttl
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	423 )
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	424 throws Exception
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	425 {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	426 return new PersistentArtifact(
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	427 artifact,
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	428 factory.getSerializer(),
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	429 ttl,
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	430 storeOrReplaceDatabase(artifact, factory, ttl));
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	431 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	432
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	433 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	434 * Implementors of this interface are able to process the raw
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	435 * artifact data from the database for loading.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	436 */
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	437 public interface ArtifactLoader {
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	438
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	439 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	440 * Creates a custom object from the raw artifact database data.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	441 * @param factory The factory that created this artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	442 * @param ttl The current time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	443 * @param bytes The raw artifact bytes from the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	444 * @param id The database id of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	445 * @return The custom object created by the implementation.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	446 */
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	447 Object load(ArtifactFactory factory, Long ttl, byte [] bytes, int id);
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	448
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	449 } // interface ArtifactLoader
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	450
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	451 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	452 * Fetches an artifact from the database identified by the
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	453 * given identifier.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	454 * @param identifer The identifier of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	455 * @return A persistent wrapper around the found artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	456 * to be able to write back a modifaction later or null
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	457 * if no artifact is found for this identifier.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	458 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	459 public PersistentArtifact getArtifact(String identifer) {
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	460
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	461 return (PersistentArtifact)loadArtifact(
86 b2e0cb83631c Removed trailing whitespace Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 84 diff changeset	462 identifer,
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	463 new ArtifactLoader() {
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	464
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	465 public Object load(
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	466 ArtifactFactory factory,
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	467 Long ttl,
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	468 byte [] bytes,
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	469 int id
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	470 ) {
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	471 ArtifactSerializer serializer = factory.getSerializer();
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	472
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	473 Artifact artifact = serializer.fromBytes(bytes);
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	474
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	475 return artifact == null
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	476 ? null
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	477 : new PersistentArtifact(artifact, serializer, ttl, id);
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	478 }
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	479 });
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	480 }
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	481
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	482 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	483 * More general loading mechanism for artifacts. The concrete
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	484 * load processing is delegated to the given loader.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	485 * @param identifer The identifier of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	486 * @param loader The loader which processes the raw database data.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	487 * @return The object created by the loader.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	488 */
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	489 public Object loadArtifact(
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	490 final String identifer,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	491 final ArtifactLoader loader
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	492 ) {
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	493 if (!isValidIdentifier(identifer)) {
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	494 return null;
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	495 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	496
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	497 final Object [] loaded = new Object[1];
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	498
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	499 SQLExecutor exec = new SQLExecutor() {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	500 public boolean doIt() throws SQLException {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	501 prepareStatement(SQL_LOAD_BY_GID);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	502 stmnt.setString(1, identifer);
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	503
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	504 result = stmnt.executeQuery();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	505
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	506 if (!result.next()) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	507 return false;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	508 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	509
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	510 int id = result.getInt(1);
242 b35d32e507b6 Fix for flys/issue9 Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 235 diff changeset	511 long ttlX = result.getLong(2);
b35d32e507b6 Fix for flys/issue9 Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 235 diff changeset	512 Long ttl = result.wasNull() ? null : ttlX;
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	513
242 b35d32e507b6 Fix for flys/issue9 Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 235 diff changeset	514 String factoryName = result.getString(3);
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	515
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	516 if (factoryLookup == null) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	517 logger.error("factory lookup == null");
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	518 return false;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	519 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	520
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	521 ArtifactFactory factory = factoryLookup
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	522 .getArtifactFactory(factoryName);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	523
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	524 if (factory == null) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	525 logger.error("factory '" + factoryName + "' not found");
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	526 return false;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	527 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	528
242 b35d32e507b6 Fix for flys/issue9 Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 235 diff changeset	529 byte [] bytes = result.getBytes(4);
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	530
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	531 loaded[0] = loader.load(factory, ttl, bytes, id);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	532 return true;
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	533 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	534 };
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	535
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	536 return exec.runRead() ? loaded[0] : null;
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	537 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	538
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	539 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	540 * Called if the load mechanism found an outdated artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	541 * It wakes up the database cleaner.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	542 * @param id The id of the outdated artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	543 */
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	544 protected void artifactOutdated(int id) {
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	545 if (logger.isDebugEnabled()) {
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	546 logger.info("artifactOutdated: id = " + id);
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	547 }
30 88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	548 if (cleaner != null) {
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	549 cleaner.wakeup();
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	550 }
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	551 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	552
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	553 public Artifact reviveArtifact(String factoryName, byte [] bytes) {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	554 if (factoryLookup == null) {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	555 logger.error("reviveArtifact: factory lookup == null");
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	556 return null;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	557 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	558 ArtifactFactory factory = factoryLookup
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	559 .getArtifactFactory(factoryName);
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	560
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	561 if (factory == null) {
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	562 logger.error(
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	563 "reviveArtifact: no factory '" + factoryName + "' found");
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	564 return null;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	565 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	566
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	567 ArtifactSerializer serializer = factory.getSerializer();
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	568
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	569 return serializer.fromBytes(bytes);
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	570 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	571
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	572 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	573 * Internal method to store/replace an artifact inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	574 * If an artifact with the given identifier does not exists it is
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	575 * created else only the content data is updated.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	576 * @param artifact The artifact to be store/update inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	577 * @param factory The factory that created the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	578 * @param ttl The initial time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	579 * @return The database id of the stored/updated artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	580 */
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	581 protected int storeOrReplaceDatabase(
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	582 final Artifact artifact,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	583 final ArtifactFactory factory,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	584 final Long ttl
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	585 ) {
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	586 final String uuid = artifact.identifier();
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	587
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	588 if (!isValidIdentifier(uuid)) {
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	589 throw new RuntimeException("No valid UUID");
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	590 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	591
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	592 final int [] id = new int[1];
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	593
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	594 SQLExecutor exec = new SQLExecutor() {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	595 public boolean doIt() throws SQLException {
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	596
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	597 prepareStatement(SQL_GET_ID);
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	598 stmnt.setString(1, uuid);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	599 result = stmnt.executeQuery();
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	600
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	601 Integer ID = result.next()
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	602 ? Integer.valueOf(result.getInt(1))
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	603 : null;
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	604
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	605 reset();
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	606
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	607 if (ID != null) { // already in database
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	608 prepareStatement(SQL_REPLACE);
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	609
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	610 if (ttl == null) {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	611 stmnt.setNull(1, Types.BIGINT);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	612 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	613 else {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	614 stmnt.setLong(1, ttl.longValue());
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	615 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	616
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	617 stmnt.setString(2, factory.getName());
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	618 stmnt.setBytes(
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	619 3,
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	620 factory.getSerializer().toBytes(artifact));
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	621 id[0] = ID.intValue();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	622 stmnt.setInt(4, id[0]);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	623 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	624 else { // new artifact
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	625 prepareStatement(SQL_NEXT_ID);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	626 result = stmnt.executeQuery();
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	627
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	628 if (!result.next()) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	629 logger.error("No id generated");
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	630 return false;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	631 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	632
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	633 reset();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	634
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	635 prepareStatement(SQL_INSERT);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	636
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	637 id[0] = result.getInt(1);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	638 stmnt.setInt(1, id[0]);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	639 stmnt.setString(2, uuid);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	640 if (ttl == null) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	641 stmnt.setNull(3, Types.BIGINT);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	642 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	643 else {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	644 stmnt.setLong(3, ttl.longValue());
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	645 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	646
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	647 stmnt.setString(4, factory.getName());
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	648
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	649 stmnt.setBytes(
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	650 5,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	651 factory.getSerializer().toBytes(artifact));
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	652 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	653 stmnt.execute();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	654 conn.commit();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	655 return true;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	656 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	657 };
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	658
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	659 if (!exec.runWrite()) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	660 throw new RuntimeException("failed insert artifact into database");
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	661 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	662
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	663 return id[0];
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	664 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	665
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	666 /**
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	667 * Internal method to store an artifact inside the database.
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	668 * @param artifact The artifact to be stored.
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	669 * @param factory The factory which created the artifact.
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	670 * @param ttl The initial time to live of the artifact.
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	671 * @return The database id of the stored artifact.
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	672 */
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	673 protected int insertDatabase(
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	674 final Artifact artifact,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	675 final ArtifactFactory factory,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	676 final Long ttl
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	677 ) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	678 final int [] id = new int[1];
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	679
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	680 SQLExecutor exec = new SQLExecutor() {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	681 public boolean doIt() throws SQLException {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	682 prepareStatement(SQL_NEXT_ID);
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	683 result = stmnt.executeQuery();
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	684
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	685 if (!result.next()) {
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	686 logger.error("No id generated");
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	687 return false;
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	688 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	689
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	690 id[0] = result.getInt(1);
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	691
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	692 reset();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	693 prepareStatement(SQL_INSERT);
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	694
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	695 String uuid = artifact.identifier();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	696 stmnt.setInt(1, id[0]);
80 8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	697 stmnt.setString(2, uuid);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	698 if (ttl == null) {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	699 stmnt.setNull(3, Types.BIGINT);
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	700 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	701 else {
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	702 stmnt.setLong(3, ttl.longValue());
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	703 }
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	704
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	705 stmnt.setString(4, factory.getName());
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	706
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	707 stmnt.setBytes(
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	708 5,
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	709 factory.getSerializer().toBytes(artifact));
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	710
8447467cef86 Implementation to import artifacts from incoming xml documents (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 79 diff changeset	711 stmnt.execute();
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	712
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	713 conn.commit();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	714 return true;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	715 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	716 };
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	717
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	718 if (!exec.runWrite()) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	719 throw new RuntimeException("failed insert artifact into database");
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	720 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	721
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	722 return id[0];
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	723 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	724
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	725 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	726 * Touches the access timestamp of a given artifact to prevent
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	727 * that it will be removed from the database by the database cleaner.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	728 * @param artifact The persistent wrapper around the living artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	729 */
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	730 public void touch(final PersistentArtifact artifact) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	731 new SQLExecutor() {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	732 public boolean doIt() throws SQLException {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	733 prepareStatement(SQL_TOUCH);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	734 stmnt.setInt(1, artifact.getId());
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	735 stmnt.execute();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	736 conn.commit();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	737 return true;
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	738 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	739 }.runWrite();
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	740 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	741
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	742 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	743 * Writes modification of an artifact back to the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	744 * @param artifact The persistent wrapper around a living
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	745 * artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	746 */
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	747 public void store(final PersistentArtifact artifact) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	748 new SQLExecutor() {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	749 public boolean doIt() throws SQLException {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	750 prepareStatement(SQL_UPDATE);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	751 stmnt.setInt(2, artifact.getId());
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	752
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	753 byte [] bytes = artifact
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	754 .getSerializer()
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	755 .toBytes(artifact.getArtifact());
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	756
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	757 stmnt.setBytes(1, bytes);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	758 stmnt.execute();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	759 conn.commit();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	760 return true;
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	761 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	762 }.runWrite();
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	763 }
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	764
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	765 public User createUser(
233 16cd059945e5 Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 230 diff changeset	766 final String name,
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	767 final Document role,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	768 final UserFactory factory,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	769 final Object context
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	770 ) {
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	771 final User [] user = new User[1];
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	772
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	773 final byte [] roleData = XMLUtils.toByteArray(role, true);
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	774
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	775 SQLExecutor exec = new SQLExecutor() {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	776 public boolean doIt() throws SQLException {
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	777
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	778 prepareStatement(SQL_USERS_NEXT_ID);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	779 result = stmnt.executeQuery();
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	780
146 967dc552455d Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 145 diff changeset	781 if (!result.next()) {
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	782 return false;
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	783 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	784
145 c0d025df722d Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 144 diff changeset	785 int id = result.getInt(1);
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	786
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	787 reset();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	788
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	789 String identifier = newIdentifier();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	790
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	791 prepareStatement(SQL_USERS_INSERT);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	792
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	793 stmnt.setInt(1, id);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	794 stmnt.setString(2, identifier);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	795 stmnt.setString(3, name);
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	796
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	797 if (roleData == null) {
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	798 stmnt.setNull(4, Types.BIGINT);
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	799 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	800 else {
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	801 stmnt.setBytes(4, roleData);
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	802 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	803
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	804 stmnt.execute();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	805 conn.commit();
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	806
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	807 user[0] = factory.createUser(
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	808 identifier, name, role, context);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	809 return true;
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	810 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	811 };
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	812
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	813 return exec.runWrite() ? user[0] : null;
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	814 }
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	815
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	816 public boolean deleteUser(final String identifier) {
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	817
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	818 if (!isValidIdentifier(identifier)) {
154 1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	819 return false;
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	820 }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	821
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	822 SQLExecutor exec = new SQLExecutor() {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	823 public boolean doIt() throws SQLException {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	824 prepareStatement(SQL_USERS_SELECT_ID_BY_GID);
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	825
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	826 stmnt.setString(1, identifier);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	827 result = stmnt.executeQuery();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	828
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	829 if (!result.next()) { // No such user
154 1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	830 return false;
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	831 }
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	832
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	833 int id = result.getInt(1);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	834
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	835 reset();
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	836
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	837 // outdate the artifacts exclusively used by the user
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	838
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	839 prepareStatement(SQL_OUTDATE_ARTIFACTS_USER);
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	840 stmnt.setInt(1, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	841 stmnt.setInt(2, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	842 stmnt.execute();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	843
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	844 reset();
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	845
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	846 // delete the collection items of the user
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	847
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	848 prepareStatement(SQL_DELETE_USER_COLLECTION_ITEMS);
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	849 stmnt.setInt(1, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	850 stmnt.execute();
233 16cd059945e5 Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 230 diff changeset	851
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	852 reset();
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	853
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	854 // delete the collections of the user
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	855
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	856 prepareStatement(SQL_USERS_DELETE_COLLECTIONS);
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	857 stmnt.setInt(1, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	858 stmnt.execute();
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	859
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	860 reset();
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	861
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	862 // delete the user
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	863
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	864 prepareStatement(SQL_USERS_DELETE_ID);
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	865 stmnt.setInt(1, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	866 stmnt.execute();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	867
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	868 conn.commit();
154 1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	869 return true;
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	870 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	871 };
154 1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	872
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	873 return exec.runWrite();
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	874 }
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	875
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	876 public User getUser(
233 16cd059945e5 Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 230 diff changeset	877 final String identifier,
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	878 final UserFactory factory,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	879 final Object context
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	880 ) {
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	881 if (!isValidIdentifier(identifier)) {
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	882 logger.debug("Invalid UUID: '" + identifier + "'");
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	883 return null;
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	884 }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	885
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	886 final User [] user = new User[1];
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	887
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	888 SQLExecutor exec = new SQLExecutor() {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	889 public boolean doIt() throws SQLException {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	890 prepareStatement(SQL_USERS_SELECT_GID);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	891 stmnt.setString(1, identifier);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	892 result = stmnt.executeQuery();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	893 if (!result.next()) { // no such user
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	894 return false;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	895 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	896 // omit id
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	897 String name = result.getString(2);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	898 byte [] roleData = result.getBytes(3);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	899
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	900 Document role = XMLUtils.fromByteArray(roleData, true);
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	901
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	902 user[0] = factory.createUser(
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	903 identifier, name, role, context);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	904 return true;
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	905 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	906 };
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	907
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	908 return exec.runRead() ? user[0] : null;
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	909 }
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	910
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	911 public User [] getUsers(
233 16cd059945e5 Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 230 diff changeset	912 final UserFactory factory,
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	913 final Object context
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	914 ) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	915 final ArrayList<User> users = new ArrayList<User>();
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	916
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	917 SQLExecutor exec = new SQLExecutor() {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	918 public boolean doIt() throws SQLException {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	919 prepareStatement(SQL_USERS_SELECT_ALL);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	920 result = stmnt.executeQuery();
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	921
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	922 while (result.next()) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	923 // omit id
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	924 String identifier = result.getString(2);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	925 String name = result.getString(3);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	926 byte [] roleData = result.getBytes(4);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	927
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	928 Document role = XMLUtils.fromByteArray(roleData, true);
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	929 User user = factory.createUser(
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	930 identifier, name, role, context);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	931 users.add(user);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	932 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	933 return true;
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	934 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	935 };
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	936
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	937 return exec.runRead()
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	938 ? users.toArray(new User[users.size()])
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	939 : null;
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	940 }
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	941
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	942 public ArtifactCollection createCollection(
233 16cd059945e5 Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 230 diff changeset	943 final String ownerIdentifier,
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	944 final String name,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	945 final ArtifactCollectionFactory factory,
199 face2302387c Insert collection attribute into database, too. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 194 diff changeset	946 final Document attribute,
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	947 final Object context
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	948 ) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	949 if (name == null) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	950 logger.debug("Name is null");
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	951 return null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	952 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	953
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	954 if (!isValidIdentifier(ownerIdentifier)) {
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	955 logger.debug("Invalid owner id: '" + ownerIdentifier + "'");
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	956 return null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	957 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	958
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	959 final ArtifactCollection [] collection = new ArtifactCollection[1];
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	960
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	961 final byte [] data = XMLUtils.toByteArray(attribute, true);
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	962
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	963 SQLExecutor exec = new SQLExecutor() {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	964 public boolean doIt() throws SQLException {
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	965 // fetch owner id
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	966 prepareStatement(SQL_USERS_SELECT_ID_BY_GID);
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	967 stmnt.setString(1, ownerIdentifier);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	968 result = stmnt.executeQuery();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	969
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	970 if (!result.next()) { // no such user
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	971 return false;
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	972 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	973
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	974 int ownerId = result.getInt(1);
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	975 reset();
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	976
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	977 // fetch new collection seq number.
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	978 prepareStatement(SQL_COLLECTIONS_NEXT_ID);
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	979 result = stmnt.executeQuery();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	980
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	981 if (!result.next()) { // no identifier generated
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	982 return false;
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	983 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	984
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	985 int id = result.getInt(1);
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	986 reset();
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	987
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	988 String identifier = newIdentifier();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	989
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	990 prepareStatement(SQL_COLLECTIONS_INSERT);
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	991
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	992 stmnt.setInt(1, id);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	993 stmnt.setString(2, identifier);
161 e4a1562dfc21 Bugfixed the collection creation in the Backend. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 159 diff changeset	994 stmnt.setString(3, name);
e4a1562dfc21 Bugfixed the collection creation in the Backend. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 159 diff changeset	995 stmnt.setInt(4, ownerId);
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	996
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	997 // XXX: A bit odd: we don't have a collection, yet.
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	998 Long ttl = factory.timeToLiveUntouched(null, context);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	999
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1000 if (ttl == null) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1001 stmnt.setNull(5, Types.BIGINT);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1002 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1003 else {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1004 stmnt.setLong(5, ttl);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1005 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1006
199 face2302387c Insert collection attribute into database, too. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 194 diff changeset	1007 if (data == null) {
face2302387c Insert collection attribute into database, too. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 194 diff changeset	1008 stmnt.setNull(6, Types.BINARY);
face2302387c Insert collection attribute into database, too. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 194 diff changeset	1009 }
face2302387c Insert collection attribute into database, too. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 194 diff changeset	1010 else {
face2302387c Insert collection attribute into database, too. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 194 diff changeset	1011 stmnt.setBytes(6, data);
face2302387c Insert collection attribute into database, too. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 194 diff changeset	1012 }
face2302387c Insert collection attribute into database, too. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 194 diff changeset	1013
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1014 stmnt.execute();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1015 conn.commit();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1016
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1017 reset();
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1018
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1019 // fetch creation time from database
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1020 // done this way to use the time system
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1021 // of the database.
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1022
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1023 prepareStatement(SQL_COLLECTIONS_CREATION_TIME);
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1024 stmnt.setInt(1, id);
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1025
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1026 result = stmnt.executeQuery();
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1027
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1028 Date creationTime = null;
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1029
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1030 if (result.next()) {
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1031 Timestamp timestamp = result.getTimestamp(1);
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1032 creationTime = new Date(timestamp.getTime());
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1033 }
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1034
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1035 collection[0] = factory.createCollection(
199 face2302387c Insert collection attribute into database, too. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 194 diff changeset	1036 identifier, name, creationTime, attribute, context);
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1037
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1038 return true;
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1039 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1040 };
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1041
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1042 return exec.runWrite() ? collection[0]: null;
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1043 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1044
217 87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1045 public ArtifactCollection getCollection(
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1046 final String collectionId,
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1047 final ArtifactCollectionFactory collectionFactory,
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1048 final UserFactory userFactory,
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1049 final Object context
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1050 ) {
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1051 if (!isValidIdentifier(collectionId)) {
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1052 logger.debug("collection id is not valid: " + collectionId);
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1053 return null;
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1054 }
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1055
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1056 final ArtifactCollection[] ac = new ArtifactCollection[1];
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1057
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1058 SQLExecutor exec = new SQLExecutor() {
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1059 public boolean doIt() throws SQLException {
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1060
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1061 prepareStatement(SQL_COLLECTIONS_SELECT_GID);
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1062 stmnt.setString(1, collectionId);
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1063
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1064 result = stmnt.executeQuery();
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1065 if (!result.next()) {
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1066 logger.debug("No such collection");
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1067 return false;
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1068 }
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1069
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1070 String collectionName = result.getString(2);
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1071 String ownerId = result.getString(3);
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1072 Date creationTime =
217 87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1073 new Date(result.getTimestamp(4).getTime());
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1074 Date lastAccess =
217 87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1075 new Date(result.getTimestamp(5).getTime());
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1076 Document attr =
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1077 XMLUtils.fromByteArray(result.getBytes(6), true);
217 87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1078
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1079 ArtifactCollection collection =
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1080 collectionFactory.createCollection(
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1081 collectionId,
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1082 collectionName,
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1083 creationTime,
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1084 attr,
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1085 context);
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1086
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1087 if (ownerId != null) {
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1088 collection.setUser(new LazyBackendUser(
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1089 ownerId, userFactory, Backend.this, context));
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1090 }
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1091
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1092 ac[0] = collection;
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1093
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1094 return true;
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1095 }
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1096 };
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1097
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1098 return exec.runRead() ? ac[0] : null;
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1099 }
87a7773030b5 The Backend got a method that retrieves an ArtifactCollection based on its GID. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 206 diff changeset	1100
164 268c2972d4a7 Implemented the interface method listCollections() in the artifact database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 161 diff changeset	1101 public ArtifactCollection [] listCollections(
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1102 final String ownerIdentifier,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1103 final Document data,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1104 final ArtifactCollectionFactory collectionFactory,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1105 final UserFactory userFactory,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1106 final Object context
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1107 ) {
233 16cd059945e5 Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 230 diff changeset	1108 if (ownerIdentifier != null
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	1109 && !isValidIdentifier(ownerIdentifier)) {
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1110 logger.debug("Invalid owner id: '" + ownerIdentifier + "'");
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1111 return null;
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1112 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1113
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1114 final ArrayList<ArtifactCollection> collections =
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1115 new ArrayList<ArtifactCollection>();
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1116
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1117 SQLExecutor exec = new SQLExecutor() {
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1118
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1119 public boolean doIt() throws SQLException {
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1120
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1121 if (ownerIdentifier != null) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1122 prepareStatement(SQL_COLLECTIONS_SELECT_USER);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1123 stmnt.setString(1, ownerIdentifier);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1124 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1125 else {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1126 prepareStatement(SQL_COLLECTIONS_SELECT_ALL);
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1127 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1128
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1129 result = stmnt.executeQuery();
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1130
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1131 HashMap<String, LazyBackendUser> users =
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1132 new HashMap<String, LazyBackendUser>();
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1133
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1134 while (result.next()) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1135 String collectionIdentifier = result.getString(1);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1136 String collectionName = result.getString(2);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1137 Date creationTime =
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1138 new Date(result.getTimestamp(3).getTime());
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1139 String userIdentifier = result.getString(4);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1140
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1141 ArtifactCollection collection =
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1142 collectionFactory.createCollection(
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1143 collectionIdentifier,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1144 collectionName,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1145 creationTime,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1146 data,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1147 context);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1148
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1149 if (userIdentifier != null) {
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1150 LazyBackendUser user = users.get(userIdentifier);
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1151 if (user == null) {
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1152 user = new LazyBackendUser(
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1153 userIdentifier, userFactory,
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1154 Backend.this, context);
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1155 users.put(userIdentifier, user);
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1156 }
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1157 collection.setUser(user);
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1158 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1159
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1160 collections.add(collection);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1161 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1162 return true;
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1163 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1164 };
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1165
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1166 return exec.runRead()
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1167 ? collections.toArray(new ArtifactCollection[collections.size()])
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1168 : null;
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1169 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1170
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1171
175 16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1172 public boolean deleteCollection(final String collectionId) {
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	1173 if (!isValidIdentifier(collectionId)) {
175 16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1174 logger.debug("Invalid collection id: '" + collectionId + "'");
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1175 return false;
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1176 }
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1177 SQLExecutor exec = new SQLExecutor() {
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1178 public boolean doIt() throws SQLException {
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1179 // fetch collection id
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1180 prepareStatement(SQL_COLLECTIONS_ID_BY_GID);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1181 stmnt.setString(1, collectionId);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1182 result = stmnt.executeQuery();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1183 if (!result.next()) {
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1184 logger.debug("No such collection: " + collectionId);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1185 return false;
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1186 }
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1187 int id = result.getInt(1);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1188 reset();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1189
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1190 // outdate artifacts that are only in this collection
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1191 prepareStatement(SQL_OUTDATE_ARTIFACTS_COLLECTION);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1192 stmnt.setInt(1, id);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1193 stmnt.setInt(2, id);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1194 stmnt.execute();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1195 reset();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1196
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1197 // delete the collection items
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1198 prepareStatement(SQL_DELETE_COLLECTION_ITEMS);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1199 stmnt.setInt(1, id);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1200 stmnt.execute();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1201 reset();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1202
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1203 // delete the collection
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1204 prepareStatement(SQL_DELETE_COLLECTION);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1205 stmnt.setInt(1, id);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1206 stmnt.execute();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1207 conn.commit();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1208 return true;
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1209 }
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1210 };
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1211 return exec.runWrite();
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1212 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1213
253 a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1214 public Document getCollectionAttribute(final String collectionId) {
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1215 if (!isValidIdentifier(collectionId)) {
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1216 logger.debug("collection id is not valid: " + collectionId);
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1217 }
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1218
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1219 final byte[][] data = new byte[1][1];
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1220
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1221 SQLExecutor exec = new SQLExecutor() {
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1222 public boolean doIt() throws SQLException {
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1223 prepareStatement(SQL_COLLECTION_GET_ATTRIBUTE);
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1224 stmnt.setString(1, collectionId);
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1225 result = stmnt.executeQuery();
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1226 if (!result.next()) {
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1227 logger.debug("No such collection.");
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1228 return false;
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1229 }
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1230
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1231 data[0] = result.getBytes(1);
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1232 return true;
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1233 }
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1234 };
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1235
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1236 return exec.runRead()
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1237 ? XMLUtils.fromByteArray(data[0], true)
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1238 : null;
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1239 }
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1240
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1241 public boolean setCollectionAttribute(
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1242 final String collectionId,
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1243 Document attribute
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1244 ) {
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1245 if (!isValidIdentifier(collectionId)) {
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1246 logger.debug("collection id is not valid: " + collectionId);
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1247 return false;
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1248 }
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1249
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1250 final byte [] data = XMLUtils.toByteArray(attribute, true);
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1251
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1252 return new SQLExecutor() {
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1253 public boolean doIt() throws SQLException {
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1254
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1255 // set the column in collection items
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1256 prepareStatement(SQL_COLLECTION_SET_ATTRIBUTE);
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1257 if (data == null) {
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1258 stmnt.setNull(1, Types.BINARY);
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1259 }
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1260 else {
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1261 stmnt.setBytes(1, data);
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1262 }
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1263 stmnt.setString(2, collectionId);
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1264 stmnt.execute();
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1265 reset();
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1266
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1267 // touch the collection
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1268 prepareStatement(SQL_COLLECTIONS_TOUCH_BY_GID);
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1269 stmnt.setString(1, collectionId);
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1270 stmnt.execute();
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1271
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1272 conn.commit();
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1273 return true;
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1274 }
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1275 }.runWrite();
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1276 }
a2df2b48d2aa Enabled the artifact database to handle requests specific to collection attributes and collection item attributes. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 252 diff changeset	1277
252 6de74b0b878e Changed the method names to get and set the attributes of collection items. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 242 diff changeset	1278 public Document getCollectionItemAttribute(
178 535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1279 final String collectionId,
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1280 final String artifactId
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1281 ) {
178 535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1282 if (!isValidIdentifier(collectionId)) {
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1283 logger.debug("collection id is not valid: " + collectionId);
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1284 return null;
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1285 }
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1286 if (!isValidIdentifier(artifactId)) {
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1287 logger.debug("artifact id is not valid: " + artifactId);
179 644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1288 return null;
178 535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1289 }
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1290
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1291 final byte [][] data = new byte[1][1];
178 535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1292
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1293 SQLExecutor exec = new SQLExecutor() {
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1294 public boolean doIt() throws SQLException {
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1295 prepareStatement(SQL_COLLECTION_ITEM_GET_ATTRIBUTE);
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1296 stmnt.setString(1, collectionId);
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1297 stmnt.setString(2, artifactId);
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1298 result = stmnt.executeQuery();
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1299 if (!result.next()) {
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1300 logger.debug("No such collection item");
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1301 return false;
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1302 }
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1303 data[0] = result.getBytes(1);
178 535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1304 return true;
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1305 }
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1306 };
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1307
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1308 return exec.runRead()
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1309 ? XMLUtils.fromByteArray(data[0], true)
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1310 : null;
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1311 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1312
252 6de74b0b878e Changed the method names to get and set the attributes of collection items. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 242 diff changeset	1313 public boolean setCollectionItemAttribute(
233 16cd059945e5 Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 230 diff changeset	1314 final String collectionId,
179 644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1315 final String artifactId,
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1316 Document attribute
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1317 ) {
179 644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1318 if (!isValidIdentifier(collectionId)) {
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1319 logger.debug("collection id is not valid: " + collectionId);
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1320 return false;
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1321 }
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1322 if (!isValidIdentifier(artifactId)) {
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1323 logger.debug("artifact id is not valid: " + artifactId);
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1324 return false;
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1325 }
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1326
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1327 final byte [] data = XMLUtils.toByteArray(attribute, true);
179 644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1328
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1329 return new SQLExecutor() {
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1330 public boolean doIt() throws SQLException {
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1331
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1332 // set the column in collection items
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1333 prepareStatement(SQL_COLLECTION_ITEM_SET_ATTRIBUTE);
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1334 if (data == null) {
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1335 stmnt.setNull(1, Types.BINARY);
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1336 }
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1337 else {
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1338 stmnt.setBytes(1, data);
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1339 }
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1340 stmnt.setString(2, collectionId);
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1341 stmnt.setString(3, artifactId);
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1342 stmnt.execute();
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1343 reset();
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1344
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1345 // touch the collection
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1346 prepareStatement(SQL_COLLECTIONS_TOUCH_BY_GID);
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1347 stmnt.setString(1, collectionId);
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1348 stmnt.execute();
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1349
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1350 conn.commit();
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1351 return true;
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1352 }
644fd11ddd9f Added code to set attribute of a collection item. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 178 diff changeset	1353 }.runWrite();
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1354 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1355
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1356 public boolean addCollectionArtifact(
176 a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1357 final String collectionId,
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1358 final String artifactId,
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1359 final Document attribute
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1360 ) {
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	1361 if (!isValidIdentifier(collectionId)) {
176 a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1362 logger.debug("Invalid collection id: '" + collectionId + "'");
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1363 return false;
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1364 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1365
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	1366 if (!isValidIdentifier(artifactId)) {
176 a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1367 logger.debug("Invalid artifact id: '" + artifactId + "'");
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1368 return false;
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1369 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1370
235 3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1371 final byte [] data = XMLUtils.toByteArray(attribute, true);
3e29395ebac6 The XML documents stored aside users, collections and collection items are now compressed/decompressed transparently. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 233 diff changeset	1372
176 a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1373 SQLExecutor exec = new SQLExecutor() {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1374 public boolean doIt() throws SQLException {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1375 // fetch artifact id
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1376 prepareStatement(SQL_GET_ID);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1377 stmnt.setString(1, artifactId);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1378 result = stmnt.executeQuery();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1379 if (!result.next()) {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1380 logger.debug("No such artifact: " + artifactId);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1381 return false;
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1382 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1383 int aid = result.getInt(1);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1384 reset();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1385
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1386 // fetch collection id
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1387 prepareStatement(SQL_COLLECTIONS_ID_BY_GID);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1388 stmnt.setString(1, collectionId);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1389 result = stmnt.executeQuery();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1390 if (!result.next()) {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1391 logger.debug("No such collection: " + collectionId);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1392 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1393 int cid = result.getInt(1);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1394 reset();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1395
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1396 // check if artifact is already in collection
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1397 prepareStatement(SQL_COLLECTION_CHECK_ARTIFACT);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1398 stmnt.setInt(1, aid);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1399 stmnt.setInt(2, cid);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1400 result = stmnt.executeQuery();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1401 if (result.next()) {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1402 logger.debug("artifact already in collection");
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1403 return false;
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1404 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1405 reset();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1406
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1407 // fetch fresh id for new collection item
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1408 prepareStatement(SQL_COLLECTION_ITEMS_ID_NEXTVAL);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1409 result = stmnt.executeQuery();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1410 if (!result.next()) {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1411 logger.debug("no collection item id generated");
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1412 return false;
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1413 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1414 int ci_id = result.getInt(1);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1415 reset();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1416
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1417 // insert new collection item
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1418 prepareStatement(SQL_COLLECTION_ITEMS_INSERT);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1419 stmnt.setInt(1, ci_id);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1420 stmnt.setInt(2, cid);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1421 stmnt.setInt(3, aid);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1422
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1423 if (data == null) {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1424 stmnt.setNull(4, Types.BINARY);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1425 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1426 else {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1427 stmnt.setBytes(4, data);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1428 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1429 stmnt.execute();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1430 conn.commit();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1431
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1432 return true;
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1433 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1434 };
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1435 return exec.runWrite();
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1436 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1437
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1438 public boolean removeCollectionArtifact(
180 38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1439 final String collectionId,
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1440 final String artifactId
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1441 ) {
180 38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1442 if (!isValidIdentifier(collectionId)) {
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1443 logger.debug("Invalid collection id: '" + collectionId + "'");
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1444 return false;
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1445 }
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1446 return new SQLExecutor() {
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1447 public boolean doIt() throws SQLException {
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1448
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1449 // fetch id, collection id and artitfact id
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1450 prepareStatement(SQL_COLLECTION_ITEM_ID_CID_AID);
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1451 stmnt.setString(1, collectionId);
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1452 stmnt.setString(2, artifactId);
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1453 result = stmnt.executeQuery();
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1454 if (!result.next()) {
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1455 logger.debug("No such collection item");
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1456 return false;
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1457 }
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1458 int id = result.getInt(1);
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1459 int cid = result.getInt(2);
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1460 int aid = result.getInt(3);
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1461 reset();
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1462
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1463 // outdate artifact iff it is only in this collection
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1464 prepareStatement(SQL_COLLECTION_ITEM_OUTDATE_ARTIFACT);
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1465 stmnt.setInt(1, aid);
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1466 stmnt.setInt(2, cid);
194 fde2f193e846 Small typo fix Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 193 diff changeset	1467 stmnt.setInt(3, aid);
180 38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1468 stmnt.execute();
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1469 reset();
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1470
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1471 // delete collection item
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1472 prepareStatement(SQL_COLLECTION_ITEM_DELETE);
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1473 stmnt.setInt(1, id);
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1474 stmnt.execute();
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1475 reset();
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1476
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1477 // touch collection
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1478 prepareStatement(SQL_COLLECTIONS_TOUCH_BY_ID);
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1479 stmnt.setInt(1, cid);
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1480 stmnt.execute();
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1481
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1482 conn.commit();
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1483 return true;
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1484 }
38fbbeffe8fe Added code to remove an artifact from a collection Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 179 diff changeset	1485 }.runWrite();
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1486 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1487
184 a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1488 public CollectionItem [] listCollectionArtifacts(
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1489 final String collectionId
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1490 ) {
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1491 if (!isValidIdentifier(collectionId)) {
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1492 logger.debug("Invalid collection id: '" + collectionId + "'");
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1493 return null;
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1494 }
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1495
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1496 final ArrayList<CollectionItem> collectionItems =
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1497 new ArrayList<CollectionItem>();
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1498
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1499 SQLExecutor exec = new SQLExecutor() {
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1500 public boolean doIt() throws SQLException {
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1501 prepareStatement(SQL_COLLECTION_ITEMS_LIST_GID);
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1502 stmnt.setString(1, collectionId);
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1503 result = stmnt.executeQuery();
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1504 while (result.next()) {
186 15c7638511dc Added an interface for CollectionItems and renamed the CollectionItem class from the artifact-database package to DefaultCollectionItem - because this is the default implementation of the interface. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 184 diff changeset	1505 CollectionItem item = new DefaultCollectionItem(
184 a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1506 result.getString(1),
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1507 result.getBytes(2));
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1508 collectionItems.add(item);
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1509 }
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1510 return true;
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1511 }
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1512 };
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1513
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1514 return exec.runRead()
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1515 ? collectionItems.toArray(
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1516 new CollectionItem[collectionItems.size()])
a22b7e367b25 Added Backend code to list the collection items in a collection. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 182 diff changeset	1517 : null;
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1518 }
273 22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1519
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1520
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1521 public boolean setCollectionTTL(final String uuid, final Long ttl) {
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1522 if (!isValidIdentifier(uuid)) {
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1523 logger.debug("Invalid collection id: '" + uuid + "'");
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1524 return false;
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1525 }
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1526
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1527 return new SQLExecutor() {
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1528 public boolean doIt() throws SQLException {
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1529 prepareStatement(SQL_UPDATE_COLLECTION_TTL);
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1530 if (ttl == null) {
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1531 stmnt.setNull(1, Types.BIGINT);
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1532 }
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1533 else {
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1534 stmnt.setLong(1, ttl);
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1535 }
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1536 stmnt.setString(2, uuid);
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1537 stmnt.execute();
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1538 conn.commit();
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1539
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1540 return true;
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1541 }
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1542 }.runWrite();
22a90706d32d Enables the artifact server to set the TTL of a specific collection via REST call. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 253 diff changeset	1543 }
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	1544 }
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	1545 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

Mercurial > dive4elements > framework

annotate artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java @ 273:22a90706d32d