View Javadoc
1   package de.dlr.shepard.context.references.dataobject.daos;
2   
3   import de.dlr.shepard.common.util.Constants;
4   import de.dlr.shepard.common.util.CypherQueryHelper;
5   import de.dlr.shepard.context.references.dataobject.entities.DataObjectReference;
6   import de.dlr.shepard.context.version.daos.VersionableEntityDAO;
7   import jakarta.enterprise.context.RequestScoped;
8   import java.util.Collections;
9   import java.util.List;
10  import java.util.UUID;
11  import java.util.stream.StreamSupport;
12  
13  @RequestScoped
14  public class DataObjectReferenceDAO extends VersionableEntityDAO<DataObjectReference> {
15  
16    /**
17     * Searches the database for references.
18     *
19     * @param dataObjectId identifies the dataObject
20     * @return a List of references
21     */
22    public List<DataObjectReference> findByDataObjectNeo4jId(long dataObjectId) {
23      String query =
24        "MATCH (d:DataObject)-[hr:has_reference]->%s WHERE ID(d)=%d ".formatted(
25            CypherQueryHelper.getObjectPart("r", "DataObjectReference", false),
26            dataObjectId
27          ) +
28        CypherQueryHelper.getReturnPart("r");
29  
30      var queryResult = findByQuery(query, Collections.emptyMap());
31  
32      List<DataObjectReference> result = StreamSupport.stream(queryResult.spliterator(), false)
33        .filter(r -> r.getDataObject() != null)
34        .filter(r -> r.getDataObject().getId().equals(dataObjectId))
35        .toList();
36  
37      return result;
38    }
39  
40    public List<DataObjectReference> findByDataObjectShepardId(long dataObjectShepardId, UUID versionUID) {
41      String query =
42        String.format(
43          "MATCH (d:DataObject)-[hr:has_reference]->%s WHERE d." + Constants.SHEPARD_ID + "=%d ",
44          CypherQueryHelper.getObjectPart("r", "DataObjectReference", false),
45          dataObjectShepardId
46        ) +
47        CypherQueryHelper.getReturnPart("r");
48      StringBuffer queryBuffer = new StringBuffer();
49      queryBuffer.append("MATCH (v:Version)<-[:has_version]-(d:DataObject)-[hr:has_reference]->");
50      queryBuffer.append(CypherQueryHelper.getObjectPart("r", "DataObjectReference", false));
51      queryBuffer.append(" WHERE d." + Constants.SHEPARD_ID + "=" + dataObjectShepardId + " AND ");
52      if (versionUID == null) queryBuffer.append(CypherQueryHelper.getVersionHeadPart("v"));
53      else queryBuffer.append(CypherQueryHelper.getVersionPart("v", versionUID));
54      queryBuffer.append(" " + CypherQueryHelper.getReturnPart("r"));
55      query = queryBuffer.toString();
56      var queryResult = findByQuery(query, Collections.emptyMap());
57      List<DataObjectReference> result = StreamSupport.stream(queryResult.spliterator(), false)
58        .filter(r -> r.getDataObject() != null)
59        .filter(r -> r.getDataObject().getShepardId().equals(dataObjectShepardId))
60        .toList();
61      return result;
62    }
63  
64    @Override
65    public Class<DataObjectReference> getEntityType() {
66      return DataObjectReference.class;
67    }
68  }