1 /**
2 * This file Copyright (c) 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.rssaggregator.command;
35
36 import info.magnolia.cms.util.AlertUtil;
37 import info.magnolia.cms.util.QueryUtil;
38 import info.magnolia.commands.MgnlCommand;
39 import info.magnolia.context.Context;
40 import info.magnolia.jcr.util.PropertyUtil;
41 import info.magnolia.module.rssaggregator.RSSAggregatorConstants;
42
43 import javax.jcr.Node;
44 import javax.jcr.NodeIterator;
45 import javax.jcr.Session;
46
47 /**
48 * Replaces an old feed URL with a new one.
49 *
50 * @author lfischer
51 */
52 public class ReplacePlanetUrlCommand extends MgnlCommand {
53
54 public static final String FEED_NAME = "planetFeed";
55 public static final String OLD_URL = "oldurl";
56 public static final String NEW_URL = "newurl";
57
58 @Override
59 public boolean execute(Context context) throws Exception {
60 final String planetFeed = (String) context.get(FEED_NAME);
61 final String oldUrl = (String) context.get(OLD_URL);
62 final String newUrl = (String) context.get(NEW_URL);
63
64 Session session = context.getJCRSession("data");
65
66 String sql = "select * from [nt:base] as t where ISDESCENDANTNODE([/rssaggregator/" + planetFeed + "]) " +
67 "and t.rssLink='" + oldUrl + "'";
68
69 int replCnt = 0;
70
71 NodeIterator entries = QueryUtil.search(RSSAggregatorConstants.WORKSPACE, sql);
72
73 while (entries.hasNext()) {
74 Node entry = entries.nextNode();
75 PropertyUtil.setProperty(entry, "rssLink", newUrl);
76 session.save();
77 replCnt++;
78 }
79
80 AlertUtil.setMessage("Replaced " + replCnt + " URLs within the Planet feed " + planetFeed + ".");
81
82 return true;
83 }
84
85 }