Creating model data with many2many field doesn't work

orm many2many controller

1 Besvara

20899 Vyer

Tobias Wetzel

Hi,

I am trying to create a model entry in my controller, which has a many2many field. The creating works but the values I added to the many2many field are not there. What is wrong?

Model definition:

class Paper(models.Model):
    _name = 'paper_submission.paper'

    title = fields.Char(string='Title', required='True')
    author_ids = fields.Many2many('paper_submission.author', string='Authors', relation="paper_submission_paper_author_relation")

references model:

class Author(models.Model):
    _name = 'paper_submission.author'

    first_name = fields.Char()
    last_name = fields.Char()

Code for creating the model entry:

 orm_paper = registry.get('paper_submission.paper')

paper_info = {"title: title, author_ids": author_ids}
paper_id = orm_paper.create(cr, SUPERUSER_ID, paper_info, context=context)

where author_ids is a list of ids, like [1,2]

Tobias Wetzel

Författare

SOLUTION: orm_paper.create({'title': title, 'author_ids': [(6, 0, author_ids)]}) using: (6, _, ids) triplet from the Odoo docs: "Values marked as _ in the list above are ignored and can be anything, generally 0 or False."

Habib

Bästa svar

You need to use tuples to write to many2many records:

In your case if the authors don't exist, and you want to create them, you would use:

orm_paper.create({'title': title, 'author_ids': [(0, 0, {'first_name': first_name, 'last_name': last_name})]

if the author does exist you would use:

orm_paper.create({'title': title, 'author_ids': [(4, author_id)]})

The following can be found at /openerp/models.py, and describes how to use the appropriate "triplet"

:class:`~openerp.fields.One2many` and
:class:`~openerp.fields.Many2many` use a special "commands" format to
manipulate the set of records stored in/associated with the field.
 
This format is a list of triplets executed sequentially, where each
          triplet is a command to execute on the set of records. Not all
          commands apply in all situations. Possible commands are:

          ``(0, _, values)``
              adds a new record created from the provided ``value`` dict.
          ``(1, id, values)``
              updates an existing record of id ``id`` with the values in
              ``values``. Can not be used in :meth:`~.create`.
          ``(2, id, _)``
              removes the record of id ``id`` from the set, then deletes it
              (from the database). Can not be used in :meth:`~.create`.
          ``(3, id, _)``
              removes the record of id ``id`` from the set, but does not
              delete it. Can not be used on
              :class:`~openerp.fields.One2many`. Can not be used in
              :meth:`~.create`.
          ``(4, id, _)``
              adds an existing record of id ``id`` to the set. Can not be
              used on :class:`~openerp.fields.One2many`.
          ``(5, _, _)``
              removes all records from the set, equivalent to using the
              command ``3`` on every record explicitly. Can not be used on
              :class:`~openerp.fields.One2many`. Can not be used in
              :meth:`~.create`.
          ``(6, _, ids)``
              replaces all existing records in the set by the ``ids`` list,
              equivalent to using the command ``5`` followed by a command
              ``4`` for each ``id`` in ``ids``. Can not be used on
              :class:`~openerp.fields.One2many`.

Njuter du av diskussionen? Läs inte bara, delta också!

Skapa ett konto idag för att ta del av exklusiva funktioner och engagera dig i vår fantastiska community!

Registrera dig

Relaterade inlägg	Svar	Vyer
Get model data in a controller Löst orm model controller	4 okt. 21	40431
How to find out the table name for a many2many relation (Where is the many2many table name stored?) Löst orm xmlrpc many2many	4 okt. 21	26775
Many2Many relationship but sorted with 'weighted' values many2one orm many2many one2one	0 nov. 18	8177
ODOO V16 Associate Parts to a Finished Good many2many	1 feb. 24	4099
many2many write() - replaces all existing records in the set by the ids Löst orm write many2many website odoo12	3 sep. 23	64430

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!