From df1f153e486fee2d817d82f8cb9dda50c9288da3 Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Mon, 23 May 2011 08:44:00 +0000 Subject: [PATCH] Test that topology.ST_AddEdgeNewFaces properly updates isolated edges contained in a newly created face [RT-SIGTA] git-svn-id: http://svn.osgeo.org/postgis/trunk@7207 b70326c6-7e19-0410-871a-916f4a2858ee --- topology/test/regress/st_addedgenewfaces.sql | 15 +++++++++++++-- topology/test/regress/st_addedgenewfaces_expected | 4 ++++ 2 files changed, 17 insertions(+), 2 deletions(-) diff --git a/topology/test/regress/st_addedgenewfaces.sql b/topology/test/regress/st_addedgenewfaces.sql index 045095370..91e3e123b 100644 --- a/topology/test/regress/st_addedgenewfaces.sql +++ b/topology/test/regress/st_addedgenewfaces.sql @@ -285,6 +285,17 @@ SELECT 'T17', 'E'||edge_id, next_left_edge, next_right_edge, SELECT 'N' || node_id, containing_face FROM city_data.node WHERE node_id IN ( 25, 26 ); +-- +-- New face in universal face, enclosing isolated edge chain +-- +INSERT INTO newedge SELECT 18, topology.st_addedgenewfaces('city_data', + 25, 26, 'LINESTRING(35 28, 35 45, 63 45, 63 25, 39 25, 39 28)'); +SELECT 'T18', 'E'||edge_id, next_left_edge, next_right_edge, + left_face, right_face FROM + city_data.edge WHERE edge_id IN ( 4, 5, 43, + ( SELECT edge_id FROM newedge WHERE id = 17 ) ) + ORDER BY edge_id; + --------------------------------------------------------------------- -- Check new relations and faces status --------------------------------------------------------------------- @@ -309,5 +320,5 @@ SELECT 'F'||face_id, st_astext(mbr) FROM city_data.face ORDER BY face_id; -- Cleanups --------------------------------------------------------------------- -DROP TABLE newedge; -SELECT topology.DropTopology('city_data'); +--DROP TABLE newedge; +--SELECT topology.DropTopology('city_data'); diff --git a/topology/test/regress/st_addedgenewfaces_expected b/topology/test/regress/st_addedgenewfaces_expected index 5ccea63a9..eb4ce5b4c 100644 --- a/topology/test/regress/st_addedgenewfaces_expected +++ b/topology/test/regress/st_addedgenewfaces_expected @@ -77,6 +77,9 @@ T16|E3|-3|2|31|31 T16|E42|42|-42|31|32 N4| T17|E43|-43|43|0|0 +T18|E4|-5|4|33|33 +T18|E5|-4|5|33|33 +T18|E43|-44|44|33|0 N25| N26| F3,F4|{3:10,3:11,3:23,3:24,3:25} @@ -105,4 +108,5 @@ F29|POLYGON((5 27,5 30,11 30,11 27,5 27)) F30|POLYGON((22 27,22 30,28 30,28 27,22 27)) F31|POLYGON((17 30,17 40,31 40,31 30,17 30)) F32|POLYGON((20 34,20 37,23 37,23 34,20 34)) +F33|POLYGON((35 25,35 45,66 45,66 25,35 25)) Topology 'city_data' dropped -- 2.50.1