how to obtain pieces of composite key in @SQLDelete to perform soft deletion of an entity?
@Data
class DummyKey {
private Long foo;
private Long bar;
}
@IdClass(DummyKey.class)
@SQLDelete(sql = "UPDATE dummy SET deleted = 'Y' WHERE ???") //how to get key params
@Where(clause = "deleted='N'")
class Dummy {
@Id
@Column(name = "foo")
private Long foo;
@Id
@Column(name = "bar")
private Long bar;
@Column(name = "stuff")
private String stuff;
@Column(name = "deleted")
private String deleted;
}