Statistics
| Revision:

svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.sqlite / org.gvsig.sqlite.provider / src / main / java / org / gvsig / sqlite / dal / functions / ST_Force2D.java @ 47583

History | View | Annotate | Download (2.39 KB)

1
/*
2
 * gvSIG. Desktop Geographic Information System.
3
 * 
4
 * Copyright (C) 2007-2020 gvSIG Association.
5
 * 
6
 * This program is free software; you can redistribute it and/or
7
 * modify it under the terms of the GNU General Public License
8
 * as published by the Free Software Foundation; either version 3
9
 * of the License, or (at your option) any later version.
10
 * 
11
 * This program is distributed in the hope that it will be useful,
12
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
14
 * GNU General Public License for more details.
15
 * 
16
 * You should have received a copy of the GNU General Public License 
17
 * along with this program. If not, see <https://www.gnu.org/licenses/>. 
18
 * 
19
 * For any additional information, do not hesitate to contact us
20
 * at info AT gvsig.com, or visit our website www.gvsig.com.
21
 */
22
package org.gvsig.sqlite.dal.functions;
23

    
24
import java.sql.SQLException;
25
import org.gvsig.fmap.geom.Geometry;
26
import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryBuilder;
27
import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;
28
import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;
29
import org.sqlite.SQLiteConnection;
30

    
31
/**
32
 *
33
 * @author gvSIG Team
34
 */
35
@SuppressWarnings("UseSpecificCatch")
36
public class ST_Force2D extends Functions.AbstractFunction {
37

    
38
    public ST_Force2D(SQLiteConnection conn) {
39
        super("ST_Force2D", conn);
40
    }
41

    
42
    @Override
43
    protected void xFunc() throws SQLException {
44
        try {
45
            byte[] bytes = value_blob(0);
46
            if (bytes == null) {
47
                this.result();
48
                return;
49
            }
50
            SQLiteConnection conn = this.getConnection();
51
            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();
52
            Geometry geom = parser.parseToGeometry(conn,bytes);
53
            if (geom == null) {
54
                this.result();
55
                return;
56
            }
57
            GeopackageGeometryBuilder builder = GeopackageUtils.createGeometryBuilder();
58
            builder.setGeometry(conn, geom.forceSubtype(Geometry.SUBTYPES.GEOM2D));
59
            bytes = builder.build();
60
            if (bytes == null) {
61
                this.result();
62
            } else {
63
                this.result(bytes);
64
            }
65

    
66
        } catch (Throwable ex) {
67
            throw new SQLException("Can't force to 2D the geometry", ex);
68
        }
69
    }
70

    
71
}