public NSArray statementsToDropPrimaryKeyConstraintsOnEntityGroups(
NSArray entityGroups,
EOSchemaSynchronizationModelChanges changes,
EOSchemaGenerationOptions options) {
if (entityGroups == null) return NSArray.EmptyArray;
if (changes == null) changes = newChanges();
NSMutableArray expressions = new NSMutableArray();
for (Enumeration enumerator = entityGroups.objectEnumerator();
enumerator.hasMoreElements(); ) {
NSArray entities = (NSArray) enumerator.nextElement();
EOEntity _last =
(EOEntity)
entities.lastObject(); // only need entity to get the table name for the group
String nameInObjectStore =
_nameInObjectStoreForEntityGroupWithChangeDictionary(
entities, changes.changesForTableNamed(_last.externalName()));
if ((nameInObjectStore != null) && (!"".equals(nameInObjectStore))) {
expressions.addObject(
this._expressionForString(
"delete from _SYS_RELATIONSHIP where source_table = '"
+ nameInObjectStore
+ "' or dest_table = '"
+ nameInObjectStore
+ "'"));
}
}
return expressions.immutableClone();
}
public NSArray customerIssues() {
NSMutableArray allChildren = new NSMutableArray();
NSMutableArray qual = new NSMutableArray();
Item customer;
Item child;
if (customerIssues == null) {
if (bugId() != null) {
qual.addObject(EOQualifier.qualifierWithQualifierFormat("bugId=" + bugId(), null));
EOFetchSpecification spec =
new EOFetchSpecification("Item", new EOAndQualifier(qual), null);
// Perform actual fetch
customerIssues =
(NSArray) session().defaultEditingContext().objectsWithFetchSpecification(spec);
} else {
Enumeration enumer = ((NSArray) customerIssueDisplayGroup.allObjects()).objectEnumerator();
// For each Customer
while (enumer.hasMoreElements()) {
customer = (Item) enumer.nextElement();
NSArray children = (NSArray) customer.valueForKey("allChildren");
// Add all of their issues (if they haven't been added already
Enumeration enumer2 = children.objectEnumerator();
while (enumer2.hasMoreElements()) {
child = (Item) enumer2.nextElement();
if (!allChildren.contains(child)) {
allChildren.addObject(child);
}
}
}
Object orderings[] = {
EOSortOrdering.sortOrderingWithKey("version", EOSortOrdering.CompareAscending),
EOSortOrdering.sortOrderingWithKey("targetMilestone", EOSortOrdering.CompareAscending),
EOSortOrdering.sortOrderingWithKey(
"priority", EOSortOrdering.CompareCaseInsensitiveAscending),
EOSortOrdering.sortOrderingWithKey(
"bugSeverity", EOSortOrdering.CompareCaseInsensitiveAscending),
};
// Sort the issues
customerIssues =
EOSortOrdering.sortedArrayUsingKeyOrderArray(allChildren, new NSArray(orderings));
}
}
return customerIssues;
}
protected PersonLink defaultSelectionValue() {
NSArray list = (NSArray) valueForBinding("forcedList");
if (list != null && list.count() > 0) {
return (PersonLink)
EOUtilities.localInstanceOfObject(ec, (EOEnterpriseObject) list.objectAtIndex(0));
}
list = (NSArray) session().valueForKey("personList");
if (list != null && list.count() > 0) {
Enumeration enu = list.objectEnumerator();
while (enu.hasMoreElements()) {
EOEnterpriseObject pers = (EOEnterpriseObject) enu.nextElement();
if (entity().equals(pers.entityName())) {
return (PersonLink) pers;
}
}
}
return null;
}
public NSArray personList() {
NSArray forcedList = (NSArray) valueForBinding("forcedList");
NSMutableArray result =
(forcedList == null)
? new NSMutableArray()
: EOUtilities.localInstancesOfObjects(ec, forcedList).mutableClone();
NSArray personList = (NSArray) session().valueForKey("personList");
if (personList != null && personList.count() > 0) {
Enumeration enu = personList.objectEnumerator();
while (enu.hasMoreElements()) {
EOEnterpriseObject pers = (EOEnterpriseObject) enu.nextElement();
if (!result.contains(pers)
&& (entity().equals(pers.entityName()) || pers.entityName().equals(alterEntity())))
result.addObject(pers);
}
}
return result;
}
public void invalidateObjects(NSArray pObjects) {
// System.out.println("ReleasePlan.invalidateObjects()");
// Invalidate Objects
if (pObjects != null) {
// System.out.println("ReleasePlan.invalidateObjects() - 2");
Enumeration enumer = pObjects.objectEnumerator();
NSMutableArray temp = new NSMutableArray();
while (enumer.hasMoreElements()) {
Item i = (Item) enumer.nextElement();
i.invalidateAllChildren();
EOGlobalID id = (EOGlobalID) (session().defaultEditingContext().globalIDForObject(i));
if (id != null) {
temp.addObject(id);
}
}
session().defaultEditingContext().invalidateObjectsWithGlobalIDs((NSArray) temp);
}
}
public NSArray statementsToImplementPrimaryKeyConstraintsOnEntityGroups(
NSArray entityGroups,
EOSchemaSynchronizationModelChanges changes,
EOSchemaGenerationOptions options) {
NSArray primaryKeyExpressions =
this.primaryKeyConstraintStatementsForEntityGroups(entityGroups);
NSMutableArray createStatements = new NSMutableArray();
NSMutableArray otherStatements = new NSMutableArray();
for (Enumeration enumerator = primaryKeyExpressions.objectEnumerator();
enumerator.hasMoreElements(); ) {
EOSQLExpression expression = (EOSQLExpression) enumerator.nextElement();
String statement = expression.statement();
if (statement.startsWith("create")) {
createStatements.addObject(expression);
} else if (!statement.startsWith("delete from _SYS_RELATIONSHIP")) {
otherStatements.addObject(expression);
}
}
return createStatements.arrayByAddingObjectsFromArray(otherStatements);
}
public NSArray primaryKeyConstraintStatementsForEntityGroup(NSArray entityGroup) {
if (entityGroup == null) return NSArray.EmptyArray;
NSMutableDictionary columnNameDictionary = new NSMutableDictionary();
NSMutableArray primaryKeyConstraintExpressions = new NSMutableArray();
for (Enumeration enumerator = entityGroup.objectEnumerator();
enumerator.hasMoreElements(); ) {
EOEntity entity = (EOEntity) enumerator.nextElement();
String tableName = entity.externalName();
NSArray primaryKeyAttributes = entity.primaryKeyAttributes();
boolean singlePrimaryKey = primaryKeyAttributes.count() == 1;
if ((tableName != null) && (!"".equals(tableName)) && (primaryKeyAttributes.count() > 0)) {
NSArray expressions = super.primaryKeyConstraintStatementsForEntityGroup(entityGroup);
if ((expressions != null) && (expressions.count() > 0))
primaryKeyConstraintExpressions.addObjectsFromArray(expressions);
for (Enumeration attributeEnumerator = primaryKeyAttributes.objectEnumerator();
attributeEnumerator.hasMoreElements(); ) {
String columnName = ((EOAttribute) attributeEnumerator.nextElement()).columnName();
columnNameDictionary.setObjectForKey(
columnName, entity.externalName() + "." + columnName);
EOSQLExpression expression =
this._expressionForString(
"create "
+ (singlePrimaryKey ? "unique" : "")
+ " index "
+ entity.externalName()
+ " "
+ columnName);
if (expression != null) primaryKeyConstraintExpressions.addObject(expression);
}
}
}
for (Enumeration enumerator = entityGroup.objectEnumerator();
enumerator.hasMoreElements(); ) {
EOEntity entity = (EOEntity) enumerator.nextElement();
String tableName = entity.externalName();
if ((tableName != null) && (!"".equals(tableName))) {
for (Enumeration relationshipEnumerator = entity.relationships().objectEnumerator();
relationshipEnumerator.hasMoreElements(); ) {
EORelationship relationship = (EORelationship) relationshipEnumerator.nextElement();
if (!relationship.isFlattened()) {
NSArray destinationAttributes = relationship.destinationAttributes();
// First exclude all the destination entity primary keys
for (Enumeration attributeEnumerator =
relationship.destinationEntity().primaryKeyAttributes().objectEnumerator();
attributeEnumerator.hasMoreElements(); ) {
EOAttribute attribute = (EOAttribute) attributeEnumerator.nextElement();
columnNameDictionary.setObjectForKey(
attribute.columnName(),
relationship.destinationEntity().externalName() + "." + attribute.columnName());
}
// Then deal with our end of things
for (Enumeration attributeEnumerator =
relationship.sourceAttributes().objectEnumerator();
attributeEnumerator.hasMoreElements(); ) {
EOAttribute attribute = (EOAttribute) attributeEnumerator.nextElement();
if ((!this.isSinglePrimaryKeyAttribute(attribute))
&& (columnNameDictionary.objectForKey(tableName + "." + attribute.columnName())
!= null)) {
columnNameDictionary.setObjectForKey(
attribute.columnName(), tableName + "." + attribute.columnName());
EOSQLExpression expression =
this._expressionForString(
"create index " + tableName + " " + attribute.columnName());
if (expression != null) primaryKeyConstraintExpressions.addObject(expression);
}
}
// Then deal with the other side
if (entity.model() == relationship.destinationEntity().model()) {
for (Enumeration attributeEnumerator =
relationship.destinationAttributes().objectEnumerator();
attributeEnumerator.hasMoreElements(); ) {
EOAttribute attribute = (EOAttribute) attributeEnumerator.nextElement();
String destinationTableName = relationship.destinationEntity().externalName();
if ((destinationTableName != null) && (!"".equals(destinationTableName))) {
if ((!this.isSinglePrimaryKeyAttribute(attribute))
&& (columnNameDictionary.objectForKey(
destinationTableName + "." + attribute.columnName())
!= null)) {
columnNameDictionary.setObjectForKey(
attribute.columnName(),
destinationTableName + "." + attribute.columnName());
EOSQLExpression expression =
this._expressionForString(
"create index "
+ destinationTableName
+ " "
+ attribute.columnName());
if (expression != null) primaryKeyConstraintExpressions.addObject(expression);
}
if ((!relationship.isCompound())
&& (relationship.sourceAttributes().count() == 1)
&& (relationship.destinationAttributes().count() == 1)) {
String semantics;
switch (relationship.joinSemantic()) {
case EORelationship.FullOuterJoin: // '\001'
case EORelationship.LeftOuterJoin: // '\002'
case EORelationship.RightOuterJoin: // '\003'
semantics = "*";
break;
default:
semantics = "=";
break;
}
String sourceColumn =
((EOAttribute) relationship.sourceAttributes().objectAtIndex(0))
.columnName();
String destinationColumn =
((EOAttribute) relationship.destinationAttributes().objectAtIndex(0))
.columnName();
EOSQLExpression expression =
this._expressionForString(
"delete from _SYS_RELATIONSHIP where relationshipName = '"
+ relationship.name()
+ "' and source_table = '"
+ tableName
+ "' ");
if (expression != null) primaryKeyConstraintExpressions.addObject(expression);
expression =
this._expressionForString(
"insert into _SYS_RELATIONSHIP (relationshipName, source_table, source_column, dest_table, dest_column, operator, one_to_many) values ('"
+ relationship.name()
+ "','"
+ tableName
+ "','"
+ sourceColumn
+ "','"
+ destinationTableName
+ "','"
+ destinationColumn
+ "','"
+ semantics
+ "',"
+ (relationship.isToMany() ? 1 : 0)
+ ")");
if (expression != null) primaryKeyConstraintExpressions.addObject(expression);
}
}
}
}
}
}
}
}
return primaryKeyConstraintExpressions.immutableClone();
}
