Package es.kukenan.smartfi.microservice.onboarding.repository

Interface AnnualRevenuesRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<AnnualRevenues,String>, org.springframework.data.jpa.repository.JpaRepository<AnnualRevenues,String>, org.springframework.data.repository.PagingAndSortingRepository<AnnualRevenues,String>, org.springframework.data.repository.query.QueryByExampleExecutor<AnnualRevenues>, org.springframework.data.repository.Repository<AnnualRevenues,String>
@Repository public interface AnnualRevenuesRepository extends org.springframework.data.jpa.repository.JpaRepository<AnnualRevenues,String>
Repository for queries for Annual Revenues.

  • Method Summary

    Modifier and Type
    Method
    Description
    List<es.kukenan.smartfi.dto.DataOnboardingResponse>
    findAllByLanguageId(int language)
    Select registers by language.
    AnnualRevenues
    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 a FROM AnnualRevenues a WHERE a.id = :id") AnnualRevenues findById(@Param("id") int id)
      Select registers by id.
      Parameters:
      id - identifier for Annual Revenues.
      Returns:
      Annual revenues object from database

    • findAllByLanguageId

      @Query("SELECT NEW es.kukenan.smartfi.dto.DataOnboardingResponse(a.id, a.description, a.id) FROM AnnualRevenues a WHERE a.language.id = :language") List<es.kukenan.smartfi.dto.DataOnboardingResponse> findAllByLanguageId(@Param("language") int language)
      Select registers by language.
      Parameters:
      language - for Annual Revenues.
      Returns:
      List of object for Annual revenues