Java tutorial
/** * 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.virtualappliance.hibernate; import java.util.Collection; import java.util.List; import org.hibernate.Query; import com.abiquo.abiserver.business.hibernate.pojohb.virtualappliance.VirtualApplianceConversionsHB; import com.abiquo.abiserver.business.hibernate.pojohb.virtualappliance.VirtualappHB; import com.abiquo.abiserver.persistence.dao.virtualappliance.VirtualApplianceConversionsDAO; import com.abiquo.abiserver.persistence.hibernate.HibernateDAO; /** * Class that implements the extra DAO functions for the * {@link com.abiquo.abiserver.persistence.dao.virtualappliance.VirtualApplianceConversionsDAO} * interface * * @author dcalavera@abiquo.com */ public class VirtualApplianceConversionsDAOHibernate extends HibernateDAO<VirtualApplianceConversionsHB, Integer> implements VirtualApplianceConversionsDAO { @Override public List<VirtualApplianceConversionsHB> findByConversion(final int idConversion) { Query query = getSession().createQuery( "from com.abiquo.abiserver.business.hibernate.pojohb.virtualappliance.VirtualApplianceConversionsHB where virtualImageConversion.id = :id"); query.setParameter("id", idConversion); return query.list(); } @Override public Collection<VirtualappHB> findByPendingAppliances(final int idPending, final Collection<Integer> appliances) { return getSession().createQuery( "select va from VirtualappExtendedHB va, com.abiquo.abiserver.business.hibernate.pojohb.virtualappliance.VirtualApplianceConversionsHB vac where va.idVirtualApp = vac.virtualAppliance.id and vac.virtualAppliance.id in (:appliances) and vac.id != :idPending") .setParameterList("appliances", appliances).setParameter("idPending", idPending).list(); } @Override public void makeTransientByVirtualAppliance(final int idVirtualAppliance) { getSession().createQuery( "delete com.abiquo.abiserver.business.hibernate.pojohb.virtualappliance.VirtualApplianceConversionsHB vac where vac.virtualAppliance.id = :idAppliance") .setParameter("idAppliance", idVirtualAppliance).executeUpdate(); } @Override public String findDatacenterUUIDByVASConversion(final int idVASC) { Query query = getSession().createSQLQuery( "select distinct(dc.uuid) from vappstateful_conversions vasc left outer join virtualapp va on vasc.idVirtualApp = va.idVirtualApp left outer join virtualdatacenter vdc on va.idVirtualDataCenter = vdc.idVirtualdataCenter left outer join datacenter dc on vdc.idDatacenter = dc.idDataCenter where vasc.id = :id"); query.setParameter("id", idVASC); return (String) query.uniqueResult(); } }