Class StringExpression

    • Constructor Detail

      • StringExpression

        public StringExpression​(SQLStatement stmt,
                                SQLTable table,
                                JavaTypeMapping mapping)
        Constructor for an SQL expression for a (field) mapping in a specified table.
        Parameters:
        stmt - The statement
        table - The table in the statement
        mapping - The mapping for the field
      • StringExpression

        public StringExpression​(org.datanucleus.query.expression.Expression.MonadicOperator op,
                                SQLExpression expr1)
        Perform an operation
        op
        on expression
        expr1
        .
        Parameters:
        op - operator
        expr1 - operand
      • StringExpression

        public StringExpression​(SQLExpression expr1,
                                org.datanucleus.query.expression.Expression.DyadicOperator op,
                                SQLExpression expr2)
        Perform an operation
        op
        between
        expr1
        and
        expr2
        .
        Parameters:
        expr1 - the first expression
        op - the operator between operands
        expr2 - the second expression
      • StringExpression

        public StringExpression​(SQLStatement stmt,
                                JavaTypeMapping mapping,
                                String functionName,
                                List args)
        Generates statement as e.g. FUNCTION_NAME(arg[,argN]).
        Parameters:
        stmt - SQL Statement
        mapping - Mapping to use
        functionName - Name of the function
        args - ScalarExpression list
      • StringExpression

        public StringExpression​(SQLStatement stmt,
                                JavaTypeMapping mapping,
                                String functionName,
                                List args,
                                List types)
        Generates statement as e.g. FUNCTION_NAME(arg AS type[,argN as typeN]).
        Parameters:
        stmt - SQL Statement
        mapping - Mapping to use
        functionName - Name of function
        args - ScalarExpression list
        types - String or ScalarExpression list
    • Method Detail

      • lt

        public BooleanExpression lt​(SQLExpression expr)
        Description copied from class: SQLExpression
        Relational operator (lower than)
        Overrides:
        lt in class SQLExpression
        Parameters:
        expr - the right-hand operand
        Returns:
        true if the value of the left-hand operand is less than the value of the right-hand operand, and otherwise is false.
      • le

        public BooleanExpression le​(SQLExpression expr)
        Description copied from class: SQLExpression
        Relational operator (lower than or equals)
        Overrides:
        le in class SQLExpression
        Parameters:
        expr - the right-hand operand
        Returns:
        true if the value of the left-hand operand is less than or equal to the value of the right-hand operand, and otherwise is false.
      • gt

        public BooleanExpression gt​(SQLExpression expr)
        Description copied from class: SQLExpression
        Relational operator (greater than)
        Overrides:
        gt in class SQLExpression
        Parameters:
        expr - the right-hand operand
        Returns:
        true if the value of the left-hand operand is greater than the value of the right-hand operand, and otherwise is false.
      • ge

        public BooleanExpression ge​(SQLExpression expr)
        Description copied from class: SQLExpression
        Relational operator (greater than or equals)
        Overrides:
        ge in class SQLExpression
        Parameters:
        expr - the right-hand operand
        Returns:
        true if the value of the left-hand operand is greater than or equal the value of the right-hand operand, and otherwise is false.
      • add

        public SQLExpression add​(SQLExpression expr)
        Description copied from class: SQLExpression
        Additive Operator. The binary + operator performs addition when applied to two operands of numeric type, producing the sum of the operands. If the type of either operand of a + operator is String, then the operation is string concatenation.
        Overrides:
        add in class SQLExpression
        Parameters:
        expr - the right-hand operand
        Returns:
        If one of the operands is String, the returned value is the string concatenation; The sum of two operands of numeric type. The left-hand operand is the minuend and the right-hand operand is the subtrahend;
      • in

        public BooleanExpression in​(SQLExpression expr,
                                    boolean not)
        Description copied from class: SQLExpression
        In expression. Return true if this is contained by expr
        Overrides:
        in in class SQLExpression
        Parameters:
        expr - the right-hand expression
        not - Whether we really want "not in"
        Returns:
        true if the left-hand expression is contained by the right-hand expression. Otherwise the result is false.
      • invoke

        public SQLExpression invoke​(String methodName,
                                    List args)
        Description copied from class: SQLExpression
        Invocation of a method on this expression.
        Overrides:
        invoke in class SQLExpression
        Parameters:
        methodName - name of the method to invoke
        args - Args to this method (if any)
        Returns:
        the converted value