net.jforum.repository.TopicDao.java Source code

Introduction

Here is the source code for net.jforum.repository.TopicDao.java

Source

/*
 * Copyright (c) JForum Team. All rights reserved.
 *
 * The software in this package is published under the terms of the LGPL
 * license a copy of which has been included with this distribution in the
 * license.txt file.
 *
 * The JForum Project
 * http://www.jforum.net
 */
package net.jforum.repository;

import net.jforum.entities.Post;
import net.jforum.entities.Topic;
import org.hibernate.Session;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.hibernate.criterion.Subqueries;
import org.springframework.stereotype.Repository;

import java.util.Arrays;
import java.util.List;

/**
 * @author Rafael Steil
 */
@Repository
public class TopicDao extends HibernateGenericDAO<Topic> implements Dao<Topic> {
    public TopicDao(Session session) {
        super(session);
    }

    @Override
    @SuppressWarnings("unchecked")
    public void remove(Topic entity) {
        List<Integer> users = session.createQuery("select p.user.id from Post p where p.topic = :topic")
                .setParameter("topic", entity).list();

        if (users.size() == 0) {
            // If no users were found, it means that all posts were already deleted,
            // probably by post delete instead of topic delete. In such case, consider
            // that the user whe should decrement from is the one who created the topic
            users = Arrays.asList(entity.getUser().getId());
        }

        session.createQuery("delete from Post where topic = :topic").setParameter("topic", entity).executeUpdate();

        session.createQuery("update User u set u.totalPosts = (select count(*) from Post p where p.user = u) "
                + "where u.id in (:users)").setParameterList("users", users).executeUpdate();

        super.remove(entity);
    }

    public Post getLastPost(Topic topic) {
        DetachedCriteria lastPost = DetachedCriteria.forClass(Post.class).setProjection(Projections.max("id"))
                .add(Restrictions.eq("topic", topic)).add(Restrictions.eq("moderate", false))
                .setComment("topicDAO.getLastPostID");

        return (Post) session.createCriteria(Post.class).add(Subqueries.propertyEq("id", lastPost))
                .setComment("topicDAO.getLastPost").uniqueResult();
    }

    public int getTotalPosts(Topic topic) {
        return (Integer) session.createCriteria(Post.class).setProjection(Projections.rowCount())
                .add(Restrictions.eq("topic", topic)).add(Restrictions.eq("moderate", false))
                .setComment("topicDAO.getTotalPosts").uniqueResult();
    }

    public Post getFirstPost(Topic topic) {
        DetachedCriteria firstPost = DetachedCriteria.forClass(Post.class).setProjection(Projections.min("id"))
                .add(Restrictions.eq("topic", topic)).setComment("topicDAO.getFirstPostID");

        return (Post) session.createCriteria(Post.class).add(Subqueries.propertyEq("id", firstPost))
                .setComment("topicDAO.getFirstPost").uniqueResult();
    }

    @SuppressWarnings("unchecked")
    public List<Post> getPosts(Topic topic, int startFrom, int count) {
        return session
                .createQuery("from Post p join fetch p.user user left join fetch user.avatar "
                        + " where p.topic = :topic and p.moderate = false order by p.date asc")
                .setParameter("topic", topic).setFirstResult(startFrom).setMaxResults(count)
                .setComment("topicDAO.getPosts").list();
    }
}