Changeset 1406

Timestamp:

Jan 18, 2011, 1:12:24 PM (12 years ago)

Author:

work@…

Message:

• test fix for database upgrade script

File:

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

trunk/grails-app/conf/DatabaseUpgrade.groovy

@@ -37 +37 @@
          * execute database change r1245 / r1246 if required
          * @param sql
+         * @param db
          */
         public static void changeStudyDescription(sql, db) {
@@ -83 +84 @@
          * execute database change r1327 if required
          * @param sql
+         * @param db
          */
         public static void changeStudyDescriptionToText(sql, db) {
@@ -103 +105 @@
         }
 
+        /**
+         * it appears that some TEXT template fields are not of type 'text'
+         * which results in the '255' character issue
+         * @param sql
+         * @param db
+         */
         public static void changeTemplateTextFieldSignatures(sql, db) {
                 if (db == "org.postgresql.Driver") {
@@ -111 +119 @@
                                 try {
                                         // change the datatype of text fields to text
-                                        sql.execute("ALTER TABLE ${row.tablename} ALTER COLUMN template_text_fields_elt TYPE text")
-                                        sql.execute("ALTER TABLE ${row.tablename} ALTER COLUMN template_text_fields_string TYPE text")
+                                        sql.execute("ALTER TABLE ${row.tablename.toString()} ALTER COLUMN template_text_fields_elt TYPE text")
+                                        sql.execute("ALTER TABLE ${row.tablename.toString()} ALTER COLUMN template_text_fields_string TYPE text")
 
                                 } catch (Exception e) {