Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
2 Antwoorden
7205 Weergaven

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

 

Avatar
Annuleer
Beste antwoord

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

Avatar
Annuleer
Auteur

Thanks Axel , It is working

Beste antwoord

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


Avatar
Annuleer
Auteur

Thanks Nilmar,

It is working while adding @api.one

Same answer of Axel , you explained more

You have an upvote

Good. Keep going :)

Gerelateerde posts Antwoorden Weergaven Activiteit
2
dec. 23
3547
0
sep. 23
2027
0
sep. 23
1734
2
jun. 25
11249
6
okt. 23
22090