Changeset 945


Ignore:
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:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/gnuMims-config.groovy

    r943 r945  
    5353//             password = "${appNameLowerCase}admin"
    5454//             dbCreate = "update"
    55 //             url = "jdbc:sqlserver://${appNameLowerCase}sql01:1433;databaseName=${appNameLowerCase}_prod"
     55//             url = "jdbc:sqlserver://sql01:1433;databaseName=${appNameLowerCase}_prod"
    5656            /** MySQL */
    5757            dialect = org.hibernate.dialect.MySQL5InnoDBDialect
     
    6060            password = "${appNameLowerCase}admin"
    6161            dbCreate = "update"
    62             url = "jdbc:mysql://${appNameLowerCase}sql01:3306/${appNameLowerCase}_prod?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
     62            url = "jdbc:mysql://sql01:3306/${appNameLowerCase}_prod?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
    6363        }
    6464    }
  • trunk/grails-app/conf/DataSource.groovy

    r923 r945  
    1515// If nothing specified then do nothing to database schema.
    1616
     17def appNameLowerCase = appName.toLowerCase()
     18
    1719// Environment specific settings.
    1820// All production config is in external config.
     
    2931//             dialect = org.hibernate.dialect.MySQL5InnoDBDialect
    3032//             driverClassName = "com.mysql.jdbc.Driver"
    31 //             username = "gnumimsadmin"
    32 //             password = "gnumimsadmin"
     33//             username = "${appNameLowerCase}admin"
     34//             password = "${appNameLowerCase}admin"
    3335//             dbCreate = "create-drop"
    34 //             url = "jdbc:mysql://host:3306/gnumims_dev?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
     36//             url = "jdbc:mysql://host:3306/${appNameLowerCase}_dev?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
    3537        }
    3638    }
     
    4648//             dialect = org.hibernate.dialect.MySQL5InnoDBDialect
    4749//             driverClassName = "com.mysql.jdbc.Driver"
    48 //             username = "gnumimsadmin"
    49 //             password = "gnumimsadmin"
     50//             username = "${appNameLowerCase}admin"
     51//             password = "${appNameLowerCase}admin"
    5052//             dbCreate = "update"
    51 //             url = "jdbc:mysql://host:3306/gnumims_test?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
     53//             url = "jdbc:mysql://host:3306/${appNameLowerCase}_test?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
    5254        }
    5355    }
Note: See TracChangeset for help on using the changeset viewer.