All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • de.fraunhofer.iosb.ilt.frostserver.persistence.pgjooq.bindings.PostGisGeometryBinding Maven / Gradle / Ivy

    There is a newer version: 2.5.0
    Show newest version
    /*
 * Copyright (C) 2024 Fraunhofer Institut IOSB, Fraunhoferstr. 1, D 76131
 * Karlsruhe, Germany.
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser 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 Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with this program.  If not, see .
 */
package de.fraunhofer.iosb.ilt.frostserver.persistence.pgjooq.bindings;

import java.sql.SQLException;
import java.sql.SQLFeatureNotSupportedException;
import java.sql.Types;
import org.geolatte.geom.Geometry;
import org.jooq.Binding;
import org.jooq.BindingGetResultSetContext;
import org.jooq.BindingGetSQLInputContext;
import org.jooq.BindingGetStatementContext;
import org.jooq.BindingRegisterContext;
import org.jooq.BindingSQLContext;
import org.jooq.BindingSetSQLOutputContext;
import org.jooq.BindingSetStatementContext;
import org.jooq.Converter;
import org.jooq.DataType;
import org.jooq.impl.SQLDataType;

/**
 *
 * @author scf
 */
public class PostGisGeometryBinding implements Binding {

    private static final PostGisGeometryBinding INSTANCE = new PostGisGeometryBinding();
    private static final Converter CONVERTER_INSTANCE = new Converter() {
        @Override
        public Geometry from(Object databaseObject) {
            // We do not actually support requesting a bare Geometry object from the database.
            return null;
        }

        @Override
        public Object to(Geometry userObject) {
            return userObject.asText();
        }

        @Override
        public Class fromType() {
            return Object.class;
        }

        @Override
        public Class toType() {
            return Geometry.class;
        }
    };
    private static final DataType DATA_TYPE = SQLDataType.VARBINARY.asConvertedDataType(INSTANCE);

    public static PostGisGeometryBinding instance() {
        return INSTANCE;
    }

    public static DataType dataType() {
        return DATA_TYPE;
    }

    private PostGisGeometryBinding() {
        // Use instance()
    }

    @Override
    public Converter converter() {
        return CONVERTER_INSTANCE;
    }

    @Override
    public void sql(BindingSQLContext ctx) throws SQLException {
        ctx.render().sql("ST_GeomFromEWKT(?)");
    }

    @Override
    public void register(BindingRegisterContext ctx) throws SQLException {
        ctx.statement().registerOutParameter(ctx.index(), Types.VARCHAR);
    }

    @Override
    public void set(BindingSetStatementContext ctx) throws SQLException {
        ctx.statement().setObject(ctx.index(), ctx.convert(converter()).value(), Types.VARCHAR);
    }

    @Override
    public void set(BindingSetSQLOutputContext ctx) throws SQLException {
        throw new SQLFeatureNotSupportedException();
    }

    @Override
    public void get(BindingGetResultSetContext ctx) throws SQLException {
        ctx.convert(converter()).value(ctx.resultSet().getBytes(ctx.index()));
    }

    @Override
    public void get(BindingGetStatementContext ctx) throws SQLException {
        ctx.convert(converter()).value(ctx.statement().getBytes(ctx.index()));
    }

    @Override
    public void get(BindingGetSQLInputContext ctx) throws SQLException {
        throw new SQLFeatureNotSupportedException();
    }

}
    
    
    
    

    




    
    
    © 2015 - 2025 Weber Informatics LLC | Privacy Policy