Changeset 149 for trunk/grails-app/conf/DataSource.groovy

Timestamp:

Oct 9, 2009, 9:47:11 PM (16 years ago)

Author:

gav

Message:

Refactor bootstrap data generation to new CreateDataService?.
Tweak security annotations so that ROLE_AppAdmin gives access to all areas.
Rework DataSource? to allow building of prod and dev WARs.
Include MySQL jdbc connector which is GNU GPL'd and used in the prod WAR.

File:

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

trunk/grails-app/conf/DataSource.groovy

@@ -1 +1 @@
 dataSource {
     pooled = true
-    /** HSQLDB  */
-    driverClassName = "org.hsqldb.jdbcDriver"
-    username = "sa"
-    password = ""
-    /** MySQL */
-//     driverClassName = "com.mysql.jdbc.Driver"
-//     username = "gnumimsadmin"
-//     password = "gnumimsadmin"
 }
 hibernate {
@@ -17 +9 @@
 
 // Environment specific settings.
-// create-drop:  drop tables and data between sessions, then call Bootstrap.
-// create:        drop data between sessions, can't explain the rest of the behaviour.
-// update:       keep data, update tables as required, then call BootStrap.
+// create-drop: Drop and re-create the database between sessions. Deletes existing data.
+// create:       Create the database if it doesn't exist, but don't modify it if it does. Deletes existing data.
+// update:     Create the database if it doesn't exist, and modify it if it does exist. Keep data.
 environments {
     development {
         dataSource {
             /** HSQLDB - In memory */
+            driverClassName = "org.hsqldb.jdbcDriver"
+            username = "sa"
+            password = ""
             dbCreate = "create-drop"
             url = "jdbc:hsqldb:mem:devDB"
             /** MySQL */
+//             driverClassName = "com.mysql.jdbc.Driver"
+//             username = "gnumimsadmin"
+//             password = "gnumimsadmin"
 //             dbCreate = "create-drop"
 //             url = "jdbc:mysql://host:3306/gnumims_dev"
@@ -34 +32 @@
         dataSource {
             /** HSQLDB - In memory */
+            driverClassName = "org.hsqldb.jdbcDriver"
+            username = "sa"
+            password = ""
             dbCreate = "update"
             url = "jdbc:hsqldb:mem:devDb"
             /** MySQL */
+//             driverClassName = "com.mysql.jdbc.Driver"
+//             username = "gnumimsadmin"
+//             password = "gnumimsadmin"
 //             dbCreate = "update"
 //             url = "jdbc:mysql://host:3306/gnumims_test"
@@ -43 +47 @@
     production {
         dataSource {
+            /* Delete dbCreate line after setup! */
             /** HSQLDB - In memory */
-            //Delete dbCreate line after setup!
-            dbCreate = "create-drop"
-            url = "jdbc:hsqldb:mem:devDB"
+//             driverClassName = "org.hsqldb.jdbcDriver"
+//             username = "sa"
+//             password = ""
+//             dbCreate = "create-drop"
+//             url = "jdbc:hsqldb:mem:devDB"
             /** HSQLDB - In file */
+//             driverClassName = "org.hsqldb.jdbcDriver"
+//             username = "sa"
+//             password = ""
 //             dbCreate = "update"
 //             url = "jdbc:hsqldb:file:prodDb;shutdown=true"
             /** MySQL */
-//             dbCreate = "update"
-//             url = "jdbc:mysql://host:3306/gnumims_prod"
+            driverClassName = "com.mysql.jdbc.Driver"
+            username = "gnumimsadmin"
+            password = "gnumimsadmin"
+            dbCreate = "update"
+            url = "jdbc:mysql://gnumimssql01:3306/gnumims_prod"
         }
     }