General cleanup and minor changes

cvvergara · cvvergara · commit c72dfe177d78 · 2025-04-29T09:59:58.000-06:00
- Removing unused SQL/legacy files from early versions of 2.x
- On SQL comments of experimental functions/signatures
  - Adding/Standardizing PROPOSED/EXPERIENTAL keyword
diff --git a/docqueries/src/test.conf b/docqueries/src/test.conf
@@ -3,7 +3,10 @@
 %main::tests = (
     'any' => {
         'files' => [qw(
+            concepts.pg
+            migration.pg
             sampledata.pg
+            withPoints-category.pg
             )],
     },
 );
diff --git a/sql/contraction/contractionHierarchies.sql b/sql/contraction/contractionHierarchies.sql
@@ -63,7 +63,7 @@ LANGUAGE SQL VOLATILE STRICT;
 
 COMMENT ON FUNCTION pgr_contractionHierarchies(TEXT, BOOLEAN, BIGINT[])
 IS 'pgr_contractionHierarchies
-EXPERIMENTAL
+- EXPERIMENTAL
 - Parameters:
     - Edges SQL with columns: id, source, target, cost [,reverse_cost]
 - Optional Parameters
diff --git a/sql/contraction/deadEndContraction.sql b/sql/contraction/deadEndContraction.sql
@@ -44,6 +44,7 @@ LANGUAGE SQL VOLATILE STRICT;
 
 COMMENT ON FUNCTION pgr_contractionDeadEnd(TEXT, BOOLEAN, BIGINT[])
 IS 'pgr_contractionDeadEnd
+- PROPOSED
 - Parameters:
     - Edges SQL with columns: id, source, target, cost [,reverse_cost]
 - Optional Parameters
diff --git a/sql/contraction/linearContraction.sql b/sql/contraction/linearContraction.sql
@@ -44,6 +44,7 @@ LANGUAGE SQL VOLATILE STRICT;
 
 COMMENT ON FUNCTION pgr_contractionLinear(TEXT, BOOLEAN, BIGINT[])
 IS 'pgr_contractionLinear
+- PROPOSED
 - Parameters:
     - Edges SQL with columns: id, source, target, cost [,reverse_cost]
 - Optional Parameters
diff --git a/sql/lineGraph/lineGraph.sql b/sql/lineGraph/lineGraph.sql
@@ -51,7 +51,7 @@ ROWS 1000;
 
 COMMENT ON FUNCTION pgr_lineGraph(TEXT, BOOLEAN)
 IS 'pgr_lineGraph
-- EXPERIMENTAL
+- PROPOSED
 - Parameters:
   - edges SQL with columns: id, source, target, cost [,reverse_cost]
 - Optional Parameters:
diff --git a/sql/max_flow/maxFlowMinCost.sql b/sql/max_flow/maxFlowMinCost.sql
@@ -181,7 +181,7 @@ IS 'pgr_maxFlowMinCost(Many to One)
 ';
 
 COMMENT ON FUNCTION pgr_maxFlowMinCost(TEXT, ANYARRAY, ANYARRAY)
-IS 'EXPERIMENTAL pgr_maxFlowMinCost(Many to Many)
+IS 'pgr_maxFlowMinCost(Many to Many)
 - EXPERIMENTAL
 - Parameters:
   - Edges SQL with columns: id, source, target, cost [,reverse_cost]
@@ -192,7 +192,7 @@ IS 'EXPERIMENTAL pgr_maxFlowMinCost(Many to Many)
 ';
 
 COMMENT ON FUNCTION pgr_maxFlowMinCost(TEXT, TEXT)
-IS 'EXPERIMENTAL pgr_maxFlowMinCost(Combinations)
+IS 'pgr_maxFlowMinCost(Combinations)
 - EXPERIMENTAL
 - Parameters:
   - Edges SQL with columns: id, source, target, cost [,reverse_cost]
diff --git a/sql/max_flow/maxFlowMinCost_Cost.sql b/sql/max_flow/maxFlowMinCost_Cost.sql
@@ -141,7 +141,7 @@ IS 'pgr_maxFlowMinCost_Cost (Many to One)
 ';
 
 COMMENT ON FUNCTION pgr_maxFlowMinCost_Cost(TEXT, ANYARRAY, ANYARRAY)
-IS 'EXPERIMENTAL pgr_maxFlowMinCost_Cost (Many to Many)
+IS 'pgr_maxFlowMinCost_Cost (Many to Many)
 - EXPERIMENTAL
 - Parameters:
   - Edges SQL with columns: id, source, target, cost [,reverse_cost]
@@ -152,7 +152,7 @@ IS 'EXPERIMENTAL pgr_maxFlowMinCost_Cost (Many to Many)
 ';
 
 COMMENT ON FUNCTION pgr_maxFlowMinCost_Cost(TEXT, TEXT)
-IS 'EXPERIMENTAL pgr_maxFlowMinCost_Cost (Combinations)
+IS 'pgr_maxFlowMinCost_Cost (Combinations)
 - EXPERIMENTAL
 - Parameters:
   - Edges SQL with columns: id, source, target, cost [,reverse_cost]
diff --git a/sql/metrics/betweennessCentrality.sql b/sql/metrics/betweennessCentrality.sql
@@ -48,6 +48,7 @@ LANGUAGE SQL VOLATILE STRICT;
 
 COMMENT ON FUNCTION pgr_betweennessCentrality(TEXT, BOOLEAN)
 IS 'pgr_betweennessCentrality
+- EXPERIMENTAL
 - Parameters:
     - edges SQL with columns: source, target, cost [,reverse_cost])
 - Optional Parameters:
diff --git a/sql/topology/nodeNetwork.sql b/sql/topology/nodeNetwork.sql
@@ -228,16 +228,5 @@ END;
 $BODY$ LANGUAGE 'plpgsql' VOLATILE STRICT COST 100;
 
 -- COMMENTS
-COMMENT ON FUNCTION pgr_nodeNetwork(TEXT, DOUBLE PRECISION, TEXT, TEXT, TEXT, TEXT, BOOLEAN) IS 'pgr_nodeNetwork
-- Parameters
-  - Edge table name
-  - tolerance
-- Optional parameters
-  - id := ''id''
-  - the_geom := ''the_geom''
-  - table_ending := ''noded''
-  - rows_where := ''''
-  - outall := false
-- DOCUMENTATION:
-  - ${PROJECT_DOC_LINK}/pgr_nodeNetwork.html
-';
+COMMENT ON FUNCTION pgr_nodeNetwork(TEXT, DOUBLE PRECISION, TEXT, TEXT, TEXT, TEXT, BOOLEAN)
+IS 'pgr_nodeNetwork deprecated function on v3.8.0';
