Examples of org.apache.cayenne.map.DbRelationship$TestJoin

org.apache.cayenne.map.DbRelationship
A DbRelationship is a descriptor of a database inter-table relationship based on one or more primary key/foreign key pairs. @author Misha Shengaout @author Andrus Adamchik

        for (DbEntity entity : dataMap.getDbEntities()) {
            Iterator<?> it = entity.getRelationships().iterator();
            while (it.hasNext()) {
                JpaDbRelationship relationship = (JpaDbRelationship) it.next();
                if (relationship.getMappedBy() != null) {
                    DbRelationship owner = (DbRelationship) relationship
                            .getTargetEntity()
                            .getRelationship(relationship.getMappedBy());


                    if (owner != null) {
                        for (DbJoin join : owner.getJoins()) {
                            DbJoin reverse = join.createReverseJoin();
                            reverse.setRelationship(relationship);
                            relationship.addJoin(reverse);
                        }
                    }

View Full Code Here

                                "No matching objects found for ObjectId "
                                        + object.getObjectId()
                                        + ". Object may have been deleted externally.");
                    }


                    DbRelationship dbRel = rel.getDbRelationships().get(0);
                    for (DbJoin join : dbRel.getJoins()) {
                        String key = join.getSourceName();
                        snapshot.put(key, storedSnapshot.get(key));
                    }


                    return true;
                }


                // target is resolved and we have an FK->PK to it,
                // so extract it from target...
                Persistent target = (Persistent) targetObject;
                Map<String, Object> idParts = target.getObjectId().getIdSnapshot();


                // this may happen in uncommitted objects - see the warning in the JavaDoc
                // of
                // this method.
                if (idParts.isEmpty()) {
                    return true;
                }


                DbRelationship dbRel = rel.getDbRelationships().get(0);
                Map<String, Object> fk = dbRel.srcFkSnapshotWithTargetSnapshot(idParts);
                snapshot.putAll(fk);
                return true;
            }
        });

View Full Code Here

                        + targetEntity.getName()
                        + "."
                        + jpaJoin.getReferencedColumnName());
            }


            DbRelationship dbRelationship = (DbRelationship) targetPath.getObject();


            // add FK
            DbAttribute src = new DbAttribute(jpaJoin.getName());


            // TODO: andrus, 5/2/2006 - infer this from Jpa relationship
            src.setMandatory(false);
            src.setMaxLength(jpaTargetId.getColumn().getLength());
            src.setType(jpaTargetId.getDefaultJdbcType());


            Entity srcEntity = dbRelationship.getSourceEntity();
            srcEntity.addAttribute(src);


            // add join
            DbJoin join = new DbJoin(dbRelationship, src.getName(), jpaTargetId
                    .getColumn()
                    .getName());
            dbRelationship.addJoin(join);


            return false;
        }

View Full Code Here

                        .getEntityDescriptor(id.getEntityId())
                        .getEntity()
                        .getDbEntity();
            }
            else {
                DbRelationship last = incoming.get(incoming.size() - 1);
                entity = (DbEntity) last.getTargetEntity();
            }


            incoming = new ArrayList<DbRelationship>(incoming);


            Iterator<?> it = entity.resolvePathComponents(id.getDbPath());

View Full Code Here

    }


    @Override
    protected void appendJoinSubtree(Appendable out, JoinTreeNode node)
            throws IOException {
        DbRelationship relationship = node.getRelationship();


        if (relationship == null) {
            return;
        }


        DbEntity targetEntity = (DbEntity) relationship.getTargetEntity();
        String targetAlias = node.getTargetTableAlias();


        out.append(", ").append(targetEntity.getFullyQualifiedName()).append(' ').append(
                targetAlias);

View Full Code Here

        }
    }


    protected void appendQualifierSubtree(Appendable out, JoinTreeNode node)
            throws IOException {
        DbRelationship relationship = node.getRelationship();


        String srcAlias = node.getSourceTableAlias();
        String targetAlias = node.getTargetTableAlias();


        List<DbJoin> joins = relationship.getJoins();
        int len = joins.size();
        for (int i = 0; i < len; i++) {
            DbJoin join = joins.get(i);


            if (i > 0) {

View Full Code Here


            // use an outer join for to-many matches
            resolveJoin(false);


            // TODO: andrus, 6/21/2007 - flattened support
            DbRelationship dbRelationship = relationship.getDbRelationships().get(0);
            DbEntity table = (DbEntity) dbRelationship.getTargetEntity();


            String alias = this.lastAlias != null ? lastAlias : context.getTableAlias(
                    idPath,
                    table.getFullyQualifiedName());


            Collection<DbAttribute> pks = table.getPrimaryKeys();


            if (pks.size() == 1) {
                DbAttribute pk = pks.iterator().next();
                context.append(' ');
                if (isUsingAliases()) {
                    context.append(alias).append('.');
                }
                context.append(pk.getName());
            }
            else {
                throw new EJBQLException(
                        "Multi-column PK to-many matches are not yet supported.");
            }
        }
        else {
            // match FK against the target object


            // TODO: andrus, 6/21/2007 - flattened support
            DbRelationship dbRelationship = relationship.getDbRelationships().get(0);
            DbEntity table = (DbEntity) dbRelationship.getSourceEntity();


            String alias = this.lastAlias != null ? lastAlias : context.getTableAlias(
                    idPath,
                    table.getFullyQualifiedName());


            List<DbJoin> joins = dbRelationship.getJoins();


            if (joins.size() == 1) {
                DbJoin join = joins.get(0);
                context.append(' ');
                if (isUsingAliases()) {

View Full Code Here

                            joinAppender = context
                                    .getTranslatorFactory()
                                    .getJoinAppender(context);
                        }


                        DbRelationship dr = (DbRelationship) pathPart;


                        EJBQLTableId rhsId = new EJBQLTableId(lhsId, dr.getName());
                        joinAppender.appendOuterJoin(marker, lhsId, rhsId);
                        lhsId = rhsId;
                    }
                    else if (pathPart instanceof DbAttribute) {
                        appendColumn(idVar, oa, (DbAttribute) pathPart, fields, oa
                                .getType());
                    }
                }
                return true;
            }


            public boolean visitToMany(ToManyProperty property) {
                visitRelationship(property);
                return true;
            }


            public boolean visitToOne(ToOneProperty property) {
                visitRelationship(property);
                return true;
            }


            private void visitRelationship(ArcProperty property) {
                ObjRelationship rel = property.getRelationship();
                DbRelationship dbRel = rel.getDbRelationships().get(0);


                for (DbJoin join : dbRel.getJoins()) {
                    DbAttribute src = join.getSource();
                    appendColumn(idVar, null, src, fields);
                }
            }
        };

View Full Code Here

        // support "AS", and the rest of the databases do not care
        context.append(subqueryTableName).append(' ').append(subqueryRootAlias);
        context.append(" WHERE");


        // TODO: andrus, 8/11/2007 flattened?
        DbRelationship correlatedJoinRelationship = context.getIncomingRelationships(
                new EJBQLTableId(id)).get(0);
        Iterator<DbJoin> it = correlatedJoinRelationship.getJoins().iterator();
        while (it.hasNext()) {
            DbJoin join = it.next();
            context.append(' ').append(subqueryRootAlias).append('.').append(
                    join.getTargetName()).append(" = ");
            context.append(correlatedTableAlias).append('.').append(join.getSourceName());

View Full Code Here

        // support "AS", and the rest of the databases do not care
        context.append(subqueryTableName).append(' ').append(subqueryRootAlias);
        context.append(" WHERE");


        // TODO: andrus, 8/11/2007 flattened?
        DbRelationship correlatedJoinRelationship = context.getIncomingRelationships(
                new EJBQLTableId(id)).get(0);


        for (DbJoin join : correlatedJoinRelationship.getJoins()) {
            context.append(' ').append(subqueryRootAlias).append('.').append(
                    join.getTargetName()).append(" = ");
            context.append(correlatedTableAlias).append('.').append(join.getSourceName());
            context.append(" AND");
        }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.cayenne.map.DbRelationship$TestJoin

er.cayenne.CayenneConverter

org.apache.cayenne.access.DataContext

org.apache.cayenne.access.DataDomainDBDiffBuilder

org.apache.cayenne.access.DataDomainInsertBucket

org.apache.cayenne.access.DataDomainQueryAction

org.apache.cayenne.access.DataNodeSyncQualifierDescriptor

org.apache.cayenne.access.DataRowUtils

org.apache.cayenne.access.DbArcIdTest

org.apache.cayenne.access.DbGenerator

org.apache.cayenne.access.DbLoader

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.