br.edu.ifpb.blogsoon.manager.repositorios.avaliacao.AvaliacaoRepository.java Source code

Introduction

Here is the source code for br.edu.ifpb.blogsoon.manager.repositorios.avaliacao.AvaliacaoRepository.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package br.edu.ifpb.blogsoon.manager.repositorios.avaliacao;

import br.edu.ifpb.blogsoon.core.entidades.Avaliacao;
import br.edu.ifpb.blogsoon.core.entidades.AvaliacaoEnum;
import br.edu.ifpb.blogsoon.core.entidades.Usuario;
import java.util.List;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.transaction.annotation.Isolation;

/**
 *
 * @author Emanuel Batista da Silva Filho - emanuelbatista2011@gmail.com
 * @author douglasgabriel
 */
public interface AvaliacaoRepository extends JpaRepository<Avaliacao, Long> {

    @Query("SELECT COUNT(a) FROM Avaliacao a WHERE a.idPost=:idPost")
    public long totalAvaliacaoPost(@Param("idPost") String idPost);

    @Query("SELECT COUNT(a) FROM Avaliacao a WHERE a.idPost=:idPost AND a.tipo=:tipo")
    public long totalAvaliacaoPostPorTipo(@Param("idPost") String idPost, @Param("tipo") AvaliacaoEnum tipo);

    public List<Avaliacao> findAvaliacaoByIdPost(String idPost);

    @Transactional(isolation = Isolation.READ_COMMITTED, value = "jpaTransactionManager")
    public List<Avaliacao> findAvaliacaoByIdPostAndTipo(String idPost, AvaliacaoEnum tipo);

    public List<Avaliacao> findAvaliacaoByIdPostAndUsuario(String idPost, Usuario usuario);
}