From e65179fd5a2bf3e71a55c46ca981a7792e3d57a3 Mon Sep 17 00:00:00 2001
From: Richard Millet <remillet@yahoo.com>
Date: Fri, 31 Aug 2018 14:16:14 -0700
Subject: [PATCH] DRYD-473: Changing constraint to the 'relationshiptype' field
 instead of the deprecated 'predicate' field.

---
 .../7.10-HF17/config/vcsconfig.sql.txt        |  2 +-
 .../nuxeo/RelationValidatorHandler.java       | 42 +++++++++----------
 2 files changed, 22 insertions(+), 22 deletions(-)

diff --git a/3rdparty/nuxeo/nuxeo-server/7.10-HF17/config/vcsconfig.sql.txt b/3rdparty/nuxeo/nuxeo-server/7.10-HF17/config/vcsconfig.sql.txt
index bbc090f90..4144c65db 100644
--- a/3rdparty/nuxeo/nuxeo-server/7.10-HF17/config/vcsconfig.sql.txt
+++ b/3rdparty/nuxeo/nuxeo-server/7.10-HF17/config/vcsconfig.sql.txt
@@ -37,4 +37,4 @@ LOG.INFO Adding constraint to the relations table to prevent duplicate relations
 SELECT constraint_name FROM information_schema.constraint_column_usage WHERE table_name = 'relations_common' AND constraint_name = 'relations_unique';
 
 #IF: emptyResult
-ALTER TABLE relations_common add CONSTRAINT relations_unique UNIQUE (subjectcsid, subjectrefname, predicate, objectcsid, objectrefname);
+ALTER TABLE relations_common add CONSTRAINT relations_unique UNIQUE (subjectcsid, subjectrefname, relationshiptype, objectcsid, objectrefname);
diff --git a/services/relation/service/src/main/java/org/collectionspace/services/relation/nuxeo/RelationValidatorHandler.java b/services/relation/service/src/main/java/org/collectionspace/services/relation/nuxeo/RelationValidatorHandler.java
index d00793877..9ae8ea227 100644
--- a/services/relation/service/src/main/java/org/collectionspace/services/relation/nuxeo/RelationValidatorHandler.java
+++ b/services/relation/service/src/main/java/org/collectionspace/services/relation/nuxeo/RelationValidatorHandler.java
@@ -29,39 +29,39 @@ public class RelationValidatorHandler extends ValidatorHandlerImpl<PoxPayloadIn,
     }
     
     @Override
-    protected void handleCreate()
-    		throws InvalidDocumentException{
-    	try {
-	    	RelationsCommon relationsCommon = (RelationsCommon)getCommonPart();
-	    	CS_ASSERT(relationsCommon != null);
-    		if (logger.isTraceEnabled() == true) {
-    			logger.trace(relationsCommon.toString());
-    		}
-	    	
+    protected void handleCreate() throws InvalidDocumentException {
+        try {
+            RelationsCommon relationsCommon = (RelationsCommon) getCommonPart();
+            CS_ASSERT(relationsCommon != null);
+            if (logger.isTraceEnabled() == true) {
+                logger.trace(relationsCommon.toString());
+            }
+
             String subjectCsid = relationsCommon.getSubjectCsid();
             String objectCsid = relationsCommon.getObjectCsid();
-	    	
+
             // If no CSID for a subject or object is included in the create payload,
-            // a refName must be provided for that subject or object as an alternate identifier.
+            // a refName must be provided for that subject or object as an alternate
+            // identifier.
             CS_ASSERT(hasCsid(subjectCsid) || hasSubjectRefname(relationsCommon));
             CS_ASSERT(hasCsid(objectCsid) || hasObjectRefname(relationsCommon));
-	    	
+
             // The Subject identifier and Object ID must not be identical:
             // that is, a resource cannot be related to itself.
             if (hasCsid(subjectCsid) && hasCsid(objectCsid)) {
-            	CS_ASSERT (subjectCsid.trim().equalsIgnoreCase(objectCsid.trim()) == false,
-                        SUBJECT_EQUALS_OBJECT_ERROR);
+                CS_ASSERT(subjectCsid.trim().equalsIgnoreCase(objectCsid.trim()) == false, SUBJECT_EQUALS_OBJECT_ERROR);
             }
 
-            // A relationship type must be provided.
+            // A relationship type must be provided.  Set the redundant "predicate" field to be the same
             CS_ASSERT(relationsCommon.getRelationshipType() != null);
+            relationsCommon.setPredicate(relationsCommon.getRelationshipType());
 
-    	} catch (AssertionError e) {
-    		if (logger.isErrorEnabled() == true) {
-    			logger.error(e.getMessage(), e);
-    		}
-    		throw new InvalidDocumentException(VALIDATION_ERROR, e);
-    	}
+        } catch (AssertionError e) {
+            if (logger.isErrorEnabled() == true) {
+                logger.error(e.getMessage(), e);
+            }
+            throw new InvalidDocumentException(VALIDATION_ERROR, e);
+        }
     }
 
 	@Override
-- 
2.47.3