Hello, Recently I noticed that there is a _parent_store attribute in a product.category, I checked in odoo, but didn't get the exact idea why it is used. Can anybody help me to understand what the _parent_store attribute actually does? Thank you in advance :)
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- 客户关系管理
- e-Commerce
- 会计
- 库存
- PoS
- Project
- MRP
此问题已终结
2
回复
2916
查看
Parent-child tree relationships are represented using a many-to-one relationship with the same model, where each record holds a reference to its parent. The inverse one-to-many relationship represents the record's direct children.
product.category model uses hierarchical data structures (parent-child relationships), Optimize hierarchy tree searching can be enabled by setting the _parent_store=True model attribute and adding the parent_path helper field. This helper field stores additional information about the hierarchy tree structure, which is used to run faster queries
Note: the parent_path field must also be added, and it must be indexed.
Thank you Waleed Ali Mohsen, Now I am getting what the _parent_store is! This explanation saves a lot of my time.
Hi Jay,
It is a Nested set of model.It manage hierarchical data structures with unbound depth in SQL. The article Managing Hierarchical Data in MySQL .
_parent_store to False should be sufficient as a workaround for an existing database. The framework can handle child_of operator on models where _parent_store is False, it will simply do multiple queries for traversing the hierarchy. Only the parent_id column is required for child_of.
Regards
So basically, It just simply used to optimize the backend performance by reducing no. of queries
| 相关帖文 | 回复 | 查看 | 活动 | |
|---|---|---|---|---|
|
0
7月 25
|
1470 | ||
|
2
11月 24
|
6321 | ||
|
2
10月 24
|
3331 | ||
|
2
8月 24
|
1892 | ||
|
3
7月 24
|
8296 |
