View Javadoc
1   /*
2    * Licensed to the Apache Software Foundation (ASF) under one
3    * or more contributor license agreements.  See the NOTICE file
4    * distributed with this work for additional information
5    * regarding copyright ownership.  The ASF licenses this file
6    * to you under the Apache License, Version 2.0 (the
7    * "License"); you may not use this file except in compliance
8    * with the License.  You may obtain a copy of the License at
9    *
10   *   http://www.apache.org/licenses/LICENSE-2.0
11   *
12   * Unless required by applicable law or agreed to in writing,
13   * software distributed under the License is distributed on an
14   * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
15   * KIND, either express or implied.  See the License for the
16   * specific language governing permissions and limitations
17   * under the License.
18   */
19  package org.apache.syncope.core.persistence.jpa.dao;
20  
21  import javax.persistence.Query;
22  import org.apache.syncope.core.persistence.api.dao.ExternalResourceDAO;
23  import org.apache.syncope.core.persistence.api.dao.PlainAttrDAO;
24  import org.apache.syncope.core.persistence.api.entity.AnyUtilsFactory;
25  import org.apache.syncope.core.persistence.api.entity.PlainAttr;
26  import org.apache.syncope.core.persistence.api.entity.PlainSchema;
27  
28  public class MyJPAJSONPlainSchemaDAO extends AbstractJPAJSONPlainSchemaDAO {
29  
30      public MyJPAJSONPlainSchemaDAO(
31              final AnyUtilsFactory anyUtilsFactory,
32              final PlainAttrDAO plainAttrDAO,
33              final ExternalResourceDAO resourceDAO) {
34  
35          super(anyUtilsFactory, plainAttrDAO, resourceDAO);
36      }
37  
38      @Override
39      public <T extends PlainAttr<?>> boolean hasAttrs(final PlainSchema schema, final Class<T> reference) {
40          Query query = entityManager().createNativeQuery(
41                  "SELECT COUNT(id) FROM " + new SearchSupport(getAnyTypeKind(reference)).field().name
42                  + " WHERE JSON_CONTAINS(plainAttrs, '[{\"schema\":\"" + schema.getKey() + "\"}]')");
43  
44          return ((Number) query.getSingleResult()).intValue() > 0;
45      }
46  }