1 /** 2 * This file Copyright (c) 2018 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.admincentral.findbar.sniff; 35 36 import info.magnolia.admincentral.findbar.PeriscopeAppDetailCreator; 37 import info.magnolia.ui.api.ioc.AdmincentralScoped; 38 import info.magnolia.ui.api.location.LocationController; 39 40 import java.util.regex.Pattern; 41 42 import javax.inject.Inject; 43 44 /** 45 * This operation fetches the node from the particular workspace. 46 * 47 * <p> 48 * Note that this operation does not do full-text search unlike {@link FindContentCommandSniffer}. 49 * </p> 50 * 51 * Examples: <b>find</b> iran <b>tour</b>, <b>find</b> articles <b>page</b> 52 */ 53 @AdmincentralScoped 54 public class FindNodeCommandSniffer extends AbstractFindCommandSniffer { 55 56 private static final Pattern COMMAND_PATTERN = Pattern.compile("find (?<content>([^\\s]+))(\\s(?<appName>[^ ]+)$)"); 57 58 @Inject 59 public FindNodeCommandSniffer(LocationController locationController, PeriscopeAppDetailCreator periscopeAppDetailCreator) { 60 super(locationController, periscopeAppDetailCreator, COMMAND_PATTERN); 61 } 62 63 @Override 64 protected String buildQuery(String nodeName) { 65 return new StringBuilder().append("SELECT * FROM ").append("[nt:base] AS t") 66 .append(" WHERE (lower(LOCALNAME()) LIKE ").append("'%").append(nodeName).append("%'") 67 .append(" OR lower(title) LIKE ").append("'%").append(nodeName).append("%')") 68 .append(" order by score() desc") 69 .toString(); 70 } 71 }