Package com.viglet.turing.persistence.repository.sn.metric

Interface TurSNSiteMetricAccessRepository

All Superinterfaces:

CrudRepository<TurSNSiteMetricAccess,String>, JpaRepository<TurSNSiteMetricAccess,String>, ListCrudRepository<TurSNSiteMetricAccess,String>, ListPagingAndSortingRepository<TurSNSiteMetricAccess,String>, PagingAndSortingRepository<TurSNSiteMetricAccess,String>, QueryByExampleExecutor<TurSNSiteMetricAccess>, Repository<TurSNSiteMetricAccess,String>

public interface TurSNSiteMetricAccessRepository
extends JpaRepository<TurSNSiteMetricAccess,String>

Since:

0.3.6

Author:

Alexandre Oliveira

Method Summary

Modifier and Type	Method	Description
int	countTerms(TurSNSite turSNSite)
int	countTermsByPeriod(TurSNSite turSNSite, Date startDate, Date endDate)
List<TurSNSiteMetricAccess>	findByTurSNSite(TurSNSite turSNSite)
List<TurSNSiteMetricAccess>	findByTurSNSiteAndLanguage(TurSNSite turSNSite, String language)
List<TurSNSiteMetricAccessTerm>	findLatestSearches(TurSNSite turSNSite, String language, String userId, Pageable pageable)
List<TurSNSiteMetricAccessTerm>	topTerms(TurSNSite turSNSite, Pageable pageable)
List<TurSNSiteMetricAccessTerm>	topTermsBetweenDates(TurSNSite turSNSite, Date startDate, Date endDate, Pageable pageable)

Methods inherited from interface CrudRepository

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

Methods inherited from interface JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

Methods inherited from interface ListCrudRepository

findAll, findAllById, saveAll

Methods inherited from interface ListPagingAndSortingRepository

findAll

Methods inherited from interface PagingAndSortingRepository

findAll

Methods inherited from interface QueryByExampleExecutor

count, exists, findAll, findBy, findOne

Method Details

findLatestSearches

@Query("select distinct new com.viglet.turing.persistence.repository.sn.metric.TurSNSiteMetricAccessTerm(sanatizedTerm, max(accessDate)) from TurSNSiteMetricAccess where turSNSite = ?1 and language = ?2 and userId = ?3 GROUP BY sanatizedTerm ORDER BY MAX(accessDate) DESC")
List<TurSNSiteMetricAccessTerm> findLatestSearches(TurSNSite turSNSite,
 String language,
 String userId,
 Pageable pageable)

topTerms

@Query("select distinct new com.viglet.turing.persistence.repository.sn.metric.TurSNSiteMetricAccessTerm(sanatizedTerm, COUNT(sanatizedTerm), AVG(CAST(numFound as double))) from TurSNSiteMetricAccess where turSNSite = ?1 GROUP BY sanatizedTerm ORDER BY COUNT(sanatizedTerm) DESC")
List<TurSNSiteMetricAccessTerm> topTerms(TurSNSite turSNSite,
 Pageable pageable)

topTermsBetweenDates

@Query("select distinct new com.viglet.turing.persistence.repository.sn.metric.TurSNSiteMetricAccessTerm(sanatizedTerm, COUNT(sanatizedTerm), AVG(CAST(numFound as double))) from TurSNSiteMetricAccess where turSNSite = ?1 AND accessDate BETWEEN ?2 AND ?3 GROUP BY sanatizedTerm ORDER BY COUNT(sanatizedTerm) DESC")
List<TurSNSiteMetricAccessTerm> topTermsBetweenDates(TurSNSite turSNSite,
 Date startDate,
 Date endDate,
 Pageable pageable)

countTerms

@Query("select COUNT(sanatizedTerm) from TurSNSiteMetricAccess where turSNSite = ?1")
int countTerms(TurSNSite turSNSite)

countTermsByPeriod

@Query("select COUNT(sanatizedTerm) from TurSNSiteMetricAccess where turSNSite = ?1 AND accessDate BETWEEN ?2 AND ?3")
int countTermsByPeriod(TurSNSite turSNSite,
 Date startDate,
 Date endDate)

findByTurSNSiteAndLanguage

List<TurSNSiteMetricAccess> findByTurSNSiteAndLanguage(TurSNSite turSNSite,
 String language)

findByTurSNSite

List<TurSNSiteMetricAccess> findByTurSNSite(TurSNSite turSNSite)