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_MakePoint.java @ 47583

History | View | Annotate | Download (2.44 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.GeometryUtils;
26
import org.gvsig.fmap.geom.primitive.Point;
27
import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryBuilder;
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_MakePoint extends Functions.AbstractFunction {
37

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

    
42
    @Override
43
    protected void xFunc() throws SQLException {
44
        try {
45
            SQLiteConnection conn = this.getConnection();
46
            double x = value_double(0);
47
            double y = value_double(1);
48
            Point p = null;
49
            if(args()==2){
50
                p = GeometryUtils.createPoint(x, y);
51
            }if(args()==3){
52
                double z = value_double(2);
53
                p = GeometryUtils.createPoint(x,y,z);
54
            } else {
55
                double z = value_double(2);
56
                double m = value_double(3);
57
                p = GeometryUtils.createPoint(x,y,z,m);
58
            }
59
            
60
            GeopackageGeometryBuilder builder = GeopackageUtils.createGeometryBuilder();
61
            builder.setGeometry(conn, p);
62
            byte[] bytes = builder.build();
63
            if (bytes == null) {
64
                this.result();
65
            } else {
66
                this.result(bytes);
67
            }
68
        } catch (Throwable ex) {
69
            throw new SQLException("Can't make point", ex);
70
        }
71
    }
72

    
73
}