com.querydsl.jpa.hibernate.sql.AbstractHibernateSQLQuery Maven / Gradle / Ivy
The newest version!
/*
* Copyright 2015, The Querydsl Team (http://www.querydsl.com/team)
*
* 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.querydsl.jpa.hibernate.sql;
import com.mysema.commons.lang.CloseableIterator;
import com.querydsl.core.DefaultQueryMetadata;
import com.querydsl.core.NonUniqueResultException;
import com.querydsl.core.QueryMetadata;
import com.querydsl.core.QueryResults;
import com.querydsl.core.types.Expression;
import com.querydsl.core.types.FactoryExpression;
import com.querydsl.jpa.AbstractSQLQuery;
import com.querydsl.jpa.FactoryExpressionTransformer;
import com.querydsl.jpa.NativeSQLSerializer;
import com.querydsl.jpa.ScrollableResultsIterator;
import com.querydsl.jpa.hibernate.DefaultSessionHolder;
import com.querydsl.jpa.hibernate.HibernateUtil;
import com.querydsl.jpa.hibernate.SessionHolder;
import com.querydsl.jpa.hibernate.StatelessSessionHolder;
import com.querydsl.sql.Configuration;
import com.querydsl.sql.SQLSerializer;
import java.util.HashSet;
import java.util.List;
import java.util.Set;
import java.util.logging.Level;
import java.util.logging.Logger;
import java.util.stream.Stream;
import org.hibernate.Session;
import org.hibernate.StatelessSession;
import org.hibernate.query.Query;
import org.jetbrains.annotations.Nullable;
/**
* {@code AbstractHibernateSQLQuery} is the base class for Hibernate Native SQL queries
*
* @param result type
* @param concrete subtype
* @author tiwe
*/
public abstract class AbstractHibernateSQLQuery>
extends AbstractSQLQuery {
private static final Logger logger = Logger.getLogger(AbstractHibernateSQLQuery.class.getName());
protected Boolean cacheable, readOnly;
protected String cacheRegion;
protected int fetchSize = 0;
private final SessionHolder session;
protected int timeout = 0;
public AbstractHibernateSQLQuery(Session session, Configuration conf) {
this(new DefaultSessionHolder(session), conf, new DefaultQueryMetadata());
}
public AbstractHibernateSQLQuery(StatelessSession session, Configuration conf) {
this(new StatelessSessionHolder(session), conf, new DefaultQueryMetadata());
}
public AbstractHibernateSQLQuery(
SessionHolder session, Configuration conf, QueryMetadata metadata) {
super(metadata, conf);
this.session = session;
}
public Query createQuery() {
return createQuery(false);
}
private Query createQuery(boolean forCount) {
var serializer = (NativeSQLSerializer) serialize(forCount);
var queryString = serializer.toString();
logQuery(queryString);
org.hibernate.query.NativeQuery query = session.createSQLQuery(queryString);
// set constants
HibernateUtil.setConstants(
query, serializer.getConstants(), queryMixin.getMetadata().getParams());
if (!forCount) {
var aliases = serializer.getAliases();
Set used = new HashSet<>();
// set entity paths
Expression projection = queryMixin.getMetadata().getProjection();
if (projection instanceof FactoryExpression) {
for (Expression expr : ((FactoryExpression) projection).getArgs()) {
if (isEntityExpression(expr)) {
query.addEntity(extractEntityExpression(expr).toString(), expr.getType());
} else if (aliases.containsKey(expr)) {
for (String scalar : aliases.get(expr)) {
if (!used.contains(scalar)) {
query.addScalar(scalar);
used.add(scalar);
break;
}
}
}
}
} else if (isEntityExpression(projection)) {
query.addEntity(extractEntityExpression(projection).toString(), projection.getType());
} else if (aliases.containsKey(projection)) {
for (String scalar : aliases.get(projection)) {
if (!used.contains(scalar)) {
query.addScalar(scalar);
used.add(scalar);
break;
}
}
}
// set result transformer, if projection is a FactoryExpression instance
if (projection instanceof FactoryExpression) {
query.setResultTransformer(
new FactoryExpressionTransformer((FactoryExpression) projection));
}
}
if (fetchSize > 0) {
query.setFetchSize(fetchSize);
}
if (timeout > 0) {
query.setTimeout(timeout);
}
if (cacheable != null) {
query.setCacheable(cacheable);
}
if (cacheRegion != null) {
query.setCacheRegion(cacheRegion);
}
if (readOnly != null) {
query.setReadOnly(readOnly);
}
return query;
}
@Override
protected SQLSerializer createSerializer() {
return new NativeSQLSerializer(configuration, true);
}
@SuppressWarnings("unchecked")
@Override
public List fetch() {
try {
return createQuery().list();
} finally {
reset();
}
}
@Override
public CloseableIterator iterate() {
try {
var query = createQuery();
return new ScrollableResultsIterator(query.getResultList());
} finally {
reset();
}
}
@Override
public Stream stream() {
try {
var query = createQuery();
return query.getResultStream();
} finally {
reset();
}
}
@Override
public QueryResults fetchResults() {
// TODO : handle entity projections as well
try {
var query = createQuery(true);
var total = ((Number) query.uniqueResult()).longValue();
if (total > 0) {
var modifiers = queryMixin.getMetadata().getModifiers();
query = createQuery(false);
@SuppressWarnings("unchecked")
List list = query.list();
return new QueryResults<>(list, modifiers, total);
} else {
return QueryResults.emptyResults();
}
} finally {
reset();
}
}
protected void logQuery(String queryString) {
if (logger.isLoggable(Level.FINE)) {
var normalizedQuery = queryString.replace('\n', ' ');
logger.fine(normalizedQuery);
}
}
protected void reset() {}
@SuppressWarnings("unchecked")
@Override
public T fetchOne() throws NonUniqueResultException {
try {
var query = createQuery();
return (T) uniqueResult(query);
} finally {
reset();
}
}
@Nullable
private Object uniqueResult(Query query) {
try {
return query.uniqueResult();
} catch (org.hibernate.NonUniqueResultException e) {
throw new NonUniqueResultException(e);
}
}
/**
* Enable caching of this query result set.
*
* @param cacheable Should the query results be cacheable?
*/
@SuppressWarnings("unchecked")
public Q setCacheable(boolean cacheable) {
this.cacheable = cacheable;
return (Q) this;
}
/**
* Set the name of the cache region.
*
* @param cacheRegion the name of a query cache region, or {@code null} for the default query
* cache
*/
@SuppressWarnings("unchecked")
public Q setCacheRegion(String cacheRegion) {
this.cacheRegion = cacheRegion;
return (Q) this;
}
/**
* Set a fetchJoin size for the underlying JDBC query.
*
* @param fetchSize the fetchJoin size
*/
@SuppressWarnings("unchecked")
public Q setFetchSize(int fetchSize) {
this.fetchSize = fetchSize;
return (Q) this;
}
/**
* Entities retrieved by this query will be loaded in a read-only mode where Hibernate will never
* dirty-check them or make changes persistent.
*/
@SuppressWarnings("unchecked")
public Q setReadOnly(boolean readOnly) {
this.readOnly = readOnly;
return (Q) this;
}
/**
* Set a timeout for the underlying JDBC query.
*
* @param timeout the timeout in seconds
*/
@SuppressWarnings("unchecked")
public Q setTimeout(int timeout) {
this.timeout = timeout;
return (Q) this;
}
@Override
protected void clone(Q query) {
super.clone(query);
cacheable = query.cacheable;
cacheRegion = query.cacheRegion;
fetchSize = query.fetchSize;
readOnly = query.readOnly;
timeout = query.timeout;
}
protected abstract Q clone(SessionHolder session);
public Q clone(Session session) {
return this.clone(new DefaultSessionHolder(session));
}
public Q clone(StatelessSession statelessSession) {
return this.clone(new StatelessSessionHolder(statelessSession));
}
@Override
public Q clone() {
return this.clone(this.session);
}
}