PostGISInfo.java

/* Copyright 2013 The jeo project. All rights reserved.
 *
 * 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.
 */
package io.jeo.postgis;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.util.Locale;

import io.jeo.sql.DbOP;
import io.jeo.util.Pair;
import io.jeo.util.Version;

public class PostGISInfo {

    Version postgis, postgres;
    
    public PostGISInfo(PostGISWorkspace ws) throws IOException {
        Pair<Version,Version> p = ws.run(new DbOP<Pair<Version,Version>>() {
            @Override
            protected Pair<Version, Version> doRun(Connection cx) throws Exception {
                ResultSet rs = 
                    open(open(cx.createStatement()).executeQuery("SELECT postgis_lib_version()"));
                rs.next();
                Version postgis = new Version(rs.getString(1));

                DatabaseMetaData md = cx.getMetaData();
                Version postgres = new Version(String.format(Locale.ROOT,
                    "%s.%s", md.getDatabaseMajorVersion(), md.getDatabaseMinorVersion()));
                return new Pair<Version,Version>(postgis, postgres);
            }
        });

        postgis = p.first;
        postgres = p.second;
    }

    public boolean hasGeography() {
        return postgis.compareTo(new Version("1.5.0")) >= 1;
    }

    public boolean isAtLeastVersion2() {
        return postgis.compareTo(new Version("2.0")) >= 1;
    }
}