Changeset 1776

Timestamp:

Apr 19, 2011, 4:35:56 PM (12 years ago)

Author:

work@…

Message:

• resolves #401, study title should be unique

Location:

trunk/grails-app

Files:

• conf/DatabaseUpgrade.groovy (modified) (2 diffs)
• domain/dbnp/studycapturing/Study.groovy (modified) (1 diff)

trunk/grails-app/conf/DatabaseUpgrade.groovy

@@ -38 +38 @@
                 fixDateCreatedAndLastUpdated(sql, db)
                 dropAssayModulePlatform(sql, db)                        // r1689
+                makeStudyTitleUnique(sql, db)                           // #401
         }
 
@@ -306 +307 @@
                 }
         }
+
+        /**
+         * Make sure the study title is unique
+         * @param sql
+         * @param db
+         */
+        public static void makeStudyTitleUnique(sql, db) {
+                def titleCount,title,newTitle
+
+                // are we running postgreSQL?
+                if (db == "org.postgresql.Driver") {
+                        // yes, find all duplicate study titles
+                        sql.eachRow("SELECT DISTINCT a.title FROM Study a WHERE (SELECT count(*) FROM Study b WHERE b.title=a.title) > 1") { row ->
+                                // grom what we are doing
+                                if (String.metaClass.getMetaMethod("grom")) "making study title '${row.title}' unique".grom()
+
+                                // iterate through studies that use this duplicate title
+                                titleCount      = 1
+                                title           = row.title.replace("'","\'")
+                                sql.eachRow(sprintf("SELECT id FROM Study WHERE title='%s'", title)) { studyRow ->
+                                        newTitle = "${title} - ${titleCount}"
+                                        sql.execute(sprintf("UPDATE Study SET title='%s' WHERE id=%d",newTitle,studyRow.id))
+                                        titleCount++
+                                }
+                        }
+                }
+        }
 }

trunk/grails-app/domain/dbnp/studycapturing/Study.groovy

@@ -52 +52 @@
 
         static constraints = {
-                title(nullable:false, blank: false, maxSize: 255)
+                title(nullable:false, blank: false, unique:true, maxSize: 255)
                 owner(nullable: true, blank: true)
                 code(nullable: true, blank: true, unique: true, maxSize: 255)