跳至內容
選單
此問題已被標幟
1 回覆
1204 瀏覽次數

Hello,

when i edit/change a sql_contraint in my module in will not update the contraint in the Database.

What is the best way to update in sql_contraint in Odoo 15 without deleting and reinstall the module?

Thanks

頭像
捨棄
最佳答案

Hi,

By keeping the same name, you can modify existing SQL constrains via custom modules.

For example, if you need to change below constrain

_sql_constraints = [
('positive_color', 'CHECK(color >= 0)', 'The color code must be positive!')
]

In your custom module,

_sql_constraints = [
('positive_color', 'CHECK(color > 0)', 'The color code must be greater than zero!')
]


Thanks

頭像
捨棄