Web Controller: When does database transaction commit?

1 Ответить

10161 Представления

Say I have a custom web controller e.g.

@http.route(....)
def myroute(self, ...):
        order = request.env['sale.order'].browse(some_id)                      
        product = request.env['product.product'].ref('mymodule.product1')
        product.write({'list_price': -100})
        order._cart_update(product_id=product.id, set_qty=1, add_qty=1)
        return request.render('mymodule.mytemplate', {...})

I'm concerned that the product update could be overwritten before it's added to the cart, which is theoretically possible if the controller method isn't atomic. Can anyone comment on how the framework will handle this?

Ravi Gadhia

Лучший ответ

In odoo transaction atomic at the request(http) level, it binds with HTTP layer
when any request comes odoo create a new environment for it.

when request(thread) return the result to a client cursor attached to it has been explicitly committed (unless there is no traceback) ref: https://github.com/odoo/odoo/blob/12.0/odoo/http.py#L285
so in your case, `list_price` value change inside _cart_update it will be updated at the end of the request dispatch and very next request get new value.

you can forcefully commit the cursor in the middle of the transaction using request.env.cr.commit() but in general case it not need

Zach Waite

Автор

So assuming there are no explicit calls to commit(), is it fair to say that everything from the entry to the return is contained within a transaction then? And as such in the example case the price used in the _cart_update() process must be the list_price set in the previous line?

Ravi Gadhia

yes it because in some case we need to rollback transaction if data don't satisfy the requirement mostly in create/write so it's a good idea to commit at last and rollback on exception.

yes it processed list_price set by the previous line

Не оставайтесь в стороне – присоединяйтесь к обсуждению!

Создайте аккаунт сегодня, чтобы получить доступ к эксклюзивным функциям и стать частью нашего замечательного сообщества!

Регистрация

Похожие посты	Ответы	Просмотры
Controller giving 404 Error controllers	2 авг. 25	3986
Controller not working Решено controllers	2 июн. 25	2438
How to add simple logic inside methods of Odoo 16 website controller? controllers	3 июн. 24	5144
understanding Odoo Frame work Решено framework	2 мар. 24	6284
Controller or middleware that handles all the requests controllers	1 мар. 23	5286

Этот вопрос был отмечен

Не оставайтесь в стороне – присоединяйтесь к обсуждению!