Java tutorial
/* Copyright (c) 2015-2016 Boundless and others. * All rights reserved. This program and the accompanying materials * are made available under the terms of the Eclipse Distribution License v1.0 * which accompanies this distribution, and is available at * https://www.eclipse.org/org/documents/edl-v10.html * * Contributors: * Gabriel Roldan (Boundless) - initial implementation */ package org.locationtech.geogig.storage.postgresql; import static com.google.common.base.Preconditions.checkArgument; import java.io.Serializable; import java.io.UnsupportedEncodingException; import java.net.URI; import java.net.URISyntaxException; import java.net.URLDecoder; import java.nio.charset.StandardCharsets; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.Properties; import org.eclipse.jdt.annotation.Nullable; import org.locationtech.geogig.repository.Hints; import com.google.common.base.Optional; import com.google.common.base.Preconditions; import com.google.common.base.Splitter; import com.google.common.base.Strings; import com.google.common.base.Throwables; public class EnvironmentBuilder { private Environment config; public EnvironmentBuilder(Hints hints) throws URISyntaxException { Optional<Serializable> repoUrl = hints.get(Hints.REPOSITORY_URL); checkArgument(repoUrl.isPresent(), "%s was not given", Hints.REPOSITORY_URL); URI url = new URI(String.valueOf(repoUrl.get())); init(url); } public EnvironmentBuilder(Properties props) { init(props); } /** * @param repoUrl repository URL of the form * {@code postgresql://<server>[:<port>]/database[/<schema>]/<repoid>?user=<username>&password=<pwd>} */ public EnvironmentBuilder(URI repoUrl) { init(repoUrl); } private static Map<String, String> extractShortKeys(String rawQuery) { Map<String, String> shortKeys = new HashMap<>(); for (String pair : Splitter.on('&').split(rawQuery)) { List<String> p = Splitter.on('=').splitToList(pair); // it should be the raw query, URL decode the values try { shortKeys.put(p.get(0), URLDecoder.decode(p.get(1), StandardCharsets.UTF_8.name())); } catch (UnsupportedEncodingException uee) { Throwables.propagate(uee); } } return shortKeys; } private void init(URI repoUrl) { // postgresql://<server>[:<port>]/database[/<schema>]/<repoid>?user=<username>&password=<pwd> Preconditions.checkNotNull(repoUrl); final String uriScheme = repoUrl.getScheme(); Preconditions.checkArgument("postgresql".equals(uriScheme), "Wrong URL protocol. Expected postgresql, got ", uriScheme); final String host = repoUrl.getHost(); final String portNumber; final String dbName; final String schema; final String repsitoryId; final String user, password; final String tablePrefix;// mainly used for unit testing int port = repoUrl.getPort(); if (-1 == port) { port = 5432; } portNumber = String.valueOf(port); List<String> path = Splitter.on('/').omitEmptyStrings().splitToList(repoUrl.getPath()); Preconditions.checkArgument(path.size() >= 2 && path.size() <= 3, "Path in URI must be like postgresql://<server>[:<port>]/database[/<schema>]/<repoid>?user=<username>&password=<pwd>", repoUrl); dbName = path.get(0); schema = path.size() == 2 ? "public" : path.get(1); repsitoryId = path.size() == 2 ? path.get(1) : path.get(2); Map<String, String> shortKeys = extractShortKeys(repoUrl.getRawQuery()); user = shortKeys.get("user"); password = shortKeys.get("password"); tablePrefix = shortKeys.get("tablePrefix"); Properties props = new Properties(); props.setProperty(Environment.KEY_DB_SERVER, host); props.setProperty(Environment.KEY_DB_PORT, portNumber); props.setProperty(Environment.KEY_DB_NAME, dbName); props.setProperty(Environment.KEY_DB_SCHEMA, schema); props.setProperty(Environment.KEY_REPOSITORY_ID, repsitoryId); props.setProperty(Environment.KEY_DB_USERNAME, user); props.setProperty(Environment.KEY_DB_PASSWORD, password); if (!Strings.isNullOrEmpty(tablePrefix)) { props.setProperty("tablePrefix", tablePrefix); } init(props); } private void init(Properties props) { String server = props.getProperty(Environment.KEY_DB_SERVER); String portNumber = props.getProperty(Environment.KEY_DB_PORT); String databaseName = props.getProperty(Environment.KEY_DB_NAME); String schema = props.getProperty(Environment.KEY_DB_SCHEMA); String userName = props.getProperty(Environment.KEY_DB_USERNAME); String password = props.getProperty(Environment.KEY_DB_PASSWORD); @Nullable String repoId = props.getProperty(Environment.KEY_REPOSITORY_ID); checkArgument(server != null, "postgres.server config is not set"); checkArgument(databaseName != null, "postgres.database config is not set"); checkArgument(schema != null, "postgres.schema config is not set"); checkArgument(userName != null, "postgres.user config is not set"); checkArgument(password != null, "postgres.password config is not set"); // checkArgument(repoId != null, "repository.id config is not set"); int port; try { port = portNumber == null ? 4532 : Integer.parseInt(portNumber); } catch (NumberFormatException nfe) { throw new IllegalArgumentException(String.format("'%s' can't be parsed as integer for argument %s", portNumber, Environment.KEY_DB_PORT), nfe); } String tablePrefix = props.getProperty("tablePrefix");// only used by tests if (tablePrefix != null && tablePrefix.trim().isEmpty()) { tablePrefix = null; } this.config = new Environment(server, port, databaseName, schema, userName, password, repoId, tablePrefix); } public Environment build() { return config; } /** * Extracts all of the {@link Environment} properties from a given root URI. * * @param rootRepoURI the root URI * @return the extracted properties */ public static Properties getRootURIProperties(final URI rootRepoURI) { // postgresql://<server>[:<port>]/database[/<schema>]?user=<username>&password=<pwd> Preconditions.checkNotNull(rootRepoURI); final String uriScheme = rootRepoURI.getScheme(); Preconditions.checkArgument("postgresql".equals(uriScheme), "Wrong URL protocol. Expected postgresql, got ", uriScheme); final String host = rootRepoURI.getHost(); final String portNumber; final String dbName; final String schema; final String user, password; final String tablePrefix;// mainly used for unit testing int port = rootRepoURI.getPort(); if (-1 == port) { port = 5432; } portNumber = String.valueOf(port); List<String> path = Splitter.on('/').omitEmptyStrings().splitToList(rootRepoURI.getPath()); Preconditions.checkArgument(path.size() >= 1 && path.size() <= 2, "Path in URI must be like postgresql://<server>[:<port>]/database[/<schema>]?user=<username>&password=<pwd>", rootRepoURI); dbName = path.get(0); schema = path.size() == 1 ? "public" : path.get(1); Map<String, String> shortKeys = extractShortKeys(rootRepoURI.getRawQuery()); user = shortKeys.get("user"); password = shortKeys.get("password"); tablePrefix = shortKeys.get("tablePrefix"); Properties props = new Properties(); props.setProperty(Environment.KEY_DB_SERVER, host); props.setProperty(Environment.KEY_DB_PORT, portNumber); props.setProperty(Environment.KEY_DB_NAME, dbName); props.setProperty(Environment.KEY_DB_SCHEMA, schema); props.setProperty(Environment.KEY_DB_USERNAME, user); props.setProperty(Environment.KEY_DB_PASSWORD, password); if (!Strings.isNullOrEmpty(tablePrefix)) { props.setProperty("tablePrefix", tablePrefix); } return props; } /** * Constructs a repository URI from the given {@link Environment} properties and repository * name. * * @param props the properties * @param repoName the repository name * @return the resolved URI of the repository */ public static URI buildRepoURI(Properties props, String repoName) { String server = props.getProperty(Environment.KEY_DB_SERVER); String portNumber = props.getProperty(Environment.KEY_DB_PORT); String databaseName = props.getProperty(Environment.KEY_DB_NAME); String schema = props.getProperty(Environment.KEY_DB_SCHEMA); String userName = props.getProperty(Environment.KEY_DB_USERNAME); String password = props.getProperty(Environment.KEY_DB_PASSWORD); String tablePrefix = props.getProperty("tablePrefix"); if (tablePrefix != null && tablePrefix.trim().isEmpty()) { tablePrefix = null; } // postgresql://<server>[:<port>]/database[/<schema>]/<repoid>?user=<username>&password=<pwd> StringBuilder sb = new StringBuilder("postgresql://").append(server).append(":").append(portNumber) .append("/").append(databaseName).append("/").append(schema).append("/").append(repoName); StringBuilder args = new StringBuilder(""); if (userName != null) { args.append("user=").append(userName); } if (password != null) { if (args.length() > 0) { args.append("&"); } args.append("password=").append(password); } if (tablePrefix != null) { if (args.length() > 0) { args.append("&"); } args.append("tablePrefix=").append(tablePrefix); } if (args.length() > 0) { sb.append("?").append(args); } URI repoURI = null; try { repoURI = new URI(sb.toString()); } catch (URISyntaxException e) { Throwables.propagate(e); } return repoURI; } }