@Override protected void scripts() { databaseFacade.getEntityManager().createNativeQuery("select 1").getSingleResult(); } }.execute();
@Override protected VolumeVO scripts() { dbf.getEntityManager().persist(finalVo); dbf.getEntityManager().flush(); dbf.getEntityManager().refresh(finalVo); return finalVo; } }.execute();
@Transactional(readOnly = true) private Timestamp getCurrentSqlDate() { Query query = dbf.getEntityManager().createNativeQuery("select current_timestamp()"); return (Timestamp) query.getSingleResult(); }
@Override @Transactional public void run() { String sql = "delete from ApplianceVmFirewallRuleVO r where r.identity in (:ids)"; Query q = dbf.getEntityManager().createQuery(sql); q.setParameter("ids", ids); q.executeUpdate(); } }.run();
@Transactional private void updateHostCpuCapacityByUuid(String hostUuid, int ratio) { String sql = String.format("update HostCapacityVO cap set cap.totalCpu = cap.cpuNum * %s where cap.uuid = :huuid", ratio); Query q = dbf.getEntityManager().createQuery(sql); q.setParameter("huuid", hostUuid); q.executeUpdate(); }
@Transactional(readOnly = true) private List<String> getVmNicUuidsToRemoveForDetachSecurityGroup(String sgUuid, String l3Uuid) { String sql = "select distinct nic.uuid from VmNicVO nic, VmNicSecurityGroupRefVO ref, UsedIpVO ip, SecurityGroupVO sg" + " where ref.vmNicUuid = nic.uuid and nic.uuid = ip.vmNicUuid and ip.l3NetworkUuid = :l3Uuid and ref.securityGroupUuid = :sgUuid" + " and sg.ipVersion = ip.ipVersion"; TypedQuery<String> tq = dbf.getEntityManager().createQuery(sql, String.class); tq.setParameter("l3Uuid", l3Uuid); tq.setParameter("sgUuid", sgUuid); return tq.getResultList(); }
@Override @Transactional(readOnly = true) public List<LoadBalancerVO> call() { String sql = "select d from LoadBalancerVO d, AccountResourceRefVO r where d.uuid = r.resourceUuid and" + " r.resourceType = :rtype and r.accountUuid in (:auuids)"; TypedQuery<LoadBalancerVO> q = dbf.getEntityManager().createQuery(sql, LoadBalancerVO.class); q.setParameter("auuids", auuids); q.setParameter("rtype", LoadBalancerVO.class.getSimpleName()); return q.getResultList(); } }.call();
@Transactional(readOnly = true) private long getUsedLb(String accountUuid) { String sql = "select count(lb.uuid) from LoadBalancerVO lb, AccountResourceRefVO ref where ref.resourceUuid = lb.uuid and " + "ref.accountUuid = :auuid and ref.resourceType = :rtype"; TypedQuery<Long> q = dbf.getEntityManager().createQuery(sql, Long.class); q.setParameter("auuid", accountUuid); q.setParameter("rtype", LoadBalancerVO.class.getSimpleName()); Long en = q.getSingleResult(); en = en == null ? 0 : en; return en; }
@Override @Transactional public DiskOfferingInventory createDiskOffering(DiskOfferingVO vo, APICreateDiskOfferingMsg msg) { dbf.getEntityManager().persist(vo); dbf.getEntityManager().flush(); dbf.getEntityManager().refresh(vo); return DiskOfferingInventory.valueOf(vo); }
@Override protected List<String> scripts() { String sql = String.format("select e.uuid from %s e where e.uuid in (:uuids)", at.resourceType().getSimpleName()); TypedQuery<String> q = databaseFacade.getEntityManager().createQuery(sql, String.class); q.setParameter("uuids", col); return q.getResultList(); } }.execute();
@Transactional(readOnly = true) private List<HostRuleTO> calculateBySecurityGroup() { String sql = "select ref.vmNicUuid from VmNicSecurityGroupRefVO ref where ref.securityGroupUuid in (:sgUuids)"; TypedQuery<String> q = dbf.getEntityManager().createQuery(sql, String.class); q.setParameter("sgUuids", securityGroupUuids); vmNicUuids = q.getResultList(); return calculateByVmNic(); }
@Override @Transactional(readOnly = true) public List<String> call() { String sql = "select vip.uuid from EipVO eip, VmNicVO nic, VipVO vip, VmInstanceVO vm where vm.uuid = nic.vmInstanceUuid and vm.state = :vmState and eip.vipUuid = vip.uuid and eip.vmNicUuid = nic.uuid and vip.l3NetworkUuid = :vipL3Uuid and nic.l3NetworkUuid in (:guestL3Uuid)"; TypedQuery<String> q = dbf.getEntityManager().createQuery(sql, String.class); q.setParameter("vipL3Uuid", publicNic.getL3NetworkUuid()); q.setParameter("guestL3Uuid", l3Uuids); q.setParameter("vmState", VmInstanceState.Running); return q.getResultList(); } }.call());
@Override @Transactional(readOnly = true) public FusionstorPrimaryStorageVO call() { String sql = "select pri from FusionstorPrimaryStorageVO pri, ImageCacheVO c where pri.uuid = c.primaryStorageUuid" + " and c.imageUuid = :imgUuid"; TypedQuery<FusionstorPrimaryStorageVO> q = dbf.getEntityManager().createQuery(sql, FusionstorPrimaryStorageVO.class); q.setParameter("imgUuid", to.getImageUuid()); return q.getSingleResult(); } }.call();
@Override protected VolumeVO scripts() { dbf.getEntityManager().persist(finalVo1); dbf.getEntityManager().flush(); dbf.getEntityManager().refresh(finalVo1); tagMgr.createTagsFromAPICreateMessage(msg, finalVo1.getUuid(), VolumeVO.class.getSimpleName()); return finalVo1; } }.execute();
@Override @Transactional(readOnly = true) public List<String> call() { String sql = "select eip.uuid from EipVO eip, VipVO vip, VmNicVO nic, VmInstanceVO vm where vm.uuid = nic.vmInstanceUuid and vm.state = :vmState and eip.vipUuid = vip.uuid and eip.vmNicUuid = nic.uuid and vip.l3NetworkUuid = :vipL3Uuid and nic.l3NetworkUuid in (:guestL3Uuid)"; TypedQuery<String> q = dbf.getEntityManager().createQuery(sql, String.class); q.setParameter("vipL3Uuid", publicNic.getL3NetworkUuid()); q.setParameter("guestL3Uuid", guestNics.stream().map(n -> n.getL3NetworkUuid()).collect(Collectors.toList())); q.setParameter("vmState", VmInstanceState.Running); return q.getResultList(); } }.call();
@Transactional private void cleanup() { Integer expiredPeriod = RestGlobalConfig.COMPLETED_API_EXPIRED_PERIOD.value(Integer.class); String sql = "DELETE FROM AsyncRestVO vo WHERE vo.state = :state and vo.createDate < :date"; Query q = dbf.getEntityManager().createQuery(sql); q.setParameter("state", AsyncRestState.done); q.setParameter("date", new Timestamp(getCurrentSqlTime().getTime() - expiredPeriod * 1000L)); q.executeUpdate(); } });
@Override @Transactional public L3NetworkInventory createL3Network(L3NetworkVO l3vo, APICreateL3NetworkMsg msg) { l3vo.setType(type.toString()); dbf.getEntityManager().persist(l3vo); dbf.getEntityManager().flush(); dbf.getEntityManager().refresh(l3vo); return L3NetworkInventory.valueOf(l3vo); }
@Transactional private void removeNicFromDb(List<VmNicInventory> nics) { dbf.entityForTranscationCallback(TransactionalCallback.Operation.REMOVE, VmNicVO.class); List<String> uuids = new ArrayList<String>(nics.size()); for (VmNicInventory nic : nics) { uuids.add(nic.getUuid()); } String sql = "delete from VmNicVO v where v.uuid in (:uuids)"; Query q = dbf.getEntityManager().createQuery(sql); q.setParameter("uuids", uuids); q.executeUpdate(); }
@Transactional private VolumeSnapshotStruct saveIndividualTypeSnapshot(VolumeSnapshotVO vo) { String sql = "update VolumeSnapshotTreeVO tree" + " set tree.current = false" + " where tree.current = true" + " and tree.volumeUuid = :volUuid"; Query q = dbf.getEntityManager().createQuery(sql); q.setParameter("volUuid", vo.getVolumeUuid()); q.executeUpdate(); return newChain(vo, false); }
@Transactional(readOnly = true) long count() { String jpql = build(true); Query q = dbf.getEntityManager().createQuery(jpql); if (logger.isTraceEnabled()) { org.hibernate.Query hq = q.unwrap(org.hibernate.Query.class); logger.trace(hq.getQueryString()); } setQueryValue(q, root); return (Long) q.getSingleResult(); } }