Package com.espacogeek.geek.repositories

Interface UserCustomStatusRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<UserCustomStatusModel,Integer>, org.springframework.data.jpa.repository.JpaRepository<UserCustomStatusModel,Integer>, org.springframework.data.repository.ListCrudRepository<UserCustomStatusModel,Integer>, org.springframework.data.repository.ListPagingAndSortingRepository<UserCustomStatusModel,Integer>, org.springframework.data.repository.PagingAndSortingRepository<UserCustomStatusModel,Integer>, org.springframework.data.repository.query.QueryByExampleExecutor<UserCustomStatusModel>, org.springframework.data.repository.Repository<UserCustomStatusModel,Integer>

@Repository
public interface UserCustomStatusRepository
extends org.springframework.data.jpa.repository.JpaRepository<UserCustomStatusModel,Integer>

Method Summary

Modifier and Type	Method	Description
int	deleteByIdAndUserId(Integer id, Integer userId)
boolean	existsByIdAndUserId(Integer id, Integer userId)
Optional<UserCustomStatusModel>	findByIdAndUserId(Integer id, Integer userId)
List<UserCustomStatusModel>	findByUserId(Integer userId)

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

Methods inherited from interface org.springframework.data.repository.ListCrudRepository

findAll, findAllById, saveAll

Methods inherited from interface org.springframework.data.repository.ListPagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findBy, findOne

Method Details

findByUserId

List<UserCustomStatusModel> findByUserId(Integer userId)

findByIdAndUserId

Optional<UserCustomStatusModel> findByIdAndUserId(Integer id,
 Integer userId)

existsByIdAndUserId

boolean existsByIdAndUserId(Integer id,
 Integer userId)

deleteByIdAndUserId

@Modifying
@Query("DELETE FROM UserCustomStatusModel s WHERE s.id = :id AND s.user.id = :userId")
int deleteByIdAndUserId(@Param("id")
 Integer id,
 @Param("userId")
 Integer userId)