Insert new record

Question

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,

Akhil P Sivan · Accepted Answer

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, {'

james_p · Answer

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

Sebastian782 · Answer

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

المنشورات ذات الصلة	الردود	أدوات العرض
Usage Of SQl Queries In odoo sql	1 نوفمبر 22	7372
sql constraints aren't being detected in my model sql	1 أكتوبر 21	4253
Odoo on microsoft sql server instead postgres sql? sql	2 نوفمبر 18	10974
Odoo 7:Copy property value to new product_template field sql	1 مارس 15	4270
Openerp with MS-SQL sql	4 مارس 15	6056

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!