@Override public UserStatisticsVO lock(long accountId, long dcId, long networkId, String publicIp, Long deviceId, String deviceType) { SearchCriteria<UserStatisticsVO> sc = AllFieldsSearch.create(); sc.setParameters("account", accountId); sc.setParameters("dc", dcId); sc.setParameters("network", networkId); sc.setParameters("ip", publicIp); sc.setParameters("device", deviceId); sc.setParameters("deviceType", deviceType); return lockOneRandomRow(sc, true); }
protected List<IPAddressVO> listPublicIpsAssignedToVpc(final long accountId, final Boolean sourceNat, final long vpcId) { final SearchCriteria<IPAddressVO> sc = IpAddressSearch.create(); sc.setParameters("accountId", accountId); sc.setParameters("vpcId", vpcId); if (sourceNat != null) { sc.addAnd("sourceNat", SearchCriteria.Op.EQ, sourceNat); } sc.setJoinParameters("virtualNetworkVlanSB", "vlanType", VlanType.VirtualNetwork); return _ipAddressDao.search(sc, null); }
@Override public List<EngineDataCenterVO> findChildZones(Object[] ids, String keyword) { SearchCriteria<EngineDataCenterVO> sc = ChildZonesSearch.create(); sc.setParameters("domainid", ids); if (keyword != null) { SearchCriteria<EngineDataCenterVO> ssc = createSearchCriteria(); ssc.addOr("name", SearchCriteria.Op.LIKE, "%" + keyword + "%"); ssc.addOr("description", SearchCriteria.Op.LIKE, "%" + keyword + "%"); sc.addAnd("name", SearchCriteria.Op.SC, ssc); } return listBy(sc); }
@Override public SecurityGroupRuleVO findByProtoPortsAndAllowedGroupId(long securityGroupId, String proto, int startPort, int endPort, Long allowedGroupId) { SearchCriteria<SecurityGroupRuleVO> sc = protoPortsAndSecurityGroupIdSearch.create(); sc.addAnd("securityGroupId", SearchCriteria.Op.EQ, securityGroupId); sc.setParameters("proto", proto); sc.setParameters("startPort", startPort); sc.setParameters("endPort", endPort); sc.setParameters("allowedNetworkId", allowedGroupId); return findOneIncludingRemovedBy(sc); }
@Override public List<NetworkVO> listNetworksByAccount(final long accountId, final long zoneId, final Network.GuestType type, final boolean isSystem) { final SearchCriteria<NetworkVO> sc = OfferingAccountNetworkSearch.create(); sc.setJoinParameters("ntwkOfferingSearch", "isSystem", isSystem); sc.setJoinParameters("ntwkAccountSearch", "accountId", accountId); sc.setParameters("zoneId", zoneId); sc.setParameters("type", type); final List<NetworkVO> networks = search(sc, null); return networks; }
@Override public void remove(long loadBalancerId, long instanceId, String instanceIp, Boolean revoke) { SearchCriteria<LoadBalancerVMMapVO> sc = createSearchCriteria(); sc.addAnd("loadBalancerId", SearchCriteria.Op.EQ, loadBalancerId); sc.addAnd("instanceId", SearchCriteria.Op.IN, instanceId); sc.addAnd("instanceIp", SearchCriteria.Op.EQ, instanceIp); if (revoke != null) { sc.addAnd("revoke", SearchCriteria.Op.EQ, revoke); } expunge(sc); }
@Override public List<NetworkVO> listBy(final long accountId, final long dataCenterId, final String cidr, final boolean skipVpc) { final SearchCriteria<NetworkVO> sc = AccountSearch.create(); sc.setJoinParameters("accounts", "account", accountId); sc.setParameters("datacenter", dataCenterId); sc.setParameters("cidr", cidr); if (skipVpc) { sc.setParameters("vpcId", (Object)null); } return listBy(sc); }
@Override public void remove(long loadBalancerId, List<Long> instanceIds, Boolean revoke) { SearchCriteria<LoadBalancerVMMapVO> sc = createSearchCriteria(); sc.addAnd("loadBalancerId", SearchCriteria.Op.EQ, loadBalancerId); sc.addAnd("instanceId", SearchCriteria.Op.IN, instanceIds.toArray()); if (revoke != null) { sc.addAnd("revoke", SearchCriteria.Op.EQ, revoke); } expunge(sc); }
private SearchCriteria<ExternalPublicIpStatisticsVO> getSingleRowSc(long accountId, long zoneId, String publicIpAddress) { SearchCriteria<ExternalPublicIpStatisticsVO> sc = SingleRowSearch.create(); sc.setParameters("accountId", accountId); sc.setParameters("zoneId", zoneId); sc.setParameters("publicIp", publicIpAddress); return sc; }
@Override public List<VMTemplateHostVO> listByZoneTemplate(long dcId, long templateId, boolean readyOnly) { SearchCriteria<VMTemplateHostVO> sc = ZoneTemplateSearch.create(); sc.setParameters("template_id", templateId); sc.setJoinParameters("tmplHost", "zone_id", dcId); if (readyOnly) { sc.setParameters("state", VMTemplateHostVO.Status.DOWNLOADED); } return listBy(sc); }
@Override public List<IPAddressVO> listPublicIpsAssignedToGuestNtwk(long accountId, long associatedNetworkId, Boolean sourceNat) { SearchCriteria<IPAddressVO> sc = IpAddressSearch.create(); sc.setParameters("accountId", accountId); sc.setParameters("associatedWithNetworkId", associatedNetworkId); if (sourceNat != null) { sc.addAnd("sourceNat", SearchCriteria.Op.EQ, sourceNat); } sc.setJoinParameters("virtualNetworkVlanSB", "vlanType", VlanType.VirtualNetwork); return _ipAddressDao.search(sc, null); }
@Override public List<DataCenterVO> findZonesByDomainId(Long domainId, String keyword) { SearchCriteria<DataCenterVO> sc = ListZonesByDomainIdSearch.create(); sc.setParameters("domainId", domainId); if (keyword != null) { SearchCriteria<DataCenterVO> ssc = createSearchCriteria(); ssc.addOr("name", SearchCriteria.Op.LIKE, "%" + keyword + "%"); ssc.addOr("description", SearchCriteria.Op.LIKE, "%" + keyword + "%"); sc.addAnd("name", SearchCriteria.Op.SC, ssc); } return listBy(sc); }
private List<NetworkVO> listAccountSpecificNetworks(SearchCriteria<NetworkVO> sc, Filter searchFilter, List<Long> permittedAccounts) { SearchCriteria<NetworkVO> accountSC = _networksDao.createSearchCriteria(); if (!permittedAccounts.isEmpty()) { accountSC.addAnd("accountId", SearchCriteria.Op.IN, permittedAccounts.toArray()); } accountSC.addAnd("aclType", SearchCriteria.Op.EQ, ACLType.Account.toString()); sc.addAnd("id", SearchCriteria.Op.SC, accountSC); return _networksDao.search(sc, searchFilter); }
@Override public List<HostVO> listByDataCenterId(long id) { SearchCriteria<HostVO> sc = DcSearch.create(); sc.setParameters("dc", id); sc.setParameters("status", Status.Up); sc.setParameters("type", Host.Type.Routing); sc.setParameters("resourceState", ResourceState.Enabled); return listBy(sc); }
@Override public AffinityGroupVO findDomainLevelGroupByName(Long domainId, String affinityGroupName) { SearchCriteria<AffinityGroupVO> sc = DomainLevelNameSearch.create(); sc.setParameters("aclType", ControlledEntity.ACLType.Domain); sc.setParameters("name", affinityGroupName); sc.setJoinParameters("domainMapSearch", "domainId", domainId); return findOneBy(sc); }
@Override public List<IPAddressVO> listPublicIpsAssignedToAccount(long accountId, long dcId, Boolean sourceNat) { SearchCriteria<IPAddressVO> sc = IpAddressSearch.create(); sc.setParameters("accountId", accountId); sc.setParameters("dataCenterId", dcId); if (sourceNat != null) { sc.addAnd("sourceNat", SearchCriteria.Op.EQ, sourceNat); } sc.setJoinParameters("virtualNetworkVlanSB", "vlanType", VlanType.VirtualNetwork); return _ipAddressDao.search(sc, null); }
@Override public List<DataCenterVO> findChildZones(Object[] ids, String keyword) { SearchCriteria<DataCenterVO> sc = ChildZonesSearch.create(); sc.setParameters("domainid", ids); if (keyword != null) { SearchCriteria<DataCenterVO> ssc = createSearchCriteria(); ssc.addOr("name", SearchCriteria.Op.LIKE, "%" + keyword + "%"); ssc.addOr("description", SearchCriteria.Op.LIKE, "%" + keyword + "%"); sc.addAnd("name", SearchCriteria.Op.SC, ssc); } return listBy(sc); }
@Override public List<AlertVO> listOlderAlerts(Date oldTime) { if (oldTime == null) return null; SearchCriteria<AlertVO> sc = createSearchCriteria(); sc.addAnd("createdDate", SearchCriteria.Op.LT, oldTime); sc.addAnd("archived", SearchCriteria.Op.EQ, false); return listIncludingRemovedBy(sc, null); }
@Override public List<DomainRouterVO> findBy(final long accountId, final long dcId, final Role role) { final SearchCriteria<DomainRouterVO> sc = AllFieldsSearch.create(); sc.setParameters("account", accountId); sc.setParameters("dc", dcId); sc.setParameters("role", role); return listBy(sc); }
@Override public AffinityGroupVO findDomainLevelGroupByType(Long domainId, String type) { SearchCriteria<AffinityGroupVO> sc = DomainLevelTypeSearch.create(); sc.setParameters("aclType", ControlledEntity.ACLType.Domain); sc.setParameters("type", type); sc.setJoinParameters("domainTypeSearch", "domainId", domainId); return findOneBy(sc); } }