Package org.jpox.store.mapped.expression

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

251
252
253
254
255
256
257
    public NumericExpression lengthMethod(StringExpression str)
    {
        ArrayList args = new ArrayList();
        args.add(str);
        return new NumericExpression("LENGTH", args);
    }
View Full Code Here
440
441
442
443
444
445
446
    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
473
474
475
476
477
478
479
            return (NumericExpression) m.newLiteral(expr.getQueryExpression(), value);
        }
        ArrayList args = new ArrayList();
        args.add(expr);

        return new NumericExpression("JPOX_ASCII", args);
    }
View Full Code Here
615
616
617
618
619
620
621
        List args = new ArrayList();
        args.add(text);
        args.add(pattern);

        return new NumericExpression("JPOX_MATCHES",args).eq(integerLiteral);
    }
View Full Code Here
627
628
629
630
631
632
633
634
635
636
637
        if (from != null)
        {
            // TODO Find a function in Postgresql that supports the "from" position for searching
            throw new JPOXUserException("PostgreSQL doesnt currently provide a function for providing indexOf(str, from). Your workaround is to miss off the 'from' position");
        }
        NumericExpression locateExpr = new NumericExpression("STRPOS", args);

        // Subtract 1 from the result of STRPOS 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
651
652
653
654
655
656
657
        ScalarExpression submethodLiteral = m.newLiteral(date.getQueryExpression(), "day");
        args.add(submethodLiteral);

        args.add(date);

        return new NumericExpression("date_part", args);
    }
View Full Code Here
674
675
676
677
678
679
680
681
682
        args.add(date);

        // Delete one from the SQL "month" (origin=1) to be compatible with Java month (origin=0)
        JavaTypeMapping m2 = getMapping(BigInteger.class, date);
        ScalarExpression integerLiteral = m2.newLiteral(date.getQueryExpression(), BigInteger.ONE);
        NumericExpression expr = new NumericExpression(new NumericExpression("date_part", args), ScalarExpression.OP_SUB, integerLiteral);
        expr.encloseWithInParentheses();
        return expr;
    }
View Full Code Here
696
697
698
699
700
701
702
        ScalarExpression submethodLiteral = m.newLiteral(date.getQueryExpression(), "year");
        args.add(submethodLiteral);

        args.add(date);

        return new NumericExpression("date_part", args);
    }
View Full Code Here
716
717
718
719
720
721
722
        ScalarExpression submethodLiteral = m.newLiteral(time.getQueryExpression(), "hour");
        args.add(submethodLiteral);

        args.add(time);

        return new NumericExpression("date_part", args);
    }
View Full Code Here
736
737
738
739
740
741
742
        ScalarExpression submethodLiteral = m.newLiteral(time.getQueryExpression(), "minute");
        args.add(submethodLiteral);

        args.add(time);

        return new NumericExpression("date_part", 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.