Changeset 945

Timestamp:

May 24, 2011, 12:54:27 PM (13 years ago)

Author:

gav

Message:

Introduce appNameLowerCase variable for production database naming convention, part 2.
Also change default production SQL host to 'sql01'.

Location:

trunk

Files:

• gnuMims-config.groovy (modified) (2 diffs)
• grails-app/conf/DataSource.groovy (modified) (3 diffs)

trunk/gnuMims-config.groovy

@@ -53 +53 @@
 //             password = "${appNameLowerCase}admin"
 //             dbCreate = "update"
-//             url = "jdbc:sqlserver://${appNameLowerCase}sql01:1433;databaseName=${appNameLowerCase}_prod"
+//             url = "jdbc:sqlserver://sql01:1433;databaseName=${appNameLowerCase}_prod"
             /** MySQL */
             dialect = org.hibernate.dialect.MySQL5InnoDBDialect
@@ -60 +60 @@
             password = "${appNameLowerCase}admin"
             dbCreate = "update"
-            url = "jdbc:mysql://${appNameLowerCase}sql01:3306/${appNameLowerCase}_prod?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
+            url = "jdbc:mysql://sql01:3306/${appNameLowerCase}_prod?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
         }
     }

trunk/grails-app/conf/DataSource.groovy

@@ -15 +15 @@
 // If nothing specified then do nothing to database schema.
 
+def appNameLowerCase = appName.toLowerCase()
+
 // Environment specific settings.
 // All production config is in external config.
@@ -29 +31 @@
 //             dialect = org.hibernate.dialect.MySQL5InnoDBDialect
 //             driverClassName = "com.mysql.jdbc.Driver"
-//             username = "gnumimsadmin"
-//             password = "gnumimsadmin"
+//             username = "${appNameLowerCase}admin"
+//             password = "${appNameLowerCase}admin"
 //             dbCreate = "create-drop"
-//             url = "jdbc:mysql://host:3306/gnumims_dev?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
+//             url = "jdbc:mysql://host:3306/${appNameLowerCase}_dev?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
         }
     }
@@ -46 +48 @@
 //             dialect = org.hibernate.dialect.MySQL5InnoDBDialect
 //             driverClassName = "com.mysql.jdbc.Driver"
-//             username = "gnumimsadmin"
-//             password = "gnumimsadmin"
+//             username = "${appNameLowerCase}admin"
+//             password = "${appNameLowerCase}admin"
 //             dbCreate = "update"
-//             url = "jdbc:mysql://host:3306/gnumims_test?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
+//             url = "jdbc:mysql://host:3306/${appNameLowerCase}_test?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
         }
     }