Odoov13 how to use cr.execute in a controller?

Question

I want to use sql queries in CustomerPortal class controllers. I wrote following code:
request.cr.execute( """my query""" )
result = request .cr.fetchall()
but I get the following error:
AttributeError: 'CustomerPortal (extended by PortalAccount, Custome' object has no attribute 'cr'a
what should I do?

Khubab Shams · Answer

Hello Arian, t ry to use ' request .session.cr' instead of 'request.cr'.

Ray Carnes (ray) · Answer

https://github.com/odoo/odoo/blob/13.0/addons/web/controllers/main.py#L1551 [1]
## inside try
registry  =  odoo . modules . registry . Registry ( dbname )
with  registry . cursor () as  cr :
cr . execute ( """ query """)
row  =  cr . fetchone ()

[1] https://github.com/odoo/odoo/blob/13.0/addons/web/controllers/main.py#L1551

Related Posts	Odgovori	Prikazi
How to execute sql query on website controller? Solved many2many query execute sql controller	3 maj 20	12735
Error in sql while using operator "in" and variable Solved function execute sql syntax	3 okt. 15	6529
is possible to add 2 filters to the web portal similar to searchbar_filters? portal	2 jul. 25	1397
How can I allow one portal user to see another portal user's information (like Sales Orders, Invoices)? Solved portal	1 maj 24	2673
Use worksheets in Odoo Portal portal	2 feb. 24	2177

This question has been flagged

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