Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
1 Antworten
4284 Ansichten

I want to create using sql command because if i am using self.create that was take a long time to get a result.

@api.multi

def action_create_history(self):

    for rec in self :

        history_obj = self.env['history.table']

        hd  = []

        hd['partner_id'] = rec.id

        hd['old_state']  = rec.state

        hd['new_state'] = 'open'

        hd['partner_reg_id']  = rec.partner_no

        hd['state']   = 'complete'
        

        history = history_obj.create(hd)

        partner.write({'history_id' : history.id})

i want change it into sql please give advice

Avatar
Verwerfen
Beste Antwort

Hi Chaanto,

You can execute queries like following

self._cr.execute('INSERT INTO my_test_table (column1, column2) VALUES (%s, %s)', (value1, value2))

To get the related database table of a model, put underscore instead of dots.

Thanks


iWesabe

Avatar
Verwerfen
Autor

Hi Global Creative Concepts Tech Co Ltd

For basic command like that i know but when i insert how about xml id, database id, etc.

is that insert automatically if not what paramater that should i put on query ?

Verknüpfte Beiträge Antworten Ansichten Aktivität
1
Feb. 21
4130
2
Okt. 18
3030
0
März 15
3413
1
März 15
5358
0
März 15
3062