test_class.declarator: virtualDatacenterGenerator
test_class.modifier: private
test_class.original_string: private VirtualDatacenterGenerator virtualDatacenterGenerator;
test_class.type: VirtualDatacenterGenerator
test_class.var_name: virtualDatacenterGenerator
test_class.declarator: vlanNetworkGenerator
test_class.modifier: private
test_class.original_string: private VLANNetworkGenerator vlanNetworkGenerator;
test_class.type: VLANNetworkGenerator
test_class.var_name: vlanNetworkGenerator
test_class.file: model/src/test/java/com/abiquo/server/core/infrastructure/network/IpPoolManagementDAOTest.java
test_class.identifier: IpPoolManagementDAOTest
test_class.superclass: extends
      DefaultDAOTestBase<IpPoolManagementDAO, IpPoolManagement>
test_case.body: @Test
      public void findNextIpByPrivateVLANNotIpAvailableAnotherVlanNetwork()
      {
          List<Object> entities = new ArrayList<Object>();
  
          IpPoolManagement ipPoolManagement1 = eg().createUniqueInstance();
          ipPoolManagement1.setAvailable(Boolean.FALSE);
  
          VLANNetwork vlan1 = vlanNetworkGenerator.createUniqueInstance();
          ipPoolManagement1.setVlanNetwork(vlan1);
  
          vlanNetworkGenerator.addAuxiliaryEntitiesToPersist(vlan1, entities);
          eg().addAuxiliaryEntitiesToPersist(ipPoolManagement1, entities);
  
          IpPoolManagement ipPoolManagement2 = eg().createUniqueInstance();
          ipPoolManagement2.setAvailable(Boolean.FALSE);
  
          VLANNetwork vlan2 = vlanNetworkGenerator.createUniqueInstance();
          ipPoolManagement1.setVlanNetwork(vlan2);
  
          vlanNetworkGenerator.addAuxiliaryEntitiesToPersist(vlan2, entities);
          eg().addAuxiliaryEntitiesToPersist(ipPoolManagement2, entities);
  
          persistAll(ds(), entities, vlan1, vlan2, ipPoolManagement1, ipPoolManagement2);
  
          IpPoolManagementDAO dao = createDaoForRollbackTransaction();
          IpPoolManagement available =
              dao.findNextIpAvailable(vlan1.getId());
  
          Assert.assertNull(available);
      }
test_case.class_method_signature: IpPoolManagementDAOTest.findNextIpByPrivateVLANNotIpAvailableAnotherVlanNetwork()
test_case.full_signature: @Test public void findNextIpByPrivateVLANNotIpAvailableAnotherVlanNetwork()
test_case.identifier: findNextIpByPrivateVLANNotIpAvailableAnotherVlanNetwork
test_case.invocations: createUniqueInstance eg setAvailable createUniqueInstance setVlanNetwork addAuxiliaryEntitiesToPersist addAuxiliaryEntitiesToPersist eg createUniqueInstance eg setAvailable createUniqueInstance setVlanNetwork addAuxiliaryEntitiesToPersist addAuxiliaryEntitiesToPersist eg persistAll ds createDaoForRollbackTransaction findNextIpAvailable getId assertNull
test_case.modifiers: @Test public
test_case.parameters: ()
test_case.return: void
test_case.signature: void findNextIpByPrivateVLANNotIpAvailableAnotherVlanNetwork()
focal_class.declarator: BY_DATACENTER =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf, "
              // "INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualMachine vm LEFT JOIN ip.virtualAppliance vapp "
              + "LEFT JOIN ip.virtualDatacenter vdc LEFT JOIN vlan.enterprise ent "
              + "WHERE net.id = vlan.network.id "
              // +"AND dhcp.id = ip.dhcp.id"
              + "AND ip.vlanNetwork.id = vlan.id "
              + " AND dc.id = :datacenter_id AND "
              + "( ip.ip LIKE :filterLike OR ip.mac LIKE :filterLike OR ip.networkName LIKE :filterLike OR "
              + " vm.name like :filterLike OR vapp.name LIKE :filterLike OR ent.name LIKE :filterLike )"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_DATACENTER =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf, "
              // "INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualMachine vm LEFT JOIN ip.virtualAppliance vapp "
              + "LEFT JOIN ip.virtualDatacenter vdc LEFT JOIN vlan.enterprise ent "
              + "WHERE net.id = vlan.network.id "
              // +"AND dhcp.id = ip.dhcp.id"
              + "AND ip.vlanNetwork.id = vlan.id "
              + " AND dc.id = :datacenter_id AND "
              + "( ip.ip LIKE :filterLike OR ip.mac LIKE :filterLike OR ip.networkName LIKE :filterLike OR "
              + " vm.name like :filterLike OR vapp.name LIKE :filterLike OR ent.name LIKE :filterLike )";
focal_class.type: String
focal_class.var_name: BY_DATACENTER
focal_class.declarator: BY_DATACENTER_AND_ENTERPRISE =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf, "
              // "INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualMachine vm LEFT JOIN ip.virtualAppliance vapp "
              + "LEFT JOIN ip.virtualDatacenter vdc LEFT JOIN vlan.enterprise ent "
              + "WHERE net.id = vlan.network.id "
              // +"AND dhcp.id = ip.dhcp.id"
              + "AND ip.vlanNetwork.id = vlan.id "
              + " AND dc.id = :datacenter_id AND "
              + "( ip.ip LIKE :filterLike OR ip.mac LIKE :filterLike OR ip.networkName LIKE :filterLike OR "
              + " vm.name like :filterLike OR vapp.name LIKE :filterLike OR ent.name LIKE :filterLike )"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_DATACENTER_AND_ENTERPRISE =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf, "
              // "INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualMachine vm LEFT JOIN ip.virtualAppliance vapp "
              + "LEFT JOIN ip.virtualDatacenter vdc LEFT JOIN vlan.enterprise ent "
              + "WHERE net.id = vlan.network.id "
              // +"AND dhcp.id = ip.dhcp.id"
              + "AND ip.vlanNetwork.id = vlan.id "
              + " AND dc.id = :datacenter_id AND "
              + "( ip.ip LIKE :filterLike OR ip.mac LIKE :filterLike OR ip.networkName LIKE :filterLike OR "
              + " vm.name like :filterLike OR vapp.name LIKE :filterLike OR ent.name LIKE :filterLike )";
focal_class.type: String
focal_class.var_name: BY_DATACENTER_AND_ENTERPRISE
focal_class.declarator: BY_DEFAULT_VLAN_USED_BY_ANY_VDC =
          " SELECT ip FROM  virtualdatacenter vdc, ip_pool_management ip where "
              + "vdc.default_vlan_network_id=ip.vlan_network_id and vdc.default_vlan_network_id=:vlan_id"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_DEFAULT_VLAN_USED_BY_ANY_VDC =
          " SELECT ip FROM  virtualdatacenter vdc, ip_pool_management ip where "
              + "vdc.default_vlan_network_id=ip.vlan_network_id and vdc.default_vlan_network_id=:vlan_id";
focal_class.type: String
focal_class.var_name: BY_DEFAULT_VLAN_USED_BY_ANY_VDC
focal_class.declarator: BY_ENT =
          " SELECT ip FROM IpPoolManagement ip " + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp, "
              + " NetworkConfiguration nc, "
              + " VirtualDatacenter vdc, "
              + " VLANNetwork vn, "
              + " Enterprise ent "
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + "WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.network.id = vdc.network.id" + " AND vdc.enterprise.id = ent.id"
              + " AND ent.id = :ent_id " + " AND " + "( ip.ip like :filterLike "
              + " OR ip.mac like :filterLike " + " OR ip.vlanNetwork.name like :filterLike "
              + " OR vapp.name like :filterLike " + " OR vm.name like :filterLike " + ")"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_ENT =
          " SELECT ip FROM IpPoolManagement ip " + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp, "
              + " NetworkConfiguration nc, "
              + " VirtualDatacenter vdc, "
              + " VLANNetwork vn, "
              + " Enterprise ent "
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + "WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.network.id = vdc.network.id" + " AND vdc.enterprise.id = ent.id"
              + " AND ent.id = :ent_id " + " AND " + "( ip.ip like :filterLike "
              + " OR ip.mac like :filterLike " + " OR ip.vlanNetwork.name like :filterLike "
              + " OR vapp.name like :filterLike " + " OR vm.name like :filterLike " + ")";
focal_class.type: String
focal_class.var_name: BY_ENT
focal_class.declarator: BY_EXTERNAL_VLAN =
          "SELECT ip FROM IpPoolManagement ip "
              + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp "
              + " left join ip.virtualDatacenter vdc, "
              + " NetworkConfiguration nc, "
              + " VLANNetwork vn "
              + " join vn.enterprise ent, "
              + " DatacenterLimits dcl"
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + " WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.id = :vlan_id " + " AND ent.id = :ent_id AND "
              + " dcl.enterprise.id = ent.id AND " + " ip.available = 1 AND "
              + " dcl.id = :dc_limit_id AND " + "( ip.ip like :filterLike "
              + " OR ip.mac like :filterLike " + " OR ip.vlanNetwork.name like :filterLike "
              + " OR vapp.name like :filterLike " + " OR vm.name like :filterLike " + ")"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_EXTERNAL_VLAN =
          "SELECT ip FROM IpPoolManagement ip "
              + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp "
              + " left join ip.virtualDatacenter vdc, "
              + " NetworkConfiguration nc, "
              + " VLANNetwork vn "
              + " join vn.enterprise ent, "
              + " DatacenterLimits dcl"
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + " WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.id = :vlan_id " + " AND ent.id = :ent_id AND "
              + " dcl.enterprise.id = ent.id AND " + " ip.available = 1 AND "
              + " dcl.id = :dc_limit_id AND " + "( ip.ip like :filterLike "
              + " OR ip.mac like :filterLike " + " OR ip.vlanNetwork.name like :filterLike "
              + " OR vapp.name like :filterLike " + " OR vm.name like :filterLike " + ")";
focal_class.type: String
focal_class.var_name: BY_EXTERNAL_VLAN
focal_class.declarator: BY_IP_PURCHASED =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf,"
              // +" INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualMachine vm LEFT JOIN ip.virtualAppliance vapp, "
              + "VirtualDatacenter vdc LEFT JOIN vdc.enterprise ent "
              + "WHERE net.id = vlan.network.id "
              // +"AND dhcp.id = ip.dhcp.id "
              + "AND ip.vlanNetwork.id = vlan.id " + "AND vdc.id = :vdc_id AND "
              + "vdc.datacenter.id = dc.id AND ip.id = :ip_id AND "
              + "ip.available = 1 AND vlan.enterprise is null AND ip.virtualDatacenter.id = :vdc_id"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_IP_PURCHASED =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf,"
              // +" INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualMachine vm LEFT JOIN ip.virtualAppliance vapp, "
              + "VirtualDatacenter vdc LEFT JOIN vdc.enterprise ent "
              + "WHERE net.id = vlan.network.id "
              // +"AND dhcp.id = ip.dhcp.id "
              + "AND ip.vlanNetwork.id = vlan.id " + "AND vdc.id = :vdc_id AND "
              + "vdc.datacenter.id = dc.id AND ip.id = :ip_id AND "
              + "ip.available = 1 AND vlan.enterprise is null AND ip.virtualDatacenter.id = :vdc_id";
focal_class.type: String
focal_class.var_name: BY_IP_PURCHASED
focal_class.declarator: BY_IP_TO_PURCHASE =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf,"
              // +" INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualMachine vm LEFT JOIN ip.virtualAppliance vapp, "
              + "VirtualDatacenter vdc LEFT JOIN vdc.enterprise ent "
              + "WHERE net.id = vlan.network.id "
              // +"AND dhcp.id = ip.dhcp.id "
              + "AND ip.vlanNetwork.id = vlan.id " + "AND vdc.id = :vdc_id AND "
              + "vdc.datacenter.id = dc.id AND ip.id = :ip_id AND "
              + "ip.available = 1 AND vlan.enterprise is null AND ip.virtualDatacenter is null"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_IP_TO_PURCHASE =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf,"
              // +" INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualMachine vm LEFT JOIN ip.virtualAppliance vapp, "
              + "VirtualDatacenter vdc LEFT JOIN vdc.enterprise ent "
              + "WHERE net.id = vlan.network.id "
              // +"AND dhcp.id = ip.dhcp.id "
              + "AND ip.vlanNetwork.id = vlan.id " + "AND vdc.id = :vdc_id AND "
              + "vdc.datacenter.id = dc.id AND ip.id = :ip_id AND "
              + "ip.available = 1 AND vlan.enterprise is null AND ip.virtualDatacenter is null";
focal_class.type: String
focal_class.var_name: BY_IP_TO_PURCHASE
focal_class.declarator: BY_NETWORK =
          " SELECT ip FROM IpPoolManagement ip "
              + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp, "
              + " NetworkConfiguration nc, "
              + " VLANNetwork vn "
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + "WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.id = :vlan_id " + " AND vn.network.id = :net_id AND "
              + "( ip.ip like :filterLike " + " OR ip.mac like :filterLike "
              + " OR ip.vlanNetwork.name like :filterLike " + " OR vapp.name like :filterLike "
              + " OR vm.name like :filterLike " + ")"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_NETWORK =
          " SELECT ip FROM IpPoolManagement ip "
              + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp, "
              + " NetworkConfiguration nc, "
              + " VLANNetwork vn "
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + "WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.id = :vlan_id " + " AND vn.network.id = :net_id AND "
              + "( ip.ip like :filterLike " + " OR ip.mac like :filterLike "
              + " OR ip.vlanNetwork.name like :filterLike " + " OR vapp.name like :filterLike "
              + " OR vm.name like :filterLike " + ")";
focal_class.type: String
focal_class.var_name: BY_NETWORK
focal_class.declarator: BY_PUBLIC_VLAN =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf,"
              // +" INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualDatacenter vdc LEFT JOIN ip.virtualAppliance vapp "
              + "LEFT JOIN ip.virtualMachine vm LEFT JOIN vdc.enterprise ent "
              + "WHERE net.id = vlan.network.id"
              // +"AND dhcp.id = ip.dhcp.id "
              + " AND ip.vlanNetwork.id = vlan.id "
              + " AND dc.id = :datacenter_id AND "
              + "vlan.id = :vlan_id AND"
              + "( ip.ip LIKE :filterLike OR ip.mac LIKE :filterLike OR ip.networkName LIKE :filterLike OR "
              + " vm.name like :filterLike OR vapp.name LIKE :filterLike OR ent.name LIKE :filterLike )"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_PUBLIC_VLAN =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf,"
              // +" INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualDatacenter vdc LEFT JOIN ip.virtualAppliance vapp "
              + "LEFT JOIN ip.virtualMachine vm LEFT JOIN vdc.enterprise ent "
              + "WHERE net.id = vlan.network.id"
              // +"AND dhcp.id = ip.dhcp.id "
              + " AND ip.vlanNetwork.id = vlan.id "
              + " AND dc.id = :datacenter_id AND "
              + "vlan.id = :vlan_id AND"
              + "( ip.ip LIKE :filterLike OR ip.mac LIKE :filterLike OR ip.networkName LIKE :filterLike OR "
              + " vm.name like :filterLike OR vapp.name LIKE :filterLike OR ent.name LIKE :filterLike )";
focal_class.type: String
focal_class.var_name: BY_PUBLIC_VLAN
focal_class.declarator: BY_VDC =
          " SELECT ip FROM IpPoolManagement ip "
              + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp, "
              + " NetworkConfiguration nc, "
              + " VirtualDatacenter vdc, "
              + " VLANNetwork vn "
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + "WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.network.id = vdc.network.id" + " AND vdc.id = :vdc_id AND"
              + "( ip.ip like :filterLike " + " OR ip.mac like :filterLike "
              + " OR ip.vlanNetwork.name like :filterLike " + " OR vapp.name like :filterLike "
              + " OR vm.name like :filterLike " + ")"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_VDC =
          " SELECT ip FROM IpPoolManagement ip "
              + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp, "
              + " NetworkConfiguration nc, "
              + " VirtualDatacenter vdc, "
              + " VLANNetwork vn "
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + "WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.network.id = vdc.network.id" + " AND vdc.id = :vdc_id AND"
              + "( ip.ip like :filterLike " + " OR ip.mac like :filterLike "
              + " OR ip.vlanNetwork.name like :filterLike " + " OR vapp.name like :filterLike "
              + " OR vm.name like :filterLike " + ")";
focal_class.type: String
focal_class.var_name: BY_VDC
focal_class.declarator: BY_VDC_PURCHASED =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf,"
              // +" INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualMachine vm LEFT JOIN ip.virtualAppliance vapp, "
              + "VirtualDatacenter vdc LEFT JOIN vdc.enterprise ent "
              + "WHERE net.id = vlan.network.id "
              // +"AND dhcp.id = ip.dhcp.id "
              + "AND ip.vlanNetwork.id = vlan.id "
              + "AND vdc.id = :vdc_id AND "
              + "vdc.datacenter.id = dc.id AND "
              + "ip.available = 1 AND vlan.enterprise is null AND ip.virtualDatacenter.id = :vdc_id AND "
              + "( ip.ip LIKE :filterLike OR ip.mac LIKE :filterLike OR ip.networkName LIKE :filterLike OR "
              + " vm.name like :filterLike OR vapp.name LIKE :filterLike OR ent.name LIKE :filterLike )"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_VDC_PURCHASED =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf,"
              // +" INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualMachine vm LEFT JOIN ip.virtualAppliance vapp, "
              + "VirtualDatacenter vdc LEFT JOIN vdc.enterprise ent "
              + "WHERE net.id = vlan.network.id "
              // +"AND dhcp.id = ip.dhcp.id "
              + "AND ip.vlanNetwork.id = vlan.id "
              + "AND vdc.id = :vdc_id AND "
              + "vdc.datacenter.id = dc.id AND "
              + "ip.available = 1 AND vlan.enterprise is null AND ip.virtualDatacenter.id = :vdc_id AND "
              + "( ip.ip LIKE :filterLike OR ip.mac LIKE :filterLike OR ip.networkName LIKE :filterLike OR "
              + " vm.name like :filterLike OR vapp.name LIKE :filterLike OR ent.name LIKE :filterLike )";
focal_class.type: String
focal_class.var_name: BY_VDC_PURCHASED
focal_class.declarator: BY_VDC_TO_PURCHASE =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf,"
              // +" INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualMachine vm LEFT JOIN ip.virtualAppliance vapp, "
              + "VirtualDatacenter vdc LEFT JOIN vdc.enterprise ent "
              + "WHERE net.id = vlan.network.id "
              // +"AND dhcp.id = ip.dhcp.id "
              + "AND ip.vlanNetwork.id = vlan.id "
              + "AND vdc.id = :vdc_id AND "
              + "vdc.datacenter.id = dc.id AND "
              + "ip.available = 1 AND ip.quarantine = 0  AND vlan.enterprise is null AND ip.virtualDatacenter is null AND "
              + "( ip.ip LIKE :filterLike OR ip.mac LIKE :filterLike OR ip.networkName LIKE :filterLike OR "
              + " vm.name like :filterLike OR vapp.name LIKE :filterLike OR ent.name LIKE :filterLike )"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_VDC_TO_PURCHASE =
          " SELECT ip FROM "
              + "Datacenter dc INNER JOIN dc.network net, VLANNetwork vlan "
              + "INNER JOIN vlan.configuration conf,"
              // +" INNER JOIN conf.dhcp dhcp, "
              + "IpPoolManagement ip LEFT JOIN ip.virtualMachine vm LEFT JOIN ip.virtualAppliance vapp, "
              + "VirtualDatacenter vdc LEFT JOIN vdc.enterprise ent "
              + "WHERE net.id = vlan.network.id "
              // +"AND dhcp.id = ip.dhcp.id "
              + "AND ip.vlanNetwork.id = vlan.id "
              + "AND vdc.id = :vdc_id AND "
              + "vdc.datacenter.id = dc.id AND "
              + "ip.available = 1 AND ip.quarantine = 0  AND vlan.enterprise is null AND ip.virtualDatacenter is null AND "
              + "( ip.ip LIKE :filterLike OR ip.mac LIKE :filterLike OR ip.networkName LIKE :filterLike OR "
              + " vm.name like :filterLike OR vapp.name LIKE :filterLike OR ent.name LIKE :filterLike )";
focal_class.type: String
focal_class.var_name: BY_VDC_TO_PURCHASE
focal_class.declarator: BY_VIRTUAL_MACHINE =
          "SELECT ip " + "FROM IpPoolManagement ip INNER JOIN ip.virtualMachine vm "
              + "WHERE vm.id = :vm_id " + "ORDER BY ip.sequence"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_VIRTUAL_MACHINE =
          "SELECT ip " + "FROM IpPoolManagement ip INNER JOIN ip.virtualMachine vm "
              + "WHERE vm.id = :vm_id " + "ORDER BY ip.sequence";
focal_class.type: String
focal_class.var_name: BY_VIRTUAL_MACHINE
focal_class.declarator: BY_VLAN =
          " SELECT ip FROM IpPoolManagement ip "
              + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp, "
              + " NetworkConfiguration nc, "
              + " VirtualDatacenter vdc, "
              + " VLANNetwork vn "
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + "WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.id = :vlan_id " + " AND vn.network.id = vdc.network.id"
              + " AND vdc.id = :vdc_id AND" + "( ip.ip like :filterLike "
              + " OR ip.mac like :filterLike " + " OR ip.vlanNetwork.name like :filterLike "
              + " OR vapp.name like :filterLike " + " OR vm.name like :filterLike " + ")"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_VLAN =
          " SELECT ip FROM IpPoolManagement ip "
              + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp, "
              + " NetworkConfiguration nc, "
              + " VirtualDatacenter vdc, "
              + " VLANNetwork vn "
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + "WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.id = :vlan_id " + " AND vn.network.id = vdc.network.id"
              + " AND vdc.id = :vdc_id AND" + "( ip.ip like :filterLike "
              + " OR ip.mac like :filterLike " + " OR ip.vlanNetwork.name like :filterLike "
              + " OR vapp.name like :filterLike " + " OR vm.name like :filterLike " + ")";
focal_class.type: String
focal_class.var_name: BY_VLAN
focal_class.declarator: BY_VLAN_NEXT_AVAILABLE =
          " SELECT ip FROM IpPoolManagement ip " + " inner join ip.vlanNetwork vn "
              + " WHERE vn.id = :vlan_id " + " AND ip.virtualMachine is null "
              + " AND ip.ip NOT in ( :excludedIp ) "
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_VLAN_NEXT_AVAILABLE =
          " SELECT ip FROM IpPoolManagement ip " + " inner join ip.vlanNetwork vn "
              + " WHERE vn.id = :vlan_id " + " AND ip.virtualMachine is null "
              + " AND ip.ip NOT in ( :excludedIp ) ";
focal_class.type: String
focal_class.var_name: BY_VLAN_NEXT_AVAILABLE
focal_class.declarator: BY_VLAN_NEXT_EXTERNAL_IP_AVAILABLE =
          " SELECT ip FROM IpPoolManagement ip " + " inner join ip.vlanNetwork vn "
              + " WHERE vn.id = :vlan_id " + " AND ip.virtualMachine is null "
              + " AND ip.ip NOT in ( :excludedIp ) " + " AND ip.available = 1"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_VLAN_NEXT_EXTERNAL_IP_AVAILABLE =
          " SELECT ip FROM IpPoolManagement ip " + " inner join ip.vlanNetwork vn "
              + " WHERE vn.id = :vlan_id " + " AND ip.virtualMachine is null "
              + " AND ip.ip NOT in ( :excludedIp ) " + " AND ip.available = 1";
focal_class.type: String
focal_class.var_name: BY_VLAN_NEXT_EXTERNAL_IP_AVAILABLE
focal_class.declarator: BY_VLAN_USED_BY_ANY_VDC =
          " SELECT ip FROM ip_pool_management ip  , rasd_management rasd, virtualdatacenter vdc "
              + "  WHERE ip.idManagement= rasd.idManagement and rasd.idVirtualDatacenter "
              + "= vdc.idVirtualDatacenter and ip.vlan_network_id =:vlan_id"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_VLAN_USED_BY_ANY_VDC =
          " SELECT ip FROM ip_pool_management ip  , rasd_management rasd, virtualdatacenter vdc "
              + "  WHERE ip.idManagement= rasd.idManagement and rasd.idVirtualDatacenter "
              + "= vdc.idVirtualDatacenter and ip.vlan_network_id =:vlan_id";
focal_class.type: String
focal_class.var_name: BY_VLAN_USED_BY_ANY_VDC
focal_class.declarator: BY_VLAN_USED_BY_ANY_VM =
          " SELECT ip FROM IpPoolManagement ip "
              + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp, "
              + " NetworkConfiguration nc, "
              + " VLANNetwork vn "
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + "WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.id = :vlan_id " + " AND ( ip.ip like :filterLike "
              + " OR ip.mac like :filterLike " + " OR ip.vlanNetwork.name like :filterLike "
              + " OR vapp.name like :filterLike " + " OR vm.name like :filterLike " + ")"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_VLAN_USED_BY_ANY_VM =
          " SELECT ip FROM IpPoolManagement ip "
              + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp, "
              + " NetworkConfiguration nc, "
              + " VLANNetwork vn "
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + "WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.id = :vlan_id " + " AND ( ip.ip like :filterLike "
              + " OR ip.mac like :filterLike " + " OR ip.vlanNetwork.name like :filterLike "
              + " OR vapp.name like :filterLike " + " OR vm.name like :filterLike " + ")";
focal_class.type: String
focal_class.var_name: BY_VLAN_USED_BY_ANY_VM
focal_class.declarator: BY_VLAN_WITHOUT_USED_IPS =
          " SELECT ip FROM IpPoolManagement ip "
              + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp, "
              + " NetworkConfiguration nc, "
              + " VirtualDatacenter vdc, "
              + " VLANNetwork vn "
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + "WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.id = :vlan_id " + " AND vn.network.id = vdc.network.id"
              + " AND vdc.id = :vdc_id " + " AND vm is null AND " + "( ip.ip like :filterLike "
              + " OR ip.mac like :filterLike " + " OR ip.vlanNetwork.name like :filterLike "
              + " OR vapp.name like :filterLike " + " OR vm.name like :filterLike " + ")"
focal_class.modifier: public static final
focal_class.original_string: public static final String BY_VLAN_WITHOUT_USED_IPS =
          " SELECT ip FROM IpPoolManagement ip "
              + " left join ip.virtualMachine vm "
              + " left join ip.virtualAppliance vapp, "
              + " NetworkConfiguration nc, "
              + " VirtualDatacenter vdc, "
              + " VLANNetwork vn "
              // + " WHERE ip.dhcp.id = nc.dhcp.id "
              + "WHERE ip.vlanNetwork.id = vn.id " + " AND nc.id = vn.configuration.id "
              + " AND vn.id = :vlan_id " + " AND vn.network.id = vdc.network.id"
              + " AND vdc.id = :vdc_id " + " AND vm is null AND " + "( ip.ip like :filterLike "
              + " OR ip.mac like :filterLike " + " OR ip.vlanNetwork.name like :filterLike "
              + " OR vapp.name like :filterLike " + " OR vm.name like :filterLike " + ")";
focal_class.type: String
focal_class.var_name: BY_VLAN_WITHOUT_USED_IPS
focal_class.declarator: GET_VLAN_ASSIGNED_TO_ANOTHER_VIRTUALMACHINE =
          "Select vm " + "FROM com.abiquo.server.core.infrastructure.network.IpPoolManagement ip "
              + "INNER JOIN ip.virtualMachine vm " + "INNER JOIN ip.vlanNetwork vlan "
              + "WHERE vlan.id = :idVlan " + "AND vm.id != :idVm "
              + "AND vm.state != 'NOT_ALLOCATED'"
focal_class.modifier: private static final
focal_class.original_string: private static final String GET_VLAN_ASSIGNED_TO_ANOTHER_VIRTUALMACHINE =
          "Select vm " + "FROM com.abiquo.server.core.infrastructure.network.IpPoolManagement ip "
              + "INNER JOIN ip.virtualMachine vm " + "INNER JOIN ip.vlanNetwork vlan "
              + "WHERE vlan.id = :idVlan " + "AND vm.id != :idVm "
              + "AND vm.state != 'NOT_ALLOCATED'";
focal_class.type: String
focal_class.var_name: GET_VLAN_ASSIGNED_TO_ANOTHER_VIRTUALMACHINE
focal_class.declarator: GET_IPPOOLMANAGEMENT_ASSIGNED_TO_DIFFERENT_VM_AND_DIFFERENT_FROM_NOT_DEPLOYED_SQL =
          "SELECT * " //
              + "FROM ip_pool_management ip, " //
              + "rasd_management rasd " //
              + "JOIN virtualmachine vm " //
              + "ON vm.idVM = rasd.idVM " + "WHERE rasd.idManagement = ip.idManagement " //
              + "AND rasd.idVM != :idVM " //
              + "AND ip.vlan_network_id = :idVlanNetwork " //
              + "AND vm.state != 'NOT_DEPLOYED' " + "AND ip.idManagement != :ip"
focal_class.modifier: private final static
focal_class.original_string: private final static String GET_IPPOOLMANAGEMENT_ASSIGNED_TO_DIFFERENT_VM_AND_DIFFERENT_FROM_NOT_DEPLOYED_SQL =
          "SELECT * " //
              + "FROM ip_pool_management ip, " //
              + "rasd_management rasd " //
              + "JOIN virtualmachine vm " //
              + "ON vm.idVM = rasd.idVM " + "WHERE rasd.idManagement = ip.idManagement " //
              + "AND rasd.idVM != :idVM " //
              + "AND ip.vlan_network_id = :idVlanNetwork " //
              + "AND vm.state != 'NOT_DEPLOYED' " + "AND ip.idManagement != :ip";
focal_class.type: String
focal_class.var_name: GET_IPPOOLMANAGEMENT_ASSIGNED_TO_DIFFERENT_VM_AND_DIFFERENT_FROM_NOT_DEPLOYED_SQL
focal_class.declarator: GET_NETWORK_POOL_PURCHASED_BY_ENTERPRISE =
          "SELECT ip "//
              + "FROM com.abiquo.server.core.infrastructure.Datacenter dc "//
              + "INNER JOIN dc.network net, "//
              + "com.abiquo.server.core.infrastructure.network.VLANNetwork vlan, "//
              // + "INNER JOIN vlan.configuration.dhcp dhcp, "//
              + "com.abiquo.server.core.infrastructure.network.IpPoolManagement ip "//
              // + "LEFT JOIN join ip.virtualMachine vm "//
              + "LEFT JOIN ip.virtualAppliance vapp, "//
              + "com.abiquo.server.core.cloud.VirtualDatacenter vdc "//
              + "where net.id = vlan.network.id "//
              // + "and dhcp.id = ip.dhcp.id "//
              + "and ip.vlanNetwork.id = vlan.id "
              + "and dc.id = vdc.datacenter.id "//
              + "and vdc.enterprise.id = :enterpriseId "
              + "and ip.virtualDatacenter.id = vdc.id "
              + "and vlan.type = 'PUBLIC'"
focal_class.modifier: private final static
focal_class.original_string: private final static String GET_NETWORK_POOL_PURCHASED_BY_ENTERPRISE =
          "SELECT ip "//
              + "FROM com.abiquo.server.core.infrastructure.Datacenter dc "//
              + "INNER JOIN dc.network net, "//
              + "com.abiquo.server.core.infrastructure.network.VLANNetwork vlan, "//
              // + "INNER JOIN vlan.configuration.dhcp dhcp, "//
              + "com.abiquo.server.core.infrastructure.network.IpPoolManagement ip "//
              // + "LEFT JOIN join ip.virtualMachine vm "//
              + "LEFT JOIN ip.virtualAppliance vapp, "//
              + "com.abiquo.server.core.cloud.VirtualDatacenter vdc "//
              + "where net.id = vlan.network.id "//
              // + "and dhcp.id = ip.dhcp.id "//
              + "and ip.vlanNetwork.id = vlan.id "
              + "and dc.id = vdc.datacenter.id "//
              + "and vdc.enterprise.id = :enterpriseId "
              + "and ip.virtualDatacenter.id = vdc.id "
              + "and vlan.type = 'PUBLIC'";
focal_class.type: String
focal_class.var_name: GET_NETWORK_POOL_PURCHASED_BY_ENTERPRISE
focal_class.declarator: GET_IP_INTO_VIRTUALMACHINE =
          " SELECT ip FROM IpPoolManagement ip" + " WHERE ip.virtualMachine.id = :idVm "
              + " AND ip.id = :idIp "
focal_class.modifier: public static final
focal_class.original_string: public static final String GET_IP_INTO_VIRTUALMACHINE =
          " SELECT ip FROM IpPoolManagement ip" + " WHERE ip.virtualMachine.id = :idVm "
              + " AND ip.id = :idIp ";
focal_class.type: String
focal_class.var_name: GET_IP_INTO_VIRTUALMACHINE
focal_class.file: model/src/main/java/com/abiquo/server/core/infrastructure/network/IpPoolManagementDAO.java
focal_class.identifier: IpPoolManagementDAO
focal_class.class_method_signature: IpPoolManagementDAO.equalMac(final String mac)
focal_class.full_signature: private static Criterion equalMac(final String mac)
focal_class.identifier: equalMac
focal_class.modifiers: private static
focal_class.parameters: (final String mac)
focal_class.return: Criterion
focal_class.signature: Criterion equalMac(final String mac)
focal_class.class_method_signature: IpPoolManagementDAO.IpPoolManagementDAO()
focal_class.full_signature: public  IpPoolManagementDAO()
focal_class.identifier: IpPoolManagementDAO
focal_class.modifiers: public
focal_class.parameters: ()
focal_class.signature:  IpPoolManagementDAO()
focal_class.class_method_signature: IpPoolManagementDAO.IpPoolManagementDAO(final EntityManager entityManager)
focal_class.full_signature: public  IpPoolManagementDAO(final EntityManager entityManager)
focal_class.identifier: IpPoolManagementDAO
focal_class.modifiers: public
focal_class.parameters: (final EntityManager entityManager)
focal_class.signature:  IpPoolManagementDAO(final EntityManager entityManager)
focal_class.class_method_signature: IpPoolManagementDAO.existsAnyWithMac(final String mac)
focal_class.full_signature: public boolean existsAnyWithMac(final String mac)
focal_class.identifier: existsAnyWithMac
focal_class.modifiers: public
focal_class.parameters: (final String mac)
focal_class.return: boolean
focal_class.signature: boolean existsAnyWithMac(final String mac)
focal_class.class_method_signature: IpPoolManagementDAO.findExternalIpsByVlan(final Integer entId,
          final Integer datacenterLimitId, final Integer vlanId, Integer startwith,
          final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc, final Boolean onlyAvailable)
focal_class.full_signature: public List<IpPoolManagement> findExternalIpsByVlan(final Integer entId,
          final Integer datacenterLimitId, final Integer vlanId, Integer startwith,
          final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc, final Boolean onlyAvailable)
focal_class.identifier: findExternalIpsByVlan
focal_class.modifiers: public
focal_class.parameters: (final Integer entId,
          final Integer datacenterLimitId, final Integer vlanId, Integer startwith,
          final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc, final Boolean onlyAvailable)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findExternalIpsByVlan(final Integer entId,
          final Integer datacenterLimitId, final Integer vlanId, Integer startwith,
          final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc, final Boolean onlyAvailable)
focal_class.class_method_signature: IpPoolManagementDAO.findFreeIpsByVlan(final VLANNetwork vlan)
focal_class.full_signature: public List<IpPoolManagement> findFreeIpsByVlan(final VLANNetwork vlan)
focal_class.identifier: findFreeIpsByVlan
focal_class.modifiers: public
focal_class.parameters: (final VLANNetwork vlan)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findFreeIpsByVlan(final VLANNetwork vlan)
focal_class.class_method_signature: IpPoolManagementDAO.findIp(final VLANNetwork vlan, final Integer ipId)
focal_class.full_signature: public IpPoolManagement findIp(final VLANNetwork vlan, final Integer ipId)
focal_class.identifier: findIp
focal_class.modifiers: public
focal_class.parameters: (final VLANNetwork vlan, final Integer ipId)
focal_class.return: IpPoolManagement
focal_class.signature: IpPoolManagement findIp(final VLANNetwork vlan, final Integer ipId)
focal_class.class_method_signature: IpPoolManagementDAO.findIpsByEnterprise(final Integer entId, Integer firstElem,
          final Integer numElem, final String has, final IpPoolManagement.OrderByEnum orderby,
          final Boolean asc)
focal_class.full_signature: public List<IpPoolManagement> findIpsByEnterprise(final Integer entId, Integer firstElem,
          final Integer numElem, final String has, final IpPoolManagement.OrderByEnum orderby,
          final Boolean asc)
focal_class.identifier: findIpsByEnterprise
focal_class.modifiers: public
focal_class.parameters: (final Integer entId, Integer firstElem,
          final Integer numElem, final String has, final IpPoolManagement.OrderByEnum orderby,
          final Boolean asc)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findIpsByEnterprise(final Integer entId, Integer firstElem,
          final Integer numElem, final String has, final IpPoolManagement.OrderByEnum orderby,
          final Boolean asc)
focal_class.class_method_signature: IpPoolManagementDAO.findIpsByNetwork(final Network network, final Integer vlanId)
focal_class.full_signature: public List<IpPoolManagement> findIpsByNetwork(final Network network, final Integer vlanId)
focal_class.identifier: findIpsByNetwork
focal_class.modifiers: public
focal_class.parameters: (final Network network, final Integer vlanId)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findIpsByNetwork(final Network network, final Integer vlanId)
focal_class.class_method_signature: IpPoolManagementDAO.findIpsByNetwork(final Network network, final Integer vlanId,
          final String has)
focal_class.full_signature: public List<IpPoolManagement> findIpsByNetwork(final Network network, final Integer vlanId,
          final String has)
focal_class.identifier: findIpsByNetwork
focal_class.modifiers: public
focal_class.parameters: (final Network network, final Integer vlanId,
          final String has)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findIpsByNetwork(final Network network, final Integer vlanId,
          final String has)
focal_class.class_method_signature: IpPoolManagementDAO.findIpsByNetwork(final Network network, final Integer vlanId,
          final String has, Integer firstElem, final Integer numElem)
focal_class.full_signature: public List<IpPoolManagement> findIpsByNetwork(final Network network, final Integer vlanId,
          final String has, Integer firstElem, final Integer numElem)
focal_class.identifier: findIpsByNetwork
focal_class.modifiers: public
focal_class.parameters: (final Network network, final Integer vlanId,
          final String has, Integer firstElem, final Integer numElem)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findIpsByNetwork(final Network network, final Integer vlanId,
          final String has, Integer firstElem, final Integer numElem)
focal_class.class_method_signature: IpPoolManagementDAO.findIpsByPrivateVLAN(final Integer vdcId, final Integer vlanId)
focal_class.full_signature: public List<IpPoolManagement> findIpsByPrivateVLAN(final Integer vdcId, final Integer vlanId)
focal_class.identifier: findIpsByPrivateVLAN
focal_class.modifiers: public
focal_class.parameters: (final Integer vdcId, final Integer vlanId)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findIpsByPrivateVLAN(final Integer vdcId, final Integer vlanId)
focal_class.class_method_signature: IpPoolManagementDAO.findIpsByPrivateVLANAvailableFiltered(final Integer vdcId,
          final Integer vlanId, Integer firstElem, final Integer numElem, final String has,
          final IpPoolManagement.OrderByEnum orderby, final Boolean asc)
focal_class.full_signature: public List<IpPoolManagement> findIpsByPrivateVLANAvailableFiltered(final Integer vdcId,
          final Integer vlanId, Integer firstElem, final Integer numElem, final String has,
          final IpPoolManagement.OrderByEnum orderby, final Boolean asc)
focal_class.identifier: findIpsByPrivateVLANAvailableFiltered
focal_class.modifiers: public
focal_class.parameters: (final Integer vdcId,
          final Integer vlanId, Integer firstElem, final Integer numElem, final String has,
          final IpPoolManagement.OrderByEnum orderby, final Boolean asc)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findIpsByPrivateVLANAvailableFiltered(final Integer vdcId,
          final Integer vlanId, Integer firstElem, final Integer numElem, final String has,
          final IpPoolManagement.OrderByEnum orderby, final Boolean asc)
focal_class.class_method_signature: IpPoolManagementDAO.findNextIpAvailable(final Integer vlanId, final String... excludedIps)
focal_class.full_signature: public IpPoolManagement findNextIpAvailable(final Integer vlanId, final String... excludedIps)
focal_class.identifier: findNextIpAvailable
focal_class.modifiers: public
focal_class.parameters: (final Integer vlanId, final String... excludedIps)
focal_class.return: IpPoolManagement
focal_class.signature: IpPoolManagement findNextIpAvailable(final Integer vlanId, final String... excludedIps)
focal_class.class_method_signature: IpPoolManagementDAO.findNextExternalIpAvailable(final Integer vlanId,
          final String... excludedIps)
focal_class.full_signature: public IpPoolManagement findNextExternalIpAvailable(final Integer vlanId,
          final String... excludedIps)
focal_class.identifier: findNextExternalIpAvailable
focal_class.modifiers: public
focal_class.parameters: (final Integer vlanId,
          final String... excludedIps)
focal_class.return: IpPoolManagement
focal_class.signature: IpPoolManagement findNextExternalIpAvailable(final Integer vlanId,
          final String... excludedIps)
focal_class.class_method_signature: IpPoolManagementDAO.findIpsByPrivateVLANFiltered(final Integer vdcId,
          final Integer vlanId, Integer firstElem, final Integer numElem, final String has,
          final IpPoolManagement.OrderByEnum orderby, final Boolean asc, final Boolean freeIps)
focal_class.full_signature: public List<IpPoolManagement> findIpsByPrivateVLANFiltered(final Integer vdcId,
          final Integer vlanId, Integer firstElem, final Integer numElem, final String has,
          final IpPoolManagement.OrderByEnum orderby, final Boolean asc, final Boolean freeIps)
focal_class.identifier: findIpsByPrivateVLANFiltered
focal_class.modifiers: public
focal_class.parameters: (final Integer vdcId,
          final Integer vlanId, Integer firstElem, final Integer numElem, final String has,
          final IpPoolManagement.OrderByEnum orderby, final Boolean asc, final Boolean freeIps)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findIpsByPrivateVLANFiltered(final Integer vdcId,
          final Integer vlanId, Integer firstElem, final Integer numElem, final String has,
          final IpPoolManagement.OrderByEnum orderby, final Boolean asc, final Boolean freeIps)
focal_class.class_method_signature: IpPoolManagementDAO.findIpsByVdc(final Integer vdcId, Integer firstElem,
          final Integer numElem, final String has, final IpPoolManagement.OrderByEnum orderby,
          final Boolean asc)
focal_class.full_signature: public List<IpPoolManagement> findIpsByVdc(final Integer vdcId, Integer firstElem,
          final Integer numElem, final String has, final IpPoolManagement.OrderByEnum orderby,
          final Boolean asc)
focal_class.identifier: findIpsByVdc
focal_class.modifiers: public
focal_class.parameters: (final Integer vdcId, Integer firstElem,
          final Integer numElem, final String has, final IpPoolManagement.OrderByEnum orderby,
          final Boolean asc)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findIpsByVdc(final Integer vdcId, Integer firstElem,
          final Integer numElem, final String has, final IpPoolManagement.OrderByEnum orderby,
          final Boolean asc)
focal_class.class_method_signature: IpPoolManagementDAO.findIpsByVirtualAppliance(final VirtualAppliance vapp)
focal_class.full_signature: public List<IpPoolManagement> findIpsByVirtualAppliance(final VirtualAppliance vapp)
focal_class.identifier: findIpsByVirtualAppliance
focal_class.modifiers: public
focal_class.parameters: (final VirtualAppliance vapp)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findIpsByVirtualAppliance(final VirtualAppliance vapp)
focal_class.class_method_signature: IpPoolManagementDAO.findIpsByVirtualMachine(final VirtualMachine virtualMachine)
focal_class.full_signature: public List<IpPoolManagement> findIpsByVirtualMachine(final VirtualMachine virtualMachine)
focal_class.identifier: findIpsByVirtualMachine
focal_class.modifiers: public
focal_class.parameters: (final VirtualMachine virtualMachine)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findIpsByVirtualMachine(final VirtualMachine virtualMachine)
focal_class.class_method_signature: IpPoolManagementDAO.findIpByVirtualMachine(final VirtualMachine vm, final Integer nicId)
focal_class.full_signature: public IpPoolManagement findIpByVirtualMachine(final VirtualMachine vm, final Integer nicId)
focal_class.identifier: findIpByVirtualMachine
focal_class.modifiers: public
focal_class.parameters: (final VirtualMachine vm, final Integer nicId)
focal_class.return: IpPoolManagement
focal_class.signature: IpPoolManagement findIpByVirtualMachine(final VirtualMachine vm, final Integer nicId)
focal_class.class_method_signature: IpPoolManagementDAO.findIpsByVirtualMachineWithConfigurationId(final VirtualMachine vm)
focal_class.full_signature: public List<IpPoolManagement> findIpsByVirtualMachineWithConfigurationId(final VirtualMachine vm)
focal_class.identifier: findIpsByVirtualMachineWithConfigurationId
focal_class.modifiers: public
focal_class.parameters: (final VirtualMachine vm)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findIpsByVirtualMachineWithConfigurationId(final VirtualMachine vm)
focal_class.class_method_signature: IpPoolManagementDAO.findIpsByVlan(final VLANNetwork vlan)
focal_class.full_signature: public List<IpPoolManagement> findIpsByVlan(final VLANNetwork vlan)
focal_class.identifier: findIpsByVlan
focal_class.modifiers: public
focal_class.parameters: (final VLANNetwork vlan)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findIpsByVlan(final VLANNetwork vlan)
focal_class.class_method_signature: IpPoolManagementDAO.findPublicIpPurchasedByVirtualDatacenter(final Integer vdcId,
          final Integer ipId)
focal_class.full_signature: public IpPoolManagement findPublicIpPurchasedByVirtualDatacenter(final Integer vdcId,
          final Integer ipId)
focal_class.identifier: findPublicIpPurchasedByVirtualDatacenter
focal_class.modifiers: public
focal_class.parameters: (final Integer vdcId,
          final Integer ipId)
focal_class.return: IpPoolManagement
focal_class.signature: IpPoolManagement findPublicIpPurchasedByVirtualDatacenter(final Integer vdcId,
          final Integer ipId)
focal_class.class_method_signature: IpPoolManagementDAO.findPublicIpsByDatacenter(final Integer datacenterId,
          Integer startwith, final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc, NetworkType type, final Boolean all)
focal_class.full_signature: public List<IpPoolManagement> findPublicIpsByDatacenter(final Integer datacenterId,
          Integer startwith, final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc, NetworkType type, final Boolean all)
focal_class.identifier: findPublicIpsByDatacenter
focal_class.modifiers: public
focal_class.parameters: (final Integer datacenterId,
          Integer startwith, final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc, NetworkType type, final Boolean all)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findPublicIpsByDatacenter(final Integer datacenterId,
          Integer startwith, final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc, NetworkType type, final Boolean all)
focal_class.class_method_signature: IpPoolManagementDAO.findPublicIpsByEnterpriseAndDatacenter(
          final Integer datacenterId, final Integer enterpriseId, Integer startwith,
          final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc, NetworkType type, final Boolean all)
focal_class.full_signature: public List<IpPoolManagement> findPublicIpsByEnterpriseAndDatacenter(
          final Integer datacenterId, final Integer enterpriseId, Integer startwith,
          final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc, NetworkType type, final Boolean all)
focal_class.identifier: findPublicIpsByEnterpriseAndDatacenter
focal_class.modifiers: public
focal_class.parameters: (
          final Integer datacenterId, final Integer enterpriseId, Integer startwith,
          final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc, NetworkType type, final Boolean all)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findPublicIpsByEnterpriseAndDatacenter(
          final Integer datacenterId, final Integer enterpriseId, Integer startwith,
          final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc, NetworkType type, final Boolean all)
focal_class.class_method_signature: IpPoolManagementDAO.findPublicIpsByVlan(final Integer datacenterId,
          final Integer vlanId, Integer startwith, final Integer limit, final String filter,
          final OrderByEnum orderByEnum, final Boolean descOrAsc, final Boolean all)
focal_class.full_signature: public List<IpPoolManagement> findPublicIpsByVlan(final Integer datacenterId,
          final Integer vlanId, Integer startwith, final Integer limit, final String filter,
          final OrderByEnum orderByEnum, final Boolean descOrAsc, final Boolean all)
focal_class.identifier: findPublicIpsByVlan
focal_class.modifiers: public
focal_class.parameters: (final Integer datacenterId,
          final Integer vlanId, Integer startwith, final Integer limit, final String filter,
          final OrderByEnum orderByEnum, final Boolean descOrAsc, final Boolean all)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findPublicIpsByVlan(final Integer datacenterId,
          final Integer vlanId, Integer startwith, final Integer limit, final String filter,
          final OrderByEnum orderByEnum, final Boolean descOrAsc, final Boolean all)
focal_class.class_method_signature: IpPoolManagementDAO.findpublicIpsPurchasedByVirtualDatacenter(final Integer vdcId,
          final Boolean onlyAvailabe, Integer startwith, final Integer limit, final String filter,
          final OrderByEnum orderByEnum, final Boolean descOrAsc)
focal_class.full_signature: public List<IpPoolManagement> findpublicIpsPurchasedByVirtualDatacenter(final Integer vdcId,
          final Boolean onlyAvailabe, Integer startwith, final Integer limit, final String filter,
          final OrderByEnum orderByEnum, final Boolean descOrAsc)
focal_class.identifier: findpublicIpsPurchasedByVirtualDatacenter
focal_class.modifiers: public
focal_class.parameters: (final Integer vdcId,
          final Boolean onlyAvailabe, Integer startwith, final Integer limit, final String filter,
          final OrderByEnum orderByEnum, final Boolean descOrAsc)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findpublicIpsPurchasedByVirtualDatacenter(final Integer vdcId,
          final Boolean onlyAvailabe, Integer startwith, final Integer limit, final String filter,
          final OrderByEnum orderByEnum, final Boolean descOrAsc)
focal_class.class_method_signature: IpPoolManagementDAO.findPublicIpsPurchasedByVlan(final VLANNetwork vlan)
focal_class.full_signature: public List<IpPoolManagement> findPublicIpsPurchasedByVlan(final VLANNetwork vlan)
focal_class.identifier: findPublicIpsPurchasedByVlan
focal_class.modifiers: public
focal_class.parameters: (final VLANNetwork vlan)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findPublicIpsPurchasedByVlan(final VLANNetwork vlan)
focal_class.class_method_signature: IpPoolManagementDAO.findpublicIpsToPurchaseByVirtualDatacenter(final Integer vdcId,
          Integer startwith, final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc)
focal_class.full_signature: public List<IpPoolManagement> findpublicIpsToPurchaseByVirtualDatacenter(final Integer vdcId,
          Integer startwith, final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc)
focal_class.identifier: findpublicIpsToPurchaseByVirtualDatacenter
focal_class.modifiers: public
focal_class.parameters: (final Integer vdcId,
          Integer startwith, final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findpublicIpsToPurchaseByVirtualDatacenter(final Integer vdcId,
          Integer startwith, final Integer limit, final String filter, final OrderByEnum orderByEnum,
          final Boolean descOrAsc)
focal_class.class_method_signature: IpPoolManagementDAO.findPublicIpToPurchaseByVirtualDatacenter(final Integer vdcId,
          final Integer ipId)
focal_class.full_signature: public IpPoolManagement findPublicIpToPurchaseByVirtualDatacenter(final Integer vdcId,
          final Integer ipId)
focal_class.identifier: findPublicIpToPurchaseByVirtualDatacenter
focal_class.modifiers: public
focal_class.parameters: (final Integer vdcId,
          final Integer ipId)
focal_class.return: IpPoolManagement
focal_class.signature: IpPoolManagement findPublicIpToPurchaseByVirtualDatacenter(final Integer vdcId,
          final Integer ipId)
focal_class.class_method_signature: IpPoolManagementDAO.findUsedIpsByPrivateVLAN(final Integer vlanId)
focal_class.full_signature: public List<IpPoolManagement> findUsedIpsByPrivateVLAN(final Integer vlanId)
focal_class.identifier: findUsedIpsByPrivateVLAN
focal_class.modifiers: public
focal_class.parameters: (final Integer vlanId)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findUsedIpsByPrivateVLAN(final Integer vlanId)
focal_class.class_method_signature: IpPoolManagementDAO.findUsedIpsByPrivateVLAN(final Integer vdcId, final Integer vlanId)
focal_class.full_signature: public List<IpPoolManagement> findUsedIpsByPrivateVLAN(final Integer vdcId, final Integer vlanId)
focal_class.identifier: findUsedIpsByPrivateVLAN
focal_class.modifiers: public
focal_class.parameters: (final Integer vdcId, final Integer vlanId)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> findUsedIpsByPrivateVLAN(final Integer vdcId, final Integer vlanId)
focal_class.class_method_signature: IpPoolManagementDAO.getAllMacs()
focal_class.full_signature: public Collection<String> getAllMacs()
focal_class.identifier: getAllMacs
focal_class.modifiers: public
focal_class.parameters: ()
focal_class.return: Collection<String>
focal_class.signature: Collection<String> getAllMacs()
focal_class.class_method_signature: IpPoolManagementDAO.getPublicNetworkPoolPurchasedByEnterprise(
          final Integer enterpriseId)
focal_class.full_signature: public List<IpPoolManagement> getPublicNetworkPoolPurchasedByEnterprise(
          final Integer enterpriseId)
focal_class.identifier: getPublicNetworkPoolPurchasedByEnterprise
focal_class.modifiers: public
focal_class.parameters: (
          final Integer enterpriseId)
focal_class.return: List<IpPoolManagement>
focal_class.signature: List<IpPoolManagement> getPublicNetworkPoolPurchasedByEnterprise(
          final Integer enterpriseId)
focal_class.class_method_signature: IpPoolManagementDAO.isDefaultNetworkofanyVDC(final Integer vlanId)
focal_class.full_signature: public boolean isDefaultNetworkofanyVDC(final Integer vlanId)
focal_class.identifier: isDefaultNetworkofanyVDC
focal_class.modifiers: public
focal_class.parameters: (final Integer vlanId)
focal_class.return: boolean
focal_class.signature: boolean isDefaultNetworkofanyVDC(final Integer vlanId)
focal_class.class_method_signature: IpPoolManagementDAO.isVlanAssignedToDifferentVM(final Integer virtualMachineId,
          final VLANNetwork vlanNetwork)
focal_class.full_signature: public Boolean isVlanAssignedToDifferentVM(final Integer virtualMachineId,
          final VLANNetwork vlanNetwork)
focal_class.identifier: isVlanAssignedToDifferentVM
focal_class.modifiers: public
focal_class.parameters: (final Integer virtualMachineId,
          final VLANNetwork vlanNetwork)
focal_class.return: Boolean
focal_class.signature: Boolean isVlanAssignedToDifferentVM(final Integer virtualMachineId,
          final VLANNetwork vlanNetwork)
focal_class.class_method_signature: IpPoolManagementDAO.privateVLANinUseByAnyVDC(final Integer vlanId)
focal_class.full_signature: public boolean privateVLANinUseByAnyVDC(final Integer vlanId)
focal_class.identifier: privateVLANinUseByAnyVDC
focal_class.modifiers: public
focal_class.parameters: (final Integer vlanId)
focal_class.return: boolean
focal_class.signature: boolean privateVLANinUseByAnyVDC(final Integer vlanId)
focal_class.class_method_signature: IpPoolManagementDAO.defineAllFilter(final Boolean all)
focal_class.full_signature: private String defineAllFilter(final Boolean all)
focal_class.identifier: defineAllFilter
focal_class.modifiers: private
focal_class.parameters: (final Boolean all)
focal_class.return: String
focal_class.signature: String defineAllFilter(final Boolean all)
focal_class.class_method_signature: IpPoolManagementDAO.defineFilterAvailable()
focal_class.full_signature: private String defineFilterAvailable()
focal_class.identifier: defineFilterAvailable
focal_class.modifiers: private
focal_class.parameters: ()
focal_class.return: String
focal_class.signature: String defineFilterAvailable()
focal_class.class_method_signature: IpPoolManagementDAO.defineFilterUsed()
focal_class.full_signature: private String defineFilterUsed()
focal_class.identifier: defineFilterUsed
focal_class.modifiers: private
focal_class.parameters: ()
focal_class.return: String
focal_class.signature: String defineFilterUsed()
focal_class.class_method_signature: IpPoolManagementDAO.defineOnlyAvailableFilter(final Boolean onlyAvailable)
focal_class.full_signature: private String defineOnlyAvailableFilter(final Boolean onlyAvailable)
focal_class.identifier: defineOnlyAvailableFilter
focal_class.modifiers: private
focal_class.parameters: (final Boolean onlyAvailable)
focal_class.return: String
focal_class.signature: String defineOnlyAvailableFilter(final Boolean onlyAvailable)
focal_class.class_method_signature: IpPoolManagementDAO.defineOrderBy(final IpPoolManagement.OrderByEnum orderBy, final Boolean asc)
focal_class.full_signature: private String defineOrderBy(final IpPoolManagement.OrderByEnum orderBy, final Boolean asc)
focal_class.identifier: defineOrderBy
focal_class.modifiers: private
focal_class.parameters: (final IpPoolManagement.OrderByEnum orderBy, final Boolean asc)
focal_class.return: String
focal_class.signature: String defineOrderBy(final IpPoolManagement.OrderByEnum orderBy, final Boolean asc)
focal_class.superclass: extends DefaultDAOBase<Integer, IpPoolManagement>
focal_method.body: public IpPoolManagement findNextIpAvailable(final Integer vlanId, final String... excludedIps)
      {
          // Get the query that counts the total results.
          Query query =
              getSession().createQuery(
                  BY_VLAN_NEXT_AVAILABLE
                      + defineOrderBy(IpPoolManagement.OrderByEnum.IP, Boolean.TRUE));
          query.setMaxResults(1);
          query.setParameter("vlan_id", vlanId);
          // query.setLockMode("next_ip", LockMode.PESSIMISTIC_WRITE);
          if (excludedIps != null && excludedIps.length != 0)
          {
              query.setParameterList("excludedIp", Arrays.asList(excludedIps));
          }
          else
          {
              query.setString("excludedIp", null);
          }
          List<IpPoolManagement> result = query.list();
  
          return result.isEmpty() ? null : result.get(0);
      }
focal_method.class_method_signature: IpPoolManagementDAO.findNextIpAvailable(final Integer vlanId, final String... excludedIps)
focal_method.full_signature: public IpPoolManagement findNextIpAvailable(final Integer vlanId, final String... excludedIps)
focal_method.identifier: findNextIpAvailable
focal_method.invocations: createQuery getSession defineOrderBy setMaxResults setParameter setParameterList asList setString list isEmpty get
focal_method.modifiers: public
focal_method.parameters: (final Integer vlanId, final String... excludedIps)
focal_method.return: IpPoolManagement
focal_method.signature: IpPoolManagement findNextIpAvailable(final Integer vlanId, final String... excludedIps)