/*
* Copyright 2013 Haulmont
*
* 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.
*/
/**
*
* @author degtyarjov
* @version $Id$
*/
package com.haulmont.yarg.loaders.factory;
import com.haulmont.yarg.exception.InitializationException;
import com.haulmont.yarg.loaders.impl.SqlDataLoader;
import com.haulmont.yarg.util.properties.PropertiesLoader;
import org.apache.commons.lang.StringUtils;
import javax.sql.DataSource;
import java.io.IOException;
import java.util.Properties;
public class PropertiesSqlLoaderFactory {
protected PropertiesLoader propertiesLoader;
public PropertiesSqlLoaderFactory(PropertiesLoader propertiesLoader) {
this.propertiesLoader = propertiesLoader;
}
public SqlDataLoader create() {
try {
Properties properties = propertiesLoader.load();
String driver = properties.getProperty(PropertiesLoader.CUBA_REPORTING_SQL_DRIVER);
String dbUrl = properties.getProperty(PropertiesLoader.CUBA_REPORTING_SQL_DB_URL);
String user = properties.getProperty(PropertiesLoader.CUBA_REPORTING_SQL_USER);
String password = properties.getProperty(PropertiesLoader.CUBA_REPORTING_SQL_PASSWORD);
if (StringUtils.isBlank(driver) || StringUtils.isBlank(dbUrl)) {
return null;
}
DataSource dataSource = DefaultLoaderFactory.setupDataSource(driver, dbUrl, user, password, 3, 2, 1);
SqlDataLoader sqlDataLoader = new SqlDataLoader(dataSource);
return sqlDataLoader;
} catch (IOException e) {
throw new InitializationException("An error occurred while loading properties", e);
}
}
}