net.chrissearle.flickrvote.dao.JpaPhotographyDao.java Source code

Introduction

Here is the source code for net.chrissearle.flickrvote.dao.JpaPhotographyDao.java

Source

/*
 * Copyright 2010 Chris Searle
 *
 *    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 net.chrissearle.flickrvote.dao;

import net.chrissearle.common.jpa.JpaDao;
import net.chrissearle.flickrvote.model.Photographer;
import org.springframework.stereotype.Repository;

import javax.persistence.NoResultException;
import javax.persistence.Query;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 * Class JpaPhotographyDao implements PhotographyDao using JPA
 *
 * @author chris
 */
@Repository("photographyDao")
public class JpaPhotographyDao extends JpaDao<String, Photographer> implements PhotographyDao {
    private Logger log = Logger.getLogger(JpaPhotographyDao.class.getName());

    /**
     * Method findByUsername finds the photographer with the given username. Null if none found.
     *
     * @param username of type String
     * @return Photographer
     */
    public Photographer findByUsername(String username) {
        if (log.isLoggable(Level.FINE)) {
            log.fine("findByUsername : " + username);
        }

        Query query = entityManager.createQuery("select p from Photographer p where p.username = :username");
        query.setParameter("username", username);

        try {
            return (Photographer) query.getSingleResult();
        } catch (NoResultException e) {
            if (log.isLoggable(Level.FINE)) {
                log.fine("No matching user found");
            }

            // Just means that there is no photographer yet present
            return null;
        }
    }

    /**
     * Method persist saves the photographer if new, updates fullname and token if existing.
     *
     * @param photographer of type Photographer
     */
    @Override
    public void persist(Photographer photographer) {
        Photographer p = findByUsername(photographer.getUsername());

        if (p != null) {
            p.setFullname(photographer.getFullname());

            if (photographer.getId() != null) {
                p.setAdministrator(photographer.isAdministrator());
            }

            photographer = p;
        }

        super.persist(photographer);
    }

    /**
     * Method clearVotes removes all votes from the entire system.
     */
    public void clearVotes() {
        Query query = entityManager.createQuery("DELETE FROM Vote v");
        query.executeUpdate();
    }

    /**
     * Method all returns all photographers
     *
     * @return List<Photographer>
     */
    @SuppressWarnings("unchecked")
    public List<Photographer> all() {
        Query query = entityManager.createQuery("SELECT p FROM Photographer p");

        return (List<Photographer>) query.getResultList();
    }

    @SuppressWarnings("unchecked")
    public List<Photographer> getAdmins() {
        Query query = entityManager.createQuery("SELECT p FROM Photographer p WHERE p.administrator = TRUE");

        return (List<Photographer>) query.getResultList();
    }
}