<commit_before>// MySQL
def fileloc = ['../UserConfig.groovy', 'webapps/ROOT/Jenkins.groovy'].grep { new File(it).exists() }.first();
def dbConfig = new ConfigSlurper(grailsSettings.grailsEnv).parse(new File(fileloc).toURI().toURL())

dataSource {
    pooled = true
    driverClassName = "org.h2.Driver"
    username = "sa"
    password = ""
}
hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = false
    cache.region.factory_class = 'net.sf.ehcache.hibernate.EhCacheRegionFactory'
}
// environment specific settings
// MySQL
/*environments {
	development {
		dataSource {
			dbCreate = "update"
			url = 'jdbc:mysql://<URL>/<DB>?useUnicode=true&autoReconnect=true'
		}
	}
	test {
		dataSource {
			dbCreate = "update"
			url = 'jdbc:mysql://<URL>/<DB>?useUnicode=true&autoReconnect=true'
		}
	}
	production {
		dataSource {
			dbCreate = "update"
			url = 'jdbc:mysql://<URL>/<DB>?useUnicode=true&autoReconnect=true'
		}
	}
}*/
environments {
    development {
        dataSource {
            dbCreate = "create-drop" // one of 'create', 'create-drop', 'update', 'validate', ''
            url = "jdbc:h2:mem:devDb;MVCC=TRUE;LOCK_TIMEOUT=10000"
        }
    }
    test {
        dataSource {
			dbCreate = "create-drop" // one of 'create', 'create-drop', 'update', 'validate', ''
			url = "jdbc:h2:mem:devDb;MVCC=TRUE;LOCK_TIMEOUT=10000"
		}
    }
	searchfdadev {
		dataSource {
			dbCreate = "create-drop"
			url = 'jdbc:mysql://searchfda.crctz8nageky.us-east-1.rds.amazonaws.com:8080/searchfda?useUnicode=true&autoReconnect=true'
			pooled = true
			driverClassName = "com.mysql.jdbc.Driver"
			dialect = "org.hibernate.dialect.MySQL5InnoDBDialect"
			username=dbConfig.rds.username
			password=dbConfig.rds.password 
	
			properties {
				maxActive = 50
				maxIdle = 25
				minIdle = 1
				initialSize = 1
		   
				numTestsPerEvictionRun = 3<commit_msg>Created searchfda-dev database on the same AWS RDS instance to separate master db from dev <commit_after>// MySQL
def fileloc = ['../UserConfig.groovy', 'webapps/ROOT/Jenkins.groovy'].grep { new File(it).exists() }.first();
def dbConfig = new ConfigSlurper(grailsSettings.grailsEnv).parse(new File(fileloc).toURI().toURL())

dataSource {
    pooled = true
    driverClassName = "org.h2.Driver"
    username = "sa"
    password = ""
}
hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = false
    cache.region.factory_class = 'net.sf.ehcache.hibernate.EhCacheRegionFactory'
}
// environment specific settings
// MySQL
/*environments {
	development {
		dataSource {
			dbCreate = "update"
			url = 'jdbc:mysql://<URL>/<DB>?useUnicode=true&autoReconnect=true'
		}
	}
	test {
		dataSource {
			dbCreate = "update"
			url = 'jdbc:mysql://<URL>/<DB>?useUnicode=true&autoReconnect=true'
		}
	}
	production {
		dataSource {
			dbCreate = "update"
			url = 'jdbc:mysql://<URL>/<DB>?useUnicode=true&autoReconnect=true'
		}
	}
}*/
environments {
    development {
        dataSource {
            dbCreate = "create-drop" // one of 'create', 'create-drop', 'update', 'validate', ''
            url = "jdbc:h2:mem:devDb;MVCC=TRUE;LOCK_TIMEOUT=10000"
        }
    }
    test {
        dataSource {
			dbCreate = "create-drop" // one of 'create', 'create-drop', 'update', 'validate', ''
			url = "jdbc:h2:mem:devDb;MVCC=TRUE;LOCK_TIMEOUT=10000"
		}
    }
	searchfdadev {
		dataSource {
			dbCreate = "create-drop"
			url = 'jdbc:mysql://searchfda.crctz8nageky.us-east-1.rds.amazonaws.com:8080/searchfda-dev?useUnicode=true&autoReconnect=true'
			pooled = true
			driverClassName = "com.mysql.jdbc.Driver"
			dialect = "org.hibernate.dialect.MySQL5InnoDBDialect"
			username=dbConfig.rds.username
			password=<PASSWORD> 
	
			properties {
				maxActive = 50
				maxIdle = 25
				minIdle = 1
				initialSize = 1
		   
				numTestsPerEvictionRun = 3
{'fraction_non_alphanumeric': 0.14437808361464555, 'fraction_numerical': 0.014022331861854065, 'mean_word_length': 3.387243735763098, 'pattern_counts': {'":': 0, '<': 16, '<?xml version=': 0, '>': 16, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7370400', 'n_tokens_mistral': 1539, 'n_tokens_neox': 1358, 'n_words': 218}