How to add _sql_constraints to check char field lenght in odoo?

Question

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 ?

faOtools · 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

Niyas Raphy (Walnut Software Solutions) · 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 [1]

Thanks

[1] https://www.youtube.com/watch?v=ijS-N1CdiWU&list=PLqRRLx0cl0hoJhjFWkFYowveq2Zn55dhM&index=14

Powiązane posty	Odpowiedzi	Widoki
How can I use two models in an API (foreign key - relations)? models	0 gru 24	2079
Import Data From Another Model Rozwiązane models	1 mar 24	3183
@api.constrains Rozwiązane constraints	2 gru 23	4544
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 ? Rozwiązane models	1 cze 23	13326
Error al tratar de borrar un campo en un modelo. models	0 sty 23	3682

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!