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

Package org.eclipse.persistence.jpa.jpql.parser

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

org.eclipse.persistence.jpa.jpql.parser.TrimExpression
The TRIM function trims the specified character from a string. If the character to be trimmed is not specified, it is assumed to be space (or blank). The optional trim_character is a single-character string literal or a character-valued input parameter (i.e., char or Character). If a trim specification is not provided, BOTH is assumed. The TRIM function returns the trimmed string.
JPA 1.0, 2.0:
BNF: expression ::= TRIM([[trim_specification] [trim_character] FROM] string_primary)

BNF: trim_character ::= string_literal | input_parameter
JPA 2.1:
BNF: expression ::= TRIM([[trim_specification] [trim_character] FROM] string_expression)

BNF: trim_character ::= string_literal | input_parameter

Example: UPDATE Student st SET st.sname=TRIM(st.sname)
@version 2.4 @since 2.3 @author Pascal Filion

      getGrammar(),
      FunctionsReturningStringsBNF.ID,
      true
    );


    TrimExpression trimExpression = (TrimExpression) jpqlExpression.getQueryStatement();
    setSpecification(trimExpression.getSpecification());
    parseTrimCharacter(trimExpression.getTrimCharacter().toParsedText());
    super.parse(trimExpression.getExpression().toParsedText());


    // The trim character is actually the string primary
    if (!hasStateObject() && hasTrimCharacter()) {
      setStateObject(new StringLiteralStateObject(this, trimCharacter.toString()));
      trimCharacter = null;

View Full Code Here


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


      // 'TRIM'
      appendIdentifier((expression != null) ? expression.getActualIdentifier() : stateObject.getIdentifier(), stateObject.getIdentifier());


      // '('
      if (shouldOutput(expression) || expression.hasLeftParenthesis()) {
        writer.append(LEFT_PARENTHESIS);
      }
      else if ((expression != null) && expression.hasSpaceAfterIdentifier()) {
        writer.append(SPACE);
      }


      // Trim specification
      if (stateObject.hasSpecification()) {
        String specification = stateObject.getSpecification().name();
        String actualSpecification = (expression != null) ? expression.getActualSpecificationIdentifier() : null;


        if (!specification.equalsIgnoreCase(actualSpecification)) {
          actualSpecification = specification;
        }


        appendIdentifier(actualSpecification, specification);
      }


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


      // Trim character
      if (stateObject.hasTrimCharacter()) {
        stateObject.getTrimCharacter().accept(this);


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


      // 'FROM'
      if (stateObject.hasSpecification() ||
          stateObject.hasTrimCharacter()) {


        appendIdentifier((expression != null) ? expression.getActualFromIdentifier() : FROM, FROM);


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


      // String primary
      if (stateObject.hasStateObject()) {
        stateObject.getStateObject().accept(this);
      }


      // ')'
      if (shouldOutput(expression) || expression.hasRightParenthesis()) {
        writer.append(RIGHT_PARENTHESIS);
      }
    }
  }

View Full Code Here

      getGrammar(),
      FunctionsReturningStringsBNF.ID,
      true
    );


    TrimExpression trimExpression = (TrimExpression) jpqlExpression.getQueryStatement();
    setSpecification(trimExpression.getSpecification());
    parseTrimCharacter(trimExpression.getTrimCharacter().toParsedText());
    super.parse(trimExpression.getExpression().toParsedText());


    // The trim character is actually the string primary
    if (!hasStateObject() && hasTrimCharacter()) {
      setStateObject(new StringLiteralStateObject(this, trimCharacter.toString()));
      trimCharacter = null;

View Full Code Here

      getGrammar(),
      FunctionsReturningStringsBNF.ID,
      true
    );


    TrimExpression trimExpression = (TrimExpression) jpqlExpression.getQueryStatement();
    setSpecification(trimExpression.getSpecification());
    parseTrimCharacter(trimExpression.getTrimCharacter().toParsedText());
    super.parse(trimExpression.getExpression().toParsedText());


    // The trim character is actually the string primary
    if (!hasStateObject() && hasTrimCharacter()) {
      setStateObject(new StringLiteralStateObject(this, trimCharacter.toString()));
      trimCharacter = null;

View Full Code Here


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


      // 'TRIM'
      appendIdentifier((expression != null) ? expression.getActualIdentifier() : stateObject.getIdentifier(), stateObject.getIdentifier());


      // '('
      if (shouldOutput(expression) || expression.hasLeftParenthesis()) {
        writer.append(LEFT_PARENTHESIS);
      }
      else if ((expression != null) && expression.hasSpaceAfterIdentifier()) {
        writer.append(SPACE);
      }


      // Trim specification
      if (stateObject.hasSpecification()) {
        String specification = stateObject.getSpecification().name();
        String actualSpecification = (expression != null) ? expression.getActualSpecificationIdentifier() : null;


        if (!specification.equalsIgnoreCase(actualSpecification)) {
          actualSpecification = specification;
        }


        appendIdentifier(actualSpecification, specification);
      }


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


      // Trim character
      if (stateObject.hasTrimCharacter()) {
        stateObject.getTrimCharacter().accept(this);


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


      // 'FROM'
      if (stateObject.hasSpecification() ||
          stateObject.hasTrimCharacter()) {


        appendIdentifier((expression != null) ? expression.getActualFromIdentifier() : FROM, FROM);


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


      // String primary
      if (stateObject.hasStateObject()) {
        stateObject.getStateObject().accept(this);
      }


      // ')'
      if (shouldOutput(expression) || expression.hasRightParenthesis()) {
        writer.append(RIGHT_PARENTHESIS);
      }
    }
  }

View Full Code Here


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


      // 'TRIM'
      appendIdentifier((expression != null) ? expression.getActualIdentifier() : stateObject.getIdentifier(), stateObject.getIdentifier());


      // '('
      if (shouldOutput(expression) || expression.hasLeftParenthesis()) {
        writer.append(LEFT_PARENTHESIS);
      }
      else if ((expression != null) && expression.hasSpaceAfterIdentifier()) {
        writer.append(SPACE);
      }


      // Trim specification
      if (stateObject.hasSpecification()) {
        String specification = stateObject.getSpecification().name();
        String actualSpecification = (expression != null) ? expression.getActualSpecificationIdentifier() : null;


        if (!specification.equalsIgnoreCase(actualSpecification)) {
          actualSpecification = specification;
        }


        appendIdentifier(actualSpecification, specification);
      }


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


      // Trim character
      if (stateObject.hasTrimCharacter()) {
        stateObject.getTrimCharacter().accept(this);


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


      // 'FROM'
      if (stateObject.hasSpecification() ||
          stateObject.hasTrimCharacter()) {


        appendIdentifier((expression != null) ? expression.getActualFromIdentifier() : FROM, FROM);


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


      // String primary
      if (stateObject.hasStateObject()) {
        stateObject.getStateObject().accept(this);
      }


      // ')'
      if (shouldOutput(expression) || expression.hasRightParenthesis()) {
        writer.append(RIGHT_PARENTHESIS);
      }
    }
  }

View Full Code Here

      getGrammar(),
      FunctionsReturningStringsBNF.ID,
      true
    );


    TrimExpression trimExpression = (TrimExpression) jpqlExpression.getQueryStatement();
    setSpecification(trimExpression.getSpecification());
    parseTrimCharacter(trimExpression.getTrimCharacter().toParsedText());
    super.parse(trimExpression.getExpression().toParsedText());


    // The trim character is actually the string primary
    if (!hasStateObject() && hasTrimCharacter()) {
      setStateObject(new StringLiteralStateObject(this, trimCharacter.toString()));
      trimCharacter = null;

View Full Code Here


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


      // 'TRIM'
      appendIdentifier((expression != null) ? expression.getActualIdentifier() : stateObject.getIdentifier(), stateObject.getIdentifier());


      // '('
      if (shouldOutput(expression) || expression.hasLeftParenthesis()) {
        writer.append(LEFT_PARENTHESIS);
      }
      else if ((expression != null) && expression.hasSpaceAfterIdentifier()) {
        writer.append(SPACE);
      }


      // Trim specification
      if (stateObject.hasSpecification()) {
        String specification = stateObject.getSpecification().name();
        String actualSpecification = (expression != null) ? expression.getActualSpecificationIdentifier() : null;


        if (!specification.equalsIgnoreCase(actualSpecification)) {
          actualSpecification = specification;
        }


        appendIdentifier(actualSpecification, specification);
      }


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


      // Trim character
      if (stateObject.hasTrimCharacter()) {
        stateObject.getTrimCharacter().accept(this);


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


      // 'FROM'
      if (stateObject.hasSpecification() ||
          stateObject.hasTrimCharacter()) {


        appendIdentifier((expression != null) ? expression.getActualFromIdentifier() : FROM, FROM);


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


      // String primary
      if (stateObject.hasStateObject()) {
        stateObject.getStateObject().accept(this);
      }


      // ')'
      if (shouldOutput(expression) || expression.hasRightParenthesis()) {
        writer.append(RIGHT_PARENTHESIS);
      }
    }
  }

View Full Code Here

TOP

Related Classes of org.eclipse.persistence.jpa.jpql.parser.TrimExpression

org.eclipse.persistence.jpa.jpql.model.AbstractActualJPQLQueryFormatter

org.eclipse.persistence.jpa.jpql.model.query.TrimExpressionStateObject

org.eclipse.persistence.jpa.jpql.tools.model.AbstractActualJPQLQueryFormatter

org.eclipse.persistence.jpa.jpql.tools.model.query.TrimExpressionStateObject

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.