com.wavemaker.runtime.data.dao.query.providers.SessionBackedQueryProvider Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of wavemaker-app-runtime-db Show documentation
wavemaker-app-runtime-db
There is a newer version: 11.9.2.ee
Show newest version
/*******************************************************************************
 * Copyright (C) 2022-2023 WaveMaker, Inc.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 ******************************************************************************/
package com.wavemaker.runtime.data.dao.query.providers;

import java.util.Optional;

import javax.persistence.Entity;

import org.hibernate.Session;
import org.hibernate.engine.spi.SessionFactoryImplementor;
import org.hibernate.engine.spi.SessionImplementor;
import org.hibernate.query.Query;
import org.hibernate.query.spi.NamedQueryRepository;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.data.domain.Pageable;
import org.springframework.data.domain.Sort;

import com.wavemaker.runtime.data.dao.util.QueryHelper;
import com.wavemaker.runtime.data.transform.Transformers;
import com.wavemaker.runtime.data.transform.WMResultTransformer;

/**
 * @author Dilip Kumar
 * @since 1/8/17
 */
public class SessionBackedQueryProvider implements QueryProvider, PaginatedQueryProvider {

    private static final Logger LOGGER = LoggerFactory.getLogger(SessionBackedQueryProvider.class);

    private String name;
    private Class responseType;

    public SessionBackedQueryProvider(final String name, final Class responseType) {
        this.name = name;
        this.responseType = responseType;
    }

    @Override
    public Query getQuery(final Session session) {
        return getAndConfigureQuery(session, name, responseType);
    }

    @Override
    public Query getQuery(final Session session, final Pageable pageable) {
        Query query;
        final Sort sort = pageable.getSort();
        final WMResultTransformer transformer = Transformers.aliasToMappedClass(responseType);

        if (sort != null) {
            query = createSortedQuery(session, sort, transformer);
        } else {
            query = getAndConfigureQuery(session, name, responseType);
        }

        if (!pageable.isUnpaged()) {
            query.setFirstResult((int) pageable.getOffset())
                .setMaxResults(pageable.getPageSize());
        }

        return query;
    }

    @Override
    public Optional> getCountQuery(final Session session) {
        Query query = null;

        final String countQueryName = this.name + "__count";
        final NamedQueryRepository repository = ((SessionFactoryImplementor) session.getSessionFactory())
            .getNamedQueryRepository();
        if (queryExists(repository, countQueryName)) {
            query = getAndConfigureQuery(session, countQueryName, Number.class);
        } else {
            LOGGER.debug("Count query not found for query:{}", name);
        }

        return Optional.ofNullable(query);
    }

    @SuppressWarnings("unchecked")
    private  Query getAndConfigureQuery(final Session session, String name, Class type) {
        final Query query;

        if (isMappedType(type)) {
            query = session.createNamedQuery(name, type);
        } else {
            query = session.createNamedQuery(name);
            Transformers.aliasToMappedClassOptional(type).ifPresent(query::setResultTransformer);
        }

        return query;
    }

    @SuppressWarnings("unchecked")
    private Query createSortedQuery(final Session session, final Sort sort, final WMResultTransformer transformer) {
        final Query query;
        final NamedQueryRepository repository = ((SessionFactoryImplementor) session.getSessionFactory())
            .getNamedQueryRepository();
        if (repository.getNamedQueryDefinition(name) != null) {
            final String sortedQuery = QueryHelper
                .applySortingForHqlQuery(repository.getNamedQueryDefinition(name).getQueryString(), sort,
                    transformer);
            if (isMappedType(responseType)) {
                query = session.createQuery(sortedQuery, responseType);
            } else {
                query = session.createQuery(sortedQuery).setResultTransformer(transformer);

            }
        } else if (repository.getNamedSQLQueryDefinition(name) != null) {
            final String sortedQuery = QueryHelper
                .applySortingForNativeQuery(repository.getNamedSQLQueryDefinition(name).getQueryString(),
                    sort, transformer,
                    ((SessionFactoryImplementor) session.getSessionFactory()).getDialect());
            query = session.createNativeQuery(sortedQuery).setResultTransformer(transformer);
        } else {
            throw ((SessionImplementor) session).getExceptionConverter()
                .convert(new IllegalArgumentException("No query defined for that name [" + name + "]"));
        }
        return query;
    }

    private boolean queryExists(final NamedQueryRepository repository, final String countQueryName) {
        return repository.getNamedQueryDefinition(countQueryName) != null || repository.getNamedSQLQueryDefinition(countQueryName) != null;
    }

    private boolean isMappedType(Class type) {
        return type.isAnnotationPresent(Entity.class);
    }
}