1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
set client_min_messages to WARNING;
SELECT topology.CreateTopology('tt') > 0;
-- Put some points in
INSERT INTO tt.node (containing_face, geom) VALUES
(0, 'POINT(0 0)') RETURNING 'N' || node_id; -- 1
INSERT INTO tt.node (containing_face, geom) VALUES
(0, 'POINT(10 0)') RETURNING 'N' || node_id; -- 2
INSERT INTO tt.node (containing_face, geom) VALUES
(0, 'POINT(5 0)') RETURNING 'N' || node_id; -- 3
INSERT INTO tt.node (containing_face, geom) VALUES
(0, 'POINT(5 10)') RETURNING 'N' || node_id; -- 4
INSERT INTO tt.node (containing_face, geom) VALUES
(0, 'POINT(10 10)') RETURNING 'N' || node_id; -- 5
INSERT INTO tt.node (containing_face, geom) VALUES
(0, 'POINT(20 10)') RETURNING 'N' || node_id; -- 6
INSERT INTO tt.node (containing_face, geom) VALUES
(null, 'POINT(30 10)') RETURNING 'N' || node_id; -- 7
-- null input
SELECT topology.ST_AddIsoEdge('tt', 1, 2, NULL);
SELECT topology.ST_AddIsoEdge(NULL, 1, 2, 'LINESTRING(0 0, 1 1)');
SELECT topology.ST_AddIsoEdge('tt', 1, NULL, 'LINESTRING(0 0, 1 1)');
SELECT topology.ST_AddIsoEdge('tt', NULL, 2, 'LINESTRING(0 0, 1 1)');
-- invalid curve
SELECT topology.ST_AddIsoEdge('tt', 1, 2, 'POINT(0 0)');
-- non-simple curve
SELECT topology.ST_AddIsoEdge('tt', 1, 2, 'LINESTRING(0 0, 10 0, 5 5, 5 -5)');
-- non-existing nodes
SELECT topology.ST_AddIsoEdge('tt', 10000, 2, 'LINESTRING(0 0, 1 1)');
-- Curve endpoints mismatch
SELECT topology.ST_AddIsoEdge('tt', 1, 2, 'LINESTRING(0 0, 1 1)');
SELECT topology.ST_AddIsoEdge('tt', 1, 2, 'LINESTRING(0 1, 10 0)');
-- Node crossing
SELECT topology.ST_AddIsoEdge('tt', 1, 2, 'LINESTRING(0 0, 10 0)');
-- Good one
SELECT 'E' || topology.ST_AddIsoEdge('tt',
4, 5, 'LINESTRING(5 10, 5 9, 10 10)');
-- Another good one
SELECT 'E' || topology.ST_AddIsoEdge('tt',
1, 2, 'LINESTRING(0 0, 2 1, 10 5, 10 0)');
-- Check that containing_face became NULL for the nodes which are
-- not isolated anymore (#976)
SELECT 'N' || node_id, containing_face FROM tt.node
ORDER BY node_id;
-- Not isolated edge (shares endpoint with previous)
SELECT topology.ST_AddIsoEdge('tt',
4, 6, 'LINESTRING(5 10, 10 9, 20 10)');
SELECT topology.ST_AddIsoEdge('tt',
5, 6, 'LINESTRING(10 10, 20 10)');
-- Not isolated edge (shares endpoint with self)
SELECT topology.ST_AddIsoEdge('tt',
3, 3, 'LINESTRING(5 0, 4 -2, 6 -2, 5 0)');
-- Not isolated edge (one of the endpoints has [bogusly] containin_face=null)
-- See http://trac.osgeo.org/postgis/ticket/978
SELECT topology.ST_AddIsoEdge('tt', 6, 7, 'LINESTRING(20 10, 30 10)');
-- Edge intersection (geometry intersects an edge)
SELECT topology.ST_AddIsoEdge('tt',
3, 6, 'LINESTRING(5 0, 20 10)');
-- TODO: check closed edge (not-isolated I guess...)
-- on different faces (TODO req. nodes contained in face)
SELECT topology.DropTopology('tt');
|
