@SuppressWarnings({"rawtypes", "unchecked"}) public static FilterConditionContext visit( In obj, QueryBuilder queryBuilder, FilterConditionBeginContext fcbc) throws TranslatorException { LogManager.logTrace(LogConstants.CTX_CONNECTOR, "Parsing IN criteria."); // $NON-NLS-1$ Expression lhs = obj.getLeftExpression(); List<Expression> rhsList = obj.getRightExpressions(); List v = new ArrayList(rhsList.size()); // = Arrays.asList(1 boolean createdQuery = false; for (Expression expr : rhsList) { if (expr instanceof Literal) { Literal literal = (Literal) expr; Object value = escapeReservedChars(literal.getValue()); v.add(value); createdQuery = true; } else { throw new TranslatorException( InfinispanPlugin.Util.gs(InfinispanPlugin.Event.TEIID25052, new Object[] {expr, "IN"})); } } if (createdQuery) { Column col = ((ColumnReference) lhs).getMetadataObject(); if (fcbc == null) { if (obj.isNegated()) { return queryBuilder.not().having(col.getSourceName()).in(v); } return queryBuilder.having(col.getSourceName()).in(v); } if (obj.isNegated()) { return fcbc.not().having(col.getSourceName()).in(v); } return fcbc.having(col.getSourceName()).in(v); } return null; }
@SuppressWarnings("rawtypes") public static FilterConditionContext visit( Like obj, QueryBuilder queryBuilder, FilterConditionBeginContext fcbc) throws TranslatorException { LogManager.logTrace(LogConstants.CTX_CONNECTOR, "Parsing LIKE criteria."); // $NON-NLS-1$ Expression lhs = obj.getLeftExpression(); Expression rhs = obj.getRightExpression(); Column c = null; Expression literalExp = null; if (lhs instanceof ColumnReference) { c = ((ColumnReference) lhs).getMetadataObject(); literalExp = rhs; } else { c = ((ColumnReference) rhs).getMetadataObject(); literalExp = lhs; } String value = null; if (literalExp instanceof Literal) { value = (String) escapeReservedChars(((Literal) literalExp).getValue()); if (fcbc == null) { if (obj.isNegated()) { return queryBuilder.not().having(c.getSourceName()).like(value); } return queryBuilder.having(c.getSourceName()).like(value); } if (obj.isNegated()) { return fcbc.not().having(c.getSourceName()).like(value); } return fcbc.having(c.getSourceName()).like(value); } throw new TranslatorException( InfinispanPlugin.Util.gs( InfinispanPlugin.Event.TEIID25052, new Object[] {literalExp.toString(), "LIKE"})); }
@SuppressWarnings("rawtypes") public static FilterConditionContext visit( Comparison obj, QueryBuilder queryBuilder, FilterConditionBeginContext fcbc) throws TranslatorException { LogManager.logTrace(LogConstants.CTX_CONNECTOR, "Parsing Comparison criteria."); // $NON-NLS-1$ Comparison.Operator op = obj.getOperator(); Expression lhs = obj.getLeftExpression(); Expression rhs = obj.getRightExpression(); // joins between the objects in the same cache is not usable if ((lhs instanceof ColumnReference && rhs instanceof ColumnReference) || (lhs instanceof Literal && rhs instanceof Literal)) { return null; } Object value = null; Column mdIDElement = null; Literal literal = null; if (lhs instanceof ColumnReference) { mdIDElement = ((ColumnReference) lhs).getMetadataObject(); literal = (Literal) rhs; value = literal.getValue(); } else if (rhs instanceof ColumnReference) { mdIDElement = ((ColumnReference) rhs).getMetadataObject(); literal = (Literal) lhs; value = literal.getValue(); } if (value == null) { throw new TranslatorException(InfinispanPlugin.Util.gs(InfinispanPlugin.Event.TEIID25051)); } value = escapeReservedChars(value); switch (op) { case NE: if (fcbc == null) { return queryBuilder.not().having(mdIDElement.getSourceName()).eq(value); } return fcbc.not().having(mdIDElement.getSourceName()).eq(value); case EQ: if (fcbc == null) { return queryBuilder.having(mdIDElement.getSourceName()).eq(value); } return fcbc.having(mdIDElement.getSourceName()).eq(value); case GT: if (fcbc == null) { return queryBuilder.having(mdIDElement.getSourceName()).gt(value); } return fcbc.having(mdIDElement.getSourceName()).gt(value); case GE: if (fcbc == null) { return queryBuilder.having(mdIDElement.getSourceName()).gte(value); } return fcbc.having(mdIDElement.getSourceName()).gte(value); case LT: if (fcbc == null) { return queryBuilder.having(mdIDElement.getSourceName()).lt(value); } return fcbc.having(mdIDElement.getSourceName()).lt(value); case LE: if (fcbc == null) { return queryBuilder.having(mdIDElement.getSourceName()).lte(value); } return fcbc.having(mdIDElement.getSourceName()).lte(value); default: throw new TranslatorException( InfinispanPlugin.Util.gs( InfinispanPlugin.Event.TEIID25050, new Object[] {op, "NE, EQ, GT, GE, LT, LE"})); } }
private static FilterConditionContext buildQueryFromWhereClause( Condition criteria, @SuppressWarnings("rawtypes") QueryBuilder queryBuilder, FilterConditionBeginContext fcbc) throws TranslatorException { if (criteria == null) return null; FilterConditionContext fcc = null; if (criteria instanceof AndOr) { LogManager.logTrace( LogConstants.CTX_CONNECTOR, "Infinispan DSL Parsing compound criteria."); // $NON-NLS-1$ AndOr crit = (AndOr) criteria; AndOr.Operator op = crit.getOperator(); switch (op) { case AND: FilterConditionContext f_and = buildQueryFromWhereClause(crit.getLeftCondition(), queryBuilder, fcbc); FilterConditionBeginContext fcbca = null; if (f_and != null) { fcbca = f_and.and(); } fcc = buildQueryFromWhereClause(crit.getRightCondition(), queryBuilder, fcbca); break; case OR: FilterConditionContext f_or = buildQueryFromWhereClause(crit.getLeftCondition(), queryBuilder, fcbc); FilterConditionBeginContext fcbcb = null; if (f_or != null) { fcbcb = f_or.or(); } fcc = buildQueryFromWhereClause(crit.getRightCondition(), queryBuilder, fcbcb); break; default: throw new TranslatorException( InfinispanPlugin.Util.gs( InfinispanPlugin.Event.TEIID25050, new Object[] {op, "And, Or"})); } } else if (criteria instanceof Comparison) { fcc = visit((Comparison) criteria, queryBuilder, fcbc); } else if (criteria instanceof Like) { fcc = visit((Like) criteria, queryBuilder, fcbc); } else if (criteria instanceof In) { fcc = visit((In) criteria, queryBuilder, fcbc); } else if (criteria instanceof IsNull) { fcc = visit((IsNull) criteria, queryBuilder, fcbc); } else if (criteria instanceof Not) { Condition c = ((Not) criteria).getCriteria(); if (fcbc == null) { fcc = queryBuilder.not(buildQueryFromWhereClause(c, queryBuilder, fcbc)); } else { fcc = fcbc.not(buildQueryFromWhereClause(c, queryBuilder, fcbc)); } } else { throw new TranslatorException( InfinispanPlugin.Util.gs(InfinispanPlugin.Event.TEIID25054, criteria.toString())); } return fcc; }