Unique Sql constraint for a field on a exisitng database - odoo 10

Question

Hi,
How to make unique Sql constraint for a field on a exisitng database ( because it work for a new database but not for my exisitng db)

Regards

Cheikh Tidiane Diop · Accepted Answer

code = fields.Char(string='Reference', index=True, tracking=True)

_sql_constraints = [('unique_code', 'unique(code)', 'La référence doit être unique !')

Thanks

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
SQL constrains will work for new and existing db. In existing database, you may have some records which already violates this constrains and thus it is not working.
So manually fix the existing violated records and apply the SQL constrains. In case if you can't fix existing records, then you have to use api.constrains for new records.

Thanks

medmars · Answer

Hi,
finally it work in my existing db, So the solution is to search for any duplicating data for the field that we want to applied to sql_constraint
remove all duplicate data
remove compiled file "model.pyc"
restart odoo-service
Refresh your browser

and it will work fine

jignesh Bharadiya · Answer

This is Help for You, *Syntax,* _sql_constraints = [('', 'unique()', '')] *Example,* _sql_constraints = [('user_unique', 'unique(userid)', 'User already exists.')]

Această întrebare a fost marcată

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