Changeset 1602 for trunk/grails-app

Timestamp:

Mar 8, 2011, 4:08:59 PM (12 years ago)

Author:

work@…

Message:

• improved database upgrade script

File:

• trunk/grails-app/conf/DatabaseUpgrade.groovy (modified) (2 diffs)

trunk/grails-app/conf/DatabaseUpgrade.groovy

@@ -33 +33 @@
                 changeTemplateTextFieldSignatures(sql, db)      // prevent Grails issue, see http://jira.codehaus.org/browse/GRAILS-6754
                 setAssayModuleDefaultValues(sql, db)            // r1490
-                dropMappingColumnNameConstraint(sql, db)
+                dropMappingColumnNameConstraint(sql, db)        // r1525
+                makeMappingColumnValueNullable(sql, db)         // r1525
                 alterStudyAndAssay(sql, db)                                     // r1594
         }
@@ -186 +187 @@
 
         /**
+         * the importer requires the value field to be nullable
+         * @param sql
+         * @param db
+         */
+        public static void makeMappingColumnValueNullable(sql, db) {
+                // are we running postgreSQL?
+                if (db == "org.postgresql.Driver") {
+                        // do we need to perform this update?
+                        if (sql.firstRow("SELECT * FROM information_schema.columns WHERE columns.table_name='mapping_column' AND columns.column_name='value' AND is_nullable='NO'")) {
+                                "performing database upgrade: making mapping_column::value nullable".grom()
+
+                                try {
+                                        sql.execute("ALTER TABLE mapping_column ALTER COLUMN value DROP NOT NULL")
+                                } catch (Exception e) {
+                                        println "makeMappingColumnValueNullable database upgrade failed: " + e.getMessage()
+                                }
+                        }
+                }
+        }
+
+        /**
          * The field study.code has been set to be nullable
          * The field assay.externalAssayId has been removed