Sql constraint for boolean field

Question

I have boolean field and i want to make sql constraint that only 1 record in model could have this field checked. how can i do this?
class ProductPricelist(models.Model):
_inherit = 'product.pricelist'
priority = fields.Boolean( 'Priority' )

Ibrahim Boudmir · Accepted Answer

Hi,
Use api.constrains that will check your record before persisting it in the DB. Like this:
@api.constrains('priority')
def _check_boolean(self):
// to boost the performance, you search for only one record that is different from the current one which has the        //boolean checked. If found, then raise.
checked_bool = self.search([('id', '!=', self.id),('priority', '=', True)], limit=1)
if self.priority and checked_bool:
// Means that more than one record has the field checked.
raise Validat

subbarao · Answer

Use the following code
@api.constrains('priority')
def _check_priority(self):
if self.priority:
checked_bool = self.search([('id', '!=', self.id),('priority', '=', True)])
if checked_bool:
raise ValidationError(_("There's already one priority is checked. Reference : %s") % checked_bool[0].name)

Related Posts	Replies	Views
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 27: ordinal not in range(128) constraint	9 Mar 16	60347
constraint of unicity constraint	1 Mar 15	4483
constraint not working porperly constraint	1 Mar 15	5198
How to show fields values in _constraints messages? constraint	2 Mar 15	4168
HD TV hi nahi hai na ki korbo o kisu na to the same contribution constraint	0 Nov 24	5

This question has been flagged

Enjoying the discussion? Don't just read, join in!