Package org.jpox.store.mapped.expression

Examples of org.jpox.store.mapped.expression.NumericExpression

591
592
593
594
595
596
597
    public NumericExpression lengthMethod(StringExpression str)
    {
        ArrayList args = new ArrayList();
        args.add(str);

        return new NumericExpression("LENGTH", args);
    }
View Full Code Here
630
631
632
633
634
635
636
    public NumericExpression modOperator(ScalarExpression operand1, ScalarExpression operand2)
    {
        ArrayList args = new ArrayList();
        args.add(operand1);
        args.add(operand2);
        return new NumericExpression("MOD", args);
    }
View Full Code Here
649
650
651
652
653
654
655
        args.add(getMapping(String.class, date).newLiteral(date.getQueryExpression(), "DD"));

        ArrayList args1 = new ArrayList();
        args1.add(new StringExpression("TO_CHAR", args));

        return new NumericExpression("TO_NUMBER", args1);
    }
View Full Code Here
671
672
673
674
675
676
677
678
679
680
        args1.add(new StringExpression("TO_CHAR", args));

        // Delete one from the SQL "month" (origin=1) to be compatible with Java month (origin=0)
        JavaTypeMapping m = getMapping(BigInteger.class, date);
        ScalarExpression integerLiteral = m.newLiteral(date.getQueryExpression(), BigInteger.ONE);
        NumericExpression expr = new NumericExpression(new NumericExpression("TO_NUMBER", args1), ScalarExpression.OP_SUB, integerLiteral);

        expr.encloseWithInParentheses();
        return expr;
    }
View Full Code Here
693
694
695
696
697
698
699
        args.add(getMapping(String.class, date).newLiteral(date.getQueryExpression(), "YYYY"));

        ArrayList args1 = new ArrayList();
        args1.add(new StringExpression("TO_CHAR", args));

        return new NumericExpression("TO_NUMBER", args1);
    }
View Full Code Here
712
713
714
715
716
717
718
        args.add(getMapping(String.class, time).newLiteral(time.getQueryExpression(), "HH24"));

        ArrayList args1 = new ArrayList();
        args1.add(new StringExpression("TO_CHAR", args));

        return new NumericExpression("TO_NUMBER", args1);
    }
View Full Code Here
731
732
733
734
735
736
737
        args.add(getMapping(String.class, time).newLiteral(time.getQueryExpression(), "MI"));

        ArrayList args1 = new ArrayList();
        args1.add(new StringExpression("TO_CHAR", args));

        return new NumericExpression("TO_NUMBER", args1);
    }
View Full Code Here
750
751
752
753
754
755
756
        args.add(getMapping(String.class, time).newLiteral(time.getQueryExpression(), "SS"));

        ArrayList args1 = new ArrayList();
        args1.add(new StringExpression("TO_CHAR", args));

        return new NumericExpression("TO_NUMBER", args1);
    }
View Full Code Here
778
779
780
781
782
783
784
785
786
787
788
789
790
        args.add(source);
        args.add(str);
        if (from != null)
        {
            // Add 1 to the passed in value so that it is of origin 1 to be compatible with INSTR
            args.add(new NumericExpression(from, ScalarExpression.OP_ADD, integerLiteral));
        }
        NumericExpression locateExpr = new NumericExpression("INSTR", args);

        // Subtract 1 from the result of INSTR to be consistent with Java strings
        // TODO Would be nice to put this in parentheses
        return new NumericExpression(locateExpr, ScalarExpression.OP_SUB, integerLiteral);
    }
View Full Code Here
270
271
272
273
274
275
276
    public NumericExpression lengthMethod(StringExpression str)
    {
        ArrayList args = new ArrayList();
        args.add(str);

        return new NumericExpression("LENGTH", args);
    }
View Full Code Here
TOP

Related Classes of org.jpox.store.mapped.expression.NumericExpression

  • org.jpox.store.mapped.AbstractDatastoreAdapter
  • org.jpox.store.mapped.mapping.BigDecimalMapping
  • org.jpox.store.mapped.mapping.BigIntegerMapping
  • org.jpox.store.mapped.mapping.CharacterMapping
  • org.jpox.store.mapped.mapping.DoubleMapping
  • org.jpox.store.mapped.mapping.EnumMapping
  • org.jpox.store.mapped.mapping.FloatMapping
  • org.jpox.store.mapped.mapping.IndexMapping
  • org.jpox.store.mapped.mapping.IntegerMapping
  • org.jpox.store.mapped.mapping.LongMapping
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.