gis.road_graph

Parameters

Name	Type	Mode
schema_name	text	TABLE
table_name	text	TABLE
trigger_name	text	TABLE
trigger_status	text	TABLE

Definition

DECLARE
    managed_object record;
    table_regclass regclass;
BEGIN
    FOR managed_object IN
        SELECT o.schema_name, o.table_name, o.geometry_type, o.add_trigger_on_geom_change
        FROM road_graph.managed_objects AS o
        ORDER BY o.id
    LOOP
        schema_name = managed_object.schema_name;
        table_name = managed_object.table_name;
        trigger_name = NULL;

-- Only add the triggers if it has been asked for this table
        IF NOT managed_object.add_trigger_on_geom_change THEN
            trigger_status = 'not requested';
            RETURN NEXT;
            CONTINUE;
        END IF;

-- Check the table exists
        table_regclass = to_regclass(format('%I.%I', schema_name, table_name));
        IF table_regclass IS NULL THEN
            trigger_status = 'table not found';
            RETURN NEXT;
            CONTINUE;
        END IF;

-- Check the table has a geom column, used by the triggers
        IF NOT EXISTS (
            SELECT 1
            FROM pg_attribute AS a
            WHERE a.attrelid = table_regclass
            AND a.attname = 'geom'
            AND NOT a.attisdropped
        ) THEN
            trigger_status = 'geom column not found';
            RETURN NEXT;
            CONTINUE;
        END IF;

-- Trigger calculating the references of the inserted or updated features
        -- It is not created again if it already exists
        trigger_name = 'trg_calculate_managed_object_references';
        IF EXISTS (
            SELECT 1
            FROM pg_trigger AS t
            WHERE t.tgrelid = table_regclass
            AND t.tgname = trigger_name
            AND NOT t.tgisinternal
        ) THEN
            trigger_status = 'already exists';
        ELSE
            EXECUTE format(
                $SQL$
                CREATE TRIGGER trg_calculate_managed_object_references
                BEFORE INSERT OR UPDATE OF geom
                ON %1$I.%2$I
                FOR EACH ROW EXECUTE PROCEDURE road_graph.calculate_managed_object_references();
                $SQL$,
                schema_name,
                table_name
            );
            trigger_status = 'created';
        END IF;
        RETURN NEXT;

-- Trigger updating the lines connected to the updated line, only for the lines
        -- It is not created again if it already exists
        IF lower(managed_object.geometry_type) IN ('linestring', 'multilinestring') THEN
            trigger_name = 'trg_update_managed_object_linked_geometries';
            IF EXISTS (
                SELECT 1
                FROM pg_trigger AS t
                WHERE t.tgrelid = table_regclass
                AND t.tgname = trigger_name
                AND NOT t.tgisinternal
            ) THEN
                trigger_status = 'already exists';
            ELSE
                EXECUTE format(
                    $SQL$
                    CREATE TRIGGER trg_update_managed_object_linked_geometries
                    AFTER UPDATE OF geom
                    ON %1$I.%2$I
                    FOR EACH ROW EXECUTE PROCEDURE road_graph.update_managed_object_linked_geometries();
                    $SQL$,
                    schema_name,
                    table_name
                );
                trigger_status = 'created';
            END IF;
            RETURN NEXT;
        END IF;
    END LOOP;

RETURN;
END;

add_managed_objects_triggers()

Description

Parameters

Definition