Class CharacterExpression

  • Direct Known Subclasses:
    CharacterLiteral

    public class CharacterExpression
    extends SQLExpression
    Representation of a Character expression in a Query
    • Constructor Detail

      • CharacterExpression

        public CharacterExpression​(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
      • CharacterExpression

        public CharacterExpression​(SQLStatement stmt,
                                   JavaTypeMapping mapping,
                                   String functionName,
                                   List args)
        Generates statement as e.g. FUNCTION_NAME(arg[,argN]). The function returns a character value. This is used where we are invoking some SQL function and it returns a character.
        Parameters:
        stmt - SQL Statement
        mapping - Mapping to use
        functionName - Name of the function
        args - SQLExpression list
      • CharacterExpression

        public CharacterExpression​(SQLStatement stmt,
                                   JavaTypeMapping mapping,
                                   String functionName,
                                   List args,
                                   List types)
        Generates statement as e.g. FUNCTION_NAME(arg [AS type] [,argN [AS type]]). The function returns a character value. This is used where we are invoking some SQL function and it returns a character.
        Parameters:
        stmt - SQL Statement
        mapping - Mapping to use
        functionName - Name of the function
        args - SQLExpression list
        types - Optional types list for the args
    • 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;
      • sub

        public SQLExpression sub​(SQLExpression expr)
        Description copied from class: SQLExpression
        Additive Operator. The binary - operator subtracts right-hand operand from left-hand operand.
        Overrides:
        sub in class SQLExpression
        Parameters:
        expr - the right-hand operand
        Returns:
        The binary - operator performs subtraction when applied to two operands of numeric type producing the difference of its operands; the left-hand operand is the minuend and the right-hand operand is the subtrahend.
      • mul

        public SQLExpression mul​(SQLExpression expr)
        Description copied from class: SQLExpression
        Multiplication Operator
        Overrides:
        mul in class SQLExpression
        Parameters:
        expr - the right-hand operator
        Returns:
        The binary * operator performs multiplication, producing the product of its operands.
      • div

        public SQLExpression div​(SQLExpression expr)
        Description copied from class: SQLExpression
        Division Operator. The left-hand operand is the dividend and the right-hand operand is the divisor.
        Overrides:
        div in class SQLExpression
        Parameters:
        expr - the right-hand operator
        Returns:
        The binary / operator performs division, producing the quotient of its operands
      • mod

        public SQLExpression mod​(SQLExpression expr)
        Method to return a modulus expression.
        Overrides:
        mod in class SQLExpression
        Parameters:
        expr - The expression to modulus against
        Returns:
        The modulus expression
      • neg

        public SQLExpression neg()
        Description copied from class: SQLExpression
        Unary Minus Operator
        Overrides:
        neg in class SQLExpression
        Returns:
        the type of the unary minus expression is the promoted type of the operand.
      • com

        public SQLExpression com()
        Description copied from class: SQLExpression
        Bitwise Complement Operator
        Overrides:
        com in class SQLExpression
        Returns:
        the type of the unary bitwise complement expression is the promoted type of the operand.
      • 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