@Repository public interface ImageRepository extends org.springframework.data.jpa.repository.JpaRepository<ImageJPA,java.lang.Integer>, VersionedContentRepository<ImageJPA>
deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAll, flush, getOne, save, saveAndFlushfindAll@Query(value="SELECT i FROM ImageJPA i WHERE i.version = ?1 AND i.language = ?2 AND i.loopEntryRef IS NULL") java.util.List<ImageJPA> findByVersionAndLanguageWhereLoopEntryRefIsNull(Version version, LanguageJPA language)
@Query(value="SELECT i FROM ImageJPA i WHERE i.version = ?1 AND i.language = ?2 AND i.loopEntryRef IS NOT NULL") java.util.List<ImageJPA> findByVersionAndLanguageWhereLoopEntryRefIsNotNull(Version version, LanguageJPA language)
@Query(value="select i.linkUrl from ImageJPA i where i.version = ?1 and i.language = ?2 and i.linkUrl > \'\'") java.util.Set<java.lang.String> findNonEmptyImageLinkUrlByVersionAndLanguage(Version version, LanguageJPA language)
java.util.Set<ImageJPA> findByVersionAndLanguage(Version version, LanguageJPA language)
@Query(value="SELECT i FROM ImageJPA i WHERE i.version = ?1 AND i.index = ?2 AND i.loopEntryRef IS NULL") java.util.List<ImageJPA> findByVersionAndIndexWhereLoopEntryRefIsNull(Version version, int index)
@Query(value="SELECT i FROM ImageJPA i WHERE i.version = ?1 AND i.index = ?2 AND i.loopEntryRef = ?3") java.util.List<ImageJPA> findByVersionAndIndexAndLoopEntryRef(Version version, int index, LoopEntryRefJPA loopEntryRef)
@Query(value="SELECT i FROM ImageJPA i WHERE i.version = ?1 AND i.language = ?2 AND i.index = ?3 AND i.loopEntryRef IS NULL") ImageJPA findByVersionAndLanguageAndIndexWhereLoopEntryRefIsNull(Version version, LanguageJPA language, int index)
@Query(value="SELECT i FROM ImageJPA i WHERE i.version = ?1 AND i.language = ?2 AND i.index = ?3 AND i.loopEntryRef = ?4") ImageJPA findByVersionAndLanguageAndIndexAndLoopEntryRef(Version version, LanguageJPA language, int index, LoopEntryRefJPA loopEntryRef)
@Query(value="SELECT i.id FROM ImageJPA i WHERE i.version = ?1 AND i.language = ?2 AND i.index = ?3 AND i.loopEntryRef IS NULL") java.lang.Integer findIdByVersionAndLanguageAndIndexWhereLoopEntryRefIsNull(Version version, LanguageJPA language, int index)
@Query(value="SELECT i.id FROM ImageJPA i WHERE i.version = ?1 AND i.language = ?2 AND i.index = ?3 AND i.loopEntryRef = ?4") java.lang.Integer findIdByVersionAndLanguageAndIndexAndLoopEntryRef(Version version, LanguageJPA language, int index, LoopEntryRefJPA loopEntryRef)
@Query(value="SELECT i FROM ImageJPA i WHERE i.generatedFilename IS NOT NULL AND i.generatedFilename <> \'\' OR i.url IS NOT NULL AND i.url <> \'\' ORDER BY i.id DESC") java.util.Collection<ImageJPA> findAllRegenerationCandidates()
@Query(value="SELECT i FROM ImageJPA i WHERE i.version = ?1") java.util.List<ImageJPA> findByVersion(Version version)
findByVersion in interface VersionedContentRepository<ImageJPA>java.util.List<ImageJPA> findByUrl(java.lang.String url)
@Modifying @Query(value="DELETE FROM ImageJPA i WHERE i.version = ?1 AND i.language = ?2") void deleteByVersionAndLanguage(Version version, LanguageJPA language)
@Modifying
@Query(value="DELETE FROM imcms_text_doc_images WHERE doc_id = ?1",
nativeQuery=true)
void deleteByDocId(java.lang.Integer docId)
@Query(value="SELECT MIN(img.index) FROM imcms_text_doc_images img WHERE img.doc_id=?1",
nativeQuery=true)
java.lang.Integer findMinIndexByVersion(int docId)