2 * This document is a part of the source code and related artifacts
3 * for CollectionSpace, an open source collections management system
4 * for museums and related institutions:
6 * http://www.collectionspace.org
7 * http://wiki.collectionspace.org
9 * Copyright 2009 University of California at Berkeley
11 * Licensed under the Educational Community License (ECL), Version 2.0.
12 * You may not use this file except in compliance with this License.
14 * You may obtain a copy of the ECL 2.0 License at
16 * https://source.collectionspace.org/collection-space/LICENSE.txt
18 * Unless required by applicable law or agreed to in writing, software
19 * distributed under the License is distributed on an "AS IS" BASIS,
20 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
21 * See the License for the specific language governing permissions and
22 * limitations under the License.
25 package org.collectionspace.services.authorization.storage;
27 import java.util.ArrayList;
28 import java.util.List;
29 import org.collectionspace.services.common.context.ServiceContext;
30 import org.collectionspace.services.common.storage.jpa.JpaDocumentFilter;
31 import org.slf4j.Logger;
32 import org.slf4j.LoggerFactory;
35 * PermissionJpaFilter is to build where clause for role queries
38 public class PermissionJpaFilter extends JpaDocumentFilter {
40 private final Logger logger = LoggerFactory.getLogger(PermissionJpaFilter.class);
43 * Instantiates a new permission jpa filter.
47 public PermissionJpaFilter(ServiceContext ctx) {
52 public List<ParamBinding> buildWhereForSearch(StringBuilder queryStrBldr) {
54 List<ParamBinding> paramList = new ArrayList<ParamBinding>();
56 String resName = null;
57 List<String> rn = getQueryParam(PermissionStorageConstants.Q_RESOURCE_NAME);
58 if (null != rn && rn.size() > 0) {
61 queryStrBldr.append(addTenant(false, paramList));
62 if (null != resName && !resName.isEmpty()) {
63 queryStrBldr.append(" AND");
64 queryStrBldr.append(" UPPER(a." + PermissionStorageConstants.RESOURCE_NAME + ")");
65 queryStrBldr.append(" LIKE");
66 queryStrBldr.append(" :" + PermissionStorageConstants.Q_RESOURCE_NAME);
67 paramList.add(new ParamBinding(PermissionStorageConstants.Q_RESOURCE_NAME, "%"
68 + resName.toUpperCase() + "%"));
71 if (logger.isDebugEnabled()) {
72 String query = queryStrBldr.toString();
73 logger.debug("query=" + query);
80 public List<ParamBinding> buildWhere(StringBuilder queryStrBldr) {
81 return new ArrayList<ParamBinding>();