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

TenthPlanet Technologies Pvt Ltd, Subbarao Singalla · 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)

Powiązane posty	Odpowiedzi	Widoki
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 27: ordinal not in range(128) constraint	9 mar 16	63413
constraint of unicity constraint	1 mar 15	6277
constraint not working porperly constraint	1 mar 15	7184
How to show fields values in _constraints messages? constraint	2 mar 15	6340
HD TV hi nahi hai na ki korbo o kisu na to the same contribution constraint	0 lis 24	7

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!