/**
* Abiquo community edition
* cloud management application for hybrid clouds
* Copyright (C) 2008-2010 - Abiquo Holdings S.L.
*
* This application is free software; you can redistribute it and/or
* modify it under the terms of the GNU LESSER GENERAL PUBLIC
* LICENSE as published by the Free Software Foundation under
* version 3 of the License
*
* This software 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
* LESSER GENERAL PUBLIC LICENSE v.3 for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the
* Free Software Foundation, Inc., 59 Temple Place - Suite 330,
* Boston, MA 02111-1307, USA.
*/
package com.abiquo.abiserver.persistence.dao.virtualimage.hibernate;
import java.util.Collection;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import com.abiquo.abiserver.business.hibernate.pojohb.user.UserHB;
import com.abiquo.abiserver.business.hibernate.pojohb.virtualimage.VirtualimageHB;
import com.abiquo.abiserver.persistence.dao.user.UserDAO;
import com.abiquo.abiserver.persistence.dao.virtualimage.VirtualImageDAO;
import com.abiquo.abiserver.persistence.hibernate.HibernateDAO;
import com.abiquo.abiserver.persistence.hibernate.HibernateDAOFactory;
/**
* Class that implements the extra DAO functions for the
* {@link com.abiquo.abiserver.persistence.dao.virtualimage.VirtualImageDAO} interface
*
* @author jdevesa@abiquo.com
*/
public class VirtualImageDAOHibernate extends HibernateDAO<VirtualimageHB, Integer> implements
VirtualImageDAO
{
/** Get images by user query. */
private static final String GET_VIRTUAL_IMAGES_BY_USER_QUERY = "GET_VIRTUAL_IMAGES_BY_USER";
private static final String GET_VIRTUAL_IMAGES_BY_ENTR_AND_REPO_AND_CATE_QUERY =
"GET_VIRTUAL_IMAGES_BY_ENTER_AND_REPOSITORY_AND_CATEGORY";
/** Get images by user and stateful query. */
private static final String GET_VIRTUAL_IMAGES_BY_USER_AND_STATEFUL_QUERY =
"GET_VIRTUAL_IMAGES_BY_USER_AND_STATEFUL";
private static final String GET_VIRTUAL_IMAGES_BY_ENTR_AND_REPO =
"GET_VIRTUAL_IMAGES_BY_ENTER_AND_REPOSITORY";
private static final String GET_VIRTUAL_IMAGES_BY_REPOSITORY_QUERY =
"GET_VIRTUAL_IMAGES_BY_REPOSITORY";
@Override
@SuppressWarnings("unchecked")
public Collection<VirtualimageHB> getImagesFromPath(Collection<String> paths)
{
return getSession()
.createQuery(
"FROM com.abiquo.abiserver.business.hibernate.pojohb.virtualimage.VirtualimageHB "
+ "WHERE pathName in (:pathName)").setParameterList("pathName", paths).list();
}
@Override
public Collection<VirtualimageHB> findByCategory(Integer idCategory)
{
return getSession()
.createQuery(
"FROM com.abiquo.abiserver.business.hibernate.pojohb.virtualimage.VirtualimageHB "
+ "WHERE category.idCategory = :idCategory")
.setParameter("idCategory", idCategory).list();
}
@Override
public Collection<VirtualimageHB> findByIcon(final Integer idIcon)
{
return getSession()
.createQuery(
"FROM com.abiquo.abiserver.business.hibernate.pojohb.virtualimage.VirtualimageHB "
+ "WHERE icon.idIcon = :idIcon").setParameter("idIcon", idIcon).list();
}
@Override
public Collection<VirtualimageHB> getImagesByUser(String username)
{
Map<String, String> params = new HashMap<String, String>();
params.put("username", username);
return findByNamedQuery(GET_VIRTUAL_IMAGES_BY_USER_QUERY, params);
}
@Override
public Collection<VirtualimageHB> getImagesByUserAndRepositoryAndCategory(String username,
Integer idRepository, Integer idCategory)
{
UserDAO userdao = HibernateDAOFactory.instance().getUserDAO();
UserHB user = userdao.getUserByUserName(username);
Map<String, Integer> params = new HashMap<String, Integer>();
params.put("idEnterprise", user.getEnterpriseHB().getIdEnterprise());
params.put("idRepository", idRepository);
params.put("idCategory", idCategory);
return findByNamedQuery(GET_VIRTUAL_IMAGES_BY_ENTR_AND_REPO_AND_CATE_QUERY, params);
}
@Override
public List<VirtualimageHB> getImagesByEnterpriseAndRepositoryAndCategory(Integer idEnterprise,
Integer idRepository, Integer idCategory)
{
Map<String, Integer> params = new HashMap<String, Integer>();
params.put("idEnterprise", idEnterprise);
params.put("idRepository", idRepository);
params.put("idCategory", idCategory);
return findByNamedQuery(GET_VIRTUAL_IMAGES_BY_ENTR_AND_REPO_AND_CATE_QUERY, params);
}
@Override
public List<VirtualimageHB> getImagesByEnterpriseAndRepository(final Integer idEnterprise,
final Integer idRepository)
{
Map<String, Integer> params = new HashMap<String, Integer>();
params.put("idEnterprise", idEnterprise);
params.put("idRepository", idRepository);
return findByNamedQuery(GET_VIRTUAL_IMAGES_BY_ENTR_AND_REPO, params);
}
@Override
public List<VirtualimageHB> getImagesByRepository(final Integer idRepository)
{
Map<String, Integer> params = new HashMap<String, Integer>();
params.put("idRepository", idRepository);
return findByNamedQuery(GET_VIRTUAL_IMAGES_BY_REPOSITORY_QUERY, params);
}
@Override
public Collection<VirtualimageHB> getImagesByUser(String username, int stateful)
{
Map<String, Object> params = new HashMap<String, Object>();
params.put("username", username);
params.put("stateful", stateful);
return findByNamedQuery(GET_VIRTUAL_IMAGES_BY_USER_AND_STATEFUL_QUERY, params);
}
}