[odoo 8 ] : How to update value of one2many field with at second level by using create and write method using API?

11 July 2016

one2many create update write odooV8

Hello All,

I've asked this Question again, because i was not able to EDIT my question.

I'm having problem on overriding create method.

I've one2many field in my current model, I want to update the value of that field when new record created, and this one2many field's co-model has it's own one2many fields.

So, basically there is two levels of one2many fields.

My one2many field has one2many field, I want to create record for that model as well,

How can i achieve this?

Any help on this appreciated.

This is need to be done using api coding standard.

EDIT

E.g.

Class A(models.Model):    
_name = 'main.model'    
x_ids = fields.one2Many('sub.model','main_id',"Test")

Class B(models.Model)    
_name = 'sub.model'    
main_id = fields.Many2one('main.model', "Main Model")    
#remaining fields.    
xx_ids = fields.One2many('another.sub.model','sub_model_id',"Test")

Class C(models.Model)    
_name = 'another.submodel'    
sub_model_id = fields.Many2one('sub.model',"Sub Model")    
#remaining fields..go here

Consider this is model structure, now when i create record of Class A model, I want to updated one2many field of Class B and Class B is having Class C one2many field, so how to update the values or create records with 2 level of one2many field? is there any option?

I am looking for the solution for both side create and write method. Please anyone has idea than it will be really helpful.

Regards,

Prince

3 Answers

Best Answer

You can achieve that in 2 ways:

Case 1: Default Values

if you have fixed data, then you can set default values in both objects i.e in ClassA set default values for 'x_ids' and in ClassB set default values for 'xx_ids'

Case 2: Create/Write method

In the First object (ClassA): while creating itself you can add its lines using One2Many and/or Many2Many semantics.

According to your sample object hierarchy:

    @api.model
    def create(self, vals):
        valsC = {....} # dict of values needed for creating ClassC
        valsB = {
                 'xx_ids': [(0, 0, valsC)],

                ....} # dict of values needed for creating ClassB

        vals['x_ids'] = [(0, 0, valsB)] # appending it into the values of ClassA
        return super(A, self).create(vals)

In Odoo, at the time of creating a record, you can pass values to its child be it a One2Many or Many2Many by using its semantics, here [(0,0,{})] represents am trying to create new One2Many record.

Note:

In valsB, I have appended the values of ClassC, and this dict am appending the original Vals of Class A, which will be like passing nested dict of values into ClassA

Similarly there exists a semantics for editing/updating, deleting and so, please refer the below samples which are used for both One2Many & Many2Many.

(0, 0, { values }) link to a new record that needs to be created with the given values dictionary

(1, ID, { values }) update the linked record with id = ID (write values on it)

(2, ID) remove and delete the linked record with id = ID (calls unlink on ID, that will delete the object completely, and the link to it as well)

(3, ID) cut the link to the linked record with id = ID (delete the relationship between the two objects but does not delete the target object itself)

(4, ID) link to existing record with id = ID (adds a relationship)

(5) unlink all (like using (3,ID) for all linked records)

(6, 0, [IDs]) replace the list of linked IDs (like using (5) then (4,ID) for each ID in the list of IDs)

Best Answer

Update A SAMPLE one2many record in odoo9,

search_var = self.browse(self.id)

search_var.update({

'stud_ids': [(0,_, {

'reg_no':4200,

'dob': '04/01/1992',

'stud_name':'amuthan',

})]

})

Best Answer

Hello,

In creation you need to override the create method of class A to be something as:

    @api.model
    def create(self, vals):
        res = super(A, self).create(vals)
        #creating C record
        c_res = self.env['another.submodel'].create({'field_name': value, ...})
        #creating B record
        b_res = self.env['sub.model'].create({'field_name': value, ...})
        #Adding C to B
        b_res.xx_ids += c_res
        #Adding B to A [it is also a One2many]
        res.x_ids += b_res
        return res

You can do similar thing in the write method with some modifications ...

Hope this could helps ...

3 Comments

Prince Caspion

- 11 July 2016

@Ahmed: Thanks for the nice example, i will try and check it.

Prince Caspion

- 12 July 2016

Ahmed given solution does not work , gives me this error, defaults.update(values)

ValueError: dictionary update sequence element #0 has length 3; 2 is required

Qutechs, Ahmed M.Elmubarak

- 12 July 2016

Hi, can you share your code some where ?

Help

3 Answers