Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
insertsql
4 Antwoorden
20619 Weergaven
Avatar
Sebastian782

Hello,

I have 2 models A and B.

When i update field_1 on A model i execute a function that should add a new record into B model.

How can i do this?

I read that we can execute SQL request (example belaw) but maybe there is an other way more clean than do an INSERT to add new record?

query = """ SELECT event_id, state, sum(nb_register) 
            FROM event_registration 
            WHERE event_id IN %s AND state IN ('draft', 'open', 'done') 
            GROUP BY event_id, state """ 
self._cr.execute(query, (tuple(self.ids),))

Thanks,
Sebastian

Avatar
Annuleer
Avatar
Akhil P Sivan
Beste antwoord

You can override the write function of model_A for that, so that when you are saving the record, it create a new record on model_B.

For eg, try the following, if you want to use old api in your v8 module:

from openerp.osv import fields, osv
class class_A(osv.osv):
    _name = 'model.A'
    _columns = {
        'field_A': fields.many2one('res.partner', string="Supplier", required=True),
     
    }
    
    def write(self, cr, uid, ids, vals, context=None):
        
        model_B_obj = self.pool.get('model_B')
        model_B_obj.create(cr, uid, ids, {'product_id':ids, 'date':vals['status_date'], 'status':vals['status']}, context)
        
        return super(class_A, self).write(cr, uid, ids, vals, context)

Using new api, you may try like this:

class class_A(models.Model):
    _name = 'model.A'
    
    field_A = fields.Many2one('res.partner', string="Supplier", required=True)
     
    
     
    @api.multi
    def write(self, vals):
        
        model_B_obj = self.env['model_B'].create({'product_id':self.id, 'date':self.status_date, 'status':self.status})
        
        return super(class_A, self).write(vals)

Avatar
Annuleer
Sebastian782
Auteur

Hi, thanks. I don't know why, i am not able to make it work. When i change my select field, it seems that it create a record, with the default values of model.B. First, I want to create record in model.B when i save model.A record, so i think the onchange is not good? It seem that it create a record when Second, i want to create the model.B with my values status_date and status of model.A Here below what i wrote: ------------------------------- @api.onchange('status') def on_change_status(self): self.env['order.history'].create({'product_id':self.id, 'date':self.status_date, 'status':self.status}) What i am doing wrong? Thanks.

Akhil P Sivan

Hi Sebastian, I have updated the answer. You don't need to use onchange for that, just need to override the write function of model_A. Try like above.

Sebastian782
Auteur

Hi Akhil, thanks for your help. I have this error : TypeError: write() takes at least 2 arguments (2 given)

Sebastian782
Auteur

I use the new API

Akhil P Sivan

try without context, as updated above

Sebastian782
Auteur

Perfect now Akhil, thanks :)

Avatar
james_p
Beste antwoord

You can achieve it without firing SQL request. Just add the below method in model A. You can read more here: https://www.odoo.com/documentation/8.0/reference/orm.html Hope that helps.

@api.onchange('field_1')
def create_new_record(self):
    self.env['model_b'].create({'field_in_model_b': value})
Avatar
Annuleer
Avatar
Sebastian782
Auteur Beste antwoord

Hi, thanks.

I don't know why, i am not able to make it work.

When i change my select field, it seems that it create a record, with the default values of model.B.

First, I want to create record in model.B when i save model.A record, so i think the onchange is not good? It seem that it create a record when

Second, i want to create the model.B with my values status_date and status of model.A

Here below what i wrote:

-------------------------------

@api.onchange('status')

def on_change_status(self):

self.env['order.history'].create({'product_id':self.id, 'date':self.status_date, 'status':self.status})

What i am doing wrong?

Thanks.

Avatar
Annuleer
Gerelateerde posts Antwoorden Weergaven Activiteit
Usage Of SQl Queries In odoo
sql
Avatar
Avatar
1
nov. 22
8346
sql constraints aren't being detected in my model
sql
Avatar
Avatar
1
okt. 21
4786
Odoo on microsoft sql server instead postgres sql?
sql
Avatar
2
nov. 18
11488
Odoo 7:Copy property value to new product_template field
sql
Avatar
1
mrt. 15
4607
Openerp with MS-SQL
sql
Avatar
Avatar
Avatar
Avatar
4
mrt. 15
6488