net.longfalcon.newsj.persistence.hibernate.PartRepairDAOImpl.java Source code

Introduction

Here is the source code for net.longfalcon.newsj.persistence.hibernate.PartRepairDAOImpl.java

Source

/*
 * Copyright (c) 2016. Sten Martinez
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License along
 * with this program; if not, write to the Free Software Foundation, Inc.,
 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
 */

package net.longfalcon.newsj.persistence.hibernate;

import net.longfalcon.newsj.model.PartRepair;
import org.hibernate.Criteria;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Isolation;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

import java.util.Collection;
import java.util.List;

/**
 * User: Sten Martinez
 * Date: 10/8/15
 * Time: 8:40 AM
 */
@Repository
public class PartRepairDAOImpl extends HibernateDAOImpl implements net.longfalcon.newsj.persistence.PartRepairDAO {

    @Override
    @Transactional
    public void updatePartRepair(PartRepair partRepair) {
        this.sessionFactory.getCurrentSession().saveOrUpdate(partRepair);
        //this.sessionFactory.getCurrentSession().flush();
    }

    @Override
    @Transactional
    public void deletePartRepair(PartRepair partRepair) {
        this.sessionFactory.getCurrentSession().delete(partRepair);
        //this.sessionFactory.getCurrentSession().flush();
    }

    @Override
    @Transactional(readOnly = true, propagation = Propagation.SUPPORTS)
    public PartRepair findByArticleNumberAndGroupId(long articleNumber, long groupId) {
        Criteria criteria = sessionFactory.getCurrentSession().createCriteria(PartRepair.class)
                .add(Restrictions.eq("numberId", articleNumber)).add(Restrictions.eq("groupId", groupId));
        return (PartRepair) criteria.uniqueResult();
    }

    /**
     * Find by group id and how many attempts its had
     * @param groupId groupid foreign key
     * @param attempts the number of attempts to look for
     * @param lessThan whether the comparison is less than the attempts or greater than or equal to
     * @return
     */
    @Override
    @Transactional(readOnly = true, propagation = Propagation.SUPPORTS)
    public List<PartRepair> findByGroupIdAndAttempts(long groupId, int attempts, boolean lessThan) {
        Criteria criteria = sessionFactory.getCurrentSession().createCriteria(PartRepair.class)
                .add(Restrictions.eq("groupId", groupId))
                .add(lessThan ? Restrictions.lt("attempts", attempts) : Restrictions.ge("attempts", attempts))
                .addOrder(Order.asc("numberId")).setMaxResults(30000);

        return criteria.list();
    }

    @Override
    @Transactional(readOnly = true, propagation = Propagation.SUPPORTS)
    public List<PartRepair> findByGroupIdAndNumbers(long groupId, Collection<Long> numbers) {
        Criteria criteria = sessionFactory.getCurrentSession().createCriteria(PartRepair.class)
                .add(Restrictions.eq("groupId", groupId)).add(Restrictions.in("numberId", numbers))
                .addOrder(Order.asc("numberId"));
        return criteria.list();
    }

}