我想使用crudRepository从数据库中删除一个条目。我有一个与Task实体具有一对多关系的工时记录卡实体,而Task与Project具有一对多关系。我想删除基于taskId和projectId的数据库中的一个元素。
以下是实体的定义:
@Entity
@Table(name = "timecards")
public class TimeCard{
@Getter @Setter
@Column(name = "timecard_id", nullable = false)
@SequenceGenerator(name = "timecardSequence", sequenceName = "timecardIdSequence", allocationSize = 1, initialValue = 1)
@GeneratedValue(generator = "timecardSequence")
@Id
private Long timeCardId;
@Getter @Setter
@ManyToOne
@JoinColumn(name = "task_id", nullable = false, referencedColumnName = "id")
private Task task;
}@Entity
@Table(name = "tasks")
public class Task{
@Getter @Setter
@Column(name = "id", nullable = false)
@SequenceGenerator(name = "taskSequence", sequenceName = "taskIdSequence", allocationSize = 1, initialValue = 1)
@GeneratedValue(generator = "taskSequence")
@Id
private Long id;
@Getter
@Setter
@Column(name = "task_id", nullable = false)
private int taskId;
@Getter @Setter
@ManyToOne
@JoinColumn(name = "project_id", referencedColumnName = "project_id")
private Project project;
}@Entity
@Table(name = "projects")
public class Project implements Serializable {
@Getter @Setter
@Column(name = "project_id", nullable = false)
@Id
private Long projectId;@Repository
public interface TimeCardRepository extends CrudRepository<TimeCard, String>{
public void deleteTimeCardByTaskTaskIdAndTaskProjectProjectId(int taskId, Long projectId);
}是我的属性表达式,但不幸的是,我得到了以下错误消息:
Caused by: io.quarkus.spring.data.deployment.UnableToParseMethodException: Entity com.timecardservice.timecard.TimeCard does not contain a field named: TaskProject_ProjectId. Offending method is deleteTimeCardByTaskTaskIdAndTaskProjectProjectId我检查了横切点的https://evonsdesigns.medium.com/spring-jpa-one-to-many-query-examples-281078bc457b,但我得到了相同的错误信息。
执行此查询的正确方式是什么?
发布于 2021-08-09 13:36:59
您需要使用a_来访问连接的表/enities的属性。
所以它应该是
public void deleteTimeCardByTask_TaskIdAndTask_Project_ProjectId(int taskId, Long projectId);还可以使用以下命令检查记录的sql语句
spring.jpa.show-sql=true发布于 2021-08-09 13:45:27
如果JPA方式还不够,您可以始终使用NativeQuery/JPQLQuery来完成此工作:
@Modifying
@Query(value = "DELETE FROM TimeCard tc WHERE tc.task.taskId = :taskId and tc.task.project.projectId = :projectId")
List<Long> deleteByIds(@Param("taskId") Long taskId, @Param("projectId") Long projectId);发布于 2021-08-09 13:48:52
您可以显式编写查询:
@Repository
public interface TimeCardRepository extends CrudRepository<TimeCard, String>{
@Modifying
@Query(value = "DELETE FROM tc timeCard WHERE tc IN ( "
+ "SELECT timeCard FROM timeCard "
+ " JOIN timeCard.task task "
+ " JOIN taks.project project "
+ " WHERE task.id = :taskId AND project.id= :projectId)")
public void deleteTimeCardByTaskTaskIdAndTaskProjectProjectId(int taskId, Long projectId);
}https://stackoverflow.com/questions/68712906
复制相似问题