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.datanucleus.store.mapped.expression.QueryExpression.andCondition()


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


        // Select id mapping of element
        stmt.select(collectionTableAlias, elementMapping);


        return stmt;

View Full Code Here

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


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


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

View Full Code Here

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

            // Apply the discriminator to the query statement
            if (multipleDiscriminatorValues)
            {
                discExpr.encloseWithInParentheses();
            }
            stmt.andCondition(discExpr);
        }


        return stmt;
    }

View Full Code Here

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

        stmt.setParent(qs);


        // Join to the owner
        ScalarExpression ownerExpr = mapping.newScalarExpression(stmt, ownerTe);
        ScalarExpression ownerInMapExpr = ownerMapping.newScalarExpression(stmt, stmt.getTableExpression(mapTableAlias));
        stmt.andCondition(ownerExpr.eq(ownerInMapExpr));


        stmt.select(mapTableAlias, valueMapping);


        return stmt;
    }

View Full Code Here

Examples of org.datanucleus.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(mapTableAlias));
        stmt.andCondition(ownerExpr.eq(ownerInCollectionExpr));


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

View Full Code Here

Examples of org.datanucleus.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.datanucleus.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 = storeMgr.getMappingManager().getMapping(String.class);
        StringLiteral lit = (StringLiteral)m.newLiteral(stmt, "COUNT(*)");
        lit.generateStatementWithoutQuotes();

View Full Code Here

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

                 * WHERE THIS.ELEM_ID IS NULL
                 */
                QueryExpression nullStmt = getQueryForElement(candidateFullClassName, 
                    storeMgr.getDatastoreClass(candidateFullClassName, clr), true, candidateAlias);
                ScalarExpression elemIdExpr = sourceMapping.newScalarExpression(nullStmt, nullStmt.getMainTableExpression());
                nullStmt.andCondition(new NullLiteral(nullStmt).eq(elemIdExpr));
                stmt.union(nullStmt);
            }


            return stmt;
        }

View Full Code Here

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

                AbstractClassMetaData targetCmd = storeMgr.getOMFContext().getMetaDataManager().getMetaDataForClass(targetElementType, clr);
                discriminatorValue = targetCmd.getInheritanceMetaData().getDiscriminatorMetaData().getValue();
            }
            ScalarExpression discrExpr = discriminatorMapping.newScalarExpression(stmt, discriminatorTableExpr);
            ScalarExpression discrVal = discriminatorMapping.newLiteral(stmt, discriminatorValue);
            stmt.andCondition(discrExpr.eq(discrVal));
        }


        if (withMetadata == null || withMetadata.booleanValue())
        {
            // Select NUCLEUS_TYPE if required

View Full Code Here

Examples of org.jpox.store.mapped.FetchStatement.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.