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

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

    
33
/**
34
 *
35
 * @author gvSIG Team
36
 */
37
@SuppressWarnings("UseSpecificCatch")
38
public class ST_ExtentAggregate extends Functions.AbstractAggregate {
39

    
40
    private Envelope env = null;
41
    private long count = 0;
42

    
43
    public ST_ExtentAggregate(SQLiteConnection conn) {
44
        super("ST_ExtentAggregate", conn);
45
    }
46

    
47
    @Override
48
    protected void xStep() throws SQLException {
49
        try {
50
            count++;
51
            byte[] bytes = value_blob(0);
52
            if (bytes == null) {
53
                return;
54
            }
55
            SQLiteConnection conn = this.getConnection();
56
            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();
57
            parser.parseEnvelope(bytes);
58
            Envelope env_geom = parser.getEnvelope(conn);
59

    
60
            if (env_geom == null) {
61
                Geometry geom = parser.parseToGeometry(conn, bytes);
62
                if( geom!=null ) {
63
                    env_geom = geom.getEnvelope();
64
                }
65
            }
66
            if (env == null) {
67
                this.env = GeometryUtils.createEnvelope(Geometry.SUBTYPES.GEOM2D);
68
            }
69
            env.add(env_geom);
70
        } catch (Throwable ex) {
71
            throw new SQLException("Can't intersects geometries", ex);
72
        }
73
    }
74

    
75
    @Override
76
    protected void xFinal() throws SQLException {
77
        try {
78
            GeopackageGeometryBuilder builder = GeopackageUtils.createGeometryBuilder();
79
            builder.setGeometry(this.getConnection(), env.getGeometry());
80
            this.result(builder.build());
81
        } catch (Throwable ex) {
82
            throw new SQLException("Can't intersects geometries", ex);
83
        }
84
    }
85
}