How to check _sql_constraints using function: Odoo 9

Question

Hi guys,
I want to check *_sql_constraints* of  a model using *function*
Example , I have a function
@api.one
*def* check_constraint(self)
# CODE TO CHECK
*return* True # If ok
*return* False # If not ok The below constraint must raise an error if the function returns False
_sql_constraints = [ .................] I know It is possible  by overriding the create method. But I forgot the correct way
Thanks in advance

Axel Mendoza · Accepted Answer

Use python constraints instead
https://www.odoo.com/documentation/9.0/reference/orm.html#openerp.api.constrains
https://www.odoo.com/documentation/9.0/reference/orm.html#openerp.models.Model._constraints

Nilmar Shereef · Answer

Hi Shameem,
you have two ways.
one way:
*std_id = fields.Char(string="Student ID", required=True)    *
*_sql_constraints = [('std_id_uniq', 'unique(std_id)', 'This ID already exists !')]*
Another way using api:
*mark1 = fields.Integer(string="Total Mark")*
*@api.constrains('mark1')    *
*def _check_mark1(self):
if self.mark1 == 0:
raise ValidationError("Please enter the marks !")*
*
*
Also you can check any logical operations inside the constrains function.
Hope this may help you*
*

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
@api.constrains Ratkaistu constraints	2 jouluk. 23	5026
How to get data n view using custom widget in odoo 9 odoo9	0 syysk. 23	2867
How to get data n view using custom widget in odoo 9 odoo9	0 syysk. 23	2556
How to Remove " ADD NEW COLUMN " from task kanban view of Project Module? Ratkaistu odoo9	2 kesäk. 25	12214
How to edit the product website description Ratkaistu odoo9	6 lokak. 23	23536

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!