cs544.wamp_blog_engine.dao.impl.CommentDAOImpl.java Source code

Introduction

Here is the source code for cs544.wamp_blog_engine.dao.impl.CommentDAOImpl.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 cs544.wamp_blog_engine.dao.impl;

import cs544.wamp_blog_engine.dao.CommentDAO;
import cs544.wamp_blog_engine.domain.Comment;
import cs544.wamp_blog_engine.domain.Post;
import java.util.ArrayList;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

/**
 *
 * @author Weldino
 */
public class CommentDAOImpl implements CommentDAO {

    private SessionFactory sf;

    public void setSf(SessionFactory sf) {
        this.sf = sf;
    }

    @Transactional(propagation = Propagation.MANDATORY)
    @Override
    public void createComment(Comment comment) {
        sf.getCurrentSession().save(comment);
    }

    @Transactional(propagation = Propagation.MANDATORY)
    @Override
    public void updateComment(Comment comment) {
        sf.getCurrentSession().saveOrUpdate(comment);
    }

    @Transactional(propagation = Propagation.MANDATORY)
    @Override
    public void removeComment(Comment comment) {
        sf.getCurrentSession().delete(comment);
    }

    @Transactional(propagation = Propagation.SUPPORTS)
    @Override
    public Comment getComment(int commentid) {
        Comment comment = (Comment) sf.getCurrentSession().get(Comment.class, commentid);
        return comment;
    }

    @Transactional(propagation = Propagation.SUPPORTS)
    @Override
    public List<Comment> getAllComments() {

        Query query = sf.getCurrentSession().createQuery("from Comment");
        List<Comment> comments = query.list();
        return comments;
    }

    @Override
    public List<Comment> getAllPostComments(Post post) {
        Query query = sf.getCurrentSession()
                .createQuery("select c from Comment c where c.parentPost=:ppost AND c.approved=TRUE");
        query.setParameter("ppost", post);
        return query.list();
    }

}