[JAVA] [Spring Data JPA] Can And condition be used in the automatically implemented method of delete?

Overview

As described in the article [Spring Data JPA] Naming rules for automatically implemented methods, JPA defines methods that match the repository naming rules. So, there is a function that automatically generates a query. This time, we will talk about whether the And condition can be used at the time of delete in the automatic generation.

About delete

• As described in Official document, even delete can be used as repository. By defining the deleteBy method and specifying the property name to be used for the condition, the query will be automatically generated. Spring Data JPA – Derived Delete Methods explains the implementation details.
• [Java] [Spring Boot] [JPA] Use database --Spring Boot starting with NetBeans (6) As you can see in the article, delete is also find There is an atmosphere where similar conditional expressions can be used.

Conclusion

And condition was usable. I haven't tried it, but I think other conditions can probably be used. However, I think it is better to implement complicated conditions with NativeQuery. ..

Implementation sample

Entity

UserPost.java

@Entity
@Table(name = "user_posts")
public class UserPost {
  @Id
  private long id;
  private long userId;
  private String contents;

  public long getId() {
    return this.id;
  }
  public void setId(long id) {
    this.id = id;
  }

  public long getUserId() {
    return this.userId;
  }
  public void setUserId(long userId) {
    this.userId = userId;
  }

  public String getContents() {
    return this.contents;
  }
  public void setContents(String contents) {
    this.contents = contents;
  }
}

Repository

UserPostRepository.java

@Repository
public interface UserPostRepository extends JpaRepository<UserPost, String> {
    //Delete record by specifying id and userId with And condition
    void deleteByIdAndUserId(long id, long userId);
}