Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
3192 Vistas

Create @api.constrains to check: 

_sql_constraints = [
        (
            "phone_owner_uniq",
            "unique (phone, owner)",
            "You cannot have two tenants with the same phone number for the same owner!",
        )
    ]

This is sql.contrains but I want to check with python constrains.

Please help me ...

Avatar
Descartar
Autor

@Kiran K
In odoo, it's working.
But in my app (FE: React native), It show error message, but it still create.
Is there any way to fix it?

Mejor respuesta

Hi BB,

Try,

    @api.constrains('phone', 'owner')

    def check_phone_owner_uniq(self):

        for record in self:

            duplicate_records = self.search([

                ('phone', '=', record.phone),

                ('owner', '=', record.owner.id),

                ('id', '!=', record.id)

            ])

            if duplicate_records:

                raise ValidationError("You cannot have two tenants with the same phone number for the same owner!")

Avatar
Descartar
Autor Mejor respuesta

Thanks for your help. 


It's working as  expected.

Avatar
Descartar
Autor

Please help me ~~~

Publicaciones relacionadas Respuestas Vistas Actividad
0
jun 21
2609
1
nov 20
4394
2
jun 20
3140
2
mar 24
5590
1
jul 23
1595