dataSource {
    pooled = true
    //jmxExport = true
    driverClassName = 'com.mysql.jdbc.Driver'
    dialect = br.com.eteg.mysqldialect.MySQLInnoDBExtendedDialect.class
    username = 'root'
    // password = ''
    //logSql = true
    properties {
        validationQuery = 'SELECT 1'
        testOnBorrow = true
        testWhileIdle = true
        testOnReturn = false
        maxActive = 10
        maxIdle = 7
        minIdle = 5
        initialSize = 5
        minEvictableIdleTimeMillis = 60000
        timeBetweenEvictionRunsMillis = 60000
        maxWait = 10000
    }
}
dataSource_logs {
    properties {
        validationQuery = 'SELECT 1'
        testOnBorrow = true
        testWhileIdle = true
        testOnReturn = false
        maxActive = 10
        maxIdle = 7
        minIdle = 5
        initialSize = 5
        minEvictableIdleTimeMillis = 60000
        timeBetweenEvictionRunsMillis = 60000
        maxWait = 10000
    }
}

hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = false
    //    cache.region.factory_class = 'org.hibernate.cache.SingletonEhCacheRegionFactory' // Hibernate 3
    cache.region.factory_class = 'org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory' // Hibernate 4
    singleSession = true // configure OSIV singleSession mode
    flush.mode = 'manual' // OSIV session flush mode outside of transactional context
    //Unicode support mysql https://mathiasbynens.be/notes/mysql-utf8mb4
    connection.charSet = 'utf8mb4'
    connection.characterEncoding = 'utf8mb4'
    connection.useUnicode = true
}
// environment specific settings
environments {
    development {
        dataSource {
            // pooled = true
            //dbCreate = 'validate'
            // url = 'jdbc:mysql://ammg-teste.ctd3u1ljvt9q.us-east-1.rds.amazonaws.com/ammg_test'
            url = 'jdbc:mysql://localhost:3306/ammg_dev?useSSL=false'
            username = 'root'
            // password = ''
            properties {
                // See http://grails.org/doc/latest/guide/conf.html#dataSource for documentation
                jmxEnabled = true
                initialSize = 5
                maxActive = 500
                minIdle = 5
                maxIdle = 25
                maxWait = 10000
                maxAge = 10 * 60000
                timeBetweenEvictionRunsMillis = 5000
                minEvictableIdleTimeMillis = 60000
                validationQuery = "SELECT 1"
                validationQueryTimeout = 3
                validationInterval = 15000
                testOnBorrow = true
                testWhileIdle = true
                testOnReturn = false
                jdbcInterceptors = "ConnectionState"
                defaultTransactionIsolation = java.sql.Connection.TRANSACTION_READ_COMMITTED
            }
        }
        dataSource_logs {
            dbCreate = "none"
            pooled = true
            //jmxExport = true
            driverClassName = 'com.mysql.jdbc.Driver'
            dialect = br.com.eteg.mysqldialect.MySQLInnoDBExtendedDialect.class
            username = 'root'
            // password = ''
            url = 'jdbc:mysql://localhost:3306/ammg_dev?useSSL=false'
            logSql = true
        }
        // dataSource_logs {
        //     username = 'appteste'
        //     password = 'teste-123'
        //     //dbCreate = "update"
        //     pooled = true
        //     //jmxExport = true
        //     driverClassName = 'com.mysql.jdbc.Driver'
        //     dialect = br.com.eteg.mysqldialect.MySQLInnoDBExtendedDialect.class
        //     url = 'jdbc:mysql://ammg-teste.ctd3u1ljvt9q.us-east-1.rds.amazonaws.com/ammg_test'
        //     logSql = true
        //     properties {
        //         // See http://grails.org/doc/latest/guide/conf.html#dataSource for documentation
        //         jmxEnabled = true
        //         initialSize = 5
        //         maxActive = 50
        //         minIdle = 5
        //         maxIdle = 25
        //         maxWait = 10000
        //         maxAge = 10 * 60000
        //         timeBetweenEvictionRunsMillis = 5000
        //         minEvictableIdleTimeMillis = 60000
        //         validationQuery = "SELECT 1"
        //         validationQueryTimeout = 3
        //         validationInterval = 15000
        //         testOnBorrow = true
        //         testWhileIdle = true
        //         testOnReturn = false
        //         jdbcInterceptors = "ConnectionState"
        //         defaultTransactionIsolation = java.sql.Connection.TRANSACTION_READ_COMMITTED
        //     }
        // }
    }

    test {
        dataSource {
            // pooled = true
            //dbCreate = 'validate'
            url = 'jdbc:mysql://ammg-teste.ctd3u1ljvt9q.us-east-1.rds.amazonaws.com/ammg_test'
            username = 'appteste'
            password = 'teste-123'
            properties {
                // See http://grails.org/doc/latest/guide/conf.html#dataSource for documentation
                jmxEnabled = true
                initialSize = 5
                maxActive = 500
                minIdle = 5
                maxIdle = 25
                maxWait = 10000
                maxAge = 10 * 60000
                timeBetweenEvictionRunsMillis = 5000
                minEvictableIdleTimeMillis = 60000
                validationQuery = "SELECT 1"
                validationQueryTimeout = 3
                validationInterval = 15000
                testOnBorrow = true
                testWhileIdle = true
                testOnReturn = false
                jdbcInterceptors = "ConnectionState"
                defaultTransactionIsolation = java.sql.Connection.TRANSACTION_READ_COMMITTED
            }
        }
        dataSource_logs {
            username = 'appteste'
            password = 'teste-123'
            //dbCreate = "update"
            pooled = true
            //jmxExport = true
            driverClassName = 'com.mysql.jdbc.Driver'
            dialect = br.com.eteg.mysqldialect.MySQLInnoDBExtendedDialect.class
            url = 'jdbc:mysql://ammg-teste.ctd3u1ljvt9q.us-east-1.rds.amazonaws.com/ammg_test'
            logSql = true
            properties {
                // See http://grails.org/doc/latest/guide/conf.html#dataSource for documentation
                jmxEnabled = true
                initialSize = 5
                maxActive = 50
                minIdle = 5
                maxIdle = 25
                maxWait = 10000
                maxAge = 10 * 60000
                timeBetweenEvictionRunsMillis = 5000
                minEvictableIdleTimeMillis = 60000
                validationQuery = "SELECT 1"
                validationQueryTimeout = 3
                validationInterval = 15000
                testOnBorrow = true
                testWhileIdle = true
                testOnReturn = false
                jdbcInterceptors = "ConnectionState"
                defaultTransactionIsolation = java.sql.Connection.TRANSACTION_READ_COMMITTED
            }
        }
    }

    production {
        dataSource {
            // pooled = true
            //dbCreate = 'validate'
            url = ''
            username = ''
            password = ''
            properties {
                // See http://grails.org/doc/latest/guide/conf.html#dataSource for documentation
                jmxEnabled = true
                initialSize = 5
                maxActive = 500
                minIdle = 5
                maxIdle = 25
                maxWait = 10000
                maxAge = 10 * 60000
                timeBetweenEvictionRunsMillis = 5000
                minEvictableIdleTimeMillis = 60000
                validationQuery = "SELECT 1"
                validationQueryTimeout = 3
                validationInterval = 15000
                testOnBorrow = true
                testWhileIdle = true
                testOnReturn = false
                jdbcInterceptors = "ConnectionState"
                defaultTransactionIsolation = java.sql.Connection.TRANSACTION_READ_COMMITTED
            }
        }
        dataSource_logs {
            username = ''
            password = ''
            pooled = true
            driverClassName = 'com.mysql.jdbc.Driver'
            dialect = br.com.eteg.mysqldialect.MySQLInnoDBExtendedDialect.class
            url = ''
            properties {
                // See http://grails.org/doc/latest/guide/conf.html#dataSource for documentation
                jmxEnabled = true
                initialSize = 5
                maxActive = 50
                minIdle = 5
                maxIdle = 25
                maxWait = 10000
                maxAge = 10 * 60000
                timeBetweenEvictionRunsMillis = 5000
                minEvictableIdleTimeMillis = 60000
                validationQuery = "SELECT 1"
                validationQueryTimeout = 3
                validationInterval = 15000
                testOnBorrow = true
                testWhileIdle = true
                testOnReturn = false
                jdbcInterceptors = "ConnectionState"
                defaultTransactionIsolation = java.sql.Connection.TRANSACTION_READ_COMMITTED
            }
        }
    }

    nightly {
        dataSource {
            // pooled = true
            //dbCreate = 'validate'
            url = 'jdbc:mysql://sgbd-teste.sede.eteg.net/ammg_test'
            username = 'eteg'
            password = 'teste-123'
        }
        dataSource_logs {
            username = 'eteg'
            password = 'teste-123'
            //dbCreate = "update"
            pooled = true
            //jmxExport = true
            driverClassName = 'com.mysql.jdbc.Driver'
            dialect = br.com.eteg.mysqldialect.MySQLInnoDBExtendedDialect.class
            url = 'jdbc:mysql://sgbd-teste.sede.eteg.net/ammg_test'
            //logSql = true
        }
    }

}