@Override public long countRoutesByGateway(long gatewayId) { SearchCriteria<Long> sc = RoutesByGatewayCount.create(); sc.setParameters("gatewayId", gatewayId); return customSearch(sc, null).get(0); }
@Override public List<StaticRouteVO> listByVpcId(long vpcId) { SearchCriteria<StaticRouteVO> sc = AllFieldsSearch.create(); sc.setParameters("vpcId", vpcId); return listBy(sc); }
@Override public boolean setStateToAdd(StaticRouteVO rule) { SearchCriteria<StaticRouteVO> sc = AllFieldsSearch.create(); sc.setParameters("id", rule.getId()); sc.setParameters("state", StaticRoute.State.Staged); rule.setState(StaticRoute.State.Add); return update(rule, sc) > 0; }
@Override @DB public boolean remove(Long id) { TransactionLegacy txn = TransactionLegacy.currentTxn(); txn.start(); StaticRouteVO entry = findById(id); if (entry != null) { _tagsDao.removeByIdAndType(id, ResourceObjectType.StaticRoute); } boolean result = super.remove(id); txn.commit(); return result; } }
protected StaticRouteDaoImpl() { super(); AllFieldsSearch = createSearchBuilder(); AllFieldsSearch.and("gatewayId", AllFieldsSearch.entity().getVpcGatewayId(), Op.EQ); AllFieldsSearch.and("vpcId", AllFieldsSearch.entity().getVpcId(), Op.EQ); AllFieldsSearch.and("state", AllFieldsSearch.entity().getState(), Op.EQ); AllFieldsSearch.and("id", AllFieldsSearch.entity().getId(), Op.EQ); AllFieldsSearch.done(); NotRevokedSearch = createSearchBuilder(); NotRevokedSearch.and("vpcId", NotRevokedSearch.entity().getVpcId(), Op.EQ); NotRevokedSearch.and("state", NotRevokedSearch.entity().getState(), Op.NEQ); NotRevokedSearch.done(); RoutesByGatewayCount = createSearchBuilder(Long.class); RoutesByGatewayCount.select(null, Func.COUNT, RoutesByGatewayCount.entity().getId()); RoutesByGatewayCount.and("gatewayId", RoutesByGatewayCount.entity().getVpcGatewayId(), Op.EQ); RoutesByGatewayCount.done(); }
@Override public List<? extends StaticRoute> listByVpcIdAndNotRevoked(long vpcId) { SearchCriteria<StaticRouteVO> sc = NotRevokedSearch.create(); sc.setParameters("vpcId", vpcId); sc.setParameters("state", StaticRoute.State.Revoke); return listBy(sc); }