Odoo Help

0

How to check _sql_constraints using function: Odoo 9

By
Shameem Babu @ iWesabe
on 11/4/16, 8:02 AM 661 views

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

 

1
Axel Mendoza
On 11/4/16, 7:08 PM

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

Thanks Axel , It is working

GLOBAL CREATIVE CONCEPTS TECH CO LTD, Shameem Babu @ iWesabe
on 11/5/16, 7:03 AM
5
Nilmar Shereef
On 11/4/16, 11:46 PM

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


Thanks Nilmar,

It is working while adding @api.one

Same answer of Axel , you explained more

You have an upvote

GLOBAL CREATIVE CONCEPTS TECH CO LTD, Shameem Babu @ iWesabe
on 11/5/16, 7:05 AM

Good. Keep going :)

Nilmar Shereef
on 11/5/16, 7:07 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)

Stats

Asked: 11/4/16, 8:02 AM
Seen: 661 times
Last updated: 11/5/16, 7:02 AM