Call a method while upgrading a module

Question

There is an option in the menifest file to call method during module installation. We can mention pre_init and post_init.
I would like to call one method while upgrading the module as similar to pre_init. because after module gets installed pre_init will not be called.
Any suggestion for this ?
Why I need this ...
I have a stored procedure to generate report data quickly which uses postgresql stored procedure, now when there is a slight change in the procedure I would like to update it thourh th

Sudhir Arya (ERP Harbor Consulting Services) · Accepted Answer

You can call any method during module update by adding *function* tag in the xml file.
# Add following code in XML file
<function model="sale.order" name="action_custom_method"/>
@api.model
def action_custom_method(self):
# Your code goes here...
return True
This way method will be called after you upgrade the module.

Info · Answer

Finally, I got the solution.

We created one  *.sql*  file and into that file we added all our stored procedures and other database objects.

We added that sql file in the  *__manifest__.py*

'data' : [
'db_function/get_product_sales_history_data.sql' ,
'db_function/update_product_sales_history.sql' ,
],   It will execute these sql files at the time of module installation as well as module upgrade time.

Related Posts	Відповіді	Переглядів
Pull request Already exist for XXX : staging, Odoo Sh errror. Odoo13.0 Odoo13	4 трав. 21	29757
smart button with http request Odoo13.0 Odoo13	0 лип. 20	3792
installing odoo13 Odoo13.0 Odoo13 odoo13CE	1 черв. 23	3172
Unable to install module social push_notifications odoo 13 Вирішено marketing Odoo13.0 Odoo13	3 лют. 22	11894
how to make hide users for anther company multicompany Odoo13.0 Odoo13	1 трав. 21	5651

Це запитання позначене

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