Package org.jpox.store.mapped.expression

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

112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
         * creates a query like WHERE ... AND (CANDIDATE_ID = ?1 OR CANDIDATE_ID =
         * ?2) or for classes with composite primary keys WHERE ... AND (
         * (CANDIDATE_IDa = ?1a AND CANDIDATE_IDb = ?1b) OR (CANDIDATE_IDa = ?2a
         * AND CANDIDATE_IDb = ?2b) )
         */
        BooleanExpression elementsExpr = null;
        for (Iterator it = userCandidates.iterator(); it.hasNext();)
        {
            Object candidateValue = it.next();
            ScalarExpression expr = m.newScalarExpression(stmt, stmt.getMainTableExpression());
            BooleanExpression keyExpr = expr.eq(m.newLiteral(stmt, candidateValue));
            if (elementsExpr == null)
            {
                elementsExpr = keyExpr;
            }
            else
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
        DatastoreMapping data_mapping = getDataStoreMapping(0);
        if (data_mapping.isBitBased() || data_mapping.isIntegerBased())
        {
            if (dba.isBitReallyBoolean())
            {
                expr = new BooleanExpression(qs, this, te);
            }
            else
            {
                expr = new BooleanBitColumnExpression(qs, this, te);
            }
        }
        else if (data_mapping.isBooleanBased())
        {
            expr = new BooleanExpression(qs, this, te);
        }
        else if (data_mapping.isStringBased())
        {
            expr = new BooleanCharColumnExpression(qs, this, te);
        }
        else
        {
            expr = new BooleanExpression(qs, this, te);
        }

        return expr;
    }
View Full Code Here
487
488
489
490
491
492
493
        args.add(source);
        args.add(str);
        ScalarExpression literal = getMapping(BigInteger.class, source).newLiteral(source.getQueryExpression(), BigInteger.ZERO);
        args.add(literal);
        //JPOX_STRPOS( SearchString, stringSearched, [StartPosition] )
        return new BooleanExpression(new StringExpression("JPOX_STRPOS", args),ScalarExpression.OP_EQ,integerLiteral);
    }
View Full Code Here
512
513
514
515
516
517
518
        args.add(leftOperand);
        args.add(rightOperand);
        ScalarExpression literal = getMapping(BigInteger.class, leftOperand).newLiteral(leftOperand.getQueryExpression(), BigInteger.ZERO);
        args.add(literal);
        //JPOX_STRPOS( SearchString, stringSearched, [StartPosition] )
        return new BooleanExpression(new StringExpression("JPOX_STRPOS", args),ScalarExpression.OP_EQ,lengthMethod((StringExpression)leftOperand).sub(lengthMethod((StringExpression)rightOperand)).add(integerLiteral).encloseWithInParentheses());
    }
View Full Code Here
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
             * creates a query like WHERE ... AND (CANDIDATE_ID = ?1 OR CANDIDATE_ID =
             * ?2) or for classes with composite primary keys WHERE ... AND (
             * (CANDIDATE_IDa = ?1a AND CANDIDATE_IDb = ?1b) OR (CANDIDATE_IDa = ?2a
             * AND CANDIDATE_IDb = ?2b) )
             */
            BooleanExpression elementsExpr = null;
            for (Iterator it = userCandidates.iterator(); it.hasNext();)
            {
                Object candidateValue = it.next();
                ScalarExpression expr = m.newScalarExpression(stmt, stmt.getMainTableExpression());
                BooleanExpression keyExpr = expr.eq(m.newLiteral(stmt, candidateValue));
                if (elementsExpr == null)
                {
                    elementsExpr = keyExpr;
                }
                else
View Full Code Here
519
520
521
522
523
524
525
       
        ScalarExpression integerLiteral = getMapping(BigInteger.class, source).newLiteral(source.getQueryExpression(), BigInteger.ONE);
        ArrayList args = new ArrayList();
        args.add(str);
        args.add(source);
        return new BooleanExpression(new StringExpression("LOCATE", args),ScalarExpression.OP_EQ,integerLiteral);
    }
View Full Code Here
2252
2253
2254
2255
2256
2257
2258
        {
            throw new IllegalArgumentTypeException(rightOperand);
        }
       
        StringLiteral pct = new StringLiteral(leftOperand.getQueryExpression(), leftOperand.getMapping(), '%');
        return new BooleanExpression(leftOperand, ScalarExpression.OP_LIKE, pct.add(leftOperand.getQueryExpression().getStoreManager().getDatastoreAdapter().getEscapedPatternExpression(rightOperand)));
    }
View Full Code Here
2367
2368
2369
2370
2371
2372
2373
     * @param pattern The literal expression with the pattern.
     * @return the match expression.
     */
    public BooleanExpression matchesMethod(StringExpression text, StringExpression pattern)
    {
        return new BooleanExpression(text, ScalarExpression.OP_LIKE, pattern);
    }
View Full Code Here
2506
2507
2508
2509
2510
2511
2512
     **/
    public BooleanExpression startsWithMethod(ScalarExpression source, ScalarExpression str)
    {
        ScalarExpression pct = getMapping(String.class, source).newLiteral(source.getQueryExpression(), "%");

        return new BooleanExpression(source, ScalarExpression.OP_LIKE, getEscapedPatternExpression(str).add(pct));
    }
View Full Code Here
430
431
432
433
434
435
436
    {
        ScalarExpression integerLiteral = getMapping(BigInteger.class, source).newLiteral(source.getQueryExpression(), BigInteger.ONE);
        ArrayList args = new ArrayList();
        args.add(str);
        args.add(source);
        return new BooleanExpression(new StringExpression("CHARINDEX", args),ScalarExpression.OP_EQ,integerLiteral);
    }
View Full Code Here
TOP

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

  • org.jpox.store.mapped.mapping.BooleanMapping
  • org.jpox.store.mapped.query.CollectionCandidates
  • org.jpox.store.rdbms.adapter.DatabaseAdapter
  • org.jpox.store.rdbms.adapter.DB2Adapter
  • org.jpox.store.rdbms.adapter.DerbyAdapter
  • org.jpox.store.rdbms.adapter.InformixAdapter
  • org.jpox.store.rdbms.adapter.MSSQLServerAdapter
  • org.jpox.store.rdbms.adapter.MySQLAdapter
  • org.jpox.store.rdbms.query.JPQLQueryCompiler
  • org.jpox.store.rdbms.query.ResultExpressionsQueryable
    • 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.