Changeset 1689 for trunk/grails-app/conf/DatabaseUpgrade.groovy

Timestamp:

Apr 4, 2011, 11:54:25 AM (12 years ago)

Author:

robert@…

Message:

Removed assayModule platform field (#387)

File:

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

trunk/grails-app/conf/DatabaseUpgrade.groovy

@@ -37 +37 @@
                 alterStudyAndAssay(sql, db)                                     // r1594
                 fixDateCreatedAndLastUpdated(sql, db)
+                dropAssayModulePlatform(sql, db)                        // r1689
         }
 
@@ -283 +284 @@
                 }
         }
+        
+        
+        /**
+         * drops the field platform from assay modules
+         * @param sql
+         * @param db
+         */
+        public static void dropAssayModulePlatform(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='assay_module' AND columns.column_name='platform'")) {
+                                if (String.metaClass.getMetaMethod("grom")) "performing database upgrade: removing assayModule platform".grom()
+
+                                try {
+                                        sql.execute("ALTER TABLE assay_module DROP COLUMN platform")
+                                } catch (Exception e) {
+                                        println "dropAssayModulePlatform database upgrade failed: " + e.getMessage()
+                                }
+                        }
+                }
+        }
 }