List of andCondition() Examples

Examples of andCondition()

org.datanucleus.store.mapped.expression.QueryExpression.andCondition()
add an condition to the query. @param condition the Boolean expression
org.jpox.store.mapped.FetchStatement.andCondition()
Method to add an extra condition to the WHERE clause. @param condition The condition
org.jpox.store.mapped.expression.QueryExpression.andCondition()
add an condition to the query. @param condition the Boolean expression
org.jpox.store.rdbms.RDBMSFetchStatement.andCondition()
Method to add an extra condition to the WHERE clause. @param condition The condition

Examples of org.jpox.store.mapped.expression.QueryExpression.andCondition()

        if (keyMapping instanceof SerialisedMapping)
        {
            // Apply condition on join-table owner field to filter by owner
            ScalarExpression keyExpr = keyMapping.newScalarExpression(stmt, stmt.getMainTableExpression());
            ScalarExpression keyVal = keyMapping.newLiteral(stmt, key).add(dba.getMapping(String.class, storeMgr).newLiteral(stmt,"%"));
            stmt.andCondition(new BooleanExpression(keyExpr,ScalarExpression.OP_LIKE,keyVal), true);             
        }
        else
        {
            // Apply condition on join-table owner field to filter by owner
            ScalarExpression keyExpr = keyMapping.newScalarExpression(stmt, stmt.getMainTableExpression());

View Full Code Here

Examples of org.jpox.store.mapped.expression.QueryExpression.andCondition()

        else
        {
            // Apply condition on join-table owner field to filter by owner
            ScalarExpression keyExpr = keyMapping.newScalarExpression(stmt, stmt.getMainTableExpression());
            ScalarExpression keyVal = keyMapping.newLiteral(stmt, key);
            stmt.andCondition(keyExpr.eq(keyVal), true);
        }
        return stmt;
    }


    /**

View Full Code Here

Examples of org.jpox.store.mapped.expression.QueryExpression.andCondition()

        QueryExpression stmt = dba.newQueryStatement(candidateTable, clr);


        // Join to the owner
        ScalarExpression ownerExpr = ownerMapping.newScalarExpression(stmt, stmt.getMainTableExpression());
        ScalarExpression ownerVal = ownerMapping.newLiteral(stmt, sm.getObject());
        stmt.andCondition(ownerExpr.eq(ownerVal));


        // Select the value table ID mapping
        stmt.select(valueMapping);


        return stmt;

View Full Code Here

Examples of org.jpox.store.mapped.expression.QueryExpression.andCondition()

            // Key = PC(embedded) or Value = PC(embedded)
            // Generate the statement dynamically since we should select the FetchPlan fields only
            QueryExpression expr = dba.newQueryStatement(setTable, clr);
            ScalarExpression ownerExpr = ownerMapping.newScalarExpression(expr, expr.getMainTableExpression());
            ScalarExpression ownerVal = ownerMapping.newLiteral(expr, sm.getObject());
            expr.andCondition(ownerExpr.eq(ownerVal), true);


            rof = newResultObjectFactory(sm, expr, true);


            stmt = expr.toStatementText(false).toString();
        }

View Full Code Here

Examples of org.jpox.store.mapped.expression.QueryExpression.andCondition()

        }


        // Apply condition on owner field to filter by owner
        ScalarExpression ownerExpr = ownerMapping.newScalarExpression(stmt, stmt.getMainTableExpression());
        ScalarExpression ownerVal = ownerMapping.newLiteral(stmt, ownerSM.getObject());
        stmt.andCondition(ownerExpr.eq(ownerVal), true);


        return stmt;
    }


    /**

View Full Code Here

Examples of org.jpox.store.mapped.expression.QueryExpression.andCondition()

        stmt.setParent(qs);


        // Join for the owner
        ScalarExpression ownerExpr = mapping.newScalarExpression(stmt, ownerTe);
        ScalarExpression ownerInCollectionExpr = ownerMapping.newScalarExpression(stmt, stmt.getTableExpression(arrayTableAlias));
        stmt.andCondition(ownerExpr.eq(ownerInCollectionExpr));


        stmt.select(arrayTableAlias, elementMapping);


        return stmt;
    }

View Full Code Here

Examples of org.jpox.store.mapped.expression.QueryExpression.andCondition()

        stmt.setParent(qs);


        // Join for the owner
        ScalarExpression ownerExpr = mapping.newScalarExpression(stmt, ownerTe);
        ScalarExpression ownerInCollectionExpr = ownerMapping.newScalarExpression(stmt, stmt.getTableExpression(arrayTableAlias));
        stmt.andCondition(ownerExpr.eq(ownerInCollectionExpr));


        // Select COUNT(*)
        JavaTypeMapping m = dba.getMapping(String.class, storeMgr);
        StringLiteral lit = (StringLiteral)m.newLiteral(stmt, "COUNT(*)");
        lit.generateStatementWithoutQuotes();

View Full Code Here

Examples of org.jpox.store.mapped.expression.QueryExpression.andCondition()

        QueryExpression stmt = dba.newQueryStatement(containerTable, setTableAlias, clr);


        // Join to the owner
        ScalarExpression ownerExpr = ownerMapping.newScalarExpression(stmt, stmt.getTableExpression(setTableAlias));
        ScalarExpression ownerVal = ownerMapping.newLiteral(stmt, sm.getObject());
        stmt.andCondition(ownerExpr.eq(ownerVal), true);


        if (!clr.isAssignableFrom(elementType, candidateClass))
        {
            throw new IncompatibleQueryElementTypeException(elementType, candidateClass);
        }

View Full Code Here

Examples of org.jpox.store.rdbms.RDBMSFetchStatement.andCondition()

        FetchStatement fetchStmt = new RDBMSFetchStatement(datastoreContainer);
        fetchStmt.select(mapping.getDatastoreField());
        JavaTypeMapping idMapping = datastoreContainer.getIDMapping();
        for (int i = 0; i < idMapping.getNumberOfDatastoreFields(); i++)
        {
            fetchStmt.andCondition(fetchStmt.referenceDatastoreField(idMapping.getDataStoreMapping(i).getDatastoreField()) + " = ?");
        }
        String textStmt = fetchStmt.toString(true);


        if (sm.getPcObjectType() != StateManager.PC)
        {

View Full Code Here

Examples of org.jpox.store.rdbms.RDBMSFetchStatement.andCondition()

        FetchStatement fetchStmt = new RDBMSFetchStatement(datastoreContainer);
        fetchStmt.select(mapping.getDatastoreField());
        JavaTypeMapping idMapping = datastoreContainer.getIDMapping();
        for (int i = 0; i < idMapping.getNumberOfDatastoreFields(); i++)
        {
            fetchStmt.andCondition(fetchStmt.referenceDatastoreField(idMapping.getDataStoreMapping(i).getDatastoreField()) + " = ?");
        }
        String textStmt = fetchStmt.toString(true);


        if (sm.getPcObjectType() != StateManager.PC)
        {

View Full Code Here

0 1 2 3

TOP

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.