This question has been flagged
1 Reply
9253 Views

Hi, i want to question ...

I create field, but i want the field become unique or primary key , 

class Product (osv.osv):
    _name = 'kode.warna'
    _columns = {
                'name': fields.char('Kode Warna', required=True),
                'ket': fields.char('Nama Warna', required=True),
                }
    

How field 'name' become unique or primary key ?

 

thanks ...

Avatar
Discard
Best Answer

Additionally define something like:

 _sql_constraints = [ ('name_uniq', 'unique(name)', 'Two foos with the same name!') ]

or like

    _sql_constraints = [
        ('name_uniq', 'unique(name, company_id)', 'Name must be unique per Company!'),
    ]

 

Avatar
Discard