use of org.neo4j.ogm.cypher.query.PagingAndSortingQuery in project neo4j-ogm by neo4j.
the class RelationshipQueryStatements method findByType.
@Override
public PagingAndSortingQuery findByType(String type, Filters parameters, int depth) {
if (depth > 0) {
FilteredQuery query = FilteredQueryBuilder.buildRelationshipQuery(type, parameters);
String matchClause = query.statement() + " WITH DISTINCT(r0) as r0,startnode(r0) AS n, endnode(r0) AS m";
String returnClause = loadClauseBuilder.build("r0", type, depth);
return new PagingAndSortingQuery(matchClause, returnClause, query.parameters(), true, true, "r0");
} else {
throw new InvalidDepthException("Cannot load a relationship entity with depth 0 i.e. no start or end node");
}
}
use of org.neo4j.ogm.cypher.query.PagingAndSortingQuery in project neo4j-ogm by neo4j.
the class LoadByIdsDelegate method loadAll.
public <T, ID extends Serializable> Collection<T> loadAll(Class<T> type, Collection<ID> ids, SortOrder sortOrder, Pagination pagination, int depth) {
Optional<String> labelsOrType = session.determineLabelsOrTypeForLoading(type);
if (!labelsOrType.isPresent()) {
LOG.warn("Unable to find database label for entity " + type.getName() + " : no results will be returned. Make sure the class is registered, " + "and not abstract without @NodeEntity annotation");
return Collections.emptyList();
}
QueryStatements<ID> queryStatements = session.queryStatementsFor(type, depth);
ClassInfo classInfo = session.metaData().classInfo(type.getName());
PagingAndSortingQuery qry = queryStatements.findAllByType(labelsOrType.get(), convertIfNeeded(classInfo, ids), depth).setSortOrder(sortOrder).setPagination(pagination);
GraphModelRequest request = new DefaultGraphModelRequest(qry.getStatement(), qry.getParameters());
return session.doInTransaction(() -> {
try (Response<GraphModel> response = session.requestHandler().execute(request)) {
Iterable<T> mapped = new GraphRowModelMapper(session.metaData(), session.context(), session.getEntityInstantiator()).map(type, response);
if (sortOrder.sortClauses().isEmpty()) {
return sortResultsByIds(type, ids, mapped);
}
Set<T> results = new LinkedHashSet<>();
for (T entity : mapped) {
if (includeMappedEntity(ids, entity)) {
results.add(entity);
}
}
return results;
}
}, Transaction.Type.READ_ONLY);
}
use of org.neo4j.ogm.cypher.query.PagingAndSortingQuery in project neo4j-ogm by neo4j.
the class LoadByTypeDelegate method loadAll.
/**
* Loads all objects of a given {@code type}. The {@code type} is used to determine the Neo4j label. If no such label
* can be determined, a warning is logged and an immutable, empty list is returned to prevent queries without label
* that potentially can retrieve all objects in the database if no {@link Filters filters} are given.
*
* @param type The type of objects to load.
* @param filters Additional filters to reduce the number of objects loaded, may be null or empty.
* @param sortOrder Sort order to be passed on to the database
* @param pagination Pagination if required
* @param depth Depth of relationships to load
* @param <T> Returned type
* @return A list of objects with the requested type
*/
public <T> Collection<T> loadAll(Class<T> type, Filters filters, SortOrder sortOrder, Pagination pagination, int depth) {
Optional<String> labelsOrType = session.determineLabelsOrTypeForLoading(type);
if (!labelsOrType.isPresent()) {
LOG.warn("Unable to find database label for entity " + type.getName() + " : no results will be returned. Make sure the class is registered, " + "and not abstract without @NodeEntity annotation");
return Collections.emptyList();
}
QueryStatements queryStatements = session.queryStatementsFor(type, depth);
SortOrder sortOrderWithResolvedProperties = sortOrderWithResolvedProperties(type, sortOrder);
PagingAndSortingQuery query;
if (filters == null || filters.isEmpty()) {
query = queryStatements.findByType(labelsOrType.get(), depth);
} else {
resolvePropertyAnnotations(type, filters);
query = queryStatements.findByType(labelsOrType.get(), filters, depth);
}
query.setSortOrder(sortOrderWithResolvedProperties).setPagination(pagination);
return session.doInTransaction(() -> {
if (query.needsRowResult()) {
DefaultGraphRowListModelRequest graphRowListModelRequest = new DefaultGraphRowListModelRequest(query.getStatement(), query.getParameters());
try (Response<GraphRowListModel> response = session.requestHandler().execute(graphRowListModelRequest)) {
return (Collection<T>) new GraphRowListModelMapper(session.metaData(), session.context(), session.getEntityInstantiator()).map(type, response);
}
} else {
GraphModelRequest request = new DefaultGraphModelRequest(query.getStatement(), query.getParameters());
try (Response<GraphModel> response = session.requestHandler().execute(request)) {
return (Collection<T>) new GraphRowModelMapper(session.metaData(), session.context(), session.getEntityInstantiator()).map(type, response);
}
}
}, Transaction.Type.READ_WRITE);
}
use of org.neo4j.ogm.cypher.query.PagingAndSortingQuery in project neo4j-ogm by neo4j.
the class RelationshipEntityQuerySortingTest method testDefaultMultipleSortOrders.
@Test
public void testDefaultMultipleSortOrders() {
String cypher = "MATCH ()-[r0:`ORBITS`]-() WITH DISTINCT(r0) as r0,startnode(r0) AS n, " + "endnode(r0) AS m ORDER BY r0.distance,r0.aphelion " + "MATCH p1 = (n)-[*0..3]-() WITH r0, COLLECT(DISTINCT p1) AS startPaths, m " + "MATCH p2 = (m)-[*0..3]-() WITH r0, startPaths, COLLECT(DISTINCT p2) AS endPaths " + "WITH r0,startPaths + endPaths AS paths UNWIND paths AS p RETURN DISTINCT p, ID(r0)";
PagingAndSortingQuery orbitsQuery = query.findByType("ORBITS", 3);
check(cypher, orbitsQuery.setSortOrder(sortOrder.add("distance", "aphelion")).getStatement());
check(cypher, orbitsQuery.setSortOrder(new SortOrder("distance", "aphelion")).getStatement());
check(cypher, orbitsQuery.setSortOrder(new SortOrder().asc("distance", "aphelion")).getStatement());
}
use of org.neo4j.ogm.cypher.query.PagingAndSortingQuery in project neo4j-ogm by neo4j.
the class NodeEntityQueryPagingTest method testFindByTypeAndOffset.
@Test
public void testFindByTypeAndOffset() {
Pagination pagination = new Pagination(1, 5);
pagination.setOffset(3);
PagingAndSortingQuery query = queryStatements.findByType("Raptor", 1).setPagination(pagination);
assertThat(query.getStatement()).isEqualTo("MATCH (n:`Raptor`) WITH n SKIP 3 LIMIT 5 MATCH p=(n)-[*0..1]-(m) RETURN p, ID(n)");
}
Aggregations