Skip ke Konten
Pertanyaan ini telah diberikan tanda
4 Replies
6777 Tampilan
Avatar
MIADI

Hello,

This is my model :

class miadi_poidsConditionnement(models.Model):

 _name = 'miadi.poidsconditionnement'

 # _order = 'conditionnement_id asc'

 conditionnement_id = fields.Many2one('miadi.packaging', 'Packaging', default='', required=True)

 produit_id = fields.Many2one('product.product', 'Product', default='', required=True)

 nb_articles = fields.Integer(string='Number of products', default=0)

 poids = fields.Float(string='Packaging Weight', default=0)

 _sql_constraints = [

 ('uniq_id', 'unique(produit_id, conditionnement_id)', 'A product already exists with this packaging !'),

 ]

But my SQL constraints don't work ! I can create 2 records with the same "conditionnement_id" and "produit_id" but I shouldn't be able to do it.


Avatar
Buang
Avatar
Usman Farzand
Jawaban Terbai

# class miadi_poidsConditionnement(models.Model):
                _sql_constraints    =    [   
                                ('uniq_id',   
                                    'UNIQUE (produit_id, conditionnement_id)',

                                    'A product already exists with this packaging !')]

Try this

Avatar
Buang
Avatar
Husam Mustafa
Jawaban Terbai

check if there is any duplication before applying the constrains , if any one found then i won't take any effect , remove the duplication first then install/upgrade the module

Avatar
Buang
Avatar
Jainesh Shah(Aktiv Software)
Jawaban Terbai

SQL constraints works only for New Records, so you may need to test it in new Database.

Avatar
Buang
Avatar
MIADI
Penulis Jawaban Terbai

Hi everybody,

I fix the problem unistalling the module and install it again

Avatar
Buang