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
|
set client_min_messages to WARNING;
-- Test with zero tolerance
SELECT topology.CreateTopology('nodes') > 0;
-- Check that the same point geometry return the same node id
SELECT 'p1', topology.addNode('nodes', 'POINT(0 0)');
SELECT 'p1b', topology.addNode('nodes', 'POINT(0 0)');
SELECT 'p2', topology.addNode('nodes', 'POINT(1 0)');
SELECT 'p2b', topology.addNode('nodes', 'POINT(1 0)');
-- Check that adding a node in the middle of an existing edge is refused
-- While adding one on the endpoint is fine
INSERT INTO nodes.edge VALUES(nextval('nodes.edge_data_edge_id_seq'),1,1,1,-1,0,0,
'LINESTRING(0 10,10 10)');
SELECT 'p3*1', topology.addNode('nodes', 'POINT(5 10)'); -- refused
SELECT 'p3', topology.addNode('nodes', 'POINT(0 10)'); -- good
SELECT 'p4', topology.addNode('nodes', 'POINT(10 10)'); -- good
-- Now allow edge splitting:
SELECT 'p5', topology.addNode('nodes', 'POINT(5 10)', true);
-- ... and verify the edge was split
SELECT 'post-p5', edge_id, ST_AsText(geom) FROM nodes.edge ORDER BY edge_id;
-- And same against a closed edge
INSERT INTO nodes.face VALUES(nextval('nodes.face_face_id_seq'), 'POLYGON((0 20, 10 20, 10 30, 0 30, 0 20))');
INSERT INTO nodes.edge VALUES(nextval('nodes.edge_data_edge_id_seq'),2,2,2,-2,1,0,
'LINESTRING(0 20,10 20,10 30, 0 30, 0 20)');
SELECT 'p6', topology.addNode('nodes', 'POINT(0 20)'); -- good
-- Now allow computing containing face:
SELECT 'p7', topology.addNode('nodes', 'POINT(5 25)', false, true);
-- Check all nodes
SELECT node_id, containing_face, st_astext(geom) from nodes.node
ORDER by node_id;
SELECT topology.DropTopology('nodes');
-- Test topology with MixedCase
SELECT topology.CreateTopology('Ul') > 0;
SELECT 'MiX', topology.addNode('Ul', 'POINT(0 0)');
SELECT topology.DropTopology('Ul');
|
