Remove Many2One

[serxoz]

Hi!

I have a model with a Many2One relation and I want to unassign it but I don't know how to do it. I hope you can tell me the direction to follow.

Thank you in advance.

[ahuret]

Hello @serxoz ! Good question ! The way to clear a Many2One value is to set an empty value (empty is different than null). The trick is to create an empty Many2One like this:

odoo.NewMany2One(0, "")

It will unassign the current value from the model instance. Tell me if it helped, and I let you close if it did !

[serxoz]

Hello @ahuret and thank you :D

I've done what you have said but now I get:

The operation cannot be completed: another model requires the record being deleted. If possible, archive it instead.

Maybe you have struggled with this thing before if not, don't worry, we can close the issue.

[ahuret]

What's the model you're trying to update ?

[serxoz]

It's a custom model of a module developed by ourselves to manage telephone numbers. It has some odoo.Relation and odoo.Many2One fields.

Here it is:

type NvDdi struct {
    LastUpdate               *odoo.Time      `xmlrpc:"__last_update,omptempty"`
    ActivityDateDeadline     *odoo.Time      `xmlrpc:"activity_date_deadline,omptempty"`
    ActivityIds              *odoo.Relation  `xmlrpc:"activity_ids,omptempty"`
    ActivityState            *odoo.Selection `xmlrpc:"activity_state,omptempty"`
    ActivitySummary          *odoo.String    `xmlrpc:"activity_summary,omptempty"`
    ActivityTypeId           *odoo.Many2One  `xmlrpc:"activity_type_id,omptempty"`
    ActivityUserId           *odoo.Many2One  `xmlrpc:"activity_user_id,omptempty"`
    Alias                    *odoo.String    `xmlrpc:"alias,omptempty"`
    Baja                     *odoo.Bool      `xmlrpc:"baja,omptempty"`
    ContratoId               *odoo.Many2One  `xmlrpc:"contrato_id,omptempty"`
    CreateDate               *odoo.Time      `xmlrpc:"create_Date,omptempty"`
    CreateUid                *odoo.Many2One  `xmlrpc:"create_uid,omptempty"`
    DisplayName              *odoo.String    `xmlrpc:"display_name,omptempty"`
    EstadoBaja               *odoo.Selection `xmlrpc:"estado_baja,omptempty"`
    FechaBaja                *odoo.Time      `xmlrpc:"fecha_baja,omptempty"`
    Id                       *odoo.Int       `xmlrpc:"id,omptempty"`
    MessageAttachmentCount   *odoo.Int       `xmlrpc:"message_attachment_count,omptempty"`
    MessageChannelIds        *odoo.Relation  `xmlrpc:"message_channel_ids,omptempty"`
    MessageFollowerIds       *odoo.Relation  `xmlrpc:"message_follower_ids,omptempty"`
    MessageHasError          *odoo.Bool      `xmlrpc:"message_has_error,omptempty"`
    MessageHasErrorCounter   *odoo.Int       `xmlrpc:"message_has_error_counter,omptempty"`
    MessageIds               *odoo.Relation  `xmlrpc:"message_ids,omptempty"`
    MessageIsFollower        *odoo.Bool      `xmlrpc:"message_is_follower,omptempty"`
    MessageMainAttachmentId  *odoo.Many2One  `xmlrpc:"message_main_attachment_id,omptempty"`
    MessageNeedaction        *odoo.Bool      `xmlrpc:"message_needaction,omptempty"`
    MessageNeedactionCounter *odoo.Int       `xmlrpc:"message_needaction_counter,omptempty"`
    MessagePartnerIds        *odoo.Relation  `xmlrpc:"message_partner_ids,omptempty"`
    MessageUnread            *odoo.Bool      `xmlrpc:"message_unread,omptempty"`
    MessageUnreadCounter     *odoo.Int       `xmlrpc:"message_unread_counter,omptempty"`
    Name                     *odoo.String    `xmlrpc:"name,omptempty"`
    PartnerId                *odoo.Many2One  `xmlrpc:"partner_id,omptempty"`
    Portabilidad             *odoo.Relation  `xmlrpc:"portabilidad,omptempty"`
    ServicioId               *odoo.Many2One  `xmlrpc:"servicio_id,omptempty"`
    WebsiteMessageIds        *odoo.Relation  `xmlrpc:"website_message_ids,omptempty"`
    WriteDate                *odoo.Time      `xmlrpc:"write_date,omptempty"`
    WriteUid                 *odoo.Many2One  `xmlrpc:"write_uid,omptempty"`
    XStudioAliasContrato     *odoo.String    `xmlrpc:"x_studio_alias_contrato,omptempty"`
}

And I am doing this:

    // d is a instance of the model NvDdi
    d.ContratoId = odoo.NewMany2One(0, "")
    d.ServicioId = odoo.NewMany2One(0, "")

But when update is executed I got the error message that told before:

Fault(2): The operation cannot be completed: another model requires the record being deleted. If possible, archive it instead.

Model: Numeracion (nv.ddi), Constraint: nv_ddi_contrato_id_fkey

[ahuret]

Did you generate the model using the generator or did you create it by hand youself. I wonder why odoo assumes the model will be deleted while it will just be unassigned...

[ahuret]

btw what about the nv_ddi_contrato_id_fkey ? looks like the nv.ddi cannot have the ContratoId empty as it need it as a foreign key.

[serxoz]

I don't know about why it suggest that with the nv_ddi_contrato_id_fkey... I have implemented this in python (and trying to move to go) and there I simply assign ContratoId to false and done... Maybe it's some design flaw in our module that Python allows but in golang it arises.

[ahuret]

Interesting, maybe the odoo.NewMany2One(0, "") only work for some use case, maybe the false value is indeed better for unassigning. Try using the newly created code in this PR: https://github.com/skilld-labs/go-odoo/pull/51/files Using the NewUnassignedMany2One .

Also I would be interested to know the version of the odoo instance you're working with.

[serxoz]

Good morning!

I've cleaned all caches:

go clean -r -modcache
go clean -r -cache

Then upgraded to the commit you pointed:

go get github.com/skilld-labs/go-odoo@0ccdee293fc3841dcc7d98fad85ff4c240459720

And, it worked! Thank you so much!

[ahuret]

Nice, I will merge it :-) Closing it !

[ahuret]

new https://github.com/skilld-labs/go-odoo/releases/tag/v1.9.1 tag contains the fix @serxoz !