org.alienlabs.hatchetharry.persistence.dao.GameDaoImpl.java Source code

Introduction

Here is the source code for org.alienlabs.hatchetharry.persistence.dao.GameDaoImpl.java

Source

/*
 * $Id: GameDaoImpl.java 1056 2006-10-27 22:49:28Z ivaynberg $
 * $Revision: 1056 $
 * $Date: 2006-10-27 15:49:28 -0700 (Fri, 27 Oct 2006) $
 *
 * ==============================================================================
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not
 * use this file except in compliance with the License. You may obtain a copy of
 * the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations under
 * the License.
 */
package org.alienlabs.hatchetharry.persistence.dao;

import java.util.List;

import org.alienlabs.hatchetharry.model.Game;
import org.apache.wicket.spring.injection.annot.SpringBean;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Required;
import org.springframework.transaction.annotation.Isolation;
import org.springframework.transaction.annotation.Transactional;

/**
 * implements {@link GameDao}.
 * 
 * @author igor
 */
public class GameDaoImpl implements GameDao {
    private static final long serialVersionUID = 1L;

    @SpringBean
    private SessionFactory factory;

    public GameDaoImpl() {
    }

    /**
     * Setter for session factory. Spring will use this to inject the session
     * factory into the dao.
     * 
     * @param _factory
     *            hibernate session factory
     */
    @Required
    public void setSessionFactory(final SessionFactory _factory) {
        this.factory = _factory;
    }

    /**
     * Helper method for retrieving hibernate session
     * 
     * @return hibernate session
     */
    @Override
    public Session getSession() {
        return this.factory.getCurrentSession();
    }

    /**
     * Load a {@link Game} from the DB, given it's <tt>id</tt> .
     * 
     * @param id
     *            The id of the Game to load.
     * @return Game
     */
    @Override
    @Transactional(readOnly = true)
    public Game load(final long id) {
        return (Game) this.getSession().get(Game.class, Long.valueOf(id));
    }

    /**
     * Save the Game to the DB
     * 
     * @param game
     * @return persistent instance of Game
     */
    @Override
    @Transactional(isolation = Isolation.READ_COMMITTED)
    public Game save(final Game game) {
        return (Game) this.getSession().merge(game);
    }

    /**
     * Delete a {@link Game} from the DB, given it's <tt>id</tt>.
     * 
     * @param id
     *            The id of the Game to delete.
     */
    @Override
    @Transactional(isolation = Isolation.READ_COMMITTED)
    public void delete(final long id) {
        this.getSession().delete(this.load(id));
    }

    /**
     * Returns a list of unique last names
     */
    @Override
    @Transactional(readOnly = true)
    public List<String> getUniqueLastNames() {
        return this.getSession()
                .createQuery("select distinct target.lastname " + " from Game target order by target.lastname")
                .list();
    }

    /**
     * Return the number of Games in the DB.
     * 
     * @return count
     */
    @Override
    @Transactional(readOnly = true)
    public int count() {
        return this.getSession().createQuery("select distinct target.id " + " from Game target order by target.id")
                .list().size();
    }
}