Examples of LikeExpression

com.salesforce.phoenix.expression.LikeExpression
Implementation for LIKE operation where the first child expression is the string and the second is the pattern. The pattern supports '_' character for single character wildcard match and '%' for zero or more character match. where these characters may be escaped by preceding them with a '\'. Example: foo LIKE 'ab%' will match a row in which foo starts with 'ab' @author jtaylor @since 0.1
net.sf.jsqlparser.expression.operators.relational.LikeExpression
org.apache.phoenix.expression.LikeExpression
Implementation for LIKE operation where the first child expression is the string and the second is the pattern. The pattern supports '_' character for single character wildcard match and '%' for zero or more character match. where these characters may be escaped by preceding them with a '\'. Example: foo LIKE 'ab%' will match a row in which foo starts with 'ab' @since 0.1
org.araneaframework.backend.list.memorybased.expression.compare.LikeExpression
org.codehaus.jparsec.examples.sql.ast.LikeExpression
Represents "expr like 'pattern' escape 'escape'" expression. @author Ben Yu
org.eclipse.persistence.jpa.jpql.parser.LikeExpression
The LIKE condition is used to specify a search for a pattern.
The string_expression must have a string value. The pattern_value is a string literal or a string-valued input parameter in which an underscore (_) stands for any single character, a percent (%) character stands for any sequence of characters (including the empty sequence), and all other characters stand for themselves. The optional escape_character is a single-character string literal or a character-valued input parameter (i.e., char or Character) and is used to escape the special meaning of the underscore and percent characters in pattern_value.

BNF: like_expression ::= string_expression [NOT] LIKE pattern_value [ESCAPE escape_character]
@version 2.4.2 @since 2.3 @author Pascal Filion

Examples of org.codehaus.jparsec.examples.sql.ast.LikeExpression

  }


  @Test
  public void testLike() {
    Parser<Expression> parser = ExpressionParser.like(NUMBER);
    assertParser(parser, "1 like 2", new LikeExpression(number(1), true, number(2), null));
    assertParser(parser, "1 not like 2", new LikeExpression(number(1), false, number(2), null));
    assertParser(parser, "1 like 2 escape 3",
        new LikeExpression(number(1), true, number(2), number(3)));
    assertParser(parser, "1 not like 2 escape 3",
        new LikeExpression(number(1), false, number(2), number(3)));
  }

View Full Code Here

Examples of org.codehaus.jparsec.examples.sql.ast.LikeExpression

    assertParser(parser, "1 = 2", new BinaryExpression(number(1), Op.EQ, number(2)));
    assertParser(parser, "1 is null",
        new BinaryExpression(number(1), Op.IS, NullExpression.instance));
    assertParser(parser, "1 is not null",
        new BinaryExpression(number(1), Op.NOT, NullExpression.instance));
    assertParser(parser, "1 like 2", new LikeExpression(number(1), true, number(2), null));
    assertParser(parser, "(1 < 2 or not exists t)",
        new BinaryExpression(
            new BinaryExpression(number(1), Op.LT, number(2)),
            Op.OR,
            new UnaryExpression(Op.NOT,

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.LikeExpression


    if (stateObject.isDecorated()) {
      toText(stateObject);
    }
    else {
      LikeExpression expression = stateObject.getExpression();


      // String expression
      if (stateObject.hasStringStateObject()) {
        stateObject.getStringStateObject().accept(this);
      }


      if (shouldOutput(expression) || expression.hasSpaceAfterStringExpression()) {
        writer.append(SPACE);
      }


      // 'NOT'
      if (stateObject.hasNot()) {
        appendIdentifier((expression != null) ? expression.getActualNotIdentifier() : NOT, NOT);
        writer.append(SPACE);
      }


      // 'LIKE'
      appendIdentifier((expression != null) ? expression.getActualLikeIdentifier() : LIKE, LIKE);


      if (shouldOutput(expression) || expression.hasSpaceAfterLike()) {
        writer.append(SPACE);
      }


      // Pattern value
      if (stateObject.hasPatternValue()) {
        stateObject.getPatternValue().accept(this);
      }


      if (exactMatch && (expression != null) && expression.hasSpaceAfterPatternValue()) {
        writer.append(SPACE);
      }


      // Escape character
      if (stateObject.hasEscapeCharacter()) {


        if (!exactMatch) {
          writer.append(SPACE);
        }


        appendIdentifier((expression != null) ? expression.getActualEscapeIdentifier() : ESCAPE, ESCAPE);


        if (shouldOutput(expression) || expression.hasSpaceAfterEscape()) {
          writer.append(SPACE);
        }


        writer.append(stateObject.getEscapeCharacter());
      }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.LikeExpression


    if (stateObject.isDecorated()) {
      toText(stateObject);
    }
    else {
      LikeExpression expression = stateObject.getExpression();


      // String expression
      if (stateObject.hasStringStateObject()) {
        stateObject.getStringStateObject().accept(this);
      }


      if (shouldOutput(expression) || expression.hasSpaceAfterStringExpression()) {
        writer.append(SPACE);
      }


      // 'NOT'
      if (stateObject.hasNot()) {
        appendIdentifier((expression != null) ? expression.getActualNotIdentifier() : NOT, NOT);
        writer.append(SPACE);
      }


      // 'LIKE'
      appendIdentifier((expression != null) ? expression.getActualLikeIdentifier() : LIKE, LIKE);


      if (shouldOutput(expression) || expression.hasSpaceAfterLike()) {
        writer.append(SPACE);
      }


      // Pattern value
      if (stateObject.hasPatternValue()) {
        stateObject.getPatternValue().accept(this);
      }


      if (exactMatch && (expression != null) && expression.hasSpaceAfterPatternValue()) {
        writer.append(SPACE);
      }


      // Escape character
      if (stateObject.hasEscapeCharacter()) {


        if (!exactMatch) {
          writer.append(SPACE);
        }


        appendIdentifier((expression != null) ? expression.getActualEscapeIdentifier() : ESCAPE, ESCAPE);


        if (shouldOutput(expression) || expression.hasSpaceAfterEscape()) {
          writer.append(SPACE);
        }


        writer.append(stateObject.getEscapeCharacter());
      }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.LikeExpression


    if (stateObject.isDecorated()) {
      toText(stateObject);
    }
    else {
      LikeExpression expression = stateObject.getExpression();


      // String expression
      if (stateObject.hasStringStateObject()) {
        stateObject.getStringStateObject().accept(this);
      }


      if (shouldOutput(expression) || expression.hasSpaceAfterStringExpression()) {
        writer.append(SPACE);
      }


      // 'NOT'
      if (stateObject.hasNot()) {
        appendIdentifier((expression != null) ? expression.getActualNotIdentifier() : NOT, NOT);
        writer.append(SPACE);
      }


      // 'LIKE'
      appendIdentifier((expression != null) ? expression.getActualLikeIdentifier() : LIKE, LIKE);


      if (shouldOutput(expression) || expression.hasSpaceAfterLike()) {
        writer.append(SPACE);
      }


      // Pattern value
      if (stateObject.hasPatternValue()) {
        stateObject.getPatternValue().accept(this);
      }


      if (exactMatch && (expression != null) && expression.hasSpaceAfterPatternValue()) {
        writer.append(SPACE);
      }


      // Escape character
      if (stateObject.hasEscapeCharacter()) {


        if (!exactMatch) {
          writer.append(SPACE);
        }


        appendIdentifier((expression != null) ? expression.getActualEscapeIdentifier() : ESCAPE, ESCAPE);


        if (shouldOutput(expression) || expression.hasSpaceAfterEscape()) {
          writer.append(SPACE);
        }


        writer.append(stateObject.getEscapeCharacter());
      }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.LikeExpression


    if (stateObject.isDecorated()) {
      toText(stateObject);
    }
    else {
      LikeExpression expression = stateObject.getExpression();


      // String expression
      if (stateObject.hasStringStateObject()) {
        stateObject.getStringStateObject().accept(this);
      }


      if (shouldOutput(expression) || expression.hasSpaceAfterStringExpression()) {
        writer.append(SPACE);
      }


      // 'NOT'
      if (stateObject.hasNot()) {
        appendIdentifier((expression != null) ? expression.getActualNotIdentifier() : NOT, NOT);
        writer.append(SPACE);
      }


      // 'LIKE'
      appendIdentifier((expression != null) ? expression.getActualLikeIdentifier() : LIKE, LIKE);


      if (shouldOutput(expression) || expression.hasSpaceAfterLike()) {
        writer.append(SPACE);
      }


      // Pattern value
      if (stateObject.hasPatternValue()) {
        stateObject.getPatternValue().accept(this);
      }


      if (exactMatch && (expression != null) && expression.hasSpaceAfterPatternValue()) {
        writer.append(SPACE);
      }


      // Escape character
      if (stateObject.hasEscapeCharacter()) {


        if (!exactMatch) {
          writer.append(SPACE);
        }


        appendIdentifier((expression != null) ? expression.getActualEscapeIdentifier() : ESCAPE, ESCAPE);


        if (shouldOutput(expression) || expression.hasSpaceAfterEscape()) {
          writer.append(SPACE);
        }


        writer.append(stateObject.getEscapeCharacter());
      }

View Full Code Here

0 1 2

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.