Skip to content

Instantly share code, notes, and snippets.

@loctv

loctv/odoo_module_dependency_graph.sql

Forked from grindtildeath/odoo_module_dependency_graph.sql
Created August 2, 2018 09:04
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save loctv/e907164e92480c9651eeb94600edc71c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save loctv/e907164e92480c9651eeb94600edc71c to your computer and use it in GitHub Desktop.
Download ZIP
Odoo module dependency graph
Raw
odoo_module_dependency_graph.sql
WITH recursive dep_tree AS (
SELECT mdl0.id, mdl0.name, NULL::integer, 1 AS level, array[mdl0.id] AS path_info
FROM ir_module_module mdl0
WHERE name = 'sale' -- state here the child module
UNION ALL
SELECT (SELECT mdl1.id FROM ir_module_module mdl1 WHERE mdl1.name = c.name), rpad('', p.level * 1, '_') || c.name, c.module_id, p.level + 1, p.path_info||c.id
FROM ir_module_module_dependency c
JOIN dep_tree p ON c.module_id = p.id
)
SELECT level, name
FROM dep_tree
ORDER BY path_info;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment