Interface RequestedFileRepository
- All Superinterfaces:
org.springframework.data.repository.CrudRepository<RequestedFile,,String> org.springframework.data.jpa.repository.JpaRepository<RequestedFile,,String> org.springframework.data.repository.PagingAndSortingRepository<RequestedFile,,String> org.springframework.data.repository.query.QueryByExampleExecutor<RequestedFile>,org.springframework.data.repository.Repository<RequestedFile,String>
@Repository
public interface RequestedFileRepository
extends org.springframework.data.jpa.repository.JpaRepository<RequestedFile,String>
Repository for queries for Requested File.
-
Method Summary
Modifier and TypeMethodDescriptionList<es.kukenan.smartfi.microservice.backoffice.dtos.backoffice.requestedfiles.DataObject>findAllByEnabledByType(Boolean enabled, String type) Select requested files.List<es.kukenan.smartfi.microservice.backoffice.dtos.backoffice.requestedfiles.DataObject>findAllMapped(String type) Select all requested files.findById(int id) Select registers by id.Methods inherited from interface org.springframework.data.repository.CrudRepository
count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, saveMethods inherited from interface org.springframework.data.jpa.repository.JpaRepository
deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getById, getOne, getReferenceById, saveAll, saveAllAndFlush, saveAndFlushMethods inherited from interface org.springframework.data.repository.PagingAndSortingRepository
findAllMethods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor
count, exists, findAll, findBy, findOne
-
Method Details
-
findById
@Query("SELECT rf FROM RequestedFile rf WHERE rf.id = :id") RequestedFile findById(@Param("id") int id) Select registers by id.- Parameters:
id- identifier for Requested File.- Returns:
- Annual revenues object from database
-
findAllMapped
@Query("SELECT NEW es.kukenan.smartfi.microservice.backoffice.dtos.backoffice.requestedfiles.DataObject(rf.id, rf.name, rf.description, rf.id, rf.enabled) FROM RequestedFile rf WHERE rf.type = :type") List<es.kukenan.smartfi.microservice.backoffice.dtos.backoffice.requestedfiles.DataObject> findAllMapped(@Param("type") String type) Select all requested files.- Parameters:
type- Product type.- Returns:
- List of object for Requested File
-
findAllByEnabledByType
@Query("SELECT NEW es.kukenan.smartfi.microservice.backoffice.dtos.backoffice.requestedfiles.DataObject(rf.id, rf.name, rf.description, rf.id, rf.enabled) FROM RequestedFile rf WHERE rf.enabled = :enabled and rf.type = :type") List<es.kukenan.smartfi.microservice.backoffice.dtos.backoffice.requestedfiles.DataObject> findAllByEnabledByType(@Param("enabled") Boolean enabled, @Param("type") String type) Select requested files.- Parameters:
enabled- Product enabled.type- Product type.- Returns:
- List of object for Requested File
-