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)

Gerelateerde posts	Antwoorden	Weergaven
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 27: ordinal not in range(128) constraint	9 mrt. 16	60689
constraint of unicity constraint	1 mrt. 15	4666
constraint not working porperly constraint	1 mrt. 15	5412
How to show fields values in _constraints messages? constraint	2 mrt. 15	4406
HD TV hi nahi hai na ki korbo o kisu na to the same contribution constraint	0 nov. 24	7

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!