Package org.datanucleus.store.rdbms.sql.expression

Examples of org.datanucleus.store.rdbms.sql.expression.StringExpression

50
51
52
53
54
55
56
57
        ArrayList funcArgs = new ArrayList();
        funcArgs.add(expr);
        funcArgs.add(hh);
        ArrayList funcArgs2 = new ArrayList();
        funcArgs2.add(new StringExpression(stmt, mapping, "TO_CHAR", funcArgs));
        return new NumericExpression(stmt, getMappingForClass(int.class), "TO_NUMBER", funcArgs2);
    }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
                throw new NucleusException(LOCALISER.msg("060003", "substring", "StringExpression", 0,
                    "NumericExpression/IntegerLiteral/ParameterLiteral"));
            }

            // Create a new StringExpression and manually update its SQL
            StringExpression strExpr = new StringExpression(stmt, null, null);
            SQLText sql = strExpr.toSQLText();
            sql.append("SUBSTRING(").append(expr).append(" FROM ").append(startExpr.add(one)).append(')');
            return strExpr;
        }
        else
        {
            // {stringExpr}.substring(numExpr1, numExpr2)
            SQLExpression one = ExpressionUtils.getLiteralForOne(stmt);

            SQLExpression startExpr = (SQLExpression)args.get(0);
            if (!(startExpr instanceof NumericExpression))
            {
                throw new NucleusException(LOCALISER.msg("060003", "substring", "StringExpression", 0,
                    "NumericExpression"));
            }
            SQLExpression endExpr = (SQLExpression)args.get(1);
            if (!(endExpr instanceof NumericExpression))
            {
                throw new NucleusException(LOCALISER.msg("060003", "substring", "StringExpression", 1,
                    "NumericExpression"));
            }

            // Create a new StringExpression and manually update its SQL
            StringExpression strExpr = new StringExpression(stmt, null, null);
            SQLText sql = strExpr.toSQLText();
            sql.append("SUBSTRING(").append(expr).append(" FROM ").append(startExpr.add(one))
                .append(" FOR ").append(endExpr.sub(startExpr)).append(')');
            return strExpr;
        }
    }
View Full Code Here
49
50
51
52
53
54
55
56
        }

        List args = new ArrayList();
        args.add(expr);
        List trimArgs = new ArrayList();
        trimArgs.add(new StringExpression(expr.getSQLStatement(), m, "CHAR", args));
        return new StringExpression(expr.getSQLStatement(), m, "RTRIM", trimArgs);
    }
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
        ArrayList funcArgs = new ArrayList();
        funcArgs.add(expr);
        funcArgs.add(mm);
        ArrayList funcArgs2 = new ArrayList();
        funcArgs2.add(new StringExpression(stmt, getMappingForClass(int.class), "TO_CHAR", funcArgs));

        // Delete one from the SQL "month" (origin=1) to be compatible with Java month (origin=0)
        NumericExpression numExpr = new NumericExpression(
            new NumericExpression(stmt, getMappingForClass(int.class), "TO_NUMBER", funcArgs2),
            Expression.OP_SUB, one);
View Full Code Here
TOP

Related Classes of org.datanucleus.store.rdbms.sql.expression.StringExpression

  • org.datanucleus.store.rdbms.sql.method.DateGetDay2Method
  • org.datanucleus.store.rdbms.sql.method.DateGetHour2Method
  • org.datanucleus.store.rdbms.sql.method.DateGetMinute2Method
  • org.datanucleus.store.rdbms.sql.method.DateGetMonth2Method
  • org.datanucleus.store.rdbms.sql.method.DateGetSecond2Method
  • org.datanucleus.store.rdbms.sql.method.DateGetYear2Method
  • org.datanucleus.store.rdbms.sql.method.SimpleStringMethod
  • org.datanucleus.store.rdbms.sql.method.StringEqualsIgnoreCaseMethod
  • org.datanucleus.store.rdbms.sql.method.StringEqualsMethod
  • org.datanucleus.store.rdbms.sql.method.StringIndexOf3Method
    • 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.