Class TemporalExpression

java.lang.Object
org.datanucleus.store.rdbms.sql.expression.SQLExpression
org.datanucleus.store.rdbms.sql.expression.TemporalExpression
Direct Known Subclasses:
AggregateTemporalExpression, TemporalLiteral, TemporalSubqueryExpression

public class TemporalExpression extends SQLExpression
Representation of temporal objects in java query languages. Can be used for anything based on java.util.Date (this includes java.time.* since they convert to java.util.Date types at the datastore).
  • Constructor Details

    • TemporalExpression

      public TemporalExpression(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
    • TemporalExpression

      public TemporalExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List<SQLExpression> args)
      Generates statement as "FUNCTION_NAME(arg [,argN])".
      Parameters:
      stmt - SQL Statement
      mapping - Mapping to use
      functionName - Name of function
      args - SQLExpression list
    • TemporalExpression

      public TemporalExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List<SQLExpression> args, List<Object> types)
      Generates statement as "FUNCTION_NAME(arg [AS type] [,argN [AS typeN]])".
      Parameters:
      stmt - SQL Statement
      mapping - Mapping to use
      functionName - Name of function
      args - SQLExpression list
      types - Optional String/SQLExpression list of types for the args
    • TemporalExpression

      protected TemporalExpression(SQLExpression expr1, org.datanucleus.store.query.expression.Expression.DyadicOperator op, SQLExpression expr2)
  • Method Details

    • eq

      public BooleanExpression eq(SQLExpression expr)
      Description copied from class: SQLExpression
      Equality operator (equals to)
      Overrides:
      eq in class SQLExpression
      Parameters:
      expr - the right-hand operand
      Returns:
      The type of an equality expression is a boolean
    • ne

      public BooleanExpression ne(SQLExpression expr)
      Description copied from class: SQLExpression
      Not equality operator (not equals to)
      Overrides:
      ne in class SQLExpression
      Parameters:
      expr - the right-hand operand
      Returns:
      The type of an equality expression is a boolean
    • 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.
    • 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.
    • 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.
    • invoke

      public SQLExpression invoke(String methodName, List<SQLExpression> 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