Package sk.iway.iwcm.components.media

Interface MediaRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<sk.iway.spirit.model.Media,Long>, DomainIdRepository<sk.iway.spirit.model.Media,Long>, org.springframework.data.jpa.repository.JpaRepository<sk.iway.spirit.model.Media,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<sk.iway.spirit.model.Media>, org.springframework.data.repository.PagingAndSortingRepository<sk.iway.spirit.model.Media,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<sk.iway.spirit.model.Media>, org.springframework.data.repository.Repository<sk.iway.spirit.model.Media,Long>

@Repository
public interface MediaRepository
extends DomainIdRepository<sk.iway.spirit.model.Media,Long>

Method Summary

Modifier and Type	Method	Description
List<sk.iway.spirit.model.Media>	findAllByMediaFkIdAndMediaFkTableNameAndDomainId(Integer mediaFkId, String mediaFkTableName, Integer domainId)
org.springframework.data.domain.Page<sk.iway.spirit.model.Media>	findAllByMediaFkIdAndMediaFkTableNameAndDomainId(Integer mediaFkId, String mediaFkTableName, Integer domainId, org.springframework.data.domain.Pageable pageable)
List<Long>	findMediaIds(String mediaLink, String mediaFkTableName)
void	updateMedia(String newMediaLink, String oldMediaLink)
void	updateMedia(String newMediaLink, String oldMediaLink, List<Long> mediaFkIds)

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

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

Methods inherited from interface sk.iway.iwcm.system.datatable.spring.DomainIdRepository

findAllByDomainId, findAllByDomainId, findFirstByIdAndDomainId

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

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

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

count, findAll, findAll, findAll, findOne

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

findAllByMediaFkIdAndMediaFkTableNameAndDomainId

org.springframework.data.domain.Page<sk.iway.spirit.model.Media> findAllByMediaFkIdAndMediaFkTableNameAndDomainId(Integer mediaFkId,
 String mediaFkTableName,
 Integer domainId,
 org.springframework.data.domain.Pageable pageable)

findAllByMediaFkIdAndMediaFkTableNameAndDomainId

List<sk.iway.spirit.model.Media> findAllByMediaFkIdAndMediaFkTableNameAndDomainId(Integer mediaFkId,
 String mediaFkTableName,
 Integer domainId)

findMediaIds

@Query(value="SELECT distinct(media_fk_id) FROM media WHERE media_link = ?1 AND media_fk_table_name = ?2",
       nativeQuery=true)
List<Long> findMediaIds(String mediaLink,
 String mediaFkTableName)

updateMedia

@Transactional
@Modifying
@Query(value="UPDATE media SET media_link = ?1 WHERE media_link = ?2",
       nativeQuery=true)
void updateMedia(String newMediaLink,
 String oldMediaLink)

updateMedia

@Transactional
@Modifying
@Query("UPDATE Media SET mediaLink = :newMediaLink WHERE mediaLink = :oldMediaLink AND mediaFkId IN :mediaFkIds AND mediaFkTableName=\'documents\'")
void updateMedia(@Param("newMediaLink")
 String newMediaLink,
 @Param("oldMediaLink")
 String oldMediaLink,
 @Param("mediaFkIds")
 List<Long> mediaFkIds)