/*
	<dependency>
            <groupId>postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>9.1-901.jdbc4</version>
        </dependency>
*/

package se.uhr.nya.application;

import java.sql.Driver;
import java.sql.DriverManager;
import java.util.Optional;

import javax.sql.DataSource;

import org.postgresql.ds.PGSimpleDataSource;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

public class PostgresDataSourceFactory {

	public static final Logger log = LoggerFactory.getLogger(PostgresDataSourceFactory.class);

	/*
	 * Run with VM Environment -Ddb2pass=password -Ddb2host=host
	 */
	public static DataSource createDataSource() throws Exception {
		String jdbcClassName = "org.postgresql.Driver";

		String dbname = fromSystemProperty("db2dbname").orElse("postgres");
		String user = fromSystemProperty("db2user").orElse("postgres");
		String password = fromSystemProperty("db2pass").orElse("secretpassword");
		String db2host = fromSystemProperty("db2host").orElse("localhost");

		DriverManager.registerDriver((Driver) Class.forName(jdbcClassName).newInstance());

		PGSimpleDataSource dataSource = new PGSimpleDataSource();
		dataSource.setDatabaseName(dbname);
		dataSource.setServerName(db2host);
		dataSource.setPortNumber(5432);
		dataSource.setUser(user);
		dataSource.setPassword(password);

		return dataSource;
	}

	private static Optional<String> fromSystemProperty(String systemprop) {
		return Optional.ofNullable(System.getProperty(systemprop));
	}

}