Example usage for org.hibernate Query uniqueResult

Introduction

In this page you can find the example usage for org.hibernate Query uniqueResult.

Prototype

R uniqueResult();

Source Link

Document

Convenience method to return a single instance that matches the query, or null if the query returns no results.

Usage

From source file:com.abiquo.server.core.infrastructure.MachineDAO.java

License:Open Source License

public Long getTotalUsedCores() {
    Query query = getSession().createQuery(QUERY_TOTAL_USED_CORES);
    Long result = (Long) query.uniqueResult();
    // If there are no results (no machines in DB) return 0
    return result == null ? 0L : result;
}

From source file:com.abiquo.server.core.infrastructure.MachineDAO.java

License:Open Source License

public Long getTotalUsedCoresExceptMachine(final Machine machine) {
    Query query = getSession().createQuery(QUERY_USED_CORES_EXCEPT_MACHINE);
    query.setInteger("id", machine.getId());
    Long result = (Long) query.uniqueResult();
    // If there are no results (no other machines in DB) return 0
    return result == null ? 0L : result;
}

From source file:com.abiquo.server.core.infrastructure.network.IpPoolManagementDAO.java

License:Open Source License

public IpPoolManagement findIpByVirtualMachine(final VirtualMachine vm, final Integer nicId) {
    Query finalQuery = getSession().createQuery(GET_IP_INTO_VIRTUALMACHINE);
    finalQuery.setParameter("idVm", vm.getId());
    finalQuery.setParameter("idIp", nicId);

    return (IpPoolManagement) finalQuery.uniqueResult();
}

From source file:com.abiquo.server.core.infrastructure.network.IpPoolManagementDAO.java

License:Open Source License

public IpPoolManagement findPublicIpPurchasedByVirtualDatacenter(final Integer vdcId, final Integer ipId) {
    Query finalQuery = getSession().createQuery(BY_IP_PURCHASED);
    finalQuery.setParameter("vdc_id", vdcId);
    finalQuery.setParameter("ip_id", ipId);

    return (IpPoolManagement) finalQuery.uniqueResult();
}

From source file:com.abiquo.server.core.infrastructure.network.IpPoolManagementDAO.java

License:Open Source License

public IpPoolManagement findPublicIpToPurchaseByVirtualDatacenter(final Integer vdcId, final Integer ipId) {
    Query finalQuery = getSession().createQuery(BY_IP_TO_PURCHASE);
    finalQuery.setParameter("vdc_id", vdcId);
    finalQuery.setParameter("ip_id", ipId);

    return (IpPoolManagement) finalQuery.uniqueResult();
}

From source file:com.abiquo.server.core.infrastructure.network.VLANNetworkDAO.java

License:Open Source License

public boolean isPublic(final VLANNetwork vlan) {
    Query query = getSession().createQuery(GET_VLAN_DATACENTER);
    query.setParameter("id", vlan.getId());

    return query.uniqueResult() != null;
}

From source file:com.abiquo.server.core.infrastructure.RackDAO.java

License:Open Source License

public Long getNumberOfDeployedVlanNetworks(final Integer rackId) {
    Query query = getSession().createQuery(COUNT_DEPLOYED_VLA);
    query.setInteger("idRack", rackId);

    Long numberOfDeployedNetworks = (Long) query.uniqueResult();

    return numberOfDeployedNetworks;
}

From source file:com.abiquo.server.core.infrastructure.storage.DiskManagementDAO.java

License:Open Source License

public DiskManagement findHardDiskByVirtualDatacenter(final VirtualDatacenter vdc, final Integer diskId) {
    Query finalQuery = getSession().createQuery(GET_DISK_INTO_VIRTUALDATACENTER);
    finalQuery.setParameter("idVdc", vdc.getId());
    finalQuery.setParameter("idDisk", diskId);

    return (DiskManagement) finalQuery.uniqueResult();
}

From source file:com.abiquo.server.core.infrastructure.storage.DiskManagementDAO.java

License:Open Source License

/**
 * Returns the unique object from a virtual machine.
 * /* ww w. ja v a 2s .com*/
 * @param vm virtual machine that has the disk
 * @param diskOrder sequence order inside the virtual machine of the disk
 * @return the found {@link DiskManagement}
 */
public DiskManagement findHardDiskByVirtualMachine(final VirtualMachine vm, final Integer diskId) {
    Query finalQuery = getSession().createQuery(GET_DISK_INTO_VIRTUALMACHINE);
    finalQuery.setParameter("idVm", vm.getId());
    finalQuery.setParameter("idDisk", diskId);

    return (DiskManagement) finalQuery.uniqueResult();
}

From source file:com.abssh.util.GenericDao.java

License:Apache License

/**
 * ?sql//from  w  ww.j  a va 2 s .  co m
 */
@SuppressWarnings("unchecked")
public T findSQLNonHibernateEntity(final String sql, final Map<String, Object> values) {
    Query query = createSQLQuery(sql, values).setResultTransformer(Transformers.aliasToBean(entityClass));
    query.setMaxResults(1);
    return (T) query.uniqueResult();
}