Spring Data Neo4j关系实体存储库

Question

我希望像查询NodeEntity一样查询RelationshipEntity。

软件包信息：

groupId=org.springframework.data
artifactId=spring-data-neo4j
version=5.1.5.RELEASE

@NodeEntity("Employee")
public class Employee{

    @Id
    @GeneratedValue
    Long id;
    String name;

    // Id
    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }
    // Name
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }

    @Relationship(type = STARTED, direction = Relationship.OUTGOING)
    private List<Status> starts = new ArrayList<>();

    @Relationship(type = PAUSED, direction = Relationship.OUTGOING)
    private List<Status> pause = new ArrayList<>();

    @Relationship(type = STOPED, direction = Relationship.OUTGOING)
    private List<Status> stops = new ArrayList<>();

    @Relationship(type = COMPLETED, direction = Relationship.OUTGOING)
    private List<Status> action = new ArrayList<>();

    // Default Relationship
    @Relationship(type = ACTION, direction = Relationship.OUTGOING)
    private List<Status> action = new ArrayList<>();
}

@NodeEntity("Project")
public class Project{

    @Id
    @GeneratedValue
    Long id;
    String name;

    // Id
    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }
    // Name
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
}

@RelationshipEntity
public class Status {

    @Id
    @GeneratedValue
    Long id;
    String name;

    // Id
    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }
    // Name
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }

    @StartNode
    private Employee employee;

    @EndNode
    private Project project;
}

public interface EmployeeRepository extends CrudRepository<Employee, Long> {
    Employee findByName(String name);

    @Query("MATCH (e:Employee)-[r]->(p:Project) WHERE e.name={empName} AND p.name={prjName} RETURN e ")
    Employee getEmployeeWorkingOnProjectId(@Param("empName") String empName, @Param("prjName") String prjName);
}

此存储库不工作。
getEmployeeWorkingOnProject(String，String)返回NULL

我在return关键字之后进行了修改，例如将其从return*修改为像returnee、r、p这样的别名，并且还尝试更改了返回中别名的顺序。

我希望获得与特定员工和特定项目相关联的所有状态（边缘）。

public interface StatusRepository extends CrudRepository<Status, Long> {

    @Query("MATCH (e:Employee)-[r]->(p:Project) WHERE e.name={empName} AND p.name={prjName} RETURN * ")
    Status getEmployeeWorkingOnProject(@Param("empName") String empName, @Param("prjName") String prjName);


    /* OR 
    @Query("MATCH (e:Employee)-[r]->(p:Project) WHERE e.name={empName} AND p.name={prjName} AND r.name={statusName} RETURN * ")
    Status getEmployeeWorkingOnProject(@Param("empName") String empName, @Param("prjName") String prjName, @Param("statusName") String statusName)
    */
}

{
  Status: {
    name: ..,
    Employee: {
      ...
    },
    Project: {
      ...
    }
  }
},
{
  Status: {
    name: ..,
    Employee: {
      ...
    },
    Project: {
      ...
    }
  }
},
..

或

STARTED : {
  Employee: {
    ...
  },
  Project: {
    ...
  }
},
STOPPED : {
  Employee: {
    ...
  },
  Project: {
    ...
  }
},

或其他类型的类似结果，其中关系实体持有两个连接节点。

Answer 1

在从下面提到的Employee(model/entity)中移除特定代码后，我能够使StatusRepository工作：

    @Relationship(type = STARTED, direction = Relationship.OUTGOING)
    private List<Status> starts = new ArrayList<>();

    @Relationship(type = PAUSED, direction = Relationship.OUTGOING)
    private List<Status> pause = new ArrayList<>();

    @Relationship(type = STOPED, direction = Relationship.OUTGOING)
    private List<Status> stops = new ArrayList<>();

    @Relationship(type = COMPLETED, direction = Relationship.OUTGOING)
    private List<Status> action = new ArrayList<>();

    // Default Relationship
    @Relationship(type = ACTION, direction = Relationship.OUTGOING)
    private List<Status> action = new ArrayList<>();