1SELECT E'--missing--\n' || TopologySummary('test'); 2CREATE SCHEMA test; 3SELECT E'--empty--\n' || TopologySummary('test'); 4CREATE TABLE test.node(id int); 5SELECT E'--node--\n' || TopologySummary('test'); 6CREATE TABLE test.edge(id int); 7SELECT E'--node+edge--\n' || TopologySummary('test'); 8CREATE TABLE test.face(id int); 9SELECT E'--node+edge+face--\n' || TopologySummary('test'); 10CREATE TABLE test.relation(id int); 11SELECT E'--node+edge+face+corrupted_relation--\n' || TopologySummary('test'); 12ALTER TABLE test.relation ADD layer_id int, ADD topogeo_id int; 13SELECT E'--node+edge+face+relation--\n' || TopologySummary('test'); 14INSERT INTO test.relation (layer_id, topogeo_id) VALUES (1,1); 15SELECT E'--node+edge+face+relation+topogeom--\n' || TopologySummary('test'); 16INSERT INTO topology.topology (id,name,srid,precision,hasz) 17 VALUES(1,'test',10,20,'f'); 18SELECT E'--registered_topo--\n' || TopologySummary('test'); 19INSERT INTO topology.layer (topology_id,layer_id, schema_name, table_name, feature_column, feature_type, level, child_id) 20 VALUES(1,1,'test','t','c', 1, 0, null); 21SELECT E'--registered_missing_layer_table--\n' || TopologySummary('test'); 22CREATE TABLE test.t(i int); 23SELECT E'--registered_missing_layer_column--\n' || TopologySummary('test'); 24ALTER TABLE test.t ADD c TopoGeometry; 25SELECT E'--registered_layer_missing_topogeom--\n' || TopologySummary('test'); 26INSERT INTO test.t(c) VALUES ( (1,1,1,1) ); 27SELECT E'--registered_layer--\n' || TopologySummary('test'); 28-- TODO: test hierarchical 29DROP TABLE test.t; 30DROP TABLE test.node; 31DROP TABLE test.edge; 32DROP TABLE test.face; 33DROP TABLE test.relation; 34DROP SCHEMA test; 35SELECT E'--registered+missing--\n' || TopologySummary('test'); 36DELETE FROM topology.layer WHERE topology_id = 1; 37DELETE FROM topology.topology WHERE id = 1; 38