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_Extent.java @ 47456

History | View | Annotate | Download (2.5 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.fmap.geom.primitive.Envelope;
27
import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryBuilder;
28
import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;
29
import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;
30
import org.sqlite.SQLiteConnection;
31

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

    
39
    public ST_Extent(SQLiteConnection conn) {
40
        super("ST_Extent", conn);
41
    }
42

    
43
    @Override
44
    protected void xFunc() throws SQLException {
45
        try {
46
            byte[] bytes = value_blob(0);
47
            if (bytes == null) {
48
                this.result();
49
                return;
50
            }
51
            SQLiteConnection conn = this.getConnection();
52
            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();
53
            parser.parseEnvelope(bytes);
54
            Envelope env = parser.getEnvelope(conn);
55

    
56
            Geometry geom;
57
            if (env == null) {
58
                geom = parser.parseToGeometry(conn, bytes);
59
            } else {
60
                geom = env.getGeometry();
61
            }
62

    
63
            GeopackageGeometryBuilder builder = GeopackageUtils.createGeometryBuilder();
64
            builder.setGeometry(conn, geom);
65
            bytes = builder.build();
66
            if (bytes == null) {
67
                this.result();
68
            } else {
69
                this.result(bytes);
70
            }
71
        } catch (Throwable ex) {
72
            throw new SQLException("Can't get extent", ex);
73
        }
74
    }
75
}