Package sk.iway.iwcm.components.enumerations.model

Interface EnumerationTypeRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<EnumerationTypeBean,Long>, org.springframework.data.jpa.repository.JpaRepository<EnumerationTypeBean,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<EnumerationTypeBean>, org.springframework.data.repository.ListCrudRepository<EnumerationTypeBean,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<EnumerationTypeBean,Long>, org.springframework.data.repository.PagingAndSortingRepository<EnumerationTypeBean,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<EnumerationTypeBean>, org.springframework.data.repository.Repository<EnumerationTypeBean,Long>

@Repository
public interface EnumerationTypeRepository
extends org.springframework.data.jpa.repository.JpaRepository<EnumerationTypeBean,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<EnumerationTypeBean>

Nested Class Summary

Nested classes/interfaces inherited from interface org.springframework.data.jpa.repository.JpaSpecificationExecutor

org.springframework.data.jpa.repository.JpaSpecificationExecutor.SpecificationFluentQuery<T extends Object>

Method Summary

Modifier and Type	Method	Description
void	deleteEnumTypeById(Integer enumerationTypeId, boolean hidden)
org.springframework.data.domain.Page<EnumerationTypeBean>	findAllByHiddenFalse(org.springframework.data.domain.Pageable pagebale)
EnumerationTypeBean	findFirstByHiddenOrderById(boolean hidden)
List<EnumerationTypeBean>	getAllNonHiddenOrderedById(boolean hidden)
EnumerationTypeBean	getByEnumId(Integer enumerationTypeId)
Integer	getChildEnumTypeId(Integer enumerationTypeId)
Object	getHiddenByEnumTypeId(Integer enumerationTypeId)
Integer	getIdByTypeName(String typeName)
EnumerationTypeBean	getNonHiddenByEnumId(Integer enumerationTypeId, boolean hidden)
Object	isAllowChildEnumerationType(Long enumerationTypeId)
Object	isAllowParentEnumerationData(Long enumerationTypeId)

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, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

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

count, count, delete, delete, exists, exists, findAll, findAll, findAll, findAll, findAll, findBy, findBy, findOne, findOne, update

Methods inherited from interface org.springframework.data.repository.ListCrudRepository

findAll, findAllById, saveAll

Methods inherited from interface org.springframework.data.repository.ListPagingAndSortingRepository

findAll

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

getNonHiddenByEnumId

@Query(value="SELECT * FROM enumeration_type WHERE enumeration_type_id = ?1 AND hidden = ?2",
       nativeQuery=true)
EnumerationTypeBean getNonHiddenByEnumId(Integer enumerationTypeId,
 boolean hidden)

getByEnumId

@Query(value="SELECT * FROM enumeration_type WHERE enumeration_type_id = ?1",
       nativeQuery=true)
EnumerationTypeBean getByEnumId(Integer enumerationTypeId)

getAllNonHiddenOrderedById

@Query(value="SELECT * FROM enumeration_type WHERE hidden = ?1 ORDER BY enumeration_type_id",
       nativeQuery=true)
List<EnumerationTypeBean> getAllNonHiddenOrderedById(boolean hidden)

findFirstByHiddenOrderById

EnumerationTypeBean findFirstByHiddenOrderById(boolean hidden)

deleteEnumTypeById

@Transactional
@Modifying
@Query("UPDATE EnumerationTypeBean SET hidden = :hidden WHERE enumerationTypeId = :enumerationTypeId")
void deleteEnumTypeById(@Param("enumerationTypeId")
 Integer enumerationTypeId,
 @Param("hidden")
 boolean hidden)

findAllByHiddenFalse

org.springframework.data.domain.Page<EnumerationTypeBean> findAllByHiddenFalse(org.springframework.data.domain.Pageable pagebale)

getHiddenByEnumTypeId

@Query(value="SELECT hidden FROM enumeration_type WHERE enumeration_type_id = ?1",
       nativeQuery=true)
Object getHiddenByEnumTypeId(Integer enumerationTypeId)

getChildEnumTypeId

@Query(value="SELECT child_enumeration_type_id FROM enumeration_type WHERE enumeration_type_id = ?1",
       nativeQuery=true)
Integer getChildEnumTypeId(Integer enumerationTypeId)

isAllowChildEnumerationType

@Query(value="SELECT allow_child_enumeration_type FROM enumeration_type WHERE enumeration_type_id = ?1",
       nativeQuery=true)
Object isAllowChildEnumerationType(Long enumerationTypeId)

isAllowParentEnumerationData

@Query(value="SELECT allow_parent_enumeration_data FROM enumeration_type WHERE enumeration_type_id = ?1",
       nativeQuery=true)
Object isAllowParentEnumerationData(Long enumerationTypeId)

getIdByTypeName

@Query("SELECT etb.id FROM EnumerationTypeBean etb WHERE etb.typeName = :typeName")
Integer getIdByTypeName(@Param("typeName")
 String typeName)