package com.cloudhopper.commons.sql;
/*
* #%L
* ch-commons-sql
* %%
* Copyright (C) 2012 - 2013 Cloudhopper by Twitter
* %%
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
* #L%
*/
import com.cloudhopper.commons.xbean.*;
import org.junit.*;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
public class DataSourceConfigurationTest {
private static final Logger logger = LoggerFactory.getLogger(DataSourceConfigurationTest.class);
@Test
public void configureNoProperties() throws Exception {
String xml = new StringBuilder(200)
.append("<configuration>")
.append(" <datasource>")
.append(" </datasource>")
.append("</configuration>")
.toString();
DataSourceConfiguration config = new DataSourceConfiguration();
XmlBean xbean = new XmlBean();
xbean.configure(xml, config, "/configuration/datasource");
// make sure certain properties are null
Assert.assertNull(config.getUsername());
Assert.assertNull(config.getPassword());
Assert.assertNull(config.getUrl());
Assert.assertNull(config.getName());
}
@Test
public void configureUrlAutomaticallySelectsProperties() throws Exception {
String xml = new StringBuilder(200)
.append("<configuration>")
.append(" <datasource>")
.append(" <url>jdbc:mysql://localhost:3306/stratus001</url>")
.append(" </datasource>")
.append("</configuration>")
.toString();
DataSourceConfiguration config = new DataSourceConfiguration();
XmlBean xbean = new XmlBean();
xbean.configure(xml, config, "/configuration/datasource");
// make sure certain properties are null
Assert.assertEquals("jdbc:mysql://localhost:3306/stratus001", config.getUrl());
Assert.assertEquals("com.mysql.jdbc.Driver", config.getDriver());
Assert.assertEquals(DatabaseVendor.MYSQL, config.getVendor());
// should have picked default validation query
Assert.assertEquals("SELECT NOW()", config.getValidationQuery());
// c3p0 should be default
Assert.assertEquals(DataSourceProvider.C3P0, config.getProvider());
}
}