Web Controller: When does database transaction commit?

Question

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

Ravi Gadhia · Accepted Answer

In odoo transaction atomic at the request(http) level, it binds with HTTP layer
when any request comes odoo create a new  environment [1]  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 [2]
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

相关帖文	回复	查看
Controller giving 404 Error controllers	2 8月 25	3987
Controller not working 已解决 controllers	2 6月 25	2439
How to add simple logic inside methods of Odoo 16 website controller? controllers	3 6月 24	5144
understanding Odoo Frame work 已解决 framework	2 3月 24	6284
Controller or middleware that handles all the requests controllers	1 3月 23	5286

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！