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	Odpovědi	Zobrazení
How to execute sql query on website controller? Vyřešeno many2many query execute sql controller	3 kvě 20	12730
Error in sql while using operator "in" and variable Vyřešeno function execute sql syntax	3 říj 15	6529
is possible to add 2 filters to the web portal similar to searchbar_filters? portal	2 čvc 25	1392
How can I allow one portal user to see another portal user's information (like Sales Orders, Invoices)? Vyřešeno portal	1 kvě 24	2664
Use worksheets in Odoo Portal portal	2 úno 24	2174

This question has been flagged

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