gis.road_graph

Parameters

Name	Type	Mode
_editing_session_id	integer	IN
road_codes	text[]	TABLE

Definition

BEGIN
    RETURN QUERY
    WITH
    items AS (
        SELECT unnest(array['edges', 'markers']) AS item
    ),
    ids AS (
        SELECT item, logged_ids->item AS item_ids
        FROM items, "road_graph".editing_sessions
        WHERE status = 'edited'
        AND id = _editing_session_id
    ),
    queries AS (
        SELECT item, "key"::integer AS id, "value" AS op
        FROM ids, jsonb_each_text(item_ids)
    ),
    objects_ids AS (
        SELECT
            item,
            array_agg(id) AS o_ids
        FROM queries
        GROUP BY item
    ),
    codes AS (
        SELECT
            DISTINCT e.road_code
        FROM
            road_graph_editing.edges AS e,
            objects_ids AS o
        WHERE o.item = 'edges' AND e.id = ANY(o.o_ids)
        UNION
        SELECT
            DISTINCT m.road_code
        FROM
            road_graph_editing.markers AS m,
            objects_ids AS o
        WHERE o.item = 'markers' AND m.id = ANY(o.o_ids)
    )
    SELECT
        array_agg(DISTINCT road_code) AS road_codes
    FROM codes
    ;

END;

get_updated_roads_from_editing_session(_editing_session_id integer)

Description

Parameters

Definition