使用 Apache-AGE 和 PostgreSQL 的有向图进行循环检测

CREATE     TABLE modules (
    id SERIAL     PRIMARY KEY,
    name VARCHAR(255)     NOT     NULL,
    version VARCHAR(255)     NOT     NULL
);

    CREATE     TABLE dependencies (
    module_id INTEGER     REFERENCES modules(id),
    dependency_id INTEGER     REFERENCES modules(id),
        PRIMARY

-- Modules    INSERT     INTO modules (name, version)     VALUES
('Module A', '1.0.0'),
('Module B', '1.1.0'),
('Module C', '1.2.0'),
('Module D', '2.0.0'),
('Module E', '2.1.0');

-- Dependencies    INSERT     INTO dependencies (module_id, dependency_id)     VALUES
(1, 2),
(1, 3),
(2, 3),
(3, 4),
(4, 5),
(5, 1);