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

Powiązane posty	Odpowiedzi	Widoki
Controller giving 404 Error controllers	2 sie 25	3978
Controller not working Rozwiązane controllers	2 cze 25	2434
How to add simple logic inside methods of Odoo 16 website controller? controllers	3 cze 24	5141
understanding Odoo Frame work Rozwiązane framework	2 mar 24	6283
Controller or middleware that handles all the requests controllers	1 mar 23	5280

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!