gis.road_graph

Parameters

Name	Type	Mode
_fix_action	text	IN
_params	jsonb	IN

Definition

DECLARE
    schema_name text;
    sql_text text;
    result jsonb;
BEGIN
    -- The issues must be fixed in an editing session:
    -- the name of the schema of the edges table is replaced when the function is installed in the editing schema
    SELECT n.nspname
    INTO schema_name
    FROM pg_class AS c
    JOIN pg_namespace AS n ON n.oid = c.relnamespace
    WHERE c.oid = 'road_graph.edges'::regclass
    ;
    IF schema_name = 'road_graph' THEN
        RETURN jsonb_build_object(
            'status', 'error',
            'message', 'The road graph issues must be fixed in an editing session, '
                || 'with the function road_graph_editing.fix_graph_issue'
        );
    END IF;

-- Check the action is known
    IF NOT EXISTS (
        SELECT 1
        FROM "road_graph".glossary_graph_check AS g
        WHERE _fix_action = ANY(g.fix_actions)
    ) THEN
        RETURN jsonb_build_object(
            'status', 'error',
            'message', format('Unknown action to fix the road graph: %L', _fix_action)
        );
    END IF;

-- Run the function of the action, named fix_graph_ followed by the action name
    -- It returns a JSON object with the keys status (success, skipped or error) and message
    -- An error does not stop the fixes of the other issues: the changes of this action are cancelled
    sql_text = format('SELECT road_graph.%I($1)', 'fix_graph_' || _fix_action);
    BEGIN
        EXECUTE sql_text
        INTO result
        USING Coalesce(_params, '{}'::jsonb);
    EXCEPTION WHEN OTHERS THEN
        RETURN jsonb_build_object(
            'status', 'error',
            'message', SQLERRM
        );
    END;

RETURN result;
END;

fix_graph_issue(_fix_action text, _params jsonb)

Description

Parameters

Definition