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

annotate artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java @ 178:535e4ea2ef9b

Added code to get the attribute of a collection item artifacts/trunk@1404 c6561f87-3c4e-4783-a992-168aeb5c3f6f

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Sun, 06 Mar 2011 10:27:16 +0000
parents	77cd37a93fca
children	644fd11ddd9f

rev	line source
100 933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	1 /*
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	2 * Copyright (c) 2010 by Intevation GmbH
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 */
933bbc9fc11f Added license file and license headers. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 93 diff changeset	8
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	9 package de.intevation.artifactdatabase;
0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	10
158 d718a4d55662 Implemented the createCollection() method in the artifact database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 157 diff changeset	11 import de.intevation.artifacts.Artifact;
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	12 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	13 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	14 import de.intevation.artifacts.ArtifactFactory;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	15 import de.intevation.artifacts.ArtifactSerializer;
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;
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	27
17 5a6b6a3debc7 Integrated logging into artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 15 diff changeset	28 import org.apache.log4j.Logger;
5a6b6a3debc7 Integrated logging into artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 15 diff changeset	29
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	30 import org.w3c.dom.Document;
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	31
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	32 /**
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	33 * 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	34 * in a SQL database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	35 *
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	36 * @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	37 */
0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	38 public class Backend
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	39 implements DatabaseCleaner.ArtifactReviver
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	40 {
17 5a6b6a3debc7 Integrated logging into artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 15 diff changeset	41 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	42
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	43 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	44 * 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	45 */
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	46 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	47 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	48
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	49 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	50 * The SQL statement to insert an artifact into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	51 */
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	52 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	53 SQL.get("artifacts.insert");
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	54
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	55 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	56 * The SQL statement to update some columns of an existing
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	57 * artifact in the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	58 */
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	59 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	60 SQL.get("artifacts.update");
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	61
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	62 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	63 * The SQL statement to touch the access time of an
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	64 * artifact inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	65 */
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	66 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	67 SQL.get("artifacts.touch");
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	68
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	69 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	70 * The SQL statement to load an artifact by a given
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	71 * identifier from the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	72 */
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	73 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	74 SQL.get("artifacts.select.gid");
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	75
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	76 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	77 * 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	78 * identified by the identifier.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	79 */
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	80 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	81 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	82
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	83 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	84 * The SQL statement to replace the content of an
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	85 * existing artifact inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	86 */
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	87 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	88 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	89
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	90 // USER SQL
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	91
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	92 public static final String SQL_USERS_NEXT_ID =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	93 SQL.get("users.id.nextval");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	94
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	95 public static final String SQL_USERS_INSERT =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	96 SQL.get("users.insert");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	97
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	98 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	99 SQL.get("users.select.id.by.gid");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	100
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	101 public static final String SQL_USERS_SELECT_GID =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	102 SQL.get("users.select.gid");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	103
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	104 public static final String SQL_USERS_DELETE_ID =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	105 SQL.get("users.delete.id");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	106
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	107 public static final String SQL_USERS_DELETE_COLLECTIONS =
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	108 SQL.get("users.delete.collections");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	109
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	110 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	111 SQL.get("users.select.all");
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	112
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	113 public static final String SQL_USERS_COLLECTIONS =
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	114 SQL.get("users.collections");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	115
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	116 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	117 SQL.get("users.collection.ids");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	118
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	119 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	120 SQL.get("users.delete.all.collections");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	121
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	122 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	123 SQL.get("artifacts.in.one.collection.only");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	124
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	125 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	126 SQL.get("outdate.artifacts.collection");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	127
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	128 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	129 SQL.get("outdate.artifacts.user");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	130
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	131 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	132 SQL.get("delete.user.collection.items");
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	133
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	134 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	135 SQL.get("collections.id.nextval");
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	136
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	137 public static final String SQL_COLLECTIONS_INSERT =
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	138 SQL.get("collections.insert");
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	139
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	140 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	141 SQL.get("collections.select.user");
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	142
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	143 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	144 SQL.get("collections.select.all");
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	145
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	146 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	147 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	148
175 16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	149 public static final String SQL_COLLECTIONS_ID_BY_GID =
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	150 SQL.get("collection.creation.time");
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	151
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	152 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	153 SQL.get("delete.collection.items");
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	154
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	155 public static final String SQL_DELETE_COLLECTION =
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	156 SQL.get("delete.collection");
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	157
176 a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	158 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	159 SQL.get("collection.check.artifact");
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	160
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	161 public static final String SQL_COLLECTION_ITEMS_ID_NEXTVAL =
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	162 SQL.get("collection.check.artifact");
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	163
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	164 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	165 SQL.get("collection.items.insert");
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	166
178 535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	167 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	168 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	169
128 bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	170 /** The singleton.*/
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	171 protected static Backend instance;
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	172
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	173 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	174 * The database cleaner. Reference is stored here because
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	175 * 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	176 * artifact. This artifact should be removed as soon as
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	177 * possible.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	178 */
30 88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	179 protected DatabaseCleaner cleaner;
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	180
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	181 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	182 * 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	183 * we need the artifact factory which references the artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	184 * serializer which is able to do the reviving job.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	185 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	186 protected FactoryLookup factoryLookup;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	187
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	188 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	189 * Little helper interface to decouple the ArtifactDatabase
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	190 * from the Backend. A ArtifactDatabase should depend on a
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	191 * Backend but a Backend not from an ArtifactDatabase.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	192 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	193 public interface FactoryLookup {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	194
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	195 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	196 * Returns an ArtifactFactory which is bound to a given name.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	197 * @param factoryName The name of the artifact factory.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	198 * @return The ArtifactFactory bound to the factory name or
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	199 * null if not matching factory is found.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	200 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	201 ArtifactFactory getArtifactFactory(String factoryName);
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	202
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	203 } // interface FactoryLookup
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	204
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	205 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	206 * Inner class that brigdes between the persisten form of the
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	207 * artifact and the living one inside the artifact database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	208 * After the describe(), feed(), advance() and out() operations
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	209 * 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	210 * back into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	211 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	212 public final class PersistentArtifact
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	213 extends Id
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	214 {
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	215 private Artifact artifact;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	216 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	217 private Long ttl;
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	218
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	219 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	220 * Cronstructor to create a persistent artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	221 * @param artifact The living artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	222 * @param serializer The serializer to store the artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	223 * after the operations.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	224 * @param ttl The time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	225 * @param id The database id of the artifact.
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 PersistentArtifact(
47 4ae4dc99127d Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 46 diff changeset	228 Artifact artifact,
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	229 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	230 Long ttl,
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	231 int id
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	232 ) {
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	233 super(id);
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	234 this.artifact = artifact;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	235 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	236 this.ttl = ttl;
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	237 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 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 * Returns the wrapped living artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	241 * @return the living artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	242 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	243 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	244 return artifact;
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	245 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	246
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	247 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	248 * Returns the serialized which is able to write a
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	249 * modified artifact back into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	250 * @return The serializer.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	251 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	252 public ArtifactSerializer getSerializer() {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	253 return serializer;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	254 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	255
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	256 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	257 * The time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	258 * @return The time to live.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	259 */
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	260 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	261 return ttl;
72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	262 }
72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	263
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	264 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	265 * Stores the living artifact back into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	266 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	267 public void store() {
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	268 if (logger.isDebugEnabled()) {
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	269 logger.debug("storing artifact id = " + getId());
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	270 }
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	271 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	272 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	273
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	274 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	275 * Only touches the access time of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	276 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	277 public void touch() {
38 93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	278 if (logger.isDebugEnabled()) {
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 diff changeset	279 logger.debug("touching artifact id = " + getId());
93edc04f3a10 Added postgresql support. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 34 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 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	282 }
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	283 } // class ArtifactWithId
14 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 * Default constructor
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	287 */
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	288 public Backend() {
0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	289 }
0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	290
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	291 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	292 * 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	293 * @param cleaner The clean which periodically removes outdated
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	294 * artifacts from the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	295 */
30 88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	296 public Backend(DatabaseCleaner cleaner) {
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	297 this.cleaner = cleaner;
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	298 }
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	299
128 bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	300
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	301 /**
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	302 * Returns the singleton of this Backend.
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	303 *
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	304 * @return the backend.
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	305 */
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	306 public static synchronized Backend getInstance() {
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	307 if (instance == null) {
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	308 instance = new Backend();
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	309 }
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	310
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	311 return instance;
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	312 }
bfa65a812c7a Made the backend singleton. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 100 diff changeset	313
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	314 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	315 * Sets the factory lookup mechanism to decouple ArtifactDatabase
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	316 * and Backend.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	317 * @param factoryLookup
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	318 */
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	319 public void setFactoryLookup(FactoryLookup factoryLookup) {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	320 this.factoryLookup = factoryLookup;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	321 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 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 * Sets the database cleaner explicitly.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	325 * @param cleaner The database cleaner
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	326 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	327 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	328 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	329 }
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	330
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	331 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	332 * Returns a new unique identifier to external identify
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	333 * the artifact across the system. This implementation
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	334 * uses random UUIDs v4 to achieve this target.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	335 * @return the new identifier
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	336 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	337 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	338 // 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	339 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	340 }
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	341
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	342 public boolean isValidIdentifier(String identifier) {
77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	343 return StringUtils.checkUUID(identifier);
77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	344 }
77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	345
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	346 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	347 * Stores a new artifact into the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	348 * @param artifact The artifact to be stored
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	349 * @param factory The factory which build the artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	350 * @param ttl The initial time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	351 * @return A persistent wrapper around the living
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	352 * artifact to be able to write modification later.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	353 * @throws Exception Thrown if something went wrong with the
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	354 * storage process.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	355 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	356 public PersistentArtifact storeInitially(
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	357 Artifact artifact,
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	358 ArtifactFactory factory,
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	359 Long ttl
47 4ae4dc99127d Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 46 diff changeset	360 )
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	361 throws Exception
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	362 {
c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	363 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	364 artifact,
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	365 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	366 ttl,
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	367 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	368 }
47 4ae4dc99127d Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 46 diff changeset	369
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	370 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	371 * 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	372 * If it exists there it is only updated.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	373 * @param artifact The artifact to store/update.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	374 * @param factory The factory which created the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	375 * @param ttl The initial time to live of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	376 * @return A persistent version of the artifact to be able
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	377 * to store a modification later.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	378 * @throws Exception Thrown if something went wrong during
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	379 * storing/updating.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	380 */
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	381 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	382 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	383 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	384 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	385 )
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	386 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	387 {
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	388 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	389 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	390 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	391 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	392 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	393 }
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	394
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	395 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	396 * Implementors of this interface are able to process the raw
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	397 * artifact data from the database for loading.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	398 */
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	399 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	400
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	401 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	402 * Creates a custom object from the raw artifact database data.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	403 * @param factory The factory that created this artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	404 * @param ttl The current time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	405 * @param bytes The raw artifact bytes from the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	406 * @param id The database id of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	407 * @return The custom object created by the implementation.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	408 */
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	409 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	410
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	411 } // 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	412
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	413 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	414 * Fetches an artifact from the database identified by the
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	415 * given identifier.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	416 * @param identifer The identifier of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	417 * @return A persistent wrapper around the found artifact
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	418 * 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	419 * if no artifact is found for this identifier.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	420 */
32 c2d53bd30ab8 Re-factored artifact API for better integration of background processing. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 31 diff changeset	421 public PersistentArtifact getArtifact(String identifer) {
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	422
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	423 return (PersistentArtifact)loadArtifact(
86 b2e0cb83631c Removed trailing whitespace Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 84 diff changeset	424 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	425 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	426
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	427 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	428 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	429 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	430 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	431 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	432 ) {
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	433 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	434
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	435 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	436
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	437 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	438 ? null
84 72e2dd4feb31 Added the time to live of an artifact to the CallContext. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 80 diff changeset	439 : 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	440 }
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	441 });
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	442 }
f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	443
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	444 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	445 * More general loading mechanism for artifacts. The concrete
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	446 * load processing is delegated to the given loader.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	447 * @param identifer The identifier of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	448 * @param loader The loader which processes the raw database data.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	449 * @return The object created by the loader.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	450 */
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	451 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	452 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	453 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	454 ) {
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	455 if (!isValidIdentifier(identifer)) {
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	456 return null;
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	457 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	458
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	459 final Object [] loaded = new Object[1];
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	460
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	461 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	462 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	463 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	464 stmnt.setString(1, identifer);
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	465
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	466 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	467
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	468 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	469 return false;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	470 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	471
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	472 int id = 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	473 long ttlX = result.getLong(3);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	474
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	475 Long ttl = result.wasNull() ? null : Long.valueOf(ttlX);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	476
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	477 if (ttl != null) { // real time to life
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	478 long last_access = result.getTimestamp(2).getTime();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	479 if (last_access + ttlX < System.currentTimeMillis()) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	480 artifactOutdated(id);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	481 return false;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	482 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	483 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	484
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	485 String factoryName = 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	486
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	487 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	488 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	489 return false;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	490 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	491
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	492 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	493 .getArtifactFactory(factoryName);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	494
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	495 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	496 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	497 return false;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	498 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	499
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	500 byte [] bytes = result.getBytes(5);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	501
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	502 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	503 return true;
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	504 }
174 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
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	507 return exec.runRead() ? loaded[0] : null;
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	508 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	509
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	510 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	511 * Called if the load mechanism found an outdated artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	512 * It wakes up the database cleaner.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	513 * @param id The id of the outdated artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	514 */
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	515 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	516 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	517 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	518 }
30 88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	519 if (cleaner != null) {
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	520 cleaner.wakeup();
88972c6daa4f Added a cleanup thread which periodically removes Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 27 diff changeset	521 }
15 9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	522 }
9ad6ec2d09c3 Implemented restoring artifacts from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 14 diff changeset	523
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	524 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	525 if (factoryLookup == null) {
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	526 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	527 return null;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	528 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	529 ArtifactFactory factory = factoryLookup
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	530 .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	531
41 5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	532 if (factory == null) {
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	533 logger.error(
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	534 "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	535 return null;
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	536 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	537
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	538 ArtifactSerializer serializer = factory.getSerializer();
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	539
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	540 return serializer.fromBytes(bytes);
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	541 }
5e4bc24ea438 Made serilization more flexible. DB update required!!! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 38 diff changeset	542
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	543 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	544 * Internal method to store/replace an artifact inside the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	545 * 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	546 * created else only the content data is updated.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	547 * @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	548 * @param factory The factory that created the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	549 * @param ttl The initial time to life of the artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	550 * @return The database id of the stored/updated artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	551 */
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	552 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	553 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	554 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	555 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	556 ) {
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	557 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	558
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	559 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	560 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	561 }
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	562
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	563 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	564
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	565 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	566 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	567
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	568 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	569 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	570 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	571
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	572 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	573 ? 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	574 : 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	575
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	576 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	577
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	578 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	579 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	580
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 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	582 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	583 }
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	584 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	585 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	586 }
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
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	588 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	589 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	590 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	591 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	592 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	593 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	594 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	595 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	596 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	597 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	598
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	599 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	600 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	601 return false;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	602 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	603
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	604 reset();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	605
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	606 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	607
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	608 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	609 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	610 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	611 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	612 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	613 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	614 else {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	615 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	616 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	617
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	618 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	619
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	620 stmnt.setBytes(
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	621 5,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	622 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	623 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	624 stmnt.execute();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	625 conn.commit();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	626 return true;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	627 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	628 };
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	629
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	630 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	631 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	632 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	633
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	634 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	635 }
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 /**
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	638 * 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	639 * @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	640 * @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	641 * @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	642 * @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	643 */
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	644 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	645 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	646 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	647 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	648 ) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	649 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	650
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	651 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	652 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	653 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	654 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	655
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	656 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	657 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	658 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	659 }
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	660
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	661 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	662
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	663 reset();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	664 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	665
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	666 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	667 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	668 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	669 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	670 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	671 }
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	672 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	673 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	674 }
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	675
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	676 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	677
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	678 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	679 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	680 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	681
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	682 stmnt.execute();
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	683
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	684 conn.commit();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	685 return true;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	686 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	687 };
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	688
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	689 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	690 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	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
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	693 return id[0];
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	694 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	695
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	696 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	697 * Touches the access timestamp of a given artifact to prevent
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	698 * 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	699 * @param artifact The persistent wrapper around the living artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	700 */
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	701 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	702 new SQLExecutor() {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	703 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	704 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	705 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	706 stmnt.execute();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	707 conn.commit();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	708 return true;
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	709 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	710 }.runWrite();
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	711 }
0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	712
90 68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	713 /**
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	714 * Writes modification of an artifact back to the database.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	715 * @param artifact The persistent wrapper around a living
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 diff changeset	716 * artifact.
68285f7bc476 More javadoc. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 86 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 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	719 new SQLExecutor() {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	720 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	721 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	722 stmnt.setInt(2, artifact.getId());
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	723
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	724 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	725 .getSerializer()
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	726 .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	727
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	728 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	729 stmnt.execute();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	730 conn.commit();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	731 return true;
26 83a059c204f8 Connected /create with artifact db. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 24 diff changeset	732 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	733 }.runWrite();
14 0d16d1bb2df0 Initial checkin of artigact persistents back by database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 13 diff changeset	734 }
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	735
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	736 public User createUser(
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	737 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	738 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	739 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	740 final Object context
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	741 ) {
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	742 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	743
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	744 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	745 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	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 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	748 result = stmnt.executeQuery();
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	749
146 967dc552455d Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 145 diff changeset	750 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	751 return false;
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	752 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	753
145 c0d025df722d Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 144 diff changeset	754 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	755
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	756 reset();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	757
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	758 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	759
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	760 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	761
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	762 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	763 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	764 stmnt.setString(3, name);
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	765
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	766 byte [] roleData = role == null
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	767 ? null
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	768 : XMLUtils.toByteArray(role);
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	769
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	770 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	771 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	772 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	773 else {
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	774 stmnt.setBytes(4, roleData);
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	775 }
b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	776
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	777 stmnt.execute();
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	778 conn.commit();
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	779
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	780 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	781 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	782 return true;
138 b90e831d3dfe Call database to create a new user. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 133 diff changeset	783 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	784 };
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	785
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	786 return exec.runWrite() ? user[0] : null;
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	787 }
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	788
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	789 public boolean deleteUser(final String identifier) {
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	790
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	791 if (!isValidIdentifier(identifier)) {
154 1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	792 return false;
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	793 }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	794
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	795 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	796 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	797 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	798
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	799 stmnt.setString(1, identifier);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	800 result = stmnt.executeQuery();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	801
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	802 if (!result.next()) { // No such user
154 1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	803 return false;
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	804 }
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	805
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	806 int id = result.getInt(1);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	807
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	808 reset();
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	809
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	810 // 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	811
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	812 prepareStatement(SQL_OUTDATE_ARTIFACTS_USER);
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	813 stmnt.setInt(1, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	814 stmnt.setInt(2, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	815 stmnt.execute();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	816
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	817 reset();
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	818
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	819 // delete the collection items of the user
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	820
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	821 prepareStatement(SQL_DELETE_USER_COLLECTION_ITEMS);
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	822 stmnt.setInt(1, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	823 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	824
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	825 reset();
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	826
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	827 // delete the collections of the user
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	828
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	829 prepareStatement(SQL_USERS_DELETE_COLLECTIONS);
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	830 stmnt.setInt(1, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	831 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	832
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	833 reset();
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	834
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	835 // delete the user
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	836
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	837 prepareStatement(SQL_USERS_DELETE_ID);
144 5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	838 stmnt.setInt(1, id);
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	839 stmnt.execute();
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	840
5369582d4fbf Enable backend to delete users Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 138 diff changeset	841 conn.commit();
154 1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	842 return true;
144 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 };
154 1a72f08ce8d7 Propagate delete user errors correctly. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 153 diff changeset	845
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	846 return exec.runWrite();
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	847 }
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	848
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	849 public User getUser(
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	850 final String identifier,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	851 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	852 final Object context
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	853 ) {
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	854 if (!isValidIdentifier(identifier)) {
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	855 logger.debug("Invalid UUID: '" + identifier + "'");
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	856 return null;
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	857 }
9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	858
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	859 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	860
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	861 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	862 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	863 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	864 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	865 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	866 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	867 return false;
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	868 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	869 // omit id
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	870 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	871 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	872
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	873 Document role = XMLUtils.fromByteArray(roleData);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	874
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	875 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	876 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	877 return true;
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	878 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	879 };
147 9a64e0c1c737 Added code to load user from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 146 diff changeset	880
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	881 return exec.runRead() ? user[0] : null;
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	882 }
2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	883
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	884 public User [] getUsers(
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	885 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	886 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	887 ) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	888 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	889
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	890 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	891 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	892 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	893 result = stmnt.executeQuery();
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	894
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	895 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	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 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	898 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	899 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	900
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	901 Document role = XMLUtils.fromByteArray(roleData);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	902 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	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 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	905 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	906 return true;
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 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 };
148 101a52d3ad08 Added code to load all users from database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 147 diff changeset	909
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	910 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	911 ? 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	912 : null;
133 2950c6011afa Fixed typo in keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 128 diff changeset	913 }
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	914
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	915 public ArtifactCollection createCollection(
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	916 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	917 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	918 final ArtifactCollectionFactory factory,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	919 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	920 final Object context
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	921 ) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	922 if (name == null) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	923 logger.debug("Name is null");
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	924 return null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	925 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	926
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	927 if (!isValidIdentifier(ownerIdentifier)) {
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	928 logger.debug("Invalid owner id: '" + ownerIdentifier + "'");
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	929 return null;
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	930 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	931
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	932 final ArtifactCollection [] collection =
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	933 new ArtifactCollection[1];
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 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 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	936 public boolean doIt() throws SQLException {
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	937 // 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	938 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	939 stmnt.setString(1, ownerIdentifier);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	940 result = stmnt.executeQuery();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	941
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	942 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	943 return false;
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	944 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	945
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	946 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	947 reset();
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 // 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	950 prepareStatement(SQL_COLLECTIONS_NEXT_ID);
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	951 result = stmnt.executeQuery();
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 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	954 return false;
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	955 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	956
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	957 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	958 reset();
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	959
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	960 String identifier = newIdentifier();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	961
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	962 prepareStatement(SQL_COLLECTIONS_INSERT);
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	963
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	964 stmnt.setInt(1, id);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	965 stmnt.setString(2, identifier);
161 e4a1562dfc21 Bugfixed the collection creation in the Backend. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 159 diff changeset	966 stmnt.setString(3, name);
e4a1562dfc21 Bugfixed the collection creation in the Backend. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 159 diff changeset	967 stmnt.setInt(4, ownerId);
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	968
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	969 // 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	970 Long ttl = factory.timeToLiveUntouched(null, context);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	971
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	972 if (ttl == null) {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	973 stmnt.setNull(5, Types.BIGINT);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	974 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	975 else {
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	976 stmnt.setLong(5, ttl);
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	977 }
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	978
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	979 stmnt.execute();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	980 conn.commit();
db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	981
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	982 reset();
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	983
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	984 // 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	985 // 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	986 // of the database.
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	987
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	988 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	989 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	990
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	991 result = stmnt.executeQuery();
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	992
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	993 Date creationTime = null;
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	994
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	995 if (result.next()) {
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	996 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	997 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	998 }
ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	999
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1000 collection[0] = factory.createCollection(
170 ac0f8bd97277 Fix parameter propagation of creation time ond collection names. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	1001 identifier, name, creationTime, data, context);
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1002
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1003 return true;
159 db0d20440b92 Added code to create collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 158 diff changeset	1004 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1005 };
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1006
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1007 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	1008 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1009
164 268c2972d4a7 Implemented the interface method listCollections() in the artifact database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 161 diff changeset	1010 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	1011 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	1012 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	1013 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	1014 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	1015 final Object context
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1016 ) {
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1017 if (ownerIdentifier != null
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	1018 && !isValidIdentifier(ownerIdentifier)) {
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1019 logger.debug("Invalid owner id: '" + ownerIdentifier + "'");
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1020 return null;
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1021 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 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 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	1024 new ArrayList<ArtifactCollection>();
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1025
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1026 SQLExecutor exec = new SQLExecutor() {
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1027
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1028 public boolean doIt() throws SQLException {
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1029
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1030 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	1031 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	1032 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	1033 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1034 else {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1035 prepareStatement(SQL_COLLECTIONS_SELECT_ALL);
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1036 }
c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1037
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1038 result = stmnt.executeQuery();
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 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 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	1041 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	1042 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	1043 Date creationTime =
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1044 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	1045 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	1046
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1047 ArtifactCollection collection =
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1048 collectionFactory.createCollection(
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1049 collectionIdentifier,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1050 collectionName,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1051 creationTime,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1052 data,
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1053 context);
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1054
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1055 if (userIdentifier != null) {
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1056 collection.setUser(new LazyBackendUser(
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1057 userIdentifier, userFactory, Backend.this, context));
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1058 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1059
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1060 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	1061 }
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1062 return true;
167 c9c27aca2f70 Added code to list collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 164 diff changeset	1063 }
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1064 };
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1065
25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1066 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	1067 ? 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	1068 : null;
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1069 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1070
174 25d472a67a9f Reduce the code repetition and the complexity of the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 170 diff changeset	1071
175 16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1072 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	1073 if (!isValidIdentifier(collectionId)) {
175 16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1074 logger.debug("Invalid collection id: '" + collectionId + "'");
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1075 return false;
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1076 }
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1077 SQLExecutor exec = new SQLExecutor() {
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1078 public boolean doIt() throws SQLException {
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1079 // fetch collection id
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1080 prepareStatement(SQL_COLLECTIONS_ID_BY_GID);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1081 stmnt.setString(1, collectionId);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1082 result = stmnt.executeQuery();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1083 if (!result.next()) {
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1084 logger.debug("No such collection: " + collectionId);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1085 return false;
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1086 }
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1087 int id = result.getInt(1);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1088 reset();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1089
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1090 // 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	1091 prepareStatement(SQL_OUTDATE_ARTIFACTS_COLLECTION);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1092 stmnt.setInt(1, id);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1093 stmnt.setInt(2, id);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1094 stmnt.execute();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1095 reset();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1096
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1097 // delete the collection items
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1098 prepareStatement(SQL_DELETE_COLLECTION_ITEMS);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1099 stmnt.setInt(1, id);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1100 stmnt.execute();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1101 reset();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1102
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1103 // delete the collection
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1104 prepareStatement(SQL_DELETE_COLLECTION);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1105 stmnt.setInt(1, id);
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1106 stmnt.execute();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1107 conn.commit();
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1108 return true;
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1109 }
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1110 };
16e6e661e6bf Added code to delete collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	1111 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	1112 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1113
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1114 public Document getCollectionAttribute(
178 535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1115 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	1116 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	1117 ) {
178 535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1118 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	1119 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	1120 return null;
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1121 }
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1122 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	1123 logger.debug("artifact id is not valid: " + artifactId);
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1124 }
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1125
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1126 final Document [] document = new Document[1];
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1127
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1128 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	1129 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	1130 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	1131 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	1132 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	1133 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	1134 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	1135 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	1136 return false;
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1137 }
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1138 document[0] = XMLUtils.fromByteArray(result.getBytes(1));
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1139 return true;
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1140 }
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1141 };
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1142
535e4ea2ef9b Added code to get the attribute of a collection item Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 177 diff changeset	1143 return exec.runRead() ? document[0] : null;
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1144 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1145
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1146 public boolean setCollectionAttribute(
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1147 String collectionId,
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1148 String artifactId,
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1149 Document attribute
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1150 ) {
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1151 // TODO: Implement me!
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1152 return false;
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1153 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1154
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1155 public boolean addCollectionArtifact(
176 a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1156 final String collectionId,
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1157 final String artifactId,
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1158 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	1159 ) {
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	1160 if (!isValidIdentifier(collectionId)) {
176 a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1161 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	1162 return false;
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1163 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1164
177 77cd37a93fca Backend: isIdentifierValid more symmetric to new newIndentifier Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 176 diff changeset	1165 if (!isValidIdentifier(artifactId)) {
176 a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1166 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	1167 return false;
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1168 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1169
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1170 SQLExecutor exec = new SQLExecutor() {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1171 public boolean doIt() throws SQLException {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1172 // fetch artifact id
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1173 prepareStatement(SQL_GET_ID);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1174 stmnt.setString(1, artifactId);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1175 result = stmnt.executeQuery();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1176 if (!result.next()) {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1177 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	1178 return false;
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1179 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1180 int aid = result.getInt(1);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1181 reset();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1182
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1183 // fetch collection id
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1184 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	1185 stmnt.setString(1, collectionId);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1186 result = stmnt.executeQuery();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1187 if (!result.next()) {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1188 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	1189 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1190 int cid = result.getInt(1);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1191 reset();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1192
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1193 // 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	1194 prepareStatement(SQL_COLLECTION_CHECK_ARTIFACT);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1195 stmnt.setInt(1, aid);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1196 stmnt.setInt(2, cid);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1197 result = stmnt.executeQuery();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1198 if (result.next()) {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1199 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	1200 return false;
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1201 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1202 reset();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1203
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1204 // 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	1205 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	1206 result = stmnt.executeQuery();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1207 if (!result.next()) {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1208 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	1209 return false;
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1210 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1211 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	1212 reset();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1213
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1214 // insert new collection item
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1215 prepareStatement(SQL_COLLECTION_ITEMS_INSERT);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1216 stmnt.setInt(1, ci_id);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1217 stmnt.setInt(2, cid);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1218 stmnt.setInt(3, aid);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1219
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1220 byte [] data = attribute != null
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1221 ? XMLUtils.toByteArray(attribute)
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1222 : null;
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1223
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1224 if (data == null) {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1225 stmnt.setNull(4, Types.BINARY);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1226 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1227 else {
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1228 stmnt.setBytes(4, data);
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1229 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1230 stmnt.execute();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1231 conn.commit();
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1232
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1233 return true;
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1234 }
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1235 };
a0eff2227588 Added code to add artifacts to collections. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 175 diff changeset	1236 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	1237 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1238
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1239 public boolean removeCollectionArtifact(
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1240 String collectionId,
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1241 String artifactId
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1242 ) {
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1243 // TODO: Implement me!
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1244 return false;
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1245 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1246
157 6e6965873a48 Simplified creation of users. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 156 diff changeset	1247 public ArtifactCollection [] listCollectionArtifacts(String collectionId) {
156 a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1248 // TODO: Implement me!
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1249 return null;
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1250 }
a76de72ad6d1 Added stubs for the collection handling in db backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 154 diff changeset	1251
13 0d6badf6af42 Added not yet working backend to artifact database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	1252 }
79 f69e5b87f05f Implementation to export artifacts as xml (applied patch from issue208 by SLT). Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 47 diff changeset	1253 // 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 @ 178:535e4ea2ef9b