Skip to Content
This question has been flagged
modelsconstraints
2 Respostes
4362 Vistes
Avatar
Ernesto Ruiz

I have a fields.Char attribute “identification_id”, That field must have  11 characters. How can I add a _sql_constraints to check the length of that field and ensure it should be 11 ?

Avatar
Descartar
Avatar
faOtools
Best Answer 

_sql_constraints = [
        (
            'identification_id_len_check',
            'check (LENGTH(identification_id) = 11)',
            ('identification_id should be 11 symbols')
        ),
    ]
SQL constraints are faster in comparison to api.constrains. 
Make sure that none of your existing records have different size. Otherwise, constrain would not be created


Avatar
Descartar
Avatar
Niyas Raphy (Walnut IT)
Best Answer

Hi,

If it is not mandatory to for _sql_constraints, try to achieve the same using the constrains.

@api.constrains('identification_id')
def check_identification_id(self):
    for rec in self:
        if len(rec.identification_id) != 11:
            raise ValidationError(_('Must be 11 Characters'))


See : How To Add Constrains For A Field in Odoo12


Thanks

Avatar
Descartar
Related Posts Respostes Vistes Activitat
How can I use two models in an API (foreign key - relations)?
models
Avatar
0
de des. 24
658
Import Data From Another Model Solved
models
Avatar
Avatar
1
de març 24
1567
@api.constrains Solved
constraints
Avatar
Avatar
2
de des. 23
2310
how can i return a form view from a model method and i just want to show only a specific field instead of all the fields of this model ? Solved
models
Avatar
Avatar
1
de juny 23
11600
Error al tratar de borrar un campo en un modelo.
models
Avatar
0
de gen. 23
2350