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 Type
    Method
    Description
    List<es.kukenan.smartfi.microservice.backoffice.dtos.backoffice.requestedfiles.DataObject>
    Select requested files.
    List<es.kukenan.smartfi.microservice.backoffice.dtos.backoffice.requestedfiles.DataObject>
    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, save

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

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

    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

    • 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