Add materialized path to project model
To manage HMT effectively the introduced adjacency list field 'parent_id' is not enough:
recursion required to traverse the tree.
Materialized path concept allows to find all ascendants, descendants,
children of the node in a single request operation.
Blueprint information
- Status:
- Complete
- Approver:
- Rodrigo Duarte
- Priority:
- Low
- Drafter:
- Alexander Makarov
- Direction:
- Approved
- Assignee:
- Alexander Makarov
- Definition:
- Superseded
- Series goal:
- None
- Implementation:
-
Started
- Milestone target:
- None
- Started by
- Steve Martinelli
- Completed by
- Lance Bragstad
Related branches
Related bugs
Sprints
Whiteboard
Gerrit topic: https:/
Addressed by: https:/
Materialized path for project hierarchy
Addressed by: https:/
Materialized path mixin
Addressed by: https:/
Materialized path mixin and field for hierarchical models
Gerrit topic: https:/
Addressed by: https:/
SQLAlchemy column type for materialized path
Addressed by: https:/
Materialized path convenience wrapper
Addressed by: https:/
Use path hybrid property in query filtering
(lbragstad) 19-02-15: I'm marking this as superseded based on the plan socialized on the mailing list [0]. All relevant content from this blueprint has been ported to an RFE bug report [1].
[0] http://
[1] https:/
Work Items
Dependency tree

* Blueprints in grey have been implemented.