The problem is not in fact not whether I am using a predicate or testing for targetMany. I will try that again but let me go back to my original question by way of example. I will leave out the velocity script and simply pose the question:
I have a MASTER table and three foreign key columns that are one-to-many. I want to iterate over the relations for the MASTER table and display the foreign key column name associated with each child set.
I hope this is clear and I apologize for the mix-up with the getManyRelationshipRoles which was really a side issue.
-----Original Message-----
From: Rod Macpherson
Sent: Sun 12/8/2002 12:40 PM
To: Aslak HellesÞy; middlegen-***@lists.sourceforge.net
Cc:
Subject: RE: [Middlegen-user] Getting Foreign Key from RelationshipRole
Oops! I omitted a rather important detail. I added getManyRelationshipRoles so there is both a one and a many:
// This existed
public Collection getOneRelationshipRoles() {
return getRelationshipRoles(middlegen.predicates.relation.TargetOne.getInstance());
}
// This was added
public Collection getManyRelationshipRoles() {
return getRelationshipRoles(middlegen.predicates.relation.TargetMany.getInstance());
}
When iterating of the filtered result there is no column map on the "target" role. Iterating over all of them and then testing for "many" works fine but should these not be equivalent?
(P.S. getting this email through outlook web access and do not see a plain text setting)
-----Original Message-----
From: Aslak HellesÞy [mailto:***@netcom.no]
Sent: Sun 12/8/2002 11:05 AM
To: Rod Macpherson; middlegen-***@lists.sourceforge.net
Cc:
Subject: RE: [Middlegen-user] Getting Foreign Key from RelationshipRole
TableDecorator doesn't have a getManyRelationshipRoles() method, so it's the first loop you'll never enter. Try:
#foreach($role in $table.relationshipRoles)
#if($role.targetMany)
#foreach( $map in $role.columnMaps )
System.out.println("${map.foreignKey}");
#end
#end
#end
Aslak
-----Original Message-----
From: middlegen-user-***@lists.sourceforge.net [mailto:middlegen-user-***@lists.sourceforge.net]On Behalf Of Rod Macpherson
Sent: 8. desember 2002 19:37
To: middlegen-***@lists.sourceforge.net
Subject: [Middlegen-user] Getting Foreign Key from RelationshipRole
I am iterating over a set of one-to-many relationship roles for a given table in my velocity script. When the target is "many" the columnMaps array is always empty. How would I print out the foreign key columns in this case? This snippet provides no output because the map is always empty. Where does that information reside?
#foreach($role in $table.manyRelationshipRoles)
#foreach( $map in $role.targetRole.columnMaps )
System.out.println("${map.foreignKey}");
#end
#end
All ideas welcome!