Application: gvSIG desktop

/*

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2020 gvSIG Association.

 *

 * This program 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 <https://www.gnu.org/licenses/>.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.primitive.Primitive;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryBuilder;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_GeometryN extends Functions.AbstractFunction {

    public ST_GeometryN(SQLiteConnection conn) {

        super("ST_GeometryN", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            int n = value_int(1);

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom1 = parser.parseToGeometry(conn,bytes1);

            if (geom1 == null) {

                this.result();

                return;

            }

            GeopackageGeometryBuilder builder = GeopackageUtils.createGeometryBuilder();

            if( geom1 instanceof org.gvsig.fmap.geom.aggregate.Aggregate ) {

                Primitive p = ((org.gvsig.fmap.geom.aggregate.Aggregate) geom1).getPrimitiveAt(n);

                builder.setGeometry(conn, p);

            }

            byte[] bytes = builder.build();

            if (bytes == null) {

                this.result();

            } else {

                this.result(bytes);

            }

        } catch (Throwable ex) {

            throw new SQLException("Can't get the N component from the geometry", ex);

        }

    }

}