private QueryParameter resolveParameter(QueryParameter queryParameter) { if ( queryParameter.getName() != null ) { return parameterMetadata.getQueryParameter( queryParameter.getName() ); } else { return parameterMetadata.getQueryParameter( queryParameter.getPosition() ); } }
/** * Apply the given graph using {@linkplain GraphSemantic#FETCH fetch semantics} * * @apiNote This method calls {@link #applyGraph(RootGraph, GraphSemantic)} using * {@link GraphSemantic#FETCH} as the semantic */ default Query<R> applyFetchGraph(RootGraph graph) { return applyGraph( graph, GraphSemantic.FETCH ); }
@Override default NativeQueryImplementor createSQLQuery(String queryString) { return (NativeQueryImplementor) QueryProducer.super.createSQLQuery( queryString ); } }
default List<R> getResultList() { return list(); }
@Override public Person findByName(String name) { return (Person) this.sessionFactory.getCurrentSession().createQuery( "from Person person where person.name = :name").setParameter("name", name).getSingleResult(); }
public void setParameterValue(Query query) { query.setParameter( flatEntityPropertyName, value ); }
default R getSingleResult() { return uniqueResult(); }
private void cleanDb(Session s) { s.createQuery( "delete Locality" ).executeUpdate(); s.createQuery( "delete Country" ).executeUpdate(); s.createQuery( "delete Continent" ).executeUpdate(); }
public Query getQuery(Session s) { return s.createQuery( "select s as s, pc as pc from Student s left join s.preferredCourse pc left join fetch s.enrolments order by s.studentNumber" ) .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); } };
/** * JPA 2.2 defines the {@code getResultStream} method so to get a {@link Stream} from the JDBC {@link java.sql.ResultSet}. * * Hibernate 5.2 already defines the {@link Query#stream()} method, so {@code getResultStream} can delegate to it. * * @return The results Stream * @since 5.2.11 */ default Stream<R> getResultStream() { return stream(); } }
@Override @SuppressWarnings("unchecked") public QueryParameterBinding getBinding(int position) { return getBinding( parameterMetadata.getQueryParameter( position ) ); }
/** * Create a {@link NativeQuery} instance for the given SQL query string. * * @param queryString The SQL query * * @return The query instance for manipulation and execution * * @deprecated (since 5.2) use {@link #createNativeQuery(String)} instead */ @Deprecated default SQLQuery createSQLQuery(String queryString) { NativeQuery query = createNativeQuery( queryString ); query.setComment( "dynamic native SQL query" ); return query; }
@Override default NativeQueryImplementor getNamedSQLQuery(String name) { return (NativeQueryImplementor) QueryProducer.super.getNamedSQLQuery( name ); }
/** * Get the results of a query. * * @param query the query to run * @return the list of matched query results * @see Query#list() */ protected List<E> list(Query<E> query) throws HibernateException { return requireNonNull(query).list(); }
/** * Convenience method to return a single instance that matches the query, or null if the query * returns no results. * * @param query the query to run * @return the single result or {@code null} * @throws HibernateException if there is more than one matching result * @see Query#uniqueResult() */ protected E uniqueResult(Query<E> query) throws HibernateException { return requireNonNull(query).uniqueResult(); }
public Query getQuery(Session s) { return s.createQuery( "select e.student as student, e.semester, e.year, e.course as course from Enrolment e order by e.studentNumber" ) .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); } };
@Override @SuppressWarnings("unchecked") public QueryParameterBinding getBinding(String name) { return getBinding( parameterMetadata.getQueryParameter( name ) ); }
/** * Apply the given graph using {@linkplain GraphSemantic#LOAD load semantics} * * @apiNote This method calls {@link #applyGraph(RootGraph, GraphSemantic)} using * {@link GraphSemantic#LOAD} as the semantic */ default Query<R> applyLoadGraph(RootGraph graph) { return applyGraph( graph, GraphSemantic.LOAD ); }
public Query getQuery(Session s) { return s.createQuery( "select e.student as student from Enrolment e order by e.studentNumber" ) .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); } };
public Query getQuery(Session s) { return s.createQuery( "select min( e.studentNumber ) as minStudentNumber, max( e.studentNumber ) as maxStudentNumber from Enrolment e" ) .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); } };