Changeset 2228

Timestamp:

May 8, 2012, 4:57:55 PM (12 years ago)

Author:

work@…

Message:

Resolved issue #51: Changed ontology description type to 'text' (instead of varchar 22) in GDT 0.2.1

Location:

trunk

Files:

• application.properties (modified) (1 diff)
• grails-app/conf/dbnp/configuration/DatabaseUpgrade.groovy (modified) (2 diffs)

trunk/application.properties

@@ -12 +12 @@
 plugins.crypto=2.0
 plugins.famfamfam=1.0.1
-plugins.gdt=0.2.0
+plugins.gdt=0.2.1
 plugins.gdtimporter=0.4.6.7
 plugins.grails-melody=1.11

trunk/grails-app/conf/dbnp/configuration/DatabaseUpgrade.groovy

@@ -43 +43 @@
                                                         // GdtImporter now by default uses 'columnindex' as domain field name
                 fixShibbolethSecUser(sql, db)                                   // fix shibboleth user
+        changeOntologyDescriptionType(sql, db)          // change ontology description type to text
         }
 
@@ -426 +427 @@
                 }
         }
+
+    /**
+     * Make sure the ontology's description is of type text instead of varchar
+     * @param sql
+     * @param db
+     */
+    public static void changeOntologyDescriptionType(sql, db) {
+        // are we running postgreSQL?
+        if (db == "org.postgresql.Driver") {
+            if (sql.firstRow("SELECT * FROM information_schema.columns WHERE columns.table_name='study' AND columns.column_name='code' AND columns.data_type='character varying'")) {
+                if (String.metaClass.getMetaMethod("grom")) "performing database upgrade: change ontology description type".grom()
+
+                try {
+                    // change the datatype of the ontology's description to text
+                    sql.execute("ALTER TABLE ontology ALTER COLUMN description TYPE text")
+                } catch (Exception e) {
+                    println "changeOntologyDescriptionType database upgrade failed: " + e.getMessage()
+                }
+            }
+        }
+   }
 }