Spring Data delete by is supported

Question

I am using Spring JPA for database access  I am able to find examples such as findByName and countByName  for which I dont have to write any method implementation  I am hoping to find examples for delete a group of records based on some condition   Does Spring JPA support deleteByName-like delete  Any pointer is appreciated   Regards and thanks

User · Answer

here follows my 2 cents  You can also use native queries  like   Modifying  Query value  quot delete from rreo r where r cod ibge    1 and r exercicio   2 quot   nativeQuery   true  void deleteByParameters Integer codIbge  Integer exercicio

User · Answer

Query value    quot delete from addresses u where u ADDRESS ID LIKE   addressId  quot   nativeQuery   true  void deleteAddressByAddressId  Param  quot addressId quot   String addressId

User · Answer

Derivation of delete queries using given method name is supported starting with version 1 6 0 RC1 of Spring Data JPA  The keywords remove and delete are supported  As return value one can choose between the number or a list of removed entities   Long removeByLastname String lastname    List lt User gt  deleteByLastname String lastname

User · Answer

Yes   deleteBy method is supported  To use it you need to annotate method with  Transactional

User · Answer

Be carefull when you use derived query for batch delete  It isn t what you expect  DeleteExecution

User · Answer

2 ways -   1st one Custom Query   Modifying  Query  delete from User where firstName    firstName   void deleteUsersByFirstName  Param  firstName   String firstName     2nd one JPA Query by method  List lt User gt  deleteByLastname String lastname     When you go with query by method  2nd way  it will first do a get call  select   from user where last name    firstName   Then it will load it in a List Then it will call delete id one by one  delete from user where id   18 delete from user where id   19   First fetch list of object  then for loop to delete id one by one  But  the 1st option  custom query    It s just a single query    It will delete wherever the value exists   Go through this link too https   www baeldung com spring-data-jpa-deleteby

User · Answer

If you take a look at the source code of Spring Data JPA  and particularly the PartTreeJpaQuery class  you will see that is tries to instantiate PartTree  Inside that class the following regular expression   private static final Pattern PREFIX TEMPLATE   Pattern compile    find read get count query    p Lu       By    should indicate what is allowed and what s not    Of course if you try to add such a method you will actually see that is does not work and you get the full stacktrace   I should note that I was using looking at version 1 5 0 RELEASE of Spring Data JPA

User · Answer

Deprecated answer  Spring Data JPA  lt  1 6 x     Modifying annotation to the rescue  You will need to provide your custom SQL behaviour though   public interface UserRepository extends JpaRepository lt User  Long gt         Modifying      Query  delete from User u where u firstName    1       void deleteUsersByFirstName String firstName       Update   In modern versions of Spring Data JPA    1 7 x  query derivation for delete  remove and count operations is accessible   public interface UserRepository extends CrudRepository lt User  Long gt         Long countByFirstName String firstName        Long deleteByFirstName String firstName        List lt User gt  removeByFirstName String firstName

User · Answer

If you will use pre defined delete methods as directly provided by spring JPA then below two queries will be execute by the framework    First collect data like id and other column  using by execute select query with delete query where clause  then after getting resultSet of first query  second delete queries will be execute for all id one by one   Note   This is not optimized way for your application because many queries will be execute for single MYSQL delete query    This is another optimized way for delete query code because only one delete query will execute by using below customized methods      NamedNativeQueries     NamedNativeQuery name    Abc deleteByCreatedTimeBetween               query    DELETE FROM abc WHERE create time BETWEEN  1 AND  2               NamedNativeQuery name    Abc getByMaxId               query    SELECT max id  from abc        Entity public class Abc implements Serializable        Repository public interface AbcRepository extends CrudRepository        int getByMaxId          Transactional      Modifying     void deleteByCreatedTimeBetween String startDate  String endDate

[spring] Spring Data: "delete by" is supported?

Examples related to spring

Examples related to spring-data

Examples related to spring-data-jpa