Package sk.iway.iwcm.components.seo.jpa

Interface ManagementKeywordsRepository

All Superinterfaces:

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

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

Method Summary

Modifier and Type	Method	Description
List<String>	getDistinctDomains()
List<String>	getDistinctDomainsLike(String param)
List<Integer>	getDistinctUserIds()
List<String>	getMostUsedBotsLike(String param)

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, 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

getDistinctUserIds

@Query(value="SELECT DISTINCT author FROM seo_keywords",
       nativeQuery=true)
List<Integer> getDistinctUserIds()

getDistinctDomains

@Query(value="SELECT DISTINCT domain FROM seo_keywords",
       nativeQuery=true)
List<String> getDistinctDomains()

getDistinctDomainsLike

@Query(value="SELECT DISTINCT domain FROM seo_keywords WHERE domain LIKE ?1",
       nativeQuery=true)
List<String> getDistinctDomainsLike(String param)

getMostUsedBotsLike

@Query(value="SELECT search_bot FROM seo_keywords WHERE search_bot LIKE ?1 GROUP BY search_bot ORDER BY COUNT(search_bot) DESC",
       nativeQuery=true)
List<String> getMostUsedBotsLike(String param)