com.chevres.rss.restapi.dao.impl.FeedDAOImpl.java Source code

Introduction

Here is the source code for com.chevres.rss.restapi.dao.impl.FeedDAOImpl.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 com.chevres.rss.restapi.dao.impl;

import com.chevres.rss.restapi.dao.FeedDAO;
import com.chevres.rss.restapi.model.Article;
import com.chevres.rss.restapi.model.ArticleState;
import com.chevres.rss.restapi.model.Feed;
import com.chevres.rss.restapi.model.User;
import com.chevres.rss.restapi.model.UserAuth;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Restrictions;

/**
 *
 * @author anthony
 */
public class FeedDAOImpl extends AbstractGenericDAO implements FeedDAO {

    @Override
    public boolean doesExist(UserAuth userAuth, String url) {
        Feed feed;
        Session session = this.getSessionFactory().openSession();

        try {
            Criteria criteria = session.createCriteria(Feed.class);
            feed = (Feed) criteria.add(Restrictions.eq("url", url))
                    .add(Restrictions.eq("idUser", userAuth.getIdUser())).uniqueResult();
        } catch (Exception e) {
            throw e;
        } finally {
            session.close();
        }
        return feed != null;
    }

    @Override
    public void removeAllForUser(User user) {
        List<Feed> feeds;
        Session session = this.getSessionFactory().openSession();
        Transaction tx;
        try {
            String id = Integer.toString(user.getId());
            tx = session.beginTransaction();
            Criteria criteria = session.createCriteria(Feed.class);
            feeds = criteria.add(Restrictions.eq("idUser", user.getId())).list();
            tx.commit();

            for (Feed feed : feeds) {
                tx = session.beginTransaction();
                String hql_feeds = "delete from Article where id_feed= :feedId";
                session.createQuery(hql_feeds).setString("feedId", Integer.toString(feed.getId())).executeUpdate();
                tx.commit();
            }

            tx = session.beginTransaction();
            String hql_feeds = "delete from Feed where id_user= :userId";
            session.createQuery(hql_feeds).setString("userId", id).executeUpdate();
            tx.commit();
        } catch (Exception e) {
            throw e;
        } finally {
            session.close();
        }
    }

    @Override
    public List<Feed> findAll(UserAuth userAuth) {
        List<Feed> feeds;
        Session session = this.getSessionFactory().openSession();
        Transaction tx;
        try {
            tx = session.beginTransaction();
            Criteria criteria = session.createCriteria(Feed.class);
            feeds = criteria.add(Restrictions.eq("idUser", userAuth.getIdUser())).list();
            tx.commit();
        } catch (Exception e) {
            throw e;
        } finally {
            session.close();
        }
        return feeds;
    }

    @Override
    public List<Feed> findAll() {
        List<Feed> feeds;
        Session session = this.getSessionFactory().openSession();
        Transaction tx;
        try {
            tx = session.beginTransaction();
            Criteria criteria = session.createCriteria(Feed.class);
            feeds = criteria.list();
            tx.commit();
        } catch (Exception e) {
            throw e;
        } finally {
            session.close();
        }
        return feeds;
    }

    @Override
    public Feed findById(UserAuth userAuth, int id) {
        Feed f;
        Session session = this.getSessionFactory().openSession();
        Transaction tx;
        try {
            tx = session.beginTransaction();
            Criteria criteria = session.createCriteria(Feed.class);
            f = (Feed) criteria.add(Restrictions.eq("idUser", userAuth.getIdUser())).add(Restrictions.eq("id", id))
                    .uniqueResult();
            tx.commit();
        } catch (Exception e) {
            throw e;
        } finally {
            session.close();
        }
        return f;
    }

    @Override
    public Feed findById(int id) {
        Feed f;
        Session session = this.getSessionFactory().openSession();
        Transaction tx;
        try {
            tx = session.beginTransaction();
            Criteria criteria = session.createCriteria(Feed.class);
            f = (Feed) criteria.add(Restrictions.eq("id", id)).uniqueResult();
            tx.commit();
        } catch (Exception e) {
            throw e;
        } finally {
            session.close();
        }
        return f;
    }

    @Override
    public void updateName(Feed oldFeed, Feed newFeed) {
        Session session = this.getSessionFactory().openSession();
        Transaction tx;
        try {
            tx = session.beginTransaction();
            oldFeed.setName(newFeed.getName());

            session.update(oldFeed);
            tx.commit();
        } catch (Exception e) {
            throw e;
        } finally {
            session.close();
        }
    }

    @Override
    public void updateRefreshError(Feed feed, boolean refreshError) {
        Session session = this.getSessionFactory().openSession();
        Transaction tx;
        try {
            tx = session.beginTransaction();
            feed.setRefreshError(refreshError);

            session.update(feed);
            tx.commit();
        } catch (Exception e) {
            throw e;
        } finally {
            session.close();
        }
    }

    @Override
    public int getNewArticles(List<Feed> feeds, ArticleState newState) {
        int newArticles;
        Session session = this.getSessionFactory().openSession();
        Transaction tx;
        try {
            tx = session.beginTransaction();

            Criteria criteria = session.createCriteria(Article.class);
            newArticles = criteria.add(Restrictions.in("feed", feeds)).add(Restrictions.eq("status", newState))
                    .list().size();

            tx.commit();
        } catch (Exception e) {
            throw e;
        } finally {
            session.close();
        }
        return newArticles;
    }

    @Override
    public int getNewArticlesByFeed(Feed feed, ArticleState newState) {
        int newArticles;
        Session session = this.getSessionFactory().openSession();
        Transaction tx;
        try {
            tx = session.beginTransaction();

            Criteria criteria = session.createCriteria(Article.class);
            newArticles = criteria.add(Restrictions.eq("feed", feed)).add(Restrictions.eq("status", newState))
                    .list().size();

            tx.commit();
        } catch (Exception e) {
            throw e;
        } finally {
            session.close();
        }
        return newArticles;
    }

    @Override
    public void deleteArticles(Feed feed) {
        Session session = this.getSessionFactory().openSession();
        Transaction tx;
        try {
            tx = session.beginTransaction();
            String hql = "delete Article where feed = :feedObject";
            Query query = session.createQuery(hql);
            query.setParameter("feedObject", feed);
            query.executeUpdate();

            tx.commit();
        } catch (Exception e) {
            throw e;
        } finally {
            session.close();
        }
    }
}