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