_sql_constraints problem

Question

Hi everyone, I'd like to constraint contact/company with same name,
I added this lines of code to /odoo/models.py , /odoo/addons/base/models/res_partner.py

_sql_constraints = [('name_uniq', 'unique (name)', 'The company name must be unique !'),
('email_uniq', 'unique(email)', ' Please enter Unique email no.')]       #: SQL constraints [(name, sql_def, message)]

a restart odoo in windows and in linux aswell, but constraint doesn't work,
in what file I have to add this lines?

Gabriele · Answer

thank you Niyas, I upgraded the base module in App>Contacts>(3 point menu)>upgrade but it doesn't make any difference, also I did not see any duplicates in res_partners table.
could you tell me from what path  I edit file module from the UI?
Have you a guide on how to develop custom module?

thank you so much I'm going crazy :)

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
Did you upgrade the base module after adding the constrains ? If not upgrade the module and see whether it makes any difference.
Also the sql constrains will not work, if there is already duplicated names in the database.

NB: also it is not recommended to edit the original odoo source code, instead do it using a custom module or from user interface.

Thanks

Bài viết liên quan	Trả lời	Lượt xem
How can I use two models in an API (foreign key - relations)? models	0 thg 12 24	1368
Import Data From Another Model Đã xử lý models	1 thg 3 24	2427
how can i return a form view from a model method and i just want to show only a specific field instead of all the fields of this model ? Đã xử lý models	1 thg 6 23	12441
Error al tratar de borrar un campo en un modelo. models	0 thg 1 23	3136
Creating a new model example? models	6 thg 9 20	29523

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!