/**
* Copyright (C) 2008 - Abiquo Holdings S.L. All rights reserved.
*
* Please see /opt/abiquo/tomcat/webapps/legal/ on Abiquo server
* or contact contact@abiquo.com for licensing information.
*/
package com.abiquo.server.core.infrastructure.network;
import java.util.List;
import javax.persistence.EntityManager;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.criterion.Criterion;
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Repository;
import com.abiquo.server.core.cloud.VirtualDatacenter;
import com.abiquo.server.core.common.persistence.DefaultDAOBase;
import com.abiquo.server.core.infrastructure.Rack;
@Repository("jpaNetworkAssignmentDAO")
public class NetworkAssignmentDAO extends DefaultDAOBase<Integer, NetworkAssignment>
{
private final static String SQL_RACK_IDS_BY_MIN_VLAN_COUNT = //
//
"SELECT rack_filtered_dc.idRack FROM "
+ //
"(SELECT r.idRack, r.idDatacenter, r.vlan_id_min, r.vlan_id_max, r.vlan_per_vdc_expected, r.nrsq, count(vn.id) as vlans_used "
+ //
"FROM rack r LEFT JOIN vlan_network_assignment vn ON r.idRack = vn.idRack GROUP BY r.idRack ) as rack_filtered_dc "
+ //
"WHERE rack_filtered_dc.idDataCenter = :idDatacenter AND rack_filtered_dc.vlans_used + rack_filtered_dc.vlan_per_vdc_expected + (((rack_filtered_dc.vlan_id_max - rack_filtered_dc.vlan_id_min +1 ) * (rack_filtered_dc.nrsq)) / 100) <= ((rack_filtered_dc.vlan_id_max - rack_filtered_dc.vlan_id_min) + 1) "
+ //
"ORDER BY rack_filtered_dc.vlans_used + rack_filtered_dc.vlan_per_vdc_expected ASC";
private final static String VDC_BY_RACK =
"SELECT DISTINCT vdc FROM NetworkAssignment na INNER JOIN na.virtualDatacenter vdc WHERE na.rack.id = :rackId";
public NetworkAssignmentDAO()
{
super(NetworkAssignment.class);
}
public NetworkAssignmentDAO(final EntityManager entityManager)
{
super(NetworkAssignment.class, entityManager);
}
public List<NetworkAssignment> findByVirtualDatacenter(final VirtualDatacenter virtualDatacenter)
{
Criteria criteria = getSession().createCriteria(NetworkAssignment.class);
Criterion onVdc =
Restrictions.eq(NetworkAssignment.VIRTUAL_DATACENTER_PROPERTY, virtualDatacenter);
criteria.add(onVdc);
// criteria.addOrder(Order.asc(VirtualDatacenter.NAME_PROPERTY));
List<NetworkAssignment> result = criteria.list();
return result;
}
public NetworkAssignment findByVlanNetwork(final VLANNetwork vlanNetwork)
{
Criteria criteria = getSession().createCriteria(NetworkAssignment.class);
Criterion onVlanNetwork =
Restrictions.eq(NetworkAssignment.VLAN_NETWORK_PROPERTY, vlanNetwork);
criteria.add(onVlanNetwork);
List<NetworkAssignment> hbs = getResultList(criteria);
if (hbs.size() > 0)
{
return hbs.get(0);
}
else
{
return null;
}
}
/**
* Return all the virtualdatacenters deployed in a rack.
*
* @param rack
* @return all the found entities
*/
@SuppressWarnings("unchecked")
public List<VirtualDatacenter> findVirtualDatacenterByRack(final Rack rack)
{
Query query = getSession().createQuery(VDC_BY_RACK);
query.setInteger("rackId", rack.getId());
return query.list();
}
}