| // Licensed to the Apache Software Foundation (ASF) under one |
| // or more contributor license agreements. See the NOTICE file |
| // distributed with this work for additional information |
| // regarding copyright ownership. The ASF licenses this file |
| // to you under the Apache License, Version 2.0 (the |
| // "License"); you may not use this file except in compliance |
| // with the License. You may obtain a copy of the License at |
| // |
| // http://www.apache.org/licenses/LICENSE-2.0 |
| // |
| // Unless required by applicable law or agreed to in writing, |
| // software distributed under the License is distributed on an |
| // "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| // KIND, either express or implied. See the License for the |
| // specific language governing permissions and limitations |
| // under the License. |
| package com.cloud.dc.dao; |
| |
| import com.cloud.dc.ASNumberVO; |
| import com.cloud.user.Account; |
| import com.cloud.utils.Pair; |
| import com.cloud.utils.db.Filter; |
| import com.cloud.utils.db.GenericDaoBase; |
| import com.cloud.utils.db.SearchBuilder; |
| import com.cloud.utils.db.SearchCriteria; |
| |
| import java.util.Arrays; |
| import java.util.List; |
| |
| public class ASNumberDaoImpl extends GenericDaoBase<ASNumberVO, Long> implements ASNumberDao { |
| |
| private final SearchBuilder<ASNumberVO> asNumberSearch; |
| |
| public ASNumberDaoImpl() { |
| asNumberSearch = createSearchBuilder(); |
| asNumberSearch.and("zoneId", asNumberSearch.entity().getDataCenterId(), SearchCriteria.Op.EQ); |
| asNumberSearch.and("rangeId", asNumberSearch.entity().getAsNumberRangeId(), SearchCriteria.Op.EQ); |
| asNumberSearch.and("isAllocated", asNumberSearch.entity().isAllocated(), SearchCriteria.Op.EQ); |
| asNumberSearch.and("asNumber", asNumberSearch.entity().getAsNumber(), SearchCriteria.Op.EQ); |
| asNumberSearch.and("networkId", asNumberSearch.entity().getNetworkId(), SearchCriteria.Op.EQ); |
| asNumberSearch.and("vpcId", asNumberSearch.entity().getVpcId(), SearchCriteria.Op.EQ); |
| asNumberSearch.and("accountId", asNumberSearch.entity().getAccountId(), SearchCriteria.Op.EQ); |
| asNumberSearch.and("domainId", asNumberSearch.entity().getDomainId(), SearchCriteria.Op.EQ); |
| asNumberSearch.done(); |
| } |
| |
| @Override |
| public Pair<List<ASNumberVO>, Integer> searchAndCountByZoneOrRangeOrAllocated(Long zoneId, Long asnRangeId, |
| Integer asNumber, Long networkId, Long vpcId, |
| Boolean allocated, |
| Long accountId, Long domainId, |
| String keyword, Account caller, |
| Long startIndex, Long pageSizeVal) { |
| SearchCriteria<ASNumberVO> sc = asNumberSearch.create(); |
| if (zoneId != null) { |
| sc.setParameters("zoneId", zoneId); |
| } |
| if (asnRangeId != null) { |
| sc.setParameters("rangeId", asnRangeId); |
| } |
| if (networkId != null) { |
| sc.setParameters("networkId", networkId); |
| } |
| if (vpcId != null) { |
| sc.setParameters("vpcId", vpcId); |
| } |
| if (allocated != null) { |
| sc.setParameters("isAllocated", allocated); |
| } |
| if (asNumber != null) { |
| sc.setParameters("asNumber", asNumber); |
| } |
| if (accountId != null) { |
| sc.setParameters("accountId", accountId); |
| } |
| if (domainId != null) { |
| sc.setParameters("domainId", domainId); |
| } |
| if (keyword != null) { |
| sc.addAnd("asNumber", SearchCriteria.Op.LIKE, "%" + keyword + "%"); |
| } |
| if (Arrays.asList(Account.Type.DOMAIN_ADMIN, Account.Type.RESOURCE_DOMAIN_ADMIN).contains(caller.getType())) { |
| SearchCriteria<ASNumberVO> scc = asNumberSearch.create(); |
| scc.addOr("domainId", SearchCriteria.Op.NULL); |
| scc.addOr("domainId", SearchCriteria.Op.EQ, caller.getDomainId()); |
| sc.addAnd("domainId", SearchCriteria.Op.SC, scc); |
| } else if (Arrays.asList(Account.Type.NORMAL, Account.Type.PROJECT).contains(caller.getType())) { |
| SearchCriteria<ASNumberVO> scc = asNumberSearch.create(); |
| scc.addOr("domainId", SearchCriteria.Op.NULL); |
| scc.addOr("accountId", SearchCriteria.Op.EQ, caller.getAccountId()); |
| sc.addAnd("domainId", SearchCriteria.Op.SC, scc); |
| } |
| Filter searchFilter = new Filter(ASNumberVO.class, "id", true, startIndex, pageSizeVal); |
| return searchAndCount(sc, searchFilter); |
| } |
| |
| @Override |
| public ASNumberVO findByAsNumber(Long asNumber) { |
| SearchCriteria<ASNumberVO> sc = asNumberSearch.create(); |
| sc.setParameters("asNumber", asNumber); |
| return findOneBy(sc); |
| } |
| |
| @Override |
| public ASNumberVO findOneByAllocationStateAndZone(long zoneId, boolean allocated) { |
| SearchCriteria<ASNumberVO> sc = asNumberSearch.create(); |
| sc.setParameters("zoneId", zoneId); |
| sc.setParameters("isAllocated", allocated); |
| return findOneBy(sc); |
| } |
| |
| @Override |
| public List<ASNumberVO> listAllocatedByASRange(Long asRangeId) { |
| SearchCriteria<ASNumberVO> sc = asNumberSearch.create(); |
| sc.setParameters("rangeId", asRangeId); |
| sc.setParameters("isAllocated", true); |
| return listBy(sc); |
| } |
| |
| public ASNumberVO findByZoneAndNetworkId(long zoneId, long networkId) { |
| SearchCriteria<ASNumberVO> sc = asNumberSearch.create(); |
| sc.setParameters("zoneId", zoneId); |
| sc.setParameters("networkId", networkId); |
| return findOneBy(sc); |
| } |
| |
| @Override |
| public ASNumberVO findByZoneAndVpcId(long zoneId, long vpcId) { |
| SearchCriteria<ASNumberVO> sc = asNumberSearch.create(); |
| sc.setParameters("zoneId", zoneId); |
| sc.setParameters("vpcId", vpcId); |
| return findOneBy(sc); |
| } |
| |
| @Override |
| public int removeASRangeNumbers(long rangeId) { |
| SearchCriteria<ASNumberVO> sc = asNumberSearch.create(); |
| sc.setParameters("rangeId", rangeId); |
| return remove(sc); |
| } |
| } |