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

Interface CountryRepository

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

  • Method Summary

    Modifier and Type
    Method
    Description
    int
    deleteCountryByName(String name)
    Delete register by name.
    List<es.kukenan.smartfi.dto.DataOnboardingResponse>
    findAllByLanguageId(int language)
    Select registers by language.
    Country
    findById(int id)
    Select registers by id.
    Country
    findByName(String name)
    Select registers by name.
    int
    updateCountry(long id, String name)
    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

    • updateCountry

      @Modifying @Query("UPDATE Country c SET c.name = :name WHERE c.id = :id") int updateCountry(@Param("id") long id, @Param("name") String name)
      Update registers by id.
      Parameters:
      id - identifier for Country.
      name - name for backoffice.
      Returns:
      integer number for update

    • deleteCountryByName

      @Modifying @Query("DELETE FROM Country c WHERE c.name = :name") int deleteCountryByName(@Param("name") String name)
      Delete register by name.
      Parameters:
      name - identifier for country.
      Returns:
      integer number for update

    • findByName

      @Query("SELECT c FROM Country c WHERE c.name = :name") Country findByName(@Param("name") String name)
      Select registers by name.
      Parameters:
      name - name for country.
      Returns:
      country object from database

    • findAllByLanguageId

      @Query("SELECT NEW es.kukenan.smartfi.dto.DataOnboardingResponse(c.id, c.name, c.id) FROM Country c WHERE c.language.id = :language") List<es.kukenan.smartfi.dto.DataOnboardingResponse> findAllByLanguageId(@Param("language") int language)
      Select registers by language.
      Parameters:
      language - for Country.
      Returns:
      list of country objects

    • findById

      @Query("SELECT c FROM Country c WHERE c.id = :id") Country findById(@Param("id") int id)
      Select registers by id.
      Parameters:
      id - identifier for Country.
      Returns:
      Country object from database