hoot.services.db.postgres.PostgresUtils.java Source code

Introduction

Here is the source code for hoot.services.db.postgres.PostgresUtils.java

Source

/*
 * This file is part of Hootenanny.
 *
 * Hootenanny is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 * --------------------------------------------------------------------
 *
 * The following copyright notices are generated automatically. If you
 * have a new notice to add, please use the format:
 * " * @copyright Copyright ..."
 * This will properly maintain the copyright information. DigitalGlobe
 * copyrights will be updated automatically.
 *
 * @copyright Copyright (C) 2014 DigitalGlobe (http://www.digitalglobe.com/)
 */
package hoot.services.db.postgres;

import java.util.HashMap;
import java.util.Map;

import org.apache.commons.lang3.StringUtils;
import org.postgresql.util.PGobject;

/**
 * Postgres specific utilities
 */
public class PostgresUtils {
    /**
     * Converts an hstore Postgres object to a string map
     * 
     * @param postgresObj a Postgres object containing an hstore
     * @return a string map with the hstore's data
     * @throws Exception
     */
    public static Map<String, String> postgresObjToHStore(final PGobject postgresObj) throws Exception {
        //type = hstore
        //value = "key 1"=>"val 1", "key 2"=>"val 2"

        //TODO: don't understand why this string doesn't match up
        //System.out.println(postgresObj.getType());
        //if (postgresObj.getType().equals("hstore"))
        //{
        //throw new Exception("Invalid PGobject type.  Expected: hstore");
        //}

        Map<String, String> hstore = new HashMap<String, String>();
        if (postgresObj != null && postgresObj.getValue() != null
                && StringUtils.trimToNull(postgresObj.getValue()) != null) {
            String[] vals = postgresObj.getValue().split(",");
            for (int i = 0; i < vals.length; i++) {
                String[] pair = vals[i].split("=>");
                if (pair.length == 2) {
                    //remove the quotes at the very beginning and end of the string
                    String key = pair[0].trim();
                    key = StringUtils.removeStart(key, "\"");
                    key = StringUtils.removeEnd(key, "\"");
                    String val = pair[1].trim();
                    val = StringUtils.removeStart(val, "\"");
                    val = StringUtils.removeEnd(val, "\"");
                    hstore.put(key, val);
                }
            }
        }
        return hstore;
    }
}