1 /**
2 * This file Copyright (c) 2012-2013 Magnolia International
3 * Ltd. (http://www.magnolia-cms.com). All rights reserved.
4 *
5 *
6 * This file is dual-licensed under both the Magnolia
7 * Network Agreement and the GNU General Public License.
8 * You may elect to use one or the other of these licenses.
9 *
10 * This file is distributed in the hope that it will be
11 * useful, but AS-IS and WITHOUT ANY WARRANTY; without even the
12 * implied warranty of MERCHANTABILITY or FITNESS FOR A
13 * PARTICULAR PURPOSE, TITLE, or NONINFRINGEMENT.
14 * Redistribution, except as permitted by whichever of the GPL
15 * or MNA you select, is prohibited.
16 *
17 * 1. For the GPL license (GPL), you can redistribute and/or
18 * modify this file under the terms of the GNU General
19 * Public License, Version 3, as published by the Free Software
20 * Foundation. You should have received a copy of the GNU
21 * General Public License, Version 3 along with this program;
22 * if not, write to the Free Software Foundation, Inc., 51
23 * Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.
24 *
25 * 2. For the Magnolia Network Agreement (MNA), this file
26 * and the accompanying materials are made available under the
27 * terms of the MNA which accompanies this distribution, and
28 * is available at http://www.magnolia-cms.com/mna.html
29 *
30 * Any modifications to this file must keep this entire header
31 * intact.
32 *
33 */
34 package info.magnolia.module.delta;
35
36 import info.magnolia.cms.util.QueryUtil;
37 import info.magnolia.module.InstallContext;
38
39 import javax.jcr.Node;
40 import javax.jcr.NodeIterator;
41 import javax.jcr.Property;
42 import javax.jcr.PropertyIterator;
43 import javax.jcr.PropertyType;
44 import javax.jcr.RepositoryException;
45 import javax.jcr.query.Query;
46
47 /**
48 * Changes all properties in an entire workspace that are of type {@link PropertyType#STRING} and has a certain value.
49 *
50 * Note that this uses the query functionality of JCR and is therefore usable only if <code>currentValue</code> is a
51 * valid <code>fullTextSearchExpression</code> as defined in JCR2 6.7.19. More specifically it is not guaranteed to
52 * find all properties intended to be changed if <code>currentValue</code> either:
53 * <ul>
54 * <li>starts with a dash</li>
55 * <li>contains the word <code>OR</code></li>
56 * <li>contains characters that conflict with the query syntax such as quote, double quote, minus and backslash</li>
57 * </ul>
58 */
59 public class ChangeAllPropertiesWithCertainValueTask extends AbstractRepositoryTask {
60
61 private String workspaceName;
62 private String currentValue;
63 private String newValue;
64
65 public ChangeAllPropertiesWithCertainValueTask(String name, String description, String workspaceName, String currentValue, String newValue) {
66 super(name, description);
67 this.workspaceName = workspaceName;
68 this.currentValue = currentValue;
69 this.newValue = newValue;
70 }
71
72 @Override
73 protected void doExecute(InstallContext installContext) throws RepositoryException, TaskExecutionException {
74
75 String query = "select * from [nt:base] as t where contains(t.*,'" + currentValue + "')";
76 NodeIterator nodeIterator = QueryUtil.search(workspaceName, query, Query.JCR_SQL2);
77 while (nodeIterator.hasNext()) {
78 Node node = nodeIterator.nextNode();
79 PropertyIterator iterator = node.getProperties();
80 while (iterator.hasNext()) {
81 Property property = iterator.nextProperty();
82 if (property.getType() == PropertyType.STRING) {
83 if (property.getString().equals(currentValue)) {
84 property.setValue(newValue);
85 }
86 }
87 }
88 }
89 }
90 }