Community mailing list archives

community@mail.odoo.com

Re: categories: what are parent_left and parent_rigth

by
redCOR AG, robert rottermann
- 09/11/2015 04:40:24
Thanks Jay,

On 11.09.2015 09:26, Jay Vora wrote:
<blockquote cite="mid:CACHFH7nhPT2G4QWbkdKSh=wfQFQErpHR28KH4eFSa52CyQObzA@mail.gmail.com" type="cite">
Robert,

Please check here.
very interesting,

now I wonder, how are parent_left and parent_rigth set, when a new category record is created.
I see, that whenever I create a new category, the values of the existing ones are adapted.

However greping the source, I did not find the piece of code, where the calculation of the new values is done.
<blockquote cite="mid:CACHFH7nhPT2G4QWbkdKSh=wfQFQErpHR28KH4eFSa52CyQObzA@mail.gmail.com" type="cite">

Thanks.

On Fri, Sep 11, 2015 at 12:44 PM, robert rottermann <robert@redcor.ch> wrote:
Hi there,

in my quest to mass import partners I need to generate categories.
This I can to using an sql statement like the following:
statement = "INSERT INTO res_partner_category (id, name, active, parent_id) 
VALUES (DEFAULT, '%s', 't', %s) RETURNING id" % (name, pid)

however, when I look at the database structure of res_partner_category, i find 
that there are the two fields: parent_left and parent_rigth
What are they for?
And more importantly: what values should they have?

thanks
robert

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
The Splendid journey of 2 years in Numbers
---
Regards,
Jay Vora,
Managing Director,
<img src="cid:part1.09000700.05080805@serpentcs.com" style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
Serpent Consulting Services Pvt. Ltd.
Web : http://www.serpentcs.com
Mobile : 91 - 9879354457
Twitter: jaynvora
Skype: jaynvora
Blog : http://jayvora.blogspot.com

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe