我想使用Spring Data JPA从多对多关系中删除条目。其中一个模型是关系的所有者,我需要删除非所有者实体的条目。这些是模型:
工作流实体
@Entity(name = "workflows")
public class Workflow {
@Id
@Column(name = "workflow_id", updatable = false, nullable = false)
@GeneratedValue(strategy = GenerationType.AUTO)
private UUID workflowId;
@ManyToMany(cascade = { CascadeType.PERSIST, CascadeType.MERGE })
@JoinTable(name = "workflow_data",
joinColumns = @JoinColumn(name = "workflow_id", referencedColumnName = "workflow_id"),
inverseJoinColumns = @JoinColumn(name = "data_upload_id", referencedColumnName = "data_upload_id"))
private Set<DataUpload> dataUploads = new HashSet<>();
// Setters and getters...
}
DataUpload实体
@Entity(name = "data_uploads")
public class DataUpload {
@Id
@Column(name = "data_upload_id")
private UUID dataUploadId;
@ManyToMany(cascade = { CascadeType.PERSIST, CascadeType.MERGE }, mappedBy = "dataUploads")
private Set<Workflow> workflows = new HashSet<>();
// Setters and getters...
}
DataUpload仓库
@Repository
public interface DataUploadsRepository extends JpaRepository<DataUpload, UUID> {
@Transactional
void delete(DataUpload dataUpload);
Optional<DataUpload> findByDataUploadId(UUID dataUploadId);
}
为了删除数据上传,我正在尝试执行存储库的几个查询方法: 第一个版本
dataUploadsRepository.deleteAll(workflow.getDataUploads());
第二版
workflow.getDataUploads().stream()
.map(DataUpload::getDataUploadId)
.map(dataUploadsRepository::findByDataUploadId)
.filter(Optional::isPresent)
.map(Optional::get)
.forEach(dataUploadsRepository::delete);
问题在于Spring Data JPA没有删除DataUploads
或关联表workflow_data
中的条目。
我该如何告诉Spring Data从data_uploads
和workflow_data
(关联表)中进行删除?
非常感谢您的帮助。