Does Spring Data JPA have any way to count entites using method name resolving

Question

Spring Data JPA supports counting entities using specifications  But does it have any way to count entities using method name resolving  Let s say I want a method countByName to count entities with specific name  just like a method findByName to fetch all entities with specific name

User · Answer

As of Spring Data 1 7 1 RELEASE you can do it with two different ways   The new way  using query derivation for both count and delete queries  Read this   Example 5   Example       public interface UserRepository extends CrudRepository lt User  Integer gt            long countByName String name           The old way  Using  Query annotation  Example       public interface UserRepository extends CrudRepository lt User  Integer gt             Query  quot SELECT COUNT u  FROM User u WHERE u name  1 quot           long aMethodNameOrSomething String name          or using  Param annotation also  public interface UserRepository extends CrudRepository lt User  Integer gt         Query  quot SELECT COUNT u  FROM User u WHERE u name  name quot       long aMethodNameOrSomething  Param  quot name quot   String name      Check also this so answer

User · Answer

Thanks you all  Now it s work  DATAJPA-231  It will be nice if was possible to create count   By    methods just like find   By ones  Example   public interface UserRepository extends JpaRepository lt User  Long gt        public Long   or BigInteger    countByActiveTrue

User · Answer

As long as you do not use 1 4 version  you can use explicit annotation   example    Query  select count e  from Product e where e area code    1   long countByAreaCode String code

User · Answer

According to the issue DATAJPA-231 the feature is not implemented yet

User · Answer

JpaRepository also extends QueryByExampleExecutor  So you don t even need to define custom methods on your interface   public interface UserRepository extends JpaRepository lt User  Long gt           no need of custom method     And then query like   User probe   new User    u setName    John   long count   repo count Example of probe

User · Answer

Apparently it is implemented now DATAJPA-231

User · Answer

This feature has been added in version 1 4 M1

User · Answer

I have only been working with it for a few weeks but I don t believe that this is strictly possible however you should be able to get the same effect with a little more effort  just write the query yourself and annotate the method name   It s probably not much simpler than writing the method yourself but it is cleaner in my opinion   Edit  it is now possible according to DATAJPA-231

User · Answer

According to Abel  after the version 1 4  tested in version 1 4 3 RELEASE  is possible doing this way   public long countByName String name

User · Answer

If anyone wants to get the count with based on multiple conditions than here is a sample custom query   Query  select count sl  from SlUrl sl where sl user   1 And sl creationDate between  2 And  3       long countUrlsBetweenDates User user  Date date1  Date date2

User · Answer

Working example    Repository public interface TenantRepository extends JpaRepository lt  Tenant  Long  gt        List lt Tenant gt findByTenantName String tenantName Pageable pageRequest       long countByTenantName String tenantName       Calling from DAO layer   Override public long countByTenantName String tenantName        return repository countByTenantName tenantName

User · Answer

Autowired private UserRepository userRepository    RequestMapping   user count   private Long getNumberOfUsers        return userRepository count

[java] Does Spring Data JPA have any way to count entites using method name resolving?

Examples related to java

Examples related to spring

Examples related to spring-data-jpa