Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
2735 Vistas

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 :)

Avatar
Descartar
Mejor respuesta

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.

Avatar
Descartar
Autor

Thank you Waleed Ali Mohsen, Now I am getting what the _parent_store is! This explanation saves a lot of my time.

Mejor respuesta

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

Avatar
Descartar
Autor

So basically, It just simply used to optimize the backend performance by reducing no. of queries

Publicaciones relacionadas Respuestas Vistas Actividad
0
jul 25
1354
2
nov 24
6057
2
oct 24
3072
2
ago 24
1799
3
jul 24
8159