@Override protected void addAdditionalCriteriaOptions(Criteria criteria, Page page, boolean doOrder) { // we join table node, to be able eto sort by node.label criteria.setAliases(Arrays.asList(new Alias[] { new Alias("node", "node", JoinType.LEFT_JOIN) })); }
public final AliasBuilder alias(final Alias alias) { Alias existing = m_aliases.get(alias.getAlias()); if (existing == null) { m_aliases.put(alias.getAlias(), alias); } else { if (alias.hasJoinCondition()) { if (existing.hasJoinCondition()) { // Combine the JOIN conditions LOG.debug("alias '{}' already associated with associationPath '{}', appending join condition.", alias.getAlias(), alias.getAssociationPath()); existing.setJoinCondition(Restrictions.and(existing.getJoinCondition(), alias.getJoinCondition())); } else { LOG.debug("alias '{}' already associated with associationPath '{}', adding join condition.", alias.getAlias(), alias.getAssociationPath()); existing.setJoinCondition(alias.getJoinCondition()); } } else { LOG.debug("alias '{}' already associated with associationPath '{}', skipping.", alias.getAlias(), alias.getAssociationPath()); } } return this; }
public final AliasBuilder alias(final String associationPath, final String alias, final JoinType type, final Restriction joinCondition) { Alias existing = m_aliases.get(alias); if (existing == null) { if (joinCondition == null) { m_aliases.put(alias, new Alias(associationPath, alias, type)); } else { m_aliases.put(alias, new Alias(associationPath, alias, type, joinCondition)); } } else { if (joinCondition == null) { LOG.debug("alias '{}' already associated with associationPath '{}', skipping.", alias, associationPath); } else { if (existing.hasJoinCondition()) { // Combine the JOIN conditions LOG.debug("alias '{}' already associated with associationPath '{}', appending join condition.", alias, associationPath); existing.setJoinCondition(Restrictions.and(existing.getJoinCondition(), joinCondition)); } else { LOG.debug("alias '{}' already associated with associationPath '{}', adding join condition.", alias, associationPath); existing.setJoinCondition(joinCondition); } } } return this; }
@Override public void visitAlias(final Alias alias) { int aliasType = 0; switch (alias.getType()) { case FULL_JOIN: aliasType = org.hibernate.Criteria.FULL_JOIN; break; case LEFT_JOIN: aliasType = org.hibernate.Criteria.LEFT_JOIN; break; case INNER_JOIN: aliasType = org.hibernate.Criteria.INNER_JOIN; break; default: aliasType = org.hibernate.Criteria.INNER_JOIN; break; } if (alias.hasJoinCondition()) { // an additional condition for the join final HibernateRestrictionVisitor visitor = new HibernateRestrictionVisitor(); alias.getJoinCondition().visit(visitor); m_criteria.createAlias(alias.getAssociationPath(), alias.getAlias(), aliasType, visitor.getCriterions().get(0)); } else { // no additional condition for the join m_criteria.createAlias(alias.getAssociationPath(), alias.getAlias(), aliasType); } }
while (aliasIterator.hasNext()) { final Alias alias = aliasIterator.next(); if (alias.getAlias().equals(alias.getAssociationPath())) { if (alias.getAlias().equals(pathElement)) { aliasIterator.remove(); final String associationPath = alias.getAssociationPath();
private Alias alias = new Alias(); line = scanner.nextLine(); try { gameData = alias.parseUserInput(line); } catch (StringIndexOutOfBoundsException e) { log.fine(e.toString());
public final AliasBuilder alias(final String associationPath, final String alias, final JoinType type, final Restriction joinCondition) { Alias existing = m_aliases.get(alias); if (existing == null) { if (joinCondition == null) { m_aliases.put(alias, new Alias(associationPath, alias, type)); } else { m_aliases.put(alias, new Alias(associationPath, alias, type, joinCondition)); } } else { if (joinCondition == null) { LOG.debug("alias '{}' already associated with associationPath '{}', skipping.", alias, associationPath); } else { if (existing.hasJoinCondition()) { // Combine the JOIN conditions LOG.debug("alias '{}' already associated with associationPath '{}', appending join condition.", alias, associationPath); existing.setJoinCondition(Restrictions.and(existing.getJoinCondition(), joinCondition)); } else { LOG.debug("alias '{}' already associated with associationPath '{}', adding join condition.", alias, associationPath); existing.setJoinCondition(joinCondition); } } } return this; }
while (aliasIterator.hasNext()) { final Alias alias = aliasIterator.next(); if (alias.getAlias().equals(alias.getAssociationPath())) { if (alias.getAlias().equals(pathElement)) { aliasIterator.remove(); final String associationPath = alias.getAssociationPath();
@Override protected void addAdditionalCriteriaOptions(Criteria criteria, Page page, boolean doOrder) { // we join table node, to be able eto sort by node.label criteria.setAliases(Arrays.asList(new Alias[] { new Alias("node", "node", JoinType.LEFT_JOIN) })); }
public final AliasBuilder alias(final Alias alias) { Alias existing = m_aliases.get(alias.getAlias()); if (existing == null) { m_aliases.put(alias.getAlias(), alias); } else { if (alias.hasJoinCondition()) { if (existing.hasJoinCondition()) { // Combine the JOIN conditions LOG.debug("alias '{}' already associated with associationPath '{}', appending join condition.", alias.getAlias(), alias.getAssociationPath()); existing.setJoinCondition(Restrictions.and(existing.getJoinCondition(), alias.getJoinCondition())); } else { LOG.debug("alias '{}' already associated with associationPath '{}', adding join condition.", alias.getAlias(), alias.getAssociationPath()); existing.setJoinCondition(alias.getJoinCondition()); } } else { LOG.debug("alias '{}' already associated with associationPath '{}', skipping.", alias.getAlias(), alias.getAssociationPath()); } } return this; }
if (alias.getAlias().equalsIgnoreCase(attribute)) { if (pd.getName().equalsIgnoreCase(alias.getAssociationPath())) { return m_beanWrapper.getPropertyValue(pd.getName()); final String aliasName = alias.getAlias(); final String aliasPath = alias.getAssociationPath();
@Override protected void addAdditionalCriteriaOptions(Criteria criteria, Page page, boolean doOrder) { if (!doOrder) return; // We join the ipInterfaces table, to be able to sort on ipInterfaces.ipAddress. criteria.setAliases(Arrays.asList(new Alias[] { new Alias("ipInterfaces", "ipInterfaces", Alias.JoinType.LEFT_JOIN, new EqRestriction("ipInterfaces.isSnmpPrimary", PrimaryType.PRIMARY)) })); }
if (alias.getAlias().equalsIgnoreCase(attribute)) { if (pd.getName().equalsIgnoreCase(alias.getAssociationPath())) { return m_beanWrapper.getPropertyValue(pd.getName()); final String aliasName = alias.getAlias(); final String aliasPath = alias.getAssociationPath();
@Override protected void addAdditionalCriteriaOptions(Criteria criteria, Page page, boolean doOrder) { if (!doOrder) return; // We join the ipInterfaces table, to be able to sort on ipInterfaces.ipAddress. criteria.setAliases(Arrays.asList(new Alias[] { new Alias("ipInterfaces", "ipInterfaces", Alias.JoinType.LEFT_JOIN, new EqRestriction("ipInterfaces.isSnmpPrimary", PrimaryType.PRIMARY)) })); }
@Override public List<String[]> getNodeServices(int nodeId){ final LinkedList<String[]> servicemap = new LinkedList<>(); Criteria criteria = new Criteria(OnmsMonitoredService.class); criteria.setAliases(Arrays.asList(new Alias[] { new Alias("ipInterface", "ipInterface", JoinType.LEFT_JOIN), new Alias("ipInterface.node", "node", JoinType.LEFT_JOIN) })); criteria.addRestriction(new EqRestriction("node.id", nodeId)); criteria.addRestriction(new NeRestriction("status", "F")); // Ignore forced-unmanaged for (OnmsMonitoredService service : m_monitoredServiceDao.findMatching(criteria)) { servicemap.add(new String[] { service.getIpAddressAsString(), service.getServiceName() }); } return servicemap; }
@Override public List<OnmsNode> findByIpAddressAndService(InetAddress ipAddress, String serviceName) { final org.opennms.core.criteria.Criteria criteria = new org.opennms.core.criteria.Criteria(OnmsNode.class) .setAliases(Arrays.asList(new Alias[] { new Alias("ipInterfaces","ipInterfaces", JoinType.LEFT_JOIN), new Alias("ipInterfaces.monitoredServices","monitoredServices", JoinType.LEFT_JOIN), new Alias("monitoredServices.serviceType","serviceType", JoinType.LEFT_JOIN) })) .addRestriction(new EqRestriction("ipInterfaces.ipAddress", ipAddress)) //TODO: Replace D with a constant .addRestriction(new NeRestriction("ipInterfaces.isManaged", "D")) .addRestriction(new EqRestriction("serviceType.name", serviceName)) .setOrders(Arrays.asList(new Order[] { Order.desc("id") })); return findMatching(criteria); }
protected InetAddress getNodeIpAddress(OnmsNode node) { final Criteria criteria = new Criteria(OnmsIpInterface.class) .setAliases(Arrays.asList(new Alias[] { new Alias("node", "node", JoinType.LEFT_JOIN) })) .addRestriction(new EqRestriction("node.id", node.getId())); List<OnmsIpInterface> matchingIfaces = getIpInterfaceDao().findMatching(criteria); return matchingIfaces.get(0).getIpAddress(); }
Criteria criteria = new Criteria(OnmsHwEntity.class) .setAliases(Arrays.asList(new Alias[] { new Alias("node","node", JoinType.LEFT_JOIN), })) .addRestriction(new EqRestriction("node.id", (int)nodeId))
Criteria criteria = new Criteria(OnmsHwEntity.class) .setAliases(Arrays.asList(new Alias[] { new Alias("node","node", JoinType.LEFT_JOIN), })) .addRestriction(new EqRestriction("node.id", (int)nodeId))