public CriteriaBuilder alias(final String associationPath, final String alias) { return alias(associationPath, alias, JoinType.LEFT_JOIN); }
public CriteriaBuilder createAlias(final String associationPath, final String alias) { return alias(associationPath, alias); }
public CriteriaBuilder alias(final String associationPath, final String alias, final JoinType type) { return alias(associationPath, alias, type, null); }
public CriteriaBuilder join(final String associationPath, final String alias) { return alias(associationPath, alias, JoinType.LEFT_JOIN); }
public CriteriaBuilder join(final String associationPath, final String alias, final JoinType type) { return alias(associationPath, alias, type); }
public CriteriaBuilder join(final String associationPath, final String alias, final JoinType type) { return alias(associationPath, alias, type); }
public CriteriaBuilder createAlias(final String associationPath, final String alias) { return alias(associationPath, alias); }
public CriteriaBuilder join(final String associationPath, final String alias) { return alias(associationPath, alias, JoinType.LEFT_JOIN); }
public CriteriaBuilder alias(final String associationPath, final String alias) { return alias(associationPath, alias, JoinType.LEFT_JOIN); }
public CriteriaBuilder alias(final String associationPath, final String alias, final JoinType type) { return alias(associationPath, alias, type, null); }
private int getNumServices(int nodeId, List<String> serviceNames) { final CriteriaBuilder builder = new CriteriaBuilder(OnmsMonitoredService.class) .alias("ipInterface", "ipInterface") .alias("ipInterface.node", "node") .eq("ipInterface.isManaged", "M") .eq("node.id", nodeId); if (serviceNames != null && serviceNames.size() > 0) { builder.alias("serviceType", "serviceType") .in("serviceType.name", serviceNames); } // Retrieve the services and group them by node id return m_monitoredServiceDao.countMatching(builder.toCriteria()); }
public OnmsAlarm getAlarm(int nodeId) { CriteriaBuilder builder = new CriteriaBuilder(OnmsAlarm.class); builder.alias("node", "node"); builder.ne("severity", OnmsSeverity.CLEARED); builder.orderBy("severity").desc(); builder.eq("node.id", nodeId); builder.limit(Integer.valueOf(1)); List<OnmsAlarm> alarms = alarmDao.findMatching(builder.toCriteria()); return alarms == null || alarms.isEmpty() ? null : alarms.get(0); } }
public OnmsAlarm getAlarm(int nodeId) { CriteriaBuilder builder = new CriteriaBuilder(OnmsAlarm.class); builder.alias("node", "node"); builder.ne("severity", OnmsSeverity.CLEARED); builder.orderBy("severity").desc(); builder.eq("node.id", nodeId); builder.limit(Integer.valueOf(1)); List<OnmsAlarm> alarms = alarmDao.findMatching(builder.toCriteria()); return alarms == null || alarms.isEmpty() ? null : alarms.get(0); } }
@Override public List<OnmsNode> findAllByVarCharAssetColumn(final String columnName, final String columnValue) { final CriteriaBuilder builder = new CriteriaBuilder(OnmsNode.class); builder.alias("assetRecord", "assets"); builder.eq("assets." + columnName, columnValue); return findMatching(builder.toCriteria()); }
@Override public Rule findByDefinition(Rule rule, Group group) { Objects.requireNonNull(rule); Objects.requireNonNull(group); CriteriaBuilder criteriaBuilder = createCriteriaBuilderDefinition(rule); criteriaBuilder.alias("group", "group"); criteriaBuilder.eq("group.id", group.getId()); // Exclude me, otherwise it will always at least return the rule if (rule.getId() != null) { criteriaBuilder.not().eq("id", rule.getId()); } final List<Rule> matchingRules = findMatching(criteriaBuilder.toCriteria()); return matchingRules.isEmpty() ? null : matchingRules.get(0); }
@Override public List<OnmsNode> findAllByVarCharAssetColumn(final String columnName, final String columnValue) { final CriteriaBuilder builder = new CriteriaBuilder(OnmsNode.class); builder.alias("assetRecord", "assets"); builder.eq("assets." + columnName, columnValue); return findMatching(builder.toCriteria()); }
@Override public List<Rule> findAllEnabledRules() { return findMatching( new CriteriaBuilder(Rule.class) .alias("group", "group") .eq("group.enabled", true) .toCriteria()); }
@Override public void deleteRules(int groupId) { CriteriaBuilder criteriaBuilder = new CriteriaBuilder(Rule.class).alias("group", "group"); criteriaBuilder.eq("group.id", groupId); runInTransaction(status -> { final Criteria criteria = criteriaBuilder.toCriteria(); classificationRuleDao.findMatching(criteria).forEach(r -> classificationRuleDao.delete(r)); classificationEngine.reload(); return null; }); }
/** {@inheritDoc} */ @Override public List<OnmsSnmpInterface> get(int nodeId, String criteria) { CriteriaBuilder builder = new CriteriaBuilder(OnmsSnmpInterface.class); builder.sql(criteria).eq("node.id", nodeId).eq("poll", "P"); builder.alias("ipInterfaces", "ipInterface", JoinType.LEFT_JOIN); return getSnmpInterfaceDao().findMatching(builder.toCriteria()); }
private List<OnmsNode> getNodes(GeolocationQuery query) { CriteriaBuilder criteriaBuilder = new CriteriaBuilder(OnmsNode.class) .alias("assetRecord", "assetRecord") .and( Restrictions.isNotNull("assetRecord"), Restrictions.isNotNull("assetRecord.geolocation") ); if (query.getLocation() != null) { criteriaBuilder.and(Restrictions.eq("location", query.getLocation())); } if (!query.getNodeIds().isEmpty()) { criteriaBuilder.in("id", query.getNodeIds()); } return genericPersistenceAccessor.findMatching(criteriaBuilder.toCriteria()); }