/**
* 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.infrastructure.hibernate;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import com.abiquo.abiserver.business.hibernate.pojohb.infrastructure.PhysicalmachineHB;
import com.abiquo.abiserver.business.hibernate.pojohb.user.EnterpriseHB;
import com.abiquo.abiserver.business.hibernate.pojohb.virtualappliance.VirtualmachineHB;
import com.abiquo.abiserver.exception.PersistenceException;
import com.abiquo.abiserver.persistence.dao.infrastructure.PhysicalMachineDAO;
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.infrastructure.PhysicalMachineDAO} interface
*
* @author jdevesa@abiquo.com
*/
public class PhysicalMachineDAOHibernate extends HibernateDAO<PhysicalmachineHB, Integer> implements
PhysicalMachineDAO
{
private static final String PHYSICALMACHINE_GET_NUMBER_OF_DEPLOYED_MACHINES =
"PHYSICALMACHINE.GET_NUMBER_OF_DEPLOYED_MACHINES";
private static final String PHYSICALMACHINE_GET_DEPLOYED_VIRTUAL_MACHINES =
"PHYSICALMACHINE.GET_DEPLOYED_VIRTUAL_MACHINES";
private static final String PHYSICALMACHINE_GET_DEPLOYED_ABIQUO_VIRTUAL_MACHINES =
"PHYSICALMACHINE.GET_DEPLOYED_ABIQUO_VIRTUAL_MACHINES";
private static final String PHYSICALMACHINE_GET_HYPERVISOR_IP =
"PHYSICALMACHINE.GET_HYPERVISOR_IP";
private static final String PHYSICALMACHINE_GET_FROM_IP = "PHYSICALMACHINE.GET_FROM_IP";
private static final String PHYSICALMACHINE_GET_ALL_HYPERVISOR_IP =
"PHYSICALMACHINE.GET_ALL_HYPERVISOR_IP";
private static final String PHYSICALMACHINE_GET_NOT_MANAGED_VIRTUAL_MACHINES =
"PHYSICALMACHINE.GET_NOT_MANAGED_VIRTUAL_MACHINES";
private static final String PHYSICALMACHINE_GET_LIST_BY_DATASTORE =
"PHYSICALMACHINE.GET_LIST_BY_DATASTORE";
private static final String PHYSICALMACHINE_GET_LIST_BY_RACK =
"PHYSICALMACHINE.GET_LIST_BY_RACK";
private static final String FIRST_PASS_QUERY = "PHYSICALMACHINE.FIRST_PASS_QUERY";
private static final String PHYSICALMACHINE_GET_NUMBER_OF_DEPLOYED_MACHINES_OWNED_BY_OTHER_ENTERPRISE =
"PHYSICALMACHINE.GET_NUMBER_OF_DEPLOYED_MACHINES_OWNED_BY_OTHER_ENTERPRISE";
@Override
public List<PhysicalmachineHB> getByRackAndVirtualDatacenter(final Integer idRack,
final Integer idVirtualDatacenter, final Long hdRequiredOnDatastore,
final EnterpriseHB enterprise)
{
// "(pm.ram - pm.ramUsed) >= " + vimage.getRamRequired() +
// " and (pm.cpu - pm.cpuUsed) >= " + vimage.getCpuRequired();
Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
Query pmQuery = session.getNamedQuery(FIRST_PASS_QUERY);
pmQuery.setInteger("idVirtualDataCenter", idVirtualDatacenter);
pmQuery.setInteger("idRack", idRack);
pmQuery.setLong("hdRequiredOnRepository", hdRequiredOnDatastore);
pmQuery.setParameter("enterprise", enterprise);
return pmQuery.list();
}
// implement extra functionality
@Override
public Long getNumberOfDeployedVirtualMachines(final PhysicalmachineHB pmHB)
{
Long numberOfDeployedMachines;
Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
Query pmQuery = session.getNamedQuery(PHYSICALMACHINE_GET_NUMBER_OF_DEPLOYED_MACHINES);
pmQuery.setInteger("idphysicalmachine", pmHB.getIdPhysicalMachine());
numberOfDeployedMachines = (Long) pmQuery.uniqueResult();
return numberOfDeployedMachines;
}
@Override
public Long getNumberOfDeployedVirtualMachinesOwnedByOtherEnterprise(
final PhysicalmachineHB pmHB, final Integer idEnterprise)
{
Long numberOfDeployedMachines;
Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
Query pmQuery =
session
.getNamedQuery(PHYSICALMACHINE_GET_NUMBER_OF_DEPLOYED_MACHINES_OWNED_BY_OTHER_ENTERPRISE);
pmQuery.setInteger("idphysicalmachine", pmHB.getIdPhysicalMachine());
pmQuery.setInteger("identerprise", idEnterprise);
List<Long> longList = pmQuery.list();
numberOfDeployedMachines = longList.get(0);
return numberOfDeployedMachines;
}
@Override
public List<VirtualmachineHB> getDeployedVirtualMachines(final Integer machineId)
{
Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
Query pmQuery = session.getNamedQuery(PHYSICALMACHINE_GET_DEPLOYED_VIRTUAL_MACHINES);
pmQuery.setInteger("idphysicalmachine", machineId);
return pmQuery.list();
}
@Override
public List<VirtualmachineHB> getDeployedAbiquoVirtualMachines(final Integer machineId)
{
Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
Query pmQuery = session.getNamedQuery(PHYSICALMACHINE_GET_DEPLOYED_ABIQUO_VIRTUAL_MACHINES);
pmQuery.setInteger("idphysicalmachine", machineId);
return pmQuery.list();
}
@Override
public String getHypervisorIP(final int machineId)
{
Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
Query pmQuery = session.getNamedQuery(PHYSICALMACHINE_GET_HYPERVISOR_IP);
pmQuery.setInteger("idphysicalmachine", machineId);
String hyperIp = (String) pmQuery.uniqueResult();
return hyperIp;
}
@Override
public void setPhysicalMachineState(final Integer machineId, final int idPhysicalMachineState)
throws PersistenceException
{
PhysicalmachineHB pm = findById(machineId);
pm.setIdState(idPhysicalMachineState);
makePersistent(pm);
}
@Override
public PhysicalmachineHB findByIp(final String hypervisorIp, final Integer idDataCenter)
{
Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
Query pmQuery = session.getNamedQuery(PHYSICALMACHINE_GET_FROM_IP);
pmQuery.setString("ipPhysicalMachine", hypervisorIp);
pmQuery.setInteger("idDataCenter", idDataCenter);
PhysicalmachineHB pm = (PhysicalmachineHB) pmQuery.uniqueResult();
return pm;
}
@Override
public List<String> findAllIp()
{
Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
Query pmQuery = session.getNamedQuery(PHYSICALMACHINE_GET_ALL_HYPERVISOR_IP);
return pmQuery.list();
}
@Override
public List<VirtualmachineHB> getNotDeployedVirtualMachines(final Integer hostId)
{
Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
Query pmQuery = session.getNamedQuery(PHYSICALMACHINE_GET_NOT_MANAGED_VIRTUAL_MACHINES);
pmQuery.setInteger("idphysicalmachine", hostId);
return pmQuery.list();
}
@Override
public List<PhysicalmachineHB> getPhysicalMachineListByDatastore(final Integer datastoreId)
{
Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
Query pmQuery = session.getNamedQuery(PHYSICALMACHINE_GET_LIST_BY_DATASTORE);
pmQuery.setInteger("idDatastore", datastoreId);
return pmQuery.list();
}
@Override
public List<PhysicalmachineHB> getPhysicalMachineByRack(final Integer rackId,
final String filters)
{
Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
String namedQuery =
filters == null || filters.isEmpty() ? PHYSICALMACHINE_GET_LIST_BY_RACK
: "PHYSICALMACHINE.GET_LIST_BY_RACK_AND_ENTERPRISE";
Query pmQuery = session.getNamedQuery(namedQuery);
pmQuery.setInteger("idRack", rackId);
if (filters != null && !filters.isEmpty())
{
pmQuery.setString("filterLike", "%" + filters + "%");
}
return pmQuery.list();
}
@Override
public void updateUsedResourcesByPhysicalMachine(final Integer idPhysicalMachine)
{
final Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
final String update =
"update physicalmachine p, "
+ "(SELECT hy.idPhysicalMachine, IFNULL(SUM(vm.ram),0) ram, IFNULL(SUM(vm.cpu),0) cpu"
+ "FROM virtualmachine vm right join hypervisor hy on vm.idHypervisor = hy.id, "
+ "physicalmachine pm "
+ "WHERE (vm.state is null or vm.state != 'NOT_DEPLOYED') AND pm.idPhysicalMachine = hy.idPhysicalMachine "
+ "AND pm.idPhysicalMachine = :idPhysicalMachine "
+ "group by hy.idPhysicalMachine) x "
+ "set p.ramused = x.ram, p.cpuused = x.cpu where p.idPhysicalMachine = x.idPhysicalMachine ";
final Query pmQuery = session.createSQLQuery(update);
pmQuery.setInteger("idPhysicalMachine", idPhysicalMachine);
pmQuery.executeUpdate();
}
}