Package es.kukenan.smartfi.microservice.smartficore.repository

Interface DocumentStatusRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<DocumentStatus,String>, org.springframework.data.jpa.repository.JpaRepository<DocumentStatus,String>, org.springframework.data.repository.PagingAndSortingRepository<DocumentStatus,String>, org.springframework.data.repository.query.QueryByExampleExecutor<DocumentStatus>, org.springframework.data.repository.Repository<DocumentStatus,String>
@Repository public interface DocumentStatusRepository extends org.springframework.data.jpa.repository.JpaRepository<DocumentStatus,String>
Repository for queries for Document status.

  • Method Summary

    Modifier and Type
    Method
    Description
    int
    deleteDocumentStatusByName(String description)
    Delete register by description.
    List<es.kukenan.smartfi.dto.DataOnboardingResponse>
    findAllByLanguageId(int language)
    Select registers by language.
    DocumentStatus
    findByIdDocument(int id)
    Select registers by id.
    DocumentStatus
    findByName(String description)
    Select registers by description status.
    int
    updateDocumentStatus(long id, String description)
    Update 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

    • updateDocumentStatus

      @Modifying @Query("UPDATE DocumentStatus d SET d.description = :description WHERE d.id = :id") int updateDocumentStatus(@Param("id") long id, @Param("description") String description)
      Update registers by id.
      Parameters:
      id - identifier for Document status.
      description - description for Document status.
      Returns:
      integer number for update

    • deleteDocumentStatusByName

      @Modifying @Query("DELETE FROM DocumentStatus d WHERE d.description = :description") int deleteDocumentStatusByName(@Param("description") String description)
      Delete register by description.
      Parameters:
      description - description for Document status.
      Returns:
      integer number for delete

    • findByName

      @Query("SELECT d FROM DocumentStatus d WHERE d.description = :description") DocumentStatus findByName(@Param("description") String description)
      Select registers by description status.
      Parameters:
      description - description for Document status.
      Returns:
      Document Status object from database

    • findByIdDocument

      @Query("SELECT d FROM DocumentStatus d WHERE d.id = :id") DocumentStatus findByIdDocument(@Param("id") int id)
      Select registers by id.
      Parameters:
      id - identifier for Document status.
      Returns:
      Document status object from database

    • findAllByLanguageId

      @Query("SELECT NEW es.kukenan.smartfi.dto.DataOnboardingResponse(d.id, d.description) FROM DocumentStatus d WHERE d.language.id = :language") List<es.kukenan.smartfi.dto.DataOnboardingResponse> findAllByLanguageId(@Param("language") int language)
      Select registers by language.
      Parameters:
      language - for Document status.
      Returns:
      List of objects from database